예제 #1
0
        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");
        }
예제 #2
0
        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");
        }