Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.executeStatement()

34
35
36
37
38
39
40
41
42
43
44
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  number(1,0)");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY nclob");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS number(10,0)");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED number(10,0)");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE nclob");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA number(1,0)");
        }
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED number(10,0)");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE nclob");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA number(1,0)");
        }
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE nclob");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA number(1,0)");
        }
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA number(1,0)");
        }
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        }
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
        else if(DbConnectionFactory.isMySql()) {
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
          dc.executeStatement("ALTER TABLE template ADD DRAWED  tinyint(1)");
            dc.executeStatement("ALTER TABLE template ADD DRAWED_BODY longtext");
            dc.executeStatement("ALTER TABLE template ADD ADD_CONTAINER_LINKS integer");
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
            dc.executeStatement("ALTER TABLE template ADD CONTAINERS_ADDED integer");
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
            dc.executeStatement("ALTER TABLE template ADD HEAD_CODE longtext");
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
        }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
            dc.executeStatement("ALTER TABLE containers ADD FOR_METADATA tinyint(1)");
        }
        else if(DbConnectionFactory.isPostgres()) {
          dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED  bool");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD DRAWED_BODY text");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD ADD_CONTAINER_LINKS int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD CONTAINERS_ADDED int4");
            dc.executeStatement("ALTER TABLE TEMPLATE ADD HEAD_CODE text");
            dc.executeStatement("ALTER TABLE CONTAINERS ADD FOR_METADATA bool");
        }
    }
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.