Class rick_db.conn.Cursor

Provides cursor logic in a database-independent fashion.

Cursor.exec(qry: str, params=None, cls=None)

Executes a SQL query specified in qry, with optional parameter list params. If cls, the specified class will be used to return objects via Object Mapper. The query may or may not return a result.

Cursor.fetchone(qry: str, params=None, cls=None)

Executes a SQL query specified in qry, with optional parameter list params and optional Object Mapper class defined via cls. It will return a single result or None

Cursor.fetchall(qry: str, params=None, cls=None)

Executes a SQL query specified in qry, with optional parameter list params and optional Object Mapper class defined via cls. It will always return a list. If no records are to be returned, the list will be empty.

Cursor.close()

Closes current cursor.

Cursor.get_cursor()

Retrieve underlying cursor object.