public void AddFieldByString()
{
var provider = new SqliteContextProvider(ConnectionString);
var logger = new MessageStackLogger();
provider.Settings.AddLogger(logger);
using (var context = provider.Open())
{
context.Database.Table<Warrior>().Ignore(wrir => wrir.Race).Create();
context.Database.Table<Warrior>().Column("Race", FieldOperation.Add, typeof(string)).Alter();
context.Commit();
}
}
public void CreateTableNotNullableColumn()
{
CreateDatabaseIfNotExists();
var provider = new SqlContextProvider(GetConnectionString("WarriorDB"));
var logger = new MessageStackLogger();
provider.Settings.AddLogger(logger);
using (var context = provider.Open())
{
// table with a foreign key
context.Database.Table<Warrior>()
.Column(wrir => wrir.ID, isNullable: false)
.Column(wrir => wrir.Race, isNullable: false)
.Create();
context.Commit();
Assert.AreEqual(logger.Logs.First().Message.Flatten(), "CREATE TABLE Warrior (ID int NOT NULL, Race varchar(max) NOT NULL, Name varchar(max), WeaponID int NOT NULL, SpecialSkill varchar(max))");
}
}
public void CreateTableNotNullableColumn()
{
var provider = new SqliteContextProvider(ConnectionString);
var logger = new MessageStackLogger();
provider.Settings.AddLogger(logger);
using (var context = provider.Open())
{
// table with a foreign key
context.Database.Table<Warrior>()
.Column(wrir => wrir.ID)
.Column(wrir => wrir.Race, isNullable: false)
.Create();
Assert.IsFalse(File.Exists(DatabaseName));
//context.QueryCommandStore.First().Execute(context);
context.Commit();
Assert.AreEqual(logger.Logs.First().Message.Flatten(), "CREATE TABLE IF NOT EXISTS Warrior (ID int NOT NULL, Race varchar(1000) NOT NULL, Name varchar(1000), WeaponID int NOT NULL, SpecialSkill varchar(1000))");
}
}