protected override string GetInsertJournalEntrySql(string scriptName, string applied, string hash, SqlScript script) { var unquotedSchemaTableName = UnquotedSchemaTableName.ToUpper(English); if (script.RedeployOnChange) { return($"insert into {FqSchemaTableName} (ScriptName, Applied, Hash) values (:" + scriptName.Replace("@", "") + ",:" + applied.Replace("@", "") + ",:" + hash.Replace("@", "") + ")"); } else { return($"insert into {unquotedSchemaTableName} (ScriptName, Applied) values (:" + scriptName.Replace("@", "") + ",:" + applied.Replace("@", "") + ")"); } }
protected override string DoesTableExistSql() { var unquotedSchemaTableName = UnquotedSchemaTableName.ToUpper(English); return($"select 1 from user_tables where table_name = '{unquotedSchemaTableName}'"); }
protected override string GetJournalEntriesSql() { var unquotedSchemaTableName = UnquotedSchemaTableName.ToUpper(English); return($"select scriptname from {unquotedSchemaTableName} order by scriptname"); }
protected override string GetInsertJournalEntrySql(string scriptName, string applied) { var unquotedSchemaTableName = UnquotedSchemaTableName.ToUpper(English); return($"insert into {unquotedSchemaTableName} (ScriptName, Applied) values (:" + scriptName.Replace("@", "") + ",:" + applied.Replace("@", "") + ")"); }
protected override string DoesTableExistSql() { var unquotedSchemaTableName = UnquotedSchemaTableName.ToUpper(English); return($"select cast(1 as Int) from systab t where t.table_name = '{unquotedSchemaTableName}'"); }