/// <summary>
/// Outputs statements for creation of new <see cref="PgRule"/>s.
/// </summary>
internal static void Create(StreamWriter writer, PgSchema oldSchema, PgSchema newSchema, SearchPathHelper searchPathHelper)
{
foreach (var rule in newSchema.Rules)
{
if (oldSchema == null || !oldSchema.Contains(rule))
{
searchPathHelper.OutputSearchPath(writer);
writer.WriteLine();
writer.WriteLine(rule.CreationSql);
}
}
}
internal static void Drop(StreamWriter writer, PgSchema oldSchema, PgSchema newSchema, SearchPathHelper searchPathHelper)
{
if (oldSchema == null)
{
return;
}
var referencedRules = new Dictionary <string, List <PgRule> >();
var dropedRules = new List <PgRule>();
foreach (var rule in oldSchema.Rules)
{
if (!newSchema.Contains(rule))
{
searchPathHelper.OutputSearchPath(writer);
writer.WriteLine();
writer.WriteLine(rule.DropSql);
}
}
}