public override void SetUp()
{
base.SetUp();
myDB = myMockery.NewMock <IDatabaseSC>();
var serviceProvider = new ServiceProvider();
serviceProvider.RegisterService("TOM Database", myDB);
myScriptingInterface = new ScriptingInterface();
myScriptingInterface.Init(serviceProvider);
// prepare data
mySchema = CreateSchema("test1");
myMgr = myScriptingInterface.GetManager(mySchema);
myMgr.CreateTable();
// add some data
ScopedTable table = myMgr.Query(0);
AddRow(table, 0, 0, new DateTime(2001, 1, 1), 1);
AddRow(table, 0, 0, new DateTime(2002, 1, 1), 2);
AddRow(table, 0, 1, new DateTime(2002, 1, 1), 12);
AddRow(table, 0, 0, new DateTime(2003, 1, 1), 3);
AddRow(table, 0, 1, new DateTime(2003, 1, 1), 13);
AddRow(table, 0, 2, new DateTime(2003, 1, 1), 23);
AddRow(table, 0, 0, new DateTime(2004, 1, 1), 4);
AddRow(table, 0, 1, new DateTime(2005, 1, 1), 15);
table = myMgr.Query(1);
AddRow(table, 1, 1, new DateTime(2002, 1, 1), 112);
}
public TomSchemaBuilder()
{
myDB = Engine.ServiceProvider.Database();
myUpdateActions = new List <IDBUpdateAction>();
BuildUpdateActions();
}
protected override void Dispose(bool disposing)
{
try
{
if (IsDisposed)
{
return;
}
if (disposing)
{
myInMemoryDB.Tables.ToSet().Foreach(t => t.Dispose());
myInMemoryDB.Tables.Clear();
myInMemoryDB.Dispose();
foreach (ITableManager mgr in myManagers.Values)
{
mgr.TryDispose();
}
myManagers.Clear();
}
myPersistentDB = null;
myInMemoryDB = null;
myManagers = null;
}
finally
{
base.Dispose(disposing);
}
}
protected override void Dispose(bool disposing)
{
try
{
if (IsDisposed)
{
return;
}
if (disposing)
{
myFindByOwnerIdCmd.TryDispose();
myFindByOwnerIdAndFromToCmd.TryDispose();
myInsertCmd.TryDispose();
myUpdateCmd.TryDispose();
myRemoveCmd.TryDispose();
}
myDB = null;
mySchema = null;
myFindByOwnerIdAndFromToCmd = null;
myInsertCmd = null;
myUpdateCmd = null;
myRemoveCmd = null;
}
finally
{
base.Dispose(disposing);
}
}
public TomSchemaBuilder()
{
myDB = Engine.ServiceProvider.Database();
myUpdateActions = new List<IDBUpdateAction>();
BuildUpdateActions();
}
public override void Fini()
{
myLogger.Info("Deinitializing Tom database");
IDatabaseSC db = (IDatabaseSC)Engine.ServiceProvider.GetService("TOM Database");
Engine.ServiceProvider.UnregisterService("TOM Database");
db.Dispose();
}
public override void TearDown()
{
Interpreter.Context.TomScripting.Dispose();
myServiceProvider.Reset();
myInterpreter = null;
myServiceProvider = null;
myDataAccess = null;
base.TearDown();
}
public override void TearDown()
{
Interpreter.Context.TomScripting.Dispose();
myServiceProvider.Reset();
myInterpreter = null;
myServiceProvider = null;
myDataAccess = null;
base.TearDown();
}
public void Execute(IDatabaseSC db)
{
if (db.ExistsTable(TableName))
{
myLogger.Debug("Table {0} already exists. Skipping", TableName);
return;
}
myLogger.Debug("Creating table {0}", TableName);
db.Execute(CreateCmd);
}
public void Execute( IDatabaseSC db )
{
if ( db.ExistsTable( TableName ) )
{
myLogger.Debug( "Table {0} already exists. Skipping", TableName );
return;
}
myLogger.Debug( "Creating table {0}", TableName );
db.Execute( CreateCmd );
}
public override void SetUp()
{
base.SetUp();
myDataAccess = myMockery.NewMock<IDatabaseSC>();
myServiceProvider = Engine.ServiceProvider;
myServiceProvider.RegisterService( "TOM Database", myDataAccess );
myServiceProvider.RegisterService( typeof( IEntityRepositoryFactory ), new FakeEntityRepositoryFactory() );
myServiceProvider.ConfigurationSC().Import( Path.Combine( MauiHome, "config" ), true );
ScriptingInterface tomScripting = new ScriptingInterface();
tomScripting.Init( myServiceProvider );
myServiceProvider.RegisterService( typeof( ScriptingInterface ), tomScripting );
myInterpreter = new Interpreter();
myInterpreter.Init( myServiceProvider );
//myInterpreter.DumpErrorToConsole = true;
myInterpreter.Start();
}
public override void SetUp()
{
base.SetUp();
myDataAccess = myMockery.NewMock <IDatabaseSC>();
myServiceProvider = Engine.ServiceProvider;
myServiceProvider.RegisterService("TOM Database", myDataAccess);
myServiceProvider.RegisterService(typeof(IEntityRepositoryFactory), new FakeEntityRepositoryFactory());
myServiceProvider.ConfigurationSC().Import(Path.Combine(MauiHome, "config"), true);
ScriptingInterface tomScripting = new ScriptingInterface();
tomScripting.Init(myServiceProvider);
myServiceProvider.RegisterService(typeof(ScriptingInterface), tomScripting);
myInterpreter = new Interpreter();
myInterpreter.Init(myServiceProvider);
//myInterpreter.DumpErrorToConsole = true;
myInterpreter.Start();
}
public void Execute(IDatabaseSC db)
{
db.Execute(UpdateCmd);
}
public void Rollback( IDatabaseSC db )
{
myLogger.Debug( "Dropping table {0}", TableName );
db.Execute( "drop table " + TableName );
}
internal PersistentTableManager(IDatabaseSC db, TableSchema schema)
{
myDB = db;
Name = schema.Name;
mySchema = schema;
}
public void Init(ServiceProvider serviceProvider)
{
myPersistentDB = serviceProvider.Database();
myInMemoryDB = new DataSet("InMemoryDB");
myManagers = new Dictionary <string, ITableManager>();
}
private void InsertKey(IDatabaseSC db)
{
var cmd = string.Format("INSERT INTO db_metadata VALUES ( '{0}', '{1}' );", Key, Value);
db.Execute(cmd);
}
public void Execute(IDatabaseSC db)
{
DeleteKey(db);
InsertKey(db);
}
public void Execute( IDatabaseSC db )
{
db.Execute( UpdateCmd );
}
public override void SetUp()
{
base.SetUp();
myDB = myMockery.NewMock<IDatabaseSC>();
var serviceProvider = new ServiceProvider();
serviceProvider.RegisterService( "TOM Database", myDB );
myScriptingInterface = new ScriptingInterface();
myScriptingInterface.Init( serviceProvider );
// prepare data
mySchema = CreateSchema( "test1" );
myMgr = myScriptingInterface.GetManager( mySchema );
myMgr.CreateTable();
// add some data
ScopedTable table = myMgr.Query( 0 );
AddRow( table, 0, 0, new DateTime( 2001, 1, 1 ), 1 );
AddRow( table, 0, 0, new DateTime( 2002, 1, 1 ), 2 );
AddRow( table, 0, 1, new DateTime( 2002, 1, 1 ), 12 );
AddRow( table, 0, 0, new DateTime( 2003, 1, 1 ), 3 );
AddRow( table, 0, 1, new DateTime( 2003, 1, 1 ), 13 );
AddRow( table, 0, 2, new DateTime( 2003, 1, 1 ), 23 );
AddRow( table, 0, 0, new DateTime( 2004, 1, 1 ), 4 );
AddRow( table, 0, 1, new DateTime( 2005, 1, 1 ), 15 );
table = myMgr.Query( 1 );
AddRow( table, 1, 1, new DateTime( 2002, 1, 1 ), 112 );
}
public void Rollback(IDatabaseSC db)
{
myLogger.Debug("Dropping table {0}", TableName);
db.Execute("drop table " + TableName);
}
public void Rollback( IDatabaseSC db )
{
db.Execute( RollbackCmd );
}
public void Rollback(IDatabaseSC db)
{
db.Execute(RollbackCmd);
}
private void InsertKey( IDatabaseSC db )
{
var cmd = string.Format( "INSERT INTO db_metadata VALUES ( '{0}', '{1}' );", Key, Value );
db.Execute( cmd );
}
public void Rollback( IDatabaseSC db )
{
DeleteKey( db );
}
private void DeleteKey(IDatabaseSC db)
{
var cmd = string.Format("DELETE FROM db_metadata where key == '{0}';", Key);
db.Execute(cmd);
}
protected override void Dispose( bool disposing )
{
try
{
if ( IsDisposed )
{
return;
}
if ( disposing )
{
myFindByOwnerIdCmd.TryDispose();
myFindByOwnerIdAndFromToCmd.TryDispose();
myInsertCmd.TryDispose();
myUpdateCmd.TryDispose();
myRemoveCmd.TryDispose();
}
myDB = null;
mySchema = null;
myFindByOwnerIdAndFromToCmd = null;
myInsertCmd = null;
myUpdateCmd = null;
myRemoveCmd = null;
}
finally
{
base.Dispose( disposing );
}
}
public void Rollback(IDatabaseSC db)
{
DeleteKey(db);
}
internal PersistentTableManager( IDatabaseSC db, string name )
{
myDB = db;
Name = name;
}
private void DeleteKey( IDatabaseSC db )
{
var cmd = string.Format( "DELETE FROM db_metadata where key == '{0}';", Key );
db.Execute( cmd );
}
internal PersistentTableManager( IDatabaseSC db, TableSchema schema )
{
myDB = db;
Name = schema.Name;
mySchema = schema;
}
public void Execute( IDatabaseSC db )
{
DeleteKey( db );
InsertKey( db );
}
internal PersistentTableManager(IDatabaseSC db, string name)
{
myDB = db;
Name = name;
}
