/// <summary>
/// Get SQLServer script to check if record exist
/// </summary>
/// <param name="recordExist"></param>
/// <returns></returns>
protected override string GetRecordExistScript(RecordExistRule recordExist)
{
var query = new Query(recordExist.TableName)
.Select("*")
.Where(recordExist.ColumnName, recordExist.Operator, recordExist.Value);
var result = _sqlServerCompiler.Compile(query);
return($"IF EXISTS ({result}) BEGIN Select 1 END ELSE BEGIN Select 0 END;");
}
/// <summary>
/// Get PostgreSQL script to check if record exist
/// </summary>
/// <param name="recordExist"></param>
/// <returns></returns>
protected override string GetRecordExistScript(RecordExistRule recordExist)
{
var query = new Query(recordExist.TableName)
.Select("*")
.Where(recordExist.ColumnName, recordExist.Operator, recordExist.Value);
var result = _postgresCompiler.Compile(query);
return($"SELECT EXISTS({result});");
}
/// <summary> /// Get script to check if record exist /// </summary> /// <param name="recordExist"></param> /// <returns></returns> protected abstract string GetRecordExistScript(RecordExistRule recordExist);
