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