protected virtual DatabaseSchema GetDatabase (DataRow row)
{
DatabaseSchema schema = new DatabaseSchema (this);
schema.Name = GetRowString (row, databaseItemStrings[0]);
return schema;
}
public override void DropDatabase(DatabaseSchema db)
{
connectionPool.Close();
System.IO.File.Delete(db.Name);
}
public SqlServerDatabaseSchema (DatabaseSchema schema):base(schema)
{
}
//http://www.postgresql.org/docs/8.2/interactive/sql-alterdatabase.html
public override void AlterDatabase (DatabaseSchema database)
{
throw new NotImplementedException ();
//http://www.postgresql.org/docs/8.2/interactive/sql-dropdatabase.html
public override void DropDatabase(DatabaseSchema database)
{
ExecuteNonQuery("DROP DATABASE IF EXISTS " + database.Name + ";");
}
public virtual DatabaseSchema GetNewDatabaseSchema (string name)
{
DatabaseSchema schema = new DatabaseSchema (this);
schema.Name = name;
return schema;
}
private void OnCreateDatabaseThreaded (object state)
{
DatabaseConnectionContext context = state as DatabaseConnectionContext;
ISchemaProvider schemaProvider = context.SchemaProvider;
DatabaseSchema db = new DatabaseSchema (schemaProvider);
db.Name = context.ConnectionSettings.Database;
schemaProvider.CreateDatabase (db);
DispatchService.GuiDispatch (delegate () {
WaitDialog.HideDialog ();
ConnectionContextService.AddDatabaseConnectionContext (context);
});
}
public virtual void CreateDatabase(DatabaseSchema database)
{
throw new NotImplementedException();
}
public DatabaseSchema(DatabaseSchema schema)
: base(schema)
{
}
public override void DropDatabase (DatabaseSchema db)
{
connectionPool.Close ();
System.IO.File.Delete (db.Name);
}
public virtual void RenameDatabase(DatabaseSchema database, string name)
{
throw new NotImplementedException();
}
public override void CreateDatabase (DatabaseSchema database)
{
//TODO: error if db exists
Runtime.LoggingService.Error ("CREATE START");
SqliteConnection conn = new SqliteConnection ("URI=file:" + database.Name + ";Version=3;");
conn.Open ();
conn.Close ();
Runtime.LoggingService.Error ("CREATE STOP");
}
//http://www.postgresql.org/docs/8.2/interactive/sql-alterdatabase.html
public override void RenameDatabase (DatabaseSchema database, string name)
{
ExecuteNonQuery ("ALTER DATABASE " + database.Name + " RENAME TO " + name + ";");
connectionPool.ConnectionContext.ConnectionSettings.Database = name;
database.Name = name;
//http://www.postgresql.org/docs/8.2/interactive/sql-dropdatabase.html
public override void DropDatabase (DatabaseSchema database)
{
ExecuteNonQuery ("DROP DATABASE IF EXISTS " + database.Name + ";");
public virtual void DropDatabase (DatabaseSchema database)
{
throw new NotImplementedException ();
}
protected override void OnBeforeDatabaseCreation (DatabaseSchema schema)
{
createDBWidget.SetDatabaseOptions ((NpgsqlDatabaseSchema)schema);
base.OnBeforeDatabaseCreation (schema);
}
public virtual void RenameDatabase (DatabaseSchema database, string name)
{
throw new NotImplementedException ();
}
// public override DataTypeSchema GetDataType (string name)
// {
// if (name == null)
// throw new ArgumentNullException ("name");
// name = name.ToUpper ();
//
// DataTypeSchema dts = new DataTypeSchema (this);
// dts.Name = name;
// switch (name) {
// //TODO: IMPLEMENT
// case "":
// break;
// default:
// dts = null;
// break;
// }
//
// return dts;
// }
//http://www.postgresql.org/docs/8.2/interactive/sql-createdatabase.html
public override void CreateDatabase(DatabaseSchema database)
{
ExecuteNonQuery("CREATE DATABASE " + database.Name);
}
protected virtual void OnBeforeDatabaseCreation (DatabaseSchema schema)
{
}
//http://www.postgresql.org/docs/8.2/interactive/sql-alterdatabase.html
public override void AlterDatabase(DatabaseSchema database)
{
throw new NotImplementedException();
}
public DatabaseSchema (DatabaseSchema schema)
: base (schema)
{
}
// public override DataTypeSchema GetDataType (string name)
// {
// if (name == null)
// throw new ArgumentNullException ("name");
// name = name.ToUpper ();
//
// DataTypeSchema dts = new DataTypeSchema (this);
// dts.Name = name;
// switch (name) {
// //TODO: IMPLEMENT
// case "":
// break;
// default:
// dts = null;
// break;
// }
//
// return dts;
// }
//http://www.postgresql.org/docs/8.2/interactive/sql-createdatabase.html
public override void CreateDatabase (DatabaseSchema database)
{
ExecuteNonQuery ("CREATE DATABASE " + database.Name);
