Examples with Select db.Select used on opensource projects

Example 66 with Select

use of db.Select in project common by zenlunatics.

the class Pages method init.

// --------------------------------------------------------------------
@Override
public void init(DBConnection db) {
    JDBCTable table_def = new JDBCTable().add(new JDBCColumn("name", Types.VARCHAR));
    db.getTable("designs", true).createMissingColumns(table_def, db).dropExtraColumns(table_def, db);
    table_def = new JDBCTable().add(new JDBCColumn("designs")).add(new JDBCColumn("description", Types.VARCHAR)).add(new JDBCColumn("type", Types.VARCHAR)).add(new JDBCColumn("data", Types.VARCHAR)).add(new JDBCColumn("_order_", Types.INTEGER));
    db.getTable("designs_items", true).createMissingColumns(table_def, db).dropExtraColumns(table_def, db);
    table_def = new JDBCTable().add(new JDBCColumn("designs")).add(new JDBCColumn("filename", Types.VARCHAR));
    db.getTable("designs_css_files", true).createMissingColumns(table_def, db).dropExtraColumns(table_def, db);
    table_def = new JDBCTable().add(new JDBCColumn("designs")).add(new JDBCColumn("filename", Types.VARCHAR));
    db.getTable("designs_js_files", true).createMissingColumns(table_def, db).dropExtraColumns(table_def, db);
    DBObject.init("pages", Page.class, db);
    table_def = new JDBCTable().add(new JDBCColumn("pages")).add(new JDBCColumn("description", Types.VARCHAR)).add(new JDBCColumn("type", Types.VARCHAR)).add(new JDBCColumn("data", Types.VARCHAR)).add(new JDBCColumn("_order_", Types.INTEGER));
    db.getTable("pages_items", true).createMissingColumns(table_def, db).dropExtraColumns(table_def, db);
    try {
        ResultSet rs = db.select(new Select("*").from("pages"));
        while (rs.next()) {
            Page page = new Page();
            DBObject.load(page, rs);
            m_pages.put(page.getName().toLowerCase(), page);
        }
        rs.getStatement().close();
    } catch (SQLException e) {
        m_site.log(e);
    }
}

Example 67 with Select

use of db.Select in project common by zenlunatics.

the class Pages method beforeDelete.

// --------------------------------------------------------------------
@Override
public boolean beforeDelete(StringBuilder where, Request request) {
    String name = request.db.lookupString(new Select("name").from("pages").where(where.toString()));
    m_pages.remove(name.toLowerCase());
    return true;
}