from dbapi import *

serverURL = "derbyserver:localhost"
#serverURL = "derbyserver:10.1.1.123"
dbname = "casino"
username = "admin"
password = "solar"
tbl = "reservation"

with connect(serverURL, dbname, username, password) as con:
    cursor = con.cursor()
    for seatNb in range(1, 31):
        sql = "INSERT INTO " + tbl + " VALUES (" + str(seatNb) + ",'N',0)"
        cursor.execute(sql)
    con.commit()
print("Table initialized")