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}'");
}