public async Task TableSchema(DbClient client)
{
TableSchema schema = await client.GetTableSchema("people");
Assert.IsFalse(schema == null);
Assert.AreEqual(3, schema.Count());
TableField id = schema["id"];
Assert.IsFalse(id == null);
Assert.AreEqual("id", id.Name);
if (!(client is SqlServer.SqlServerClient))
{
Assert.AreEqual(KeyType.Primary, id.Key);
}
if (!(client is Sqlite.SqliteClient) &&
!(client is SqlServer.SqlServerClient))
{
Assert.AreEqual(true, id.AutoIncrement);
Assert.AreEqual(true, id.NotNull);
}
TableField name = schema["name"];
Assert.IsFalse(name == null);
Assert.AreEqual(typeof(string), name.Type);
TableField bd = schema["birthday"];
Assert.IsFalse(bd == null);
Assert.AreEqual(typeof(DateTime), bd.Type);
client.Dispose();
}
