public override string SerializeViewExists(SQLViewExists viewExists)
{
var select = new SQLSelect();
select.Tables.Add("X$VIEW");
select.Where.Add("Xv$Name", ComparisonOperator.EqualTo, viewExists.ViewName);
return SerializeSelect(select);
}
/// <summary> /// Should return the SELECT statement for determining whether a view exists. /// If a row is returned then the view exists. /// </summary> public abstract string SerializeViewExists(SQLViewExists viewExists);
public override string SerializeViewExists(SQLViewExists viewExists)
{
throw new NotSupportedException();
}
public override string SerializeViewExists(SQLViewExists viewExists)
{
var select = new SQLSelect();
select.Tables.Add("VIEWS").SchemaName = "INFORMATION_SCHEMA";
select.Where.Add("TABLE_SCHEMA", ComparisonOperator.EqualTo, "PUBLIC");
select.Where.Add("TABLE_NAME", ComparisonOperator.EqualTo, viewExists.ViewName);
return SerializeSelect(select);
}
public override string SerializeViewExists(SQLViewExists viewExists)
{
var select = new SQLSelect();
select.Tables.Add("sqlite_master");
select.Where.Add("Type", ComparisonOperator.EqualTo, "View");
select.Where.Add("Name", ComparisonOperator.EqualTo, viewExists.ViewName);
return SerializeSelect(select);
}
