protected static string SaveDataMigrationScriptEntiry(DataMigrationScript script)
{
return string.Format(
"INSERT INTO Rhetos.DataMigrationScript (Tag, Path, Content) VALUES ({0}, {1}, {2})",
SqlUtility.QuoteText(script.Tag),
SqlUtility.QuoteText(script.Path),
SqlUtility.QuoteText(script.Content));
}
protected void LogScript(string msg, DataMigrationScript script, EventType eventType = EventType.Trace)
{
_logger.Write(eventType, () => msg + " " + script.Path + " (" + script.Tag + ")");
}
protected static string SaveDataMigrationScriptMetadata(DataMigrationScript script)
{
return string.Format(
"DELETE FROM Rhetos.DataMigrationScript WHERE Active = 0 AND Tag = {0};"
+ "INSERT INTO Rhetos.DataMigrationScript (Tag, Path, Content, Active) VALUES ({0}, {1}, {2}, 1);",
SqlUtility.QuoteText(script.Tag),
SqlUtility.QuoteText(script.Path),
SqlUtility.QuoteText(script.Content));
}
