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 static string SaveDataMigrationScriptMetadata(DataMigrationScript script) { return(string.Format( "DELETE FROM Rhetos.DataMigrationScript WHERE Active = 0 AND Tag = {0};\r\n" + "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))); }
private IEnumerable <SqlTransactionBatches.SqlScript> UpdateMetadata(DataMigrationScript script) { string updateMetadata = $"UPDATE Rhetos.DataMigrationScript SET Down = {SqlUtility.QuoteText(script.Down)}" + $" WHERE Tag = {SqlUtility.QuoteText(script.Tag)};"; yield return(new SqlTransactionBatches.SqlScript { Sql = updateMetadata, IsBatch = false, Name = null }); }
private IEnumerable <SqlBatchScript> RemoveScriptAndMetadata(DataMigrationScript script) { string removeMetadata = $"UPDATE Rhetos.DataMigrationScript SET Active = 0 WHERE Tag = {SqlUtility.QuoteText(script.Tag)};"; if (!string.IsNullOrEmpty(script.Down)) { yield return new SqlBatchScript { Sql = script.Down, IsBatch = true, Name = script.Path } } ; yield return(new SqlBatchScript { Sql = removeMetadata, IsBatch = false, Name = null }); }
private IEnumerable <SqlTransactionBatches.SqlScript> AddScriptAndMetadata(DataMigrationScript script) { string addMetadata = string.Format( "DELETE FROM Rhetos.DataMigrationScript WHERE Active = 0 AND Tag = {0};\r\n" + "INSERT INTO Rhetos.DataMigrationScript (Tag, Path, Content, Down, Active) VALUES ({0}, {1}, {2}, {3}, 1);", SqlUtility.QuoteText(script.Tag), SqlUtility.QuoteText(script.Path), SqlUtility.QuoteText(script.Content), SqlUtility.QuoteText(script.Down)); yield return(new SqlTransactionBatches.SqlScript { Sql = script.Content, IsBatch = true, Name = script.Path }); yield return(new SqlTransactionBatches.SqlScript { Sql = addMetadata, IsBatch = false, Name = null }); }
protected void LogScript(string msg, DataMigrationScript script, EventType eventType = EventType.Trace) { _logger.Write(eventType, () => msg + " " + script.Path + " (tag " + script.Tag + ")"); }