public void InsertEntry(MySqlConnection conn, Versions version, string endpoint, string DatabaseName)
{
using (var insertComm = new MySqlCommand($"INSERT INTO `{DatabaseName}_builds` (`branch`, `buildconfig`, `cdnconfig`, `buildid`, `versionsname`, `productconfig`) VALUES " +
$"(@branch, @buildConfig, @CDNConfig, @buildid, @versionsName, @productConfig)", conn))
{
insertComm.Parameters.AddWithValue("@branch", MySqlMisc.GetBranch(endpoint));
insertComm.Parameters.AddWithValue("@buildconfig", version.BuildConfig);
insertComm.Parameters.AddWithValue("@CDNConfig", version.CDNConfig);
insertComm.Parameters.AddWithValue("@buildid", version.BuildId);
insertComm.Parameters.AddWithValue("@versionsName", version.VersionsName);
insertComm.Parameters.AddWithValue("@productConfig", version.ProductConfig);
insertComm.ExecuteNonQuery();
Console.WriteLine($"{endpoint} : {version.VersionsName} has been added to the Database.");
}
}
public void UpdateEntry(MySqlConnection conn, Versions version, string endpoint, string DatabaseName)
{
try
{
using (var updateComm = new MySqlCommand($"UPDATE `{DatabaseName}_builds` SET `branch` = @Branch, `buildconfig` = @BuildConfig, `cdnconfig` = @CdnConfig, " +
$"`buildid` = @BuildId, `versionsname` = @Version, `productconfig` = @ProductConfig " +
$"WHERE `buildconfig` = @BuildConfig", conn))
{
updateComm.Parameters.AddWithValue("@Branch", MySqlMisc.GetBranch(endpoint));
updateComm.Parameters.AddWithValue("@BuildConfig", version.BuildConfig);
updateComm.Parameters.AddWithValue("@CdnConfig", version.CDNConfig);
updateComm.Parameters.AddWithValue("@BuildId", version.BuildId);
updateComm.Parameters.AddWithValue("@Version", version.VersionsName);
updateComm.Parameters.AddWithValue("@ProductConfig", version.ProductConfig);
updateComm.ExecuteNonQuery();
Console.WriteLine($"{endpoint} : {version.VersionsName} has been updated.");
}
}
catch (Exception ex) { Console.WriteLine(ex); };
}
