private void DropCreateTestTables() { string propertyTableSql = "" + "CREATE TABLE Property (Id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, Name text, Address text)"; _db.TryDropTable("Property"); _db.TransactDDL(propertyTableSql); string BuildingTableSql = "" + "CREATE TABLE Building ( BIN text PRIMARY KEY NOT NULL, Identifier text, PropertyId int )"; _db.TryDropTable("Building"); if (!_db.TableExists("Building")) { _db.TransactDDL(BuildingTableSql); } string UnitTableSql = "" + "CREATE TABLE unit ( unit_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, BIN TEXT, unit_no TEXT )"; _db.TryDropTable("unit"); _db.TransactDDL(UnitTableSql); string WorkOrderTableSql = "" + "CREATE TABLE wk_order ( wo_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, desc text)"; _db.TryDropTable("wk_order"); _db.TransactDDL(WorkOrderTableSql); }
public void Creates_table_with_string_id() { // The Guitar test object has a string field named simply SKU. This will not be matched // without an attribute decoration, and horrible plague and pesilence will result. _db.TryDropTable("guitardocuments"); var guitarstore = new SqliteDocumentStore <GuitarDocuments>(_db); bool exists = _db.TableExists(guitarstore.TableName); Assert.IsTrue(exists); }
private void DropCreateTestTables() { string BuildingTableSql = "" + "CREATE TABLE Building ( BIN text PRIMARY KEY NOT NULL, Identifier text, PropertyId int )"; _db.TryDropTable("Building"); if (!_db.TableExists("Building")) { _db.TransactDDL(BuildingTableSql); } }
public void Creates_table_with_string_id() { // The Instrument test object has an int field named simply Id. Without any // Attribute decoration, this should result in a table with a serial int PK. // NOTE: Gotta go look to see if the field is a serial in or not... //var db = new CommandRunner("chinook"); var InstrumentStore = new SqliteDocumentStore <InstrumentDocuments>(_db); bool exists = _db.TableExists(InstrumentStore.TableName); Assert.IsTrue(exists); }
public void Creates_table_with_int_id() { // The Widget test object has an int field named Identifier. This will not be matched // without an attribute decoration, and horrible plague and pesilence will result. Also, // the attribute IsAuto property is set to false, so the field will NOT be a serial key. _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db); bool exists = _db.TableExists(widgetstore.TableName); Assert.IsTrue(exists); }
public override void DropCreateAll(bool forceDropCreateTables) { if (!forceDropCreateTables) { return; } const string urlItemSql = @" CREATE TABLE UrlItem ( Id INTEGER PRIMARY KEY AUTOINCREMENT , CustomUrl VARCHAR(1000) , OriginUrl VARCHAR(2000) NOT NULL , ExpireInDays DOUBLE NOT NULL , ExpireMode SMALLINT NOT NULL , CreatedOn DATETIME NOT NULL );"; const string urlHitSql = @" CREATE TABLE UrlHit ( Id INTEGER PRIMARY KEY AUTOINCREMENT , UrlItemId INTEGER , ClientIp VARCHAR(45) , HitOn DATETIME NOT NULL );"; if (_db.TableExists("UrlItem")) { _db.TryDropTable("UrlItem"); } if (_db.TableExists("UrlHit")) { _db.TryDropTable("UrlHit"); } _db.TransactDDL(urlItemSql); _db.TransactDDL(urlHitSql); }
public void Creates_table_with_serial_id() { // The Company test object has an int field named simply "Id". Without any // Attribute decoration, this should result in a table with a serial int PK. // NOTE: Gotta go look to see if the field is a serial in or not... //var db = new CommandRunner("chinook"); _db.TryDropTable("companydocuments"); var companyStore = new SqliteDocumentStore <CompanyDocuments>(_db); bool exists = _db.TableExists(companyStore.TableName); Assert.IsTrue(exists); }
public void Table_Created_Created_for_SQLite_Store_With_Biggylist() { Assert.True(_db.TableExists("Property")); }
public void Table_Created_Created_for_Sqlite_Store_With_Biggylist() { Assert.True(_db.TableExists("propertydocuments")); }