Package org.apache.derbyTesting.junit

Examples of org.apache.derbyTesting.junit.BaseTestSuite.execute()

107
108
109
110
111
112
113
114
115
116
117
        s.execute("insert into four values (3, 1, 1, 1, 1)");
        s.execute("insert into four values (3, 1, 2, 1, 1)");
        s.execute("insert into four values (3, 1, 3, 1, 1)");
       
        s.execute("insert into idept values ('Dept', 1, 'Department1', null, null, null, null)");
        s.execute("insert into idept values ('HardwareDept', 2, 'Department2', 25, 1, 'hardwareaset2', null)");
        s.execute("insert into idept values ('HardwareDept', 3, 'Department3', 25, 2, 'hardwareaset3', null)");
        s.execute("insert into idept values ('SoftwareDept', 4, 'Department4', 25, 1, null, 'softwareasset4')");
        s.execute("insert into idept values ('SoftwareDept', 5, 'Department5', 30, 4, null, 'softwareasset5')");
      }
    };
View Full Code Here
108
109
110
111
112
113
114
115
116
117
118
        s.execute("insert into four values (3, 1, 2, 1, 1)");
        s.execute("insert into four values (3, 1, 3, 1, 1)");
       
        s.execute("insert into idept values ('Dept', 1, 'Department1', null, null, null, null)");
        s.execute("insert into idept values ('HardwareDept', 2, 'Department2', 25, 1, 'hardwareaset2', null)");
        s.execute("insert into idept values ('HardwareDept', 3, 'Department3', 25, 2, 'hardwareaset3', null)");
        s.execute("insert into idept values ('SoftwareDept', 4, 'Department4', 25, 1, null, 'softwareasset4')");
        s.execute("insert into idept values ('SoftwareDept', 5, 'Department5', 30, 4, null, 'softwareasset5')");
      }
    };
  }
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
        s.execute("insert into four values (3, 1, 3, 1, 1)");
       
        s.execute("insert into idept values ('Dept', 1, 'Department1', null, null, null, null)");
        s.execute("insert into idept values ('HardwareDept', 2, 'Department2', 25, 1, 'hardwareaset2', null)");
        s.execute("insert into idept values ('HardwareDept', 3, 'Department3', 25, 2, 'hardwareaset3', null)");
        s.execute("insert into idept values ('SoftwareDept', 4, 'Department4', 25, 1, null, 'softwareasset4')");
        s.execute("insert into idept values ('SoftwareDept', 5, 'Department5', 30, 4, null, 'softwareasset5')");
      }
    };
  }
 
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
       
        s.execute("insert into idept values ('Dept', 1, 'Department1', null, null, null, null)");
        s.execute("insert into idept values ('HardwareDept', 2, 'Department2', 25, 1, 'hardwareaset2', null)");
        s.execute("insert into idept values ('HardwareDept', 3, 'Department3', 25, 2, 'hardwareaset3', null)");
        s.execute("insert into idept values ('SoftwareDept', 4, 'Department4', 25, 1, null, 'softwareasset4')");
        s.execute("insert into idept values ('SoftwareDept', 5, 'Department5', 30, 4, null, 'softwareasset5')");
      }
    };
  }
 
  public void testNoData() throws SQLException {
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    p.put("derby.optimizer.noTimeout", "true");
    Test t = new SystemPropertyTestSetup(s, p);
   
    return new CleanDatabaseTestSetup(t) {
      protected void decorateSQL(Statement s) throws SQLException {
        s.execute("create table t (i int, s smallint, r real, f float, d date, t time, ts timestamp, c char(10), v varchar(20))");
        // 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)");
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
    return new CleanDatabaseTestSetup(t) {
      protected void decorateSQL(Statement s) throws SQLException {
        s.execute("create table t (i int, s smallint, r real, f float, d date, t time, ts timestamp, c char(10), v varchar(20))");
        // 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)");
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
      protected void decorateSQL(Statement s) throws SQLException {
        s.execute("create table t (i int, s smallint, r real, f float, d date, t time, ts timestamp, c char(10), v varchar(20))");
        // 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)");
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
        s.execute("create table t (i int, s smallint, r real, f float, d date, t time, ts timestamp, c char(10), v varchar(20))");
        // 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)");
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
        // 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, " +
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
        // 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
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.