"""Simple test of kirbybase.
"""
import os
from kirbybase import KirbyBase, KBError
import datetime
# Uncomment one or the other of next two lines to switch between multiuser
# and embedded. If multiuser, make sure you have a kbserver running.
db = KirbyBase()
#db = KirbyBase('client', '127.0.0.1', 44444)
# If table exists, delete it.
if os.path.exists('plane.tbl'):
db.drop('plane.tbl')
# Create a table.
db.create('plane.tbl', ['name:str','country:str','role:str','speed:int',
'range:int','began_service:datetime.date', 'still_flying:bool'])
# Insert a bunch of records.
print db.insert('plane.tbl', ['P-51','USA','Fighter',403,1201,
datetime.date(1943,6,24),True])
print db.insert('plane.tbl', ['P-47','USA','Fighter',365,888,
datetime.date(1943,3,12),False])
print db.insert('plane.tbl', ['B-17','USA','Bomber',315,1400,
datetime.date(1937,5,1),True])
print db.insert('plane.tbl', ['Typhoon', 'Great Britain','Fighter-Bomber',
389,690,datetime.date(1944,11,20),False])
print db.insert('plane.tbl', ['Sptitfire','Great Britain','Fighter',345,
