Examples with Rows db.Rows used on opensource projects

Example 6 with Rows

use of db.Rows in project common by zenlunatics.

the class RecordOwnerAccessPolicy method userOwnsRecord.

// --------------------------------------------------------------------------
private boolean userOwnsRecord(String from, int id, Request request) {
    Rows data = new Rows(request.db).select(new Select(m_many_many_table == null ? OWNER_COLUMN : "id").from(from).whereIdEquals(id));
    data.next();
    boolean user_owns_record = userOwnsRecord(data, request);
    data.close();
    return user_owns_record;
}

Example 7 with Rows

use of db.Rows in project common by zenlunatics.

the class Documents method doGet.

// --------------------------------------------------------------------------
@Override
public boolean doGet(Request request) throws IOException {
    if (super.doGet(request))
        return true;
    int key_value = request.getInt("db_key_value", 0);
    if (key_value != 0) {
        Rows data = new Rows(request.db).select(new Select("*").from("documents").whereIdEquals(key_value));
        if (data.next()) {
            new Head(request, data.getString("title")).styleSheet("admin").close();
            FileColumn column = (FileColumn) request.site.getViewDef("documents", request.db).getColumn("filename");
            File file = column.getFile(data, request);
            BufferedReader br = new BufferedReader(new FileReader(file));
            String line = br.readLine();
            while (line != null) {
                request.writer.write(line);
                line = br.readLine();
            }
            br.close();
        } else
            request.writer.write("document not found");
        data.close();
    } else {
        request.site.writePageOpen("Documents", request);
        request.site.newView("documents", request).writeComponent();
    }
    request.close();
    return true;
}

Example 8 with Rows

use of db.Rows in project common by zenlunatics.

the class CurrencyColumn method writeValue.

// --------------------------------------------------------------------------
@Override
public boolean writeValue(View view, Map<String, Object> data, Request request) throws IOException {
    Rows d = view.data();
    if (d == null)
        return false;
    int column_index = d.getColumnIndex(m_name);
    if (column_index == -1)
        request.site.log("column " + m_name + " not found in CurrencyColumn.writeValue");
    else {
        int type = d.getColumnType(column_index);
        switch(type) {
            case Types.DOUBLE:
                double dbl = getDouble(view, request);
                if (!d.wasNull())
                    request.writer.writeCurrency(dbl);
                return true;
            case Types.INTEGER:
                int i = d.getInt(column_index);
                if (!d.wasNull())
                    request.writer.writeCurrency(i);
                return true;
            case Types.REAL:
                float f = d.getFloat(column_index);
                if (!d.wasNull())
                    request.writer.writeCurrency(f);
                return true;
        }
    }
    return writeValue(m_name, 0, view, request.writer);
}