Rows

class dbapix.row.Row(raw, cur)

A row in a query result.

Rows are tuples, but they have been augmented to behave like dicts:

for row in cur.execute('''SELECT foo FROM bar'''):
    print(row[0])
    print(row['foo']) # The same thing.

Warning

Checking if a string is in a row via 'foo' in row will check for both the key 'foo' and the value 'foo'! If you need to be explicit, then you should look in the various views:

'foo' in row.keys()
# or
'foo' in row.values()

Row.__getitem__(x)

Get an item via index or key.

Parameters

x – If an int, lookup by index. If a str, lookup by name.

Raises

KeyError or IndexError

Dict-like

Row.get(key, default=None)

Get a value by column name.

Parameters

• key (str) – The name of the column.

• default – What to return if the name doesn’t exist.

Raises

KeyError if the column doesn’t exist.

Row.copy()

Get a copy of the row as a dict.

The next 3 have the appropriate behaviour in Python 2 or Python 3

Row.keys()

Row.values()

Row.items()

The following are also defined as in Python 2:

Row.iterkeys()

Row.viewkeys()

Row.itervalues()

Row.viewvalues()

Row.iteritems()

Row.viewitems()

Row Lists

class dbapix.row.RowList(cur)

An extension of list for holding rows.

RowList.as_dataframe(**kwargs)

Convert these rows into a pandas.DataFrame.

See also

Cursor.as_dataframe().