Examples of Postgres9Connection

Examples of in.partake.model.dao.postgres9.Postgres9Connection

34
35
36
37
38
39
40
41
42
43
44
45
        else
            insert(con, t);
    }

    public void insert(PartakeConnection con, ConfigurationItem t) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        Connection cn = pcon.getConnection();

        PreparedStatement ps = null;
        try {
            String sql = "INSERT INTO " + TABLE_NAME + "(key, value) VALUES(?, ?)";
            ps = cn.prepareStatement(sql);
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

52
53
54
55
56
57
58
59
60
61
62
63
            close(ps);
        }
    }

    public void update(PartakeConnection con, ConfigurationItem t) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        Connection cn = pcon.getConnection();

        PreparedStatement ps = null;
        try {
            String sql = "UPDATE " + TABLE_NAME + " SET value = ? WHERE key = ?";
            ps = cn.prepareStatement(sql);
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

71
72
73
74
75
76
77
78
79
80
81
82
        }
    }

    @Override
    public ConfigurationItem find(PartakeConnection con, String key) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        Connection cn = pcon.getConnection();

        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = "SELECT value FROM " + TABLE_NAME + " WHERE key = ?";
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

96
97
98
99
100
101
102
103
104
105
106
107
        }
    }

    @Override
    public boolean exists(PartakeConnection con, String key) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        Connection cn = pcon.getConnection();

        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String sql = "SELECT 1 FROM " + TABLE_NAME + " WHERE key = ?";
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

117
118
119
120
121
122
123
124
125
126
127
128
        }
    }

    @Override
    public void remove(PartakeConnection con, String key) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        Connection cn = pcon.getConnection();

        PreparedStatement ps = null;
        try {
            String sql = "DELETE FROM " + TABLE_NAME + " WHERE key = ?";
            ps = cn.prepareStatement(sql);
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

37
38
39
40
41
42
43
44
45
46
47
        this.mapper = new EntityTwitterMessageMapper();
    }

    @Override
    public void initialize(PartakeConnection con) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        entityDao.initialize(pcon);

        if (!existsTable(pcon, INDEX_TABLE_NAME)) {
            // event id may be NULL if system message.
            indexDao.createIndexTable(pcon, "CREATE TABLE " + INDEX_TABLE_NAME + "(id TEXT PRIMARY KEY, userId TEXT NOT NULL, createdAt TIMESTAMP NOT NULL)");
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

49
50
51
52
53
54
55
56
57
        }
    }

    @Override
    public void truncate(PartakeConnection con) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        entityDao.truncate(pcon);
        indexDao.truncate(pcon);
    }
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

56
57
58
59
60
61
62
63
64
65
66
        indexDao.truncate(pcon);
    }

    @Override
    public void put(PartakeConnection con, TwitterMessage t) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;

        Postgres9Entity entity = new Postgres9Entity(t.getId(), CURRENT_VERSION, t.toJSON().toString().getBytes(UTF8), null, TimeUtil.getCurrentDateTime());
        if (entityDao.exists(pcon, t.getId()))
            entityDao.update(pcon, entity);
        else
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

78
79
80
81
82
83
84
85
86
        return entityDao.exists((Postgres9Connection) con, id);
    }

    @Override
    public void remove(PartakeConnection con, String id) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        entityDao.remove(pcon, id);
        indexDao.remove(pcon, "id", id);
    }
View Full Code Here

Examples of in.partake.model.dao.postgres9.Postgres9Connection

39
40
41
42
43
44
45
46
47
48
49
        this.mapper = new EntityUserSentMessageMapper();
    }

    @Override
    public void initialize(PartakeConnection con) throws DAOException {
        Postgres9Connection pcon = (Postgres9Connection) con;
        entityDao.initialize(pcon);

        if (!existsTable(pcon, INDEX_TABLE_NAME)) {
            // event id may be NULL if system message.
            indexDao.createIndexTable(pcon, "CREATE TABLE " + INDEX_TABLE_NAME + "(id TEXT PRIMARY KEY, senderId TEXT NOT NULL, createdAt TIMESTAMP NOT NULL)");
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.