public void Setup() { var cn = new #if __MonoCS__ SqliteConnection #else SQLiteConnection #endif ("Data Source=:memory:;Version=3;"); //New=true cn.Open(); db = db ?? Db.Init(cn, 30); db.Execute(@"CREATE TABLE Posts ( id INTEGER PRIMARY KEY ASC, name VARCHAR(16), description VARCHAR(128), publish INTEGER, changed DATETIME );INSERT INTO posts(name,description,changed,publish) VALUES('name','description',DATETIME('now'),1)"); }
public void Setup() { var cn = new MySql.Data.MySqlClient.MySqlConnection( System.Configuration.ConfigurationManager.ConnectionStrings[0].ConnectionString); cn.Open(); db = Db.Init(cn, 30); db.Execute(@"CREATE TABLE IF NOT EXISTS profiles( id INT(11) NOT NULL AUTO_INCREMENT , address VARCHAR(32), postcode VARCHAR(32), city VARCHAR(32), facultyId INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY(facultyId) );"); if (db.Profiles.All().Count() == 0) { db.Profiles.Insert(new { Address = "Alam Sari", City = "Kajang", PostCode = 43000, FacultyId = 1 }); } }
public void Setup() { var connectionString = ConfigurationManager.ConnectionStrings ["MySql"].ConnectionString; var cn = new MySqlConnection(connectionString); cn.Open(); db = Db.Init(cn, 30); db.Execute("drop table if exists profiles;"); db.Execute(@"CREATE TABLE profiles( id INT(11) NOT NULL AUTO_INCREMENT , address VARCHAR(32), postcode VARCHAR(32), city VARCHAR(32), facultyId INT(11) NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY(facultyId) );"); db.Execute("drop table if exists reportnote"); db.Execute(@"CREATE TABLE reportnote( UserId INT, SessionId INT, NoterId INT, Note VARCHAR(256), Changed DATETIME, PRIMARY KEY (NoterId), Key(UserId), Key(SessionId) );"); if (db.Profiles.All().Count() == 0) { db.Profiles.Insert(new { Address = "Alam Sari", City = "Kajang", PostCode = 43000, FacultyId = 1 }); } }