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()); }