public void generate_simple_document_table()
{
var mapping = new DocumentMapping(typeof(MySpecialDocument));
var builder = new StringWriter();
mapping.WriteSchemaObjects(null, builder);
var sql = builder.ToString();
sql.ShouldContain("CREATE TABLE mt_doc_documentmappingtests_myspecialdocument");
sql.ShouldContain("jsonb NOT NULL");
}
public void write_upsert_sql()
{
var mapping = new DocumentMapping(typeof(MySpecialDocument));
var builder = new StringWriter();
mapping.WriteSchemaObjects(null, builder);
var sql = builder.ToString();
sql.ShouldContain("INSERT INTO mt_doc_documentmappingtests_myspecialdocument");
sql.ShouldContain("CREATE OR REPLACE FUNCTION mt_upsert_documentmappingtests_myspecialdocument");
}
public void generate_table_with_indexes()
{
var mapping = new DocumentMapping(typeof(User));
var i1 = mapping.AddIndex("first_name");
var i2 = mapping.AddIndex("last_name");
var builder = new StringWriter();
mapping.WriteSchemaObjects(null, builder);
var sql = builder.ToString();
sql.ShouldContain(i1.ToDDL());
sql.ShouldContain(i2.ToDDL());
}
