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 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; }