public void CreateTableTypes()
{
var i = 1;
var query = Query
.CreateTable("foobar")
.Field <bool>("test" + i++)
.Field <sbyte>("test" + i++)
.Field <byte>("test" + i++)
.Field <short>("test" + i++)
.Field <ushort>("test" + i++)
.Field <int>("test" + i++)
.Field <uint>("test" + i++)
.Field <long>("test" + i++)
.Field <ulong>("test" + i++)
.Field <float>("test" + i++)
.Field <double>("test" + i++)
.Field <string>("test" + i++)
.Field <string>("test" + i++, 100)
.Field <DateTime>("test" + i++)
;
var builder = new SQLiteQueryBuilder();
var queryString = builder.GetQueryString(query);
Assert.Equal("CREATE TABLE `foobar` (`test1` integer, `test2` integer, `test3` integer, `test4` integer, `test5` integer, `test6` integer, `test7` integer, `test8` integer, `test9` integer, `test10` real, `test11` real, `test12` text, `test13` text, `test14` text) ;", queryString);
}
public void CreateTable()
{
var query = Query
.CreateTable("foobar")
.Field <int>("foobarId", FieldOptions.NotNull | FieldOptions.PrimaryKey | FieldOptions.AutoIncrement)
.Field <string>("name", 100, FieldOptions.NotNull)
.Field <string>("info");
var builder = new SQLiteQueryBuilder();
var queryString = builder.GetQueryString(query);
Assert.Equal("CREATE TABLE `foobar` (`foobarId` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` text NOT NULL, `info` text) ;", queryString);
}
public void CreateTablePrimaryKey()
{
var query = Query
.CreateTable("foobar")
.Field <int>("foobarId", FieldOptions.PrimaryKey);
var builder = new SQLiteQueryBuilder();
var queryString = builder.GetQueryString(query);
Assert.Equal("CREATE TABLE `foobar` (`foobarId` integer PRIMARY KEY) ;", queryString);
query = Query
.CreateTable("foobar")
.Field <int>("foobarId1", FieldOptions.PrimaryKey)
.Field <int>("foobarId2", FieldOptions.PrimaryKey);
builder = new SQLiteQueryBuilder();
queryString = builder.GetQueryString(query);
Assert.Equal("CREATE TABLE `foobar` (`foobarId1` integer, `foobarId2` integer, PRIMARY KEY (`foobarId1`, `foobarId2`)) ;", queryString);
}