Package junit.framework

Examples of junit.framework.TestSuite.execute()

63
64
65
66
67
68
69
70
71
72
73
        // for tests from distinctElimination
        s.execute("create table one(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index one_c1 on one(c1)");
        s.execute("create table two(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index two_c1c3 on two(c1, c3)");
        s.execute("create table three(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index three_c1 on three(c1)");
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
        s.execute("create table one(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index one_c1 on one(c1)");
        s.execute("create table two(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index two_c1c3 on two(c1, c3)");
        s.execute("create table three(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index three_c1 on three(c1)");
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
        s.execute("create unique index one_c1 on one(c1)");
        s.execute("create table two(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index two_c1c3 on two(c1, c3)");
        s.execute("create table three(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index three_c1 on three(c1)");
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
        s.execute("create table two(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index two_c1c3 on two(c1, c3)");
        s.execute("create table three(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index three_c1 on three(c1)");
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
        s.execute("create unique index two_c1c3 on two(c1, c3)");
        s.execute("create table three(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index three_c1 on three(c1)");
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
        s.execute("create table four(c1 int, c2 int, c3 int, c4 int, c5 int)");
        s.execute("create unique index four_c1c3 on four(c1, c3)");
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
        s.execute("insert into one values (2, 1, 1, 1, 1)");
        s.execute("insert into one values (3, 1, 1, 1, 1)");
        s.execute("insert into one values (4, 1, 1, 1, 1)");
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
        s.execute("CREATE TABLE \"APP\".\"IDEPT\" (\"DISCRIM_DEPT\" VARCHAR(32), \"NO1\" INTEGER NOT NULL, " +
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
        s.execute("insert into one values (2, 1, 1, 1, 1)");
        s.execute("insert into one values (3, 1, 1, 1, 1)");
        s.execute("insert into one values (4, 1, 1, 1, 1)");
        s.execute("insert into one values (5, 1, 1, 1, 1)");
        s.execute("insert into one values (6, 1, 1, 1, 1)");
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
            "\"NAME\" VARCHAR(50), \"AUDITOR_NO\" INTEGER, \"REPORTTO_NO\" INTEGER, \"HARDWAREASSET\"" +
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
        s.execute("insert into one values (2, 1, 1, 1, 1)");
        s.execute("insert into one values (3, 1, 1, 1, 1)");
        s.execute("insert into one values (4, 1, 1, 1, 1)");
        s.execute("insert into one values (5, 1, 1, 1, 1)");
        s.execute("insert into one values (6, 1, 1, 1, 1)");
        s.execute("insert into one values (7, 1, 1, 1, 1)");
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
            " VARCHAR(15), \"SOFTWAREASSET\" VARCHAR(15))");
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
        s.execute("insert into one values (2, 1, 1, 1, 1)");
        s.execute("insert into one values (3, 1, 1, 1, 1)");
        s.execute("insert into one values (4, 1, 1, 1, 1)");
        s.execute("insert into one values (5, 1, 1, 1, 1)");
        s.execute("insert into one values (6, 1, 1, 1, 1)");
        s.execute("insert into one values (7, 1, 1, 1, 1)");
        s.execute("insert into one values (8, 1, 1, 1, 1)");
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
        s.execute("ALTER TABLE \"APP\".\"IDEPT\" ADD CONSTRAINT \"PK_IDEPT\" PRIMARY KEY (\"NO1\")");

        s.execute("insert into one values (1, 1, 1, 1, 1)");
        s.execute("insert into one values (2, 1, 1, 1, 1)");
        s.execute("insert into one values (3, 1, 1, 1, 1)");
        s.execute("insert into one values (4, 1, 1, 1, 1)");
        s.execute("insert into one values (5, 1, 1, 1, 1)");
        s.execute("insert into one values (6, 1, 1, 1, 1)");
        s.execute("insert into one values (7, 1, 1, 1, 1)");
        s.execute("insert into one values (8, 1, 1, 1, 1)");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.