Пример #1
0
        public void OnTableCompositeCreate(IQuery systemQuery)
        {
            // SYSTEM.SEQUENCE_INFO
            var tableInfo = new TableInfo(SequenceManager.SequenceInfoTableName);

            tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("schema", PrimitiveTypes.String());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("type", PrimitiveTypes.Numeric());
            tableInfo = tableInfo.AsReadOnly();
            systemQuery.Access().CreateTable(tableInfo);

            // SYSTEM.SEQUENCE
            tableInfo = new TableInfo(SequenceManager.SequenceTableName);
            tableInfo.AddColumn("seq_id", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("last_value", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("increment", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("minvalue", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("maxvalue", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("start", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("cache", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("cycle", PrimitiveTypes.Boolean());
            tableInfo = tableInfo.AsReadOnly();
            systemQuery.Access().CreateTable(tableInfo);
        }
Пример #2
0
        private static void Create(IQuery systemQuery)
        {
            // SYSTEM.ROUTINE
            systemQuery.Access()
                .CreateTable(table => table
                    .Named(RoutineManager.RoutineTableName)
                    .WithColumn("id", PrimitiveTypes.Numeric())
                    .WithColumn("schema", PrimitiveTypes.String())
                    .WithColumn("name", PrimitiveTypes.String())
                    .WithColumn("type", PrimitiveTypes.String())
                    .WithColumn("location", PrimitiveTypes.String())
                    .WithColumn("body", PrimitiveTypes.Binary())
                    .WithColumn("return_type", PrimitiveTypes.String())
                    .WithColumn("username", PrimitiveTypes.String()));

            // SYSTEM.ROUTINE_PARAM
            systemQuery.Access().CreateTable(table => table
                .Named(RoutineManager.RoutineParameterTableName)
                .WithColumn("routine_id", PrimitiveTypes.Numeric())
                .WithColumn("arg_name", PrimitiveTypes.String())
                .WithColumn("arg_type", PrimitiveTypes.String())
                .WithColumn("arg_attrs", PrimitiveTypes.Numeric())
                .WithColumn("in_out", PrimitiveTypes.Integer())
                .WithColumn("offset", PrimitiveTypes.Integer()));
        }
        private static void Create(IQuery systemQuery)
        {
            // SYSTEM.ROUTINE
            systemQuery.Access()
            .CreateTable(table => table
                         .Named(RoutineManager.RoutineTableName)
                         .WithColumn("id", PrimitiveTypes.Numeric())
                         .WithColumn("schema", PrimitiveTypes.String())
                         .WithColumn("name", PrimitiveTypes.String())
                         .WithColumn("type", PrimitiveTypes.String())
                         .WithColumn("location", PrimitiveTypes.String())
                         .WithColumn("body", PrimitiveTypes.Binary())
                         .WithColumn("return_type", PrimitiveTypes.String())
                         .WithColumn("username", PrimitiveTypes.String()));


            // SYSTEM.ROUTINE_PARAM
            systemQuery.Access().CreateTable(table => table
                                             .Named(RoutineManager.RoutineParameterTableName)
                                             .WithColumn("routine_id", PrimitiveTypes.Numeric())
                                             .WithColumn("arg_name", PrimitiveTypes.String())
                                             .WithColumn("arg_type", PrimitiveTypes.String())
                                             .WithColumn("arg_attrs", PrimitiveTypes.Numeric())
                                             .WithColumn("in_out", PrimitiveTypes.Integer())
                                             .WithColumn("offset", PrimitiveTypes.Integer()));
        }
Пример #4
0
        private static void CreateTestTable(IQuery query)
        {
            var tableName1 = ObjectName.Parse("APP.test_table");

            query.Access().CreateTable(table => table
                                       .Named(tableName1)
                                       .WithColumn(column => column
                                                   .Named("id")
                                                   .HavingType(PrimitiveTypes.Integer())
                                                   .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY",
                                                                                           new SqlExpression[] { SqlExpression.Constant(tableName1.FullName) }))
                                                   .NotNull())
                                       .WithColumn("first_name", PrimitiveTypes.String())
                                       .WithColumn("last_name", PrimitiveTypes.String())
                                       .WithColumn("birth_date", PrimitiveTypes.DateTime())
                                       .WithColumn("active", PrimitiveTypes.Boolean()));

            query.Session.Access().AddPrimaryKey(tableName1, "id", "PK_TEST_TABLE");

            query.Access().CreateTable(table => table
                                       .Named("APP.test_table2")
                                       .WithColumn("person_id", PrimitiveTypes.Integer())
                                       .WithColumn("value", PrimitiveTypes.Boolean()));

            var body = new PlSqlBlockStatement();

            body.Statements.Add(new CallStatement(ObjectName.Parse("system.output"), new[] {
                new InvokeArgument(SqlExpression.Constant("One row was inserted"))
            }));
            var procedureInfo = new PlSqlProcedureInfo(ObjectName.Parse("APP.proc1"), new RoutineParameter[0], body);

            query.Access().CreateObject(procedureInfo);
        }
Пример #5
0
 protected override bool OnTearDown(string testName, IQuery query)
 {
     var tableName = ObjectName.Parse("APP.test_table");
     query.Access().DropAllTableConstraints(tableName);
     query.Access().DropObject(DbObjectType.Table, tableName);
     return true;
 }
Пример #6
0
        private void Create(IQuery systemQuery)
        {
            // SYSTEM.ROUTINE
            var tableInfo = new TableInfo(RoutineManager.RoutineTableName);

            tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("schema", PrimitiveTypes.String());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("type", PrimitiveTypes.String());
            tableInfo.AddColumn("location", PrimitiveTypes.String());
            tableInfo.AddColumn("body", PrimitiveTypes.Binary());
            tableInfo.AddColumn("return_type", PrimitiveTypes.String());
            tableInfo.AddColumn("username", PrimitiveTypes.String());
            systemQuery.Access().CreateTable(tableInfo);

            // SYSTEM.ROUTINE_PARAM
            tableInfo = new TableInfo(RoutineManager.RoutineParameterTableName);
            tableInfo.AddColumn("routine_id", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("arg_name", PrimitiveTypes.String());
            tableInfo.AddColumn("arg_type", PrimitiveTypes.String());
            tableInfo.AddColumn("arg_attrs", PrimitiveTypes.Numeric());
            tableInfo.AddColumn("in_out", PrimitiveTypes.Integer());
            tableInfo.AddColumn("offset", PrimitiveTypes.Integer());
            systemQuery.Access().CreateTable(tableInfo);
        }
        protected override bool OnTearDown(string testName, IQuery query)
        {
            query.Access().DropObject(DbObjectType.Routine, procName);
            query.Access().DropObject(DbObjectType.Routine, funcName);

            return(true);
        }
Пример #8
0
        private static void CreateTestTable(IQuery query, string testName)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().CreateTable(table => {
                table
                .Named(tableName)
                .WithColumn(column => column.Named("id")
                            .HavingType(PrimitiveTypes.Integer())
                            .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY",
                                                                    new SqlExpression[] { SqlExpression.Constant(tableName.FullName) })))
                .WithColumn("first_name", PrimitiveTypes.String())
                .WithColumn("last_name", PrimitiveTypes.String())
                .WithColumn("birth_date", PrimitiveTypes.DateTime())
                .WithColumn(column => column
                            .Named("active")
                            .HavingType(PrimitiveTypes.Boolean())
                            .NotNull(testName.Equals("NotNullColumnViolation")));

                if (testName.EndsWith("WithLob"))
                {
                    table.WithColumn("bio", PrimitiveTypes.Clob(2048));
                }
                else if (testName.EndsWith("WithUserType"))
                {
                    var userType = query.Access().ResolveUserType("type1");
                    table.WithColumn("user_obj", userType);
                }
            });

            query.Access().AddPrimaryKey(tableName, "id", "PK_TEST_TABLE");
        }
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");
            var tableInfo = new TableInfo(tableName);

            tableInfo.AddColumn("a", PrimitiveTypes.Integer());
            tableInfo.AddColumn("b", PrimitiveTypes.String());

            query.Access().CreateObject(tableInfo);

            var table = query.Access().GetMutableTable(tableName);

            for (int i = 0; i < 15; i++)
            {
                var aValue = Field.Integer(i * i);
                var bValue = Field.String(i.ToString());

                var row = table.NewRow();
                row.SetValue(0, aValue);
                row.SetValue(1, bValue);

                table.AddRow(row);
            }

            return(true);
        }
Пример #10
0
 private static void CreateSystemRoles(IQuery query)
 {
     query.Access().CreateRole(SystemRoles.SecureAccessRole);
     query.Access().CreateRole(SystemRoles.UserManagerRole);
     query.Access().CreateRole(SystemRoles.SchemaManagerRole);
     query.Access().CreateRole(SystemRoles.LockedRole);
 }
Пример #11
0
 protected override bool OnTearDown(string testName, IQuery query)
 {
     query.Access().DropRole("role2");
     query.Access().DropRole("test_role1");
     query.Access().DeleteUser("test_user");
     return(true);
 }
Пример #12
0
 private static void CreateSystemRoles(IQuery query)
 {
     query.Access().CreateRole(SystemRoles.SecureAccessRole);
     query.Access().CreateRole(SystemRoles.UserManagerRole);
     query.Access().CreateRole(SystemRoles.SchemaManagerRole);
     query.Access().CreateRole(SystemRoles.LockedRole);
 }
Пример #13
0
 protected override bool OnTearDown(string testName, IQuery query)
 {
     query.Access().DropObject(DbObjectType.Routine, ObjectName.Parse("APP.proc1"));
     query.Access().DropObject(DbObjectType.Routine, ObjectName.Parse("APP.proc2"));
     query.Access().DropObject(DbObjectType.Routine, ObjectName.Parse("APP.proc3"));
     query.Access().DropObject(DbObjectType.Routine, ObjectName.Parse("APP.extProc"));
     return(true);
 }
Пример #14
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("SYSTEM.test_table");

            query.Access().RevokeAllGrantsOn(DbObjectType.Table, tableName);
            query.Access().DropObject(DbObjectType.Table, tableName);
            return(true);
        }
Пример #15
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var viewName = ObjectName.Parse("APP.text_view1");
            query.Access().DropObject(DbObjectType.View, viewName);

            query.Access().DropObject(DbObjectType.Table, ObjectName.Parse("APP.test_table"));
            return true;
        }
Пример #16
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().DropAllTableConstraints(tableName);
            query.Access().DropObject(DbObjectType.Table, tableName);
            return(true);
        }
Пример #17
0
 protected override bool OnTearDown(string testName, IQuery query)
 {
     var tableName = ObjectName.Parse("APP.test_table");
     query.Access().RevokeAllGrantsOn(DbObjectType.Table, tableName);
     query.Access().DropRole("test_role");
     query.Access().DeleteUser("test_user");
     query.Access().DropObject(DbObjectType.Table, tableName);
     return true;
 }
Пример #18
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var viewName = ObjectName.Parse("APP.text_view1");

            query.Access().DropObject(DbObjectType.View, viewName);

            query.Access().DropObject(DbObjectType.Table, ObjectName.Parse("APP.test_table"));
            return(true);
        }
Пример #19
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            query.Access().CreateUser("test_user", "0123456789");
            query.Access().CreateRole("test_role1");
            query.Access().CreateRole("role2");

            if (testName == "Unlock")
                query.Access().SetUserStatus("test_user", UserStatus.Locked);
            return true;
        }
Пример #20
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            query.Access().CreateUser("test_user", "0123456789");
            query.Access().CreateRole("test_role1");
            query.Access().CreateRole("role2");

            if (testName == "Unlock")
            {
                query.Access().SetUserStatus("test_user", UserStatus.Locked);
            }
            return(true);
        }
Пример #21
0
        private void CreateTables(IQuery query)
        {
            query.Access().CreateTable(table => table
                                       .Named("APP.test_table")
                                       .WithColumn("a", PrimitiveTypes.Integer())
                                       .WithColumn("b", PrimitiveTypes.String()));

            query.Access().CreateTable(table => table
                                       .Named("APP.dest_table")
                                       .WithColumn("a", PrimitiveTypes.Integer())
                                       .WithColumn("b", PrimitiveTypes.String()));
        }
Пример #22
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            query.Access().DeleteUser("test_user");
            query.Access().DropRole("test_role");

            var tableName1 = ObjectName.Parse("APP.test_table");
            var tableName2 = ObjectName.Parse("APP.test_table2");

            query.Access().DropAllTableConstraints(tableName1);
            query.Access().DropObject(DbObjectType.Table, tableName1);
            query.Access().DropObject(DbObjectType.Table, tableName2);
            return(true);
        }
Пример #23
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("SYSTEM.test_table");
            var tableInfo = new TableInfo(tableName);

            tableInfo.AddColumn("a", PrimitiveTypes.Integer());
            tableInfo.AddColumn("b", PrimitiveTypes.String());

            query.Access().CreateObject(tableInfo);
            query.Access().GrantOnTable(tableName, User.PublicName, PrivilegeSets.TableAll);

            return(true);
        }
Пример #24
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            query.Access().DropObject(DbObjectType.Sequence, ObjectName.Parse("APP.seq1"));

            if (testName.EndsWith("TableId"))
            {
                var tableName = ObjectName.Parse("APP.test_table");
                query.Access().DropAllTableConstraints(tableName);
                query.Access().DropObject(DbObjectType.Table, tableName);
            }

            return(true);
        }
Пример #25
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            query.Access().DeleteUser("test_user");
            query.Access().DropRole("test_role");

            var tableName1 = ObjectName.Parse("APP.test_table");
            var tableName2 = ObjectName.Parse("APP.test_table2");

            query.Access().DropAllTableConstraints(tableName1);
            query.Access().DropObject(DbObjectType.Table, tableName1);
            query.Access().DropObject(DbObjectType.Table, tableName2);
            return true;
        }
Пример #26
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var triggerName1 = ObjectName.Parse("APP.trigger1");
            var triggerName2 = ObjectName.Parse("APP.trigger2");
            var tableName    = ObjectName.Parse("APP.test_table");
            var procedurName = ObjectName.Parse("APP.proc1");

            query.Access().DropObject(DbObjectType.Trigger, triggerName1);
            query.Access().DropObject(DbObjectType.Trigger, triggerName2);
            query.Access().DropObject(DbObjectType.Table, tableName);
            query.Access().DropObject(DbObjectType.Routine, procedurName);

            return(true);
        }
Пример #27
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().CreateTable(table => table
                                       .Named(tableName)
                                       .WithColumn("id", PrimitiveTypes.Integer()));

            query.Access().CreateUser("test_user", "0123456789");
            query.Access().GrantOnTable(tableName, "test_user", Privileges.Alter);

            query.Access().CreateRole("test_role");
            query.Access().AddUserToRole("test_user", "test_role");
            return(true);
        }
Пример #28
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().CreateTable(table => table
                .Named(tableName)
                .WithColumn("id", PrimitiveTypes.Integer()));

            query.Access().CreateUser("test_user", "0123456789");
            query.Access().GrantOnTable(tableName, "test_user", Privileges.Alter);

            query.Access().CreateRole("test_role");
            query.Access().AddUserToRole("test_user", "test_role");
            return true;
        }
Пример #29
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().DropAllTableConstraints(tableName);
            query.Access().DropObject(DbObjectType.Table, tableName);
            if (testName.EndsWith("Violation") ||
                testName.EndsWith("ConstraintCheck"))
            {
                tableName = ObjectName.Parse("APP.test_table2");
                query.Access().DropAllTableConstraints(tableName);
                query.Access().DropObject(DbObjectType.Table, tableName);
            }

            return(true);
        }
Пример #30
0
 private void CreateTable(IQuery query)
 {
     query.Access().CreateTable(table => table
         .Named("APP.test_table")
         .WithColumn("a", PrimitiveTypes.Integer())
         .WithColumn("b", PrimitiveTypes.String()));
 }
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var procName = ObjectName.Parse("APP.proc1");

            query.Access().DropObject(DbObjectType.Routine, procName);
            return(true);
        }
Пример #32
0
 protected override bool OnSetUp(string testName, IQuery query)
 {
     var seqName = ObjectName.Parse("APP.seq1");
     query.Access().CreateObject(new SequenceInfo(seqName, SqlNumber.Zero, SqlNumber.One, SqlNumber.Zero,
         new SqlNumber(Int64.MaxValue), Int32.MaxValue));
     return true;
 }
Пример #33
0
 protected override bool OnSetUp(string testName, IQuery query)
 {
     var seqName = ObjectName.Parse("APP.seq1");
     query.Access().CreateObject(new SequenceInfo(seqName, new SqlNumber(0), new SqlNumber(1), new SqlNumber(0),
         new SqlNumber(Int16.MaxValue), 256));
     return true;
 }
Пример #34
0
        private void CreateTestTable(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");

            query.Access().CreateTable(table => table
                                       .Named(tableName)
                                       .WithColumn(column => column
                                                   .Named("id")
                                                   .HavingType(PrimitiveTypes.Integer())
                                                   .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY", new SqlExpression[] {
                SqlExpression.Constant("APP.test_table")
            })))
                                       .WithColumn("name", PrimitiveTypes.String()));

            query.Access().AddPrimaryKey(tableName, "id");
        }
        private void InsertData(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.persons");
            var table     = query.Access().GetMutableTable(tableName);
            var row       = table.NewRow();

            row["name"] = Field.String("Antonello Provenzano");
            row["age"]  = Field.Integer(36);
            row.SetDefault(query);
            table.AddRow(row);

            row         = table.NewRow();
            row["name"] = Field.String("Sebastiano Provenzano");
            row["age"]  = Field.Integer(35);
            row.SetDefault(query);
            table.AddRow(row);

            row         = table.NewRow();
            row["name"] = Field.String("Mart Rosmaa");
            row["age"]  = Field.Integer(33);
            row.SetDefault(query);
            table.AddRow(row);

            row         = table.NewRow();
            row["name"] = Field.String("Karl Inge Stensson");
            row["age"]  = Field.Integer(54);
            row.SetDefault(query);
            table.AddRow(row);
        }
Пример #36
0
        private static void OpenAndAdvanceCursor(IQuery query)
        {
            var cursor = (Cursor)query.Access().GetObject(DbObjectType.Cursor, new ObjectName("c1"));

            cursor.Open(query);
            cursor.Fetch(FetchDirection.Next);
        }
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var seqName = ObjectName.Parse("APP.seq1");

            query.Access().DropObject(DbObjectType.Sequence, seqName);
            return(true);
        }
        private static void AddTestData(IQuery context)
        {
            var table = context.Access().GetMutableTable(ObjectName.Parse("APP.test_table"));
            var row   = table.NewRow();

            // row.SetValue("id", Field.Integer(0));
            row.SetDefault(0, context);
            row.SetValue("first_name", Field.String("John"));
            row.SetValue("last_name", Field.String("Doe"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1977, 01, 01)));
            row.SetValue("active", Field.Boolean(false));
            table.AddRow(row);

            row = table.NewRow();

            // row.SetValue("id", Field.Integer(1));
            row.SetDefault(0, context);
            row.SetValue("first_name", Field.String("Jane"));
            row.SetValue("last_name", Field.String("Doe"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1978, 11, 01)));
            row.SetValue("active", Field.Boolean(true));
            table.AddRow(row);

            row = table.NewRow();

            // row.SetValue("id", Field.Integer(2));
            row.SetDefault(0, context);
            row.SetValue("first_name", Field.String("Roger"));
            row.SetValue("last_name", Field.String("Rabbit"));
            row.SetValue("birth_date", Field.Date(new SqlDateTime(1985, 05, 05)));
            row.SetValue("active", Field.Boolean(true));
            table.AddRow(row);
        }
Пример #39
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            var typeName = ObjectName.Parse("APP.type1");

            query.Access().DropObject(DbObjectType.Type, typeName);
            return(true);
        }
Пример #40
0
        private void CreateTable(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.test_table");
            query.Access().CreateTable(table => table
                .Named(tableName)
                .WithColumn(column => column
                    .Named("id")
                    .HavingType(PrimitiveTypes.Integer())
                    .WithDefault(SqlExpression.FunctionCall("UNIQUEKEY", new SqlExpression[] {
                        SqlExpression.Constant(tableName.FullName)
                    })))
                .WithColumn("a", PrimitiveTypes.Integer())
                .WithColumn("b", PrimitiveTypes.String()));

            query.Access().AddPrimaryKey(tableName, "id", "PK_TEST_TABLE");
        }
Пример #41
0
        private void InsertData(IQuery query)
        {
            var tableName = ObjectName.Parse("APP.persons");
            var table = query.Access().GetMutableTable(tableName);
            var row = table.NewRow();
            row["name"] = Field.String("Antonello Provenzano");
            row["age"] = Field.Integer(36);
            row.SetDefault(query);
            table.AddRow(row);

            row = table.NewRow();
            row["name"] = Field.String("Sebastiano Provenzano");
            row["age"] = Field.Integer(35);
            row.SetDefault(query);
            table.AddRow(row);

            row = table.NewRow();
            row["name"] = Field.String("Mart Rosmaa");
            row["age"] = Field.Integer(33);
            row.SetDefault(query);
            table.AddRow(row);

            row = table.NewRow();
            row["name"] = Field.String("Karl Inge Stensson");
            row["age"] = Field.Integer(54);
            row.SetDefault(query);
            table.AddRow(row);
        }
Пример #42
0
        private static void CreatePublicUser(IQuery query)
        {
            var userName = User.PublicName;
            var userId = new UserIdentification(KnownUserIdentifications.ClearText, "###");
            var userInfo = new UserInfo(userName, userId);

            query.Access().CreateUser(userInfo);
        }
Пример #43
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            triggerName = ObjectName.Parse("APP.trigger1");
            query.Access().CreateTrigger(new ProcedureTriggerInfo(triggerName, ObjectName.Parse("APP.table1"),
                TriggerEventTime.After, TriggerEventType.Delete, ObjectName.Parse("APP.proc1")));

            return true;
        }
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var seqName = ObjectName.Parse("APP.seq1");

            query.Access().CreateObject(new SequenceInfo(seqName, SqlNumber.Zero, SqlNumber.One, SqlNumber.Zero,
                                                         new SqlNumber(Int64.MaxValue), Int32.MaxValue));
            return(true);
        }
Пример #45
0
        protected override bool OnTearDown(string testName, IQuery query)
        {
            if (testName != "RollbackTableCreate") {
                query.Access().DropObject(DbObjectType.Table, ObjectName.Parse("APP.test_table"));
            }

            return true;
        }
Пример #46
0
 protected override bool OnSetUp(string testName, IQuery query)
 {
     query.Access().CreateTable(table => table
         .Named("APP.test_table")
         .WithColumn("a", PrimitiveTypes.Integer())
         .WithColumn("b", PrimitiveTypes.String()));
     return true;
 }
Пример #47
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var tableInfo = new TableInfo(ObjectName.Parse("APP.test_table"));
            tableInfo.AddColumn("a", PrimitiveTypes.Integer());

            query.Access().CreateObject(tableInfo);
            return true;
        }
        protected override bool OnSetUp(string testName, IQuery query)
        {
            triggerName = ObjectName.Parse("APP.trigger1");
            query.Access().CreateTrigger(new ProcedureTriggerInfo(triggerName, ObjectName.Parse("APP.table1"),
                                                                  TriggerEventTime.After, TriggerEventType.Delete, ObjectName.Parse("APP.proc1")));

            return(true);
        }
Пример #49
0
 private void CreateFunction(IQuery query)
 {
     var functionName = ObjectName.Parse("APP.func1");
     var body = new PlSqlBlockStatement();
     body.Statements.Add(new ReturnStatement(SqlExpression.Constant(200)));
     var functionInfo = new PlSqlFunctionInfo(functionName, new RoutineParameter[0], PrimitiveTypes.Integer(), body);
     query.Access().CreateRoutine(functionInfo);
 }
Пример #50
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            if (testName == "Authenticate_Success") {
                query.Access().CreateUser("tester", "123456789");
            }

            return true;
        }
Пример #51
0
        private static void CreateTables(IQuery context)
        {
            var tableInfo = new TableInfo(UserManager.UserTableName);
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            // TODO: User table must be completed ...
            tableInfo = tableInfo.AsReadOnly();
            context.Access().CreateTable(tableInfo);

            context.Access().AddPrimaryKey(UserManager.UserTableName, new[] { "name" }, "SYSTEM_USER_PK");

            tableInfo = new TableInfo(UserManager.PasswordTableName);
            tableInfo.AddColumn("user", PrimitiveTypes.String());
            tableInfo.AddColumn("method", PrimitiveTypes.String());
            tableInfo.AddColumn("method_args", PrimitiveTypes.Binary());
            tableInfo.AddColumn("identifier", PrimitiveTypes.String());
            tableInfo = tableInfo.AsReadOnly();
            context.Access().CreateTable(tableInfo);

            tableInfo = new TableInfo(UserManager.UserRoleTableName);
            tableInfo.AddColumn("user", PrimitiveTypes.String());
            tableInfo.AddColumn("role", PrimitiveTypes.String());
            tableInfo.AddColumn("admin", PrimitiveTypes.Boolean());
            tableInfo = tableInfo.AsReadOnly();
            context.Access().CreateTable(tableInfo);

            tableInfo = new TableInfo(UserManager.RoleTableName);
            tableInfo.AddColumn("name", PrimitiveTypes.String(), true);
            tableInfo = tableInfo.AsReadOnly();
            context.Access().CreateTable(tableInfo);

            context.Access().AddPrimaryKey(UserManager.RoleTableName, new[] { "name" }, "SYSTEM_ROLE_PK");

            var fkCol = new[] { "user" };
            var rfkCol = new[] { "role" };
            var refCol = new[] { "name" };
            const ForeignKeyAction onUpdate = ForeignKeyAction.NoAction;
            const ForeignKeyAction onDelete = ForeignKeyAction.Cascade;
            context.Access().AddForeignKey(UserManager.PasswordTableName, fkCol, UserManager.UserTableName, refCol, onDelete,
                onUpdate, "USER_PASSWORD_FK");
            context.Access().AddForeignKey(UserManager.UserRoleTableName, fkCol, UserManager.UserTableName, refCol, onDelete,
                onUpdate, "USER_PRIV_FK");
            context.Access().AddForeignKey(UserManager.UserRoleTableName, rfkCol, UserManager.RoleTableName, refCol, onDelete,
                onUpdate, "USER_ROLE_FK");
        }
Пример #52
0
        private void AddForeignKeys(IQuery systemQuery)
        {
            var fkCol = new[] { "routine_id" };
            var refCol = new[] { "id" };
            const ForeignKeyAction onUpdate = ForeignKeyAction.NoAction;
            const ForeignKeyAction onDelete = ForeignKeyAction.Cascade;

            systemQuery.Access().AddForeignKey(RoutineManager.RoutineParameterTableName, fkCol, RoutineManager.RoutineTableName, refCol,
                onDelete, onUpdate, "ROUTINE_PARAMS_FK");
        }
Пример #53
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var typeName = ObjectName.Parse("APP.type1");
            var typeInfo = new UserTypeInfo(typeName);
            typeInfo.AddMember("a", PrimitiveTypes.Integer());
            typeInfo.AddMember("b", PrimitiveTypes.DateTime());
            query.Access().CreateObject(typeInfo);

            return true;
        }
Пример #54
0
        private static void OnCompositeCreate(IQuery systemQuery)
        {
            // SYSTEM.SEQUENCE_INFO
            systemQuery.Access().CreateTable(table => table
                .Named(SequenceManager.SequenceInfoTableName)
                .WithColumn("id", PrimitiveTypes.Numeric())
                .WithColumn("schema", PrimitiveTypes.String())
                .WithColumn("name", PrimitiveTypes.String())
                .WithColumn("type", PrimitiveTypes.Numeric()));

            //var tableInfo = new TableInfo(SequenceManager.SequenceInfoTableName);
            //tableInfo.AddColumn("id", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("schema", PrimitiveTypes.String());
            //tableInfo.AddColumn("name", PrimitiveTypes.String());
            //tableInfo.AddColumn("type", PrimitiveTypes.Numeric());
            //tableInfo = tableInfo.AsReadOnly();
            //systemQuery.Access().CreateTable(tableInfo);

            // SYSTEM.SEQUENCE
            systemQuery.Access().CreateTable(table => table
                .Named(SequenceManager.SequenceTableName)
                .WithColumn("seq_id", PrimitiveTypes.Numeric())
                .WithColumn("last_value", PrimitiveTypes.Numeric())
                .WithColumn("increment", PrimitiveTypes.Numeric())
                .WithColumn("minvalue", PrimitiveTypes.Numeric())
                .WithColumn("maxvalue", PrimitiveTypes.Numeric())
                .WithColumn("start", PrimitiveTypes.Numeric())
                .WithColumn("cache", PrimitiveTypes.Numeric())
                .WithColumn("cycle", PrimitiveTypes.Boolean()));

            //tableInfo = new TableInfo(SequenceManager.SequenceTableName);
            //tableInfo.AddColumn("seq_id", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("last_value", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("increment", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("minvalue", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("maxvalue", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("start", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("cache", PrimitiveTypes.Numeric());
            //tableInfo.AddColumn("cycle", PrimitiveTypes.Boolean());
            //tableInfo = tableInfo.AsReadOnly();
            //systemQuery.Access().CreateTable(tableInfo);
        }
Пример #55
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var procName = ObjectName.Parse("APP.proc1");
            var body = new PlSqlBlockStatement();
            body.Statements.Add(new AssignVariableStatement(SqlExpression.VariableReference("a"), SqlExpression.Constant(34)));

            var funtionInfo = new PlSqlProcedureInfo(procName, new RoutineParameter[0], body);
            query.Access().CreateObject(funtionInfo);

            return true;
        }
Пример #56
0
        private static void OnCompositeCreate(IQuery systemQuery)
        {
            systemQuery.Access().CreateTable(table => table
                .Named(ViewManager.ViewTableName)
                .WithColumn("schema", PrimitiveTypes.String())
                .WithColumn("name", PrimitiveTypes.String())
                .WithColumn("query", PrimitiveTypes.String())
                .WithColumn("plan", PrimitiveTypes.Binary()));

            // TODO: Columns...
        }
Пример #57
0
 public void OnTableCompositeSetup(IQuery systemQuery)
 {
     var tableInfo = new TableInfo(SystemSchema.GrantsTableName);
     tableInfo.AddColumn("priv_bit", PrimitiveTypes.Numeric());
     tableInfo.AddColumn("object", PrimitiveTypes.Numeric());
     tableInfo.AddColumn("name", PrimitiveTypes.String());
     tableInfo.AddColumn("grantee", PrimitiveTypes.String());
     tableInfo.AddColumn("grant_option", PrimitiveTypes.Boolean());
     tableInfo.AddColumn("granter", PrimitiveTypes.String());
     tableInfo = tableInfo.AsReadOnly();
     systemQuery.Access().CreateSystemTable(tableInfo);
 }
Пример #58
0
        protected override bool OnSetUp(string testName, IQuery query)
        {
            var funcName = ObjectName.Parse("APP.func1");
            var returnType = PrimitiveTypes.String();
            var body = new PlSqlBlockStatement();
            body.Statements.Add(new ReturnStatement(SqlExpression.Constant("Hello!")));

            var funtionInfo = new PlSqlFunctionInfo(funcName, new RoutineParameter[0], returnType, body);
            query.Access().CreateObject(funtionInfo);

            return true;
        }
Пример #59
0
        public void OnTableCompositeCreate(IQuery systemQuery)
        {
            var tableInfo = new TableInfo(TypeManager.TypeTableName);
            tableInfo.AddColumn("id", PrimitiveTypes.Integer());
            tableInfo.AddColumn("schema", PrimitiveTypes.String(), true);
            tableInfo.AddColumn("name", PrimitiveTypes.String(), true);
            tableInfo.AddColumn("parent", PrimitiveTypes.String());
            tableInfo.AddColumn("sealed", PrimitiveTypes.Boolean());
            tableInfo.AddColumn("abstract", PrimitiveTypes.Boolean());
            tableInfo.AddColumn("owner", PrimitiveTypes.String());
            systemQuery.Access().CreateTable(tableInfo);

            tableInfo = new TableInfo(TypeManager.TypeMemberTableName);
            tableInfo.AddColumn("type_id", PrimitiveTypes.Integer());
            tableInfo.AddColumn("name", PrimitiveTypes.String(), true);
            tableInfo.AddColumn("type", PrimitiveTypes.String());
            systemQuery.Access().CreateTable(tableInfo);

            systemQuery.Access().AddPrimaryKey(TypeManager.TypeTableName, new[] { "id" }, "PK_TYPE");
            systemQuery.Access().AddForeignKey(TypeManager.TypeMemberTableName, new[] { "type_id" }, TypeManager.TypeTableName, new[] { "id" }, ForeignKeyAction.Cascade, ForeignKeyAction.Cascade, "FK_MEMBER_TYPE");
        }
Пример #60
0
        public void OnTableCompositeCreate(IQuery systemQuery)
        {
            var tableInfo = new TableInfo(ViewManager.ViewTableName);
            tableInfo.AddColumn("schema", PrimitiveTypes.String());
            tableInfo.AddColumn("name", PrimitiveTypes.String());
            tableInfo.AddColumn("query", PrimitiveTypes.String());
            tableInfo.AddColumn("plan", PrimitiveTypes.Binary());

            // TODO: Columns...

            systemQuery.Access().CreateTable(tableInfo);
        }