Package com.mycila.testing.plugin.db.api

Examples of com.mycila.testing.plugin.db.api.SqlResults

50
51
52
53
54
55
56
57
58
59
60
61
    public void setup() throws Exception {
        db.runScript("/create.sql").runScript("/insert.sql");
        System.out.println(db.prepare("SELECT ID, NAME, SEX as S FROM PERSON").query());

        db2.runScript("/types.sql").runScript("/types-insert.sql");
        SqlResults results2 = db2.prepare("SELECT * FROM TESTTYPES").query();
        System.out.println(results2);
        System.out.println(results2.column("column21"));

        db3.runScript("/types.sql");
        System.out.println(db3.prepare("SELECT * FROM TESTTYPES").query());
    }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
81
        System.out.println(db3.prepare("SELECT * FROM TESTTYPES").query());
    }

    //@Test
    public void test_select() throws Exception {
        SqlResults results2 = db2.prepare("SELECT * FROM TESTTYPES").query();
        System.out.println("All results:\n" + results2);
        System.out.println("columns: " + results2.columnCount());
        System.out.println("rows: " + results2.columnCount());
        System.out.println("9th element of row 5: " + results2.row(4).column(8));
        System.out.println("name of column 4: " + results2.columnHeader(3).name());
    }
View Full Code Here
79
80
81
82
83
84
85
86
        System.out.println(db.prepare("select * from person;").query());
    }

    @Test
    public void test_select() throws Exception {
        SqlResults sqlResults = db.prepare("SELECT ID, NAME, SEX as S FROM PERSON").query();
        System.out.println(sqlResults);
    }
View Full Code Here
TOP

Related Classes of com.mycila.testing.plugin.db.api.SqlResults

  • com.mycila.testing.plugin.db.DatabasePluginUsage
  • com.mycila.testing.plugin.db.SqlResultsTest
    • Copyright © 2018 www.massapicom. 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.