public void write_ddl_in_default_drop_then_create_mode() { var users = DocumentMapping.For <User>(); var table = new DocumentTable(users); var rules = new PostgresqlMigrator { TableCreation = CreationStyle.DropThenCreate }; var ddl = table.ToCreateSql(rules); ddl.ShouldContain("DROP TABLE IF EXISTS public.mt_doc_user CASCADE;"); ddl.ShouldContain("CREATE TABLE public.mt_doc_user"); }
public void write_ddl_in_create_if_not_exists_mode() { var users = DocumentMapping.For <User>(); var table = new DocumentTable(users); var rules = new PostgresqlMigrator { TableCreation = CreationStyle.CreateIfNotExists }; var ddl = table.ToCreateSql(rules); ddl.ShouldNotContain("DROP TABLE IF EXISTS public.mt_doc_user CASCADE;"); ddl.ShouldContain("CREATE TABLE IF NOT EXISTS public.mt_doc_user"); }