>>> import pyrvasive

>>> pyrvasive.sources()
('DEMODATA', 'MAXDEV', 'MAXDAT')

>>> db = pyrvasive.Connection('DEMODATA')

>>> db.tables
('Billing', 'Class', 'Course', 'Department', 'Enrolls', 'Faculty', 'Person', 'Room', 'Student', 'Tuition')

>>> for c in db.columns('Billing'):
...     print c['name'], c['type'], c['size'], c['null']
...
Student_ID <class 'decimal.Decimal'> 20 False
Transaction_Number <type 'int'> 5 True
Log <type 'datetime.datetime'> 19 True
Amount_Owed <class 'decimal.Decimal'> 7 True
Amount_Paid <class 'decimal.Decimal'> 7 True
Registrar_ID <class 'decimal.Decimal'> 20 False
Comments <type 'str'> 65500 True

>>> q = """
        SELECT * FROM "Billing"
        WHERE Student_ID = ?;
        """
>>> params = (100062607,)
>>> for row in db.execute(q, params):
...     print row.Amount_Paid, row.Amount_Owed
...
1031.25 2125.00

>>> q = """
        DELETE FROM "Billing"
        WHERE Student_ID = ?;
        """
>>> params = (100062607,)
>>> rows_deleted = db.execute(q, params)

>>> table = 'Enrolls'
>>> data = {
        'Student_ID': 123456,
        'Class_ID':   72,
        'Grade':      91.8,
    }
>>> rows_inserted = db.insert(table, data)

>>> q = """
        CREATE TABLE "Student Badges" (
            Student_ID CHAR(10) NOT NULL,
            Badge_Num UINT NOT NULL,
            Created TIMESTAMP,
            Log LONGVARCHAR);

        CREATE UNIQUE NOT MODIFIABLE INDEX index1 on "Student Badges"
        (Student_ID ASC);

        CREATE INDEX index2 on "Student Badges"
        (Badge_Num ASC);
        """
>>> db.executescript(q)