private void CreateSchemaIfNotExists(System.Data.IDbConnection db)
{
const string createSchemaSQL = @"DO $$
BEGIN
IF NOT EXISTS(
SELECT schema_name
FROM information_schema.schemata
WHERE schema_name = 'TestSchema'
)
THEN
EXECUTE 'CREATE SCHEMA ""TestSchema""';
END IF;
END
$$;";
db.ExecuteSql(createSchemaSQL);
}
private void CreateSchemaIfNotExists(System.Data.IDbConnection db)
{
const string createSchemaSQL = @"DO $$
BEGIN
IF NOT EXISTS(
SELECT 1
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = 'TestSchema'
)
THEN
EXECUTE 'CREATE SCHEMA ""TestSchema""';
END IF;
END
$$;";
db.ExecuteSql(createSchemaSQL);
}
private void CreateSchemaIfNotExists(System.Data.IDbConnection db, string name)
{
string createSchemaSQL = @"DO $$
BEGIN
IF NOT EXISTS(
SELECT schema_name
FROM information_schema.schemata
WHERE schema_name = '{0}'
)
THEN
EXECUTE 'CREATE SCHEMA ""{0}""';
END IF;
END
$$;"
.Fmt(name);
db.ExecuteSql(createSchemaSQL);
}
private void CreateSchemaIfNotExists(System.Data.IDbConnection db, string name)
{
string createSchemaSQL = @"DO $$
BEGIN
IF NOT EXISTS(
SELECT 1
FROM INFORMATION_SCHEMA.SCHEMATA
WHERE SCHEMA_NAME = '{0}'
)
THEN
EXECUTE 'CREATE SCHEMA ""{0}""';
END IF;
END
$$;"
.Fmt(name);
db.ExecuteSql(createSchemaSQL);
}
public override void Drop(System.Data.IDbConnection connection)
{
connection.ExecuteSql(String.Format ("DROP VIEW {0}", Name.FullName));
}
public override void Drop(System.Data.IDbConnection connection)
{
connection.ExecuteSql(String.Format ("DROP SCHEMA {0}", Name.ObjectFormatted));
}
