public static void ClassInitialize(TestContext testContext) { uow = new UnitOfWork(); //uow.DbAdapter.DbConnection.Execute("DROP TABLE testobject;"); //uow.DbAdapter.DbConnection.Execute("DROP TABLE counttest;"); uow.DbAdapter.DbConnection.Execute("CREATE TABLE IF NOT EXISTS testobject (" + "ID BIGINT(20) AUTO_INCREMENT PRIMARY KEY," + "Title VARCHAR(45) NOT NULL UNIQUE," + "Description MEDIUMTEXT," + "StatusID INT NOT NULL," + "InputOn DATETIME NOT NULL," + "InputByID INT NOT NULL," + "IsActive TINYINT(1) NOT NULL) " + "ENGINE=InnoDB;"); uow.DbAdapter.DbConnection.Execute("TRUNCATE TABLE testobject"); uow.DbAdapter.DbConnection.Execute("CREATE TABLE IF NOT EXISTS counttest (" + "Number INT PRIMARY KEY," + "Name VARCHAR(45) NOT NULL UNIQUE) " + "ENGINE=InnoDB;"); uow.DbAdapter.DbConnection.Execute("TRUNCATE TABLE counttest"); CountTestRepository repo = uow.GetRepo <CountTestRepository>(); repo.Add(new CountTest { Number = 1, Name = "Object 1" }); repo.Add(new CountTest { Number = 2, Name = "Object 2" }); repo.Add(new CountTest { Number = 3, Name = "Object 3" }); repo.Add(new CountTest { Number = 4, Name = "Object 4" }); }
public static void ClassInitialize(TestContext testContext) { uow = new UnitOfWork(); uow.DbAdapter.DbConnection.Execute("DROP TABLE testobject"); uow.DbAdapter.DbConnection.Execute("DROP TABLE counttest"); uow.DbAdapter.DbConnection.Execute("DROP TABLE datetest"); uow.DbAdapter.DbConnection.Execute("DELETE FROM FM.CACHEDOTNET"); uow.DbAdapter.DbConnection.Execute("" + "CREATE TABLE testobject (" + //"ID INT PRIMARY KEY, " + // ID column is added automatically "Title VARCHAR(45) NOT NULL UNIQUE," + "Description %String," + "StatusID INT NOT NULL," + "InputOn DATETIME NOT NULL," + "InputByID INT NOT NULL," + "IsActive TINYINT(1) NOT NULL) "); uow.DbAdapter.DbConnection.Execute("" + "CREATE TABLE counttest (" + "Number INT UNIQUE," + "Name VARCHAR(45) NOT NULL UNIQUE) "); uow.DbAdapter.DbConnection.Execute("" + "CREATE TABLE datetest (" + "Title VARCHAR(45) NOT NULL UNIQUE," + "Fileman_DateTime %FilemanTimeStamp," + "Fileman_Date %FilemanDate," + "Sql_DateTime DATETIME," + "Sql_Date DATE) "); CountTestRepository repo = uow.GetRepo <CountTestRepository>(); repo.Add(new CountTest { Number = 1, Name = "Object 1" }); repo.Add(new CountTest { Number = 2, Name = "Object 2" }); repo.Add(new CountTest { Number = 3, Name = "Object 3" }); repo.Add(new CountTest { Number = 4, Name = "Object 4" }); }
public static void ClassInitialize(TestContext testContext) { string dbPath = $"{Environment.CurrentDirectory}\\unittest.db"; uow = new UnitOfWork(dbPath); if (!File.Exists(dbPath)) { SQLiteConnection.CreateFile(dbPath); } uow.DbAdapter.DbConnection.Execute("CREATE TABLE IF NOT EXISTS testobject (" + "ID INTEGER PRIMARY KEY AUTOINCREMENT," + "Title TEXT NOT NULL UNIQUE," + "Description TEXT," + "StatusID INTEGER NOT NULL," + "InputOn TEXT NOT NULL," + "InputByID INTEGER NOT NULL," + "IsActive INTEGER NOT NULL);"); uow.DbAdapter.DbConnection.Execute("DELETE FROM testobject"); uow.DbAdapter.DbConnection.Execute("CREATE TABLE IF NOT EXISTS counttest (" + "Number INTEGER PRIMARY KEY," + "Name TEXT NOT NULL UNIQUE);"); uow.DbAdapter.DbConnection.Execute("DELETE FROM counttest"); CountTestRepository repo = uow.GetRepo <CountTestRepository>(); repo.Add(new CountTest { Number = 1, Name = "Object 1" }); repo.Add(new CountTest { Number = 2, Name = "Object 2" }); repo.Add(new CountTest { Number = 3, Name = "Object 3" }); repo.Add(new CountTest { Number = 4, Name = "Object 4" }); }
public static void ClassInitialize(TestContext testContext) { uow = new UnitOfWork(); //uow.DbAdapter.DbConnection.Execute("DROP TABLE testobject;"); //uow.DbAdapter.DbConnection.Execute("DROP TABLE counttest;"); uow.DbAdapter.DbConnection.Execute("" + "IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='testobject' AND xtype='U')" + "CREATE TABLE testobject (" + "ID BIGINT IDENTITY(1,1) PRIMARY KEY," + "Title NVARCHAR(45) NOT NULL UNIQUE," + "Description NVARCHAR(MAX)," + "StatusID INT NOT NULL," + "InputOn DATETIME NOT NULL," + "InputByID INT NOT NULL," + "IsActive TINYINT NOT NULL)"); uow.DbAdapter.DbConnection.Execute("TRUNCATE TABLE testobject"); uow.DbAdapter.DbConnection.Execute("" + "IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='counttest' AND xtype='U')" + "CREATE TABLE counttest " + "(" + "Number INT PRIMARY KEY," + "Name VARCHAR(45) NOT NULL UNIQUE)"); uow.DbAdapter.DbConnection.Execute("TRUNCATE TABLE counttest"); CountTestRepository repo = uow.GetRepo <CountTestRepository>(); repo.Add(new CountTest { Number = 1, Name = "Object 1" }); repo.Add(new CountTest { Number = 2, Name = "Object 2" }); repo.Add(new CountTest { Number = 3, Name = "Object 3" }); repo.Add(new CountTest { Number = 4, Name = "Object 4" }); }