public void TestCreateAndInsert()
{
var ctx = ModelContext.GetInstance(typeof(PeopleModel2));
var o = new PeopleModel2 {Name = "tom"};
ctx.Operator.Save(o);
Assert.AreEqual(4, StaticRecorder.Messages.Count);
Assert.AreEqual("CREATE TABLE \"PEOPLE\" (\"ID\" BIGINT NOT NULL PRIMARY KEY,\"NAME\" VARCHAR (5) CHARACTER SET UNICODE_FSS NOT NULL);<Text><30>()", StaticRecorder.Messages[0]);
Assert.AreEqual("CREATE GENERATOR GEN_PEOPLE_ID;<Text><30>()", StaticRecorder.Messages[1]);
Assert.AreEqual("SELECT GEN_ID(GEN_PEOPLE_ID, 1) FROM RDB$DATABASE<Text><30>()", StaticRecorder.Messages[2]);
// TODO: why the ID is int32 ?
Assert.AreEqual(string.Format("INSERT INTO \"PEOPLE\" (\"NAME\",\"ID\") VALUES (@Name_0,@Id_1);<Text><30>(@Name_0=tom:String,@Id_1={0}:Int32)", o.Id), StaticRecorder.Messages[3]);
}
public void TestCreateAndInsert()
{
var ctx = ModelContext.GetInstance(typeof(PeopleModel2));
var o = new PeopleModel2 {
Name = "tom"
};
ctx.Operator.Save(o);
Assert.AreEqual(4, StaticRecorder.Messages.Count);
Assert.AreEqual("CREATE TABLE \"PEOPLE\" (\"ID\" BIGINT NOT NULL PRIMARY KEY,\"NAME\" VARCHAR (5) CHARACTER SET UNICODE_FSS NOT NULL);<Text><30>()", StaticRecorder.Messages[0]);
Assert.AreEqual("CREATE GENERATOR GEN_PEOPLE_ID;<Text><30>()", StaticRecorder.Messages[1]);
Assert.AreEqual("SELECT GEN_ID(GEN_PEOPLE_ID, 1) FROM RDB$DATABASE<Text><30>()", StaticRecorder.Messages[2]);
// TODO: why the ID is int32 ?
Assert.AreEqual(string.Format("INSERT INTO \"PEOPLE\" (\"NAME\",\"ID\") VALUES (@Name_0,@Id_1);<Text><30>(@Name_0=tom:String,@Id_1={0}:Int32)", o.Id), StaticRecorder.Messages[3]);
}