Close(db, conn, curs)

def writedata(self):

crt = os.access(self.__outdata, os.F_OK)

conn = sqlite3.connect(self.__outdata)

c = conn.cursor()

conn.text_factory = str

Print(crt)

if not crt:

C.executescript(emptydb)

else:

C.executescript(del_tbls)

for client in self.__clients:

code = client.getcode()

family = client.getfamily()

name = client.getname()

patronym = client.getpatronym()

comment = client.getcomment()

passport = client.getpassport()

c.execute("insert into client(code,family,name,patronym,comment,passport) values(?,?,?,?,?,?)", (code, family, name, patronym, comment, passport))

Conn.commit()

for room in self.__rooms:

code = room.getcode()

number = room.getnumber()

capacity = room.getcapacity()

comfort = room.getcomfort()

price = room.getprice()

c.execute("insert into room (code,number,capacity,comfort,price) values(?,?,?,?,?)", (code,number,capacity,comfort,price))

Conn.commit()

for accom in self.__accoms:

client = accom.getclients()[0].getcode()

room = accom.getroom().getcode()

date_in = accom.getdate_in()

date_out = accom.getdate_out()

notes = accom.getnotes()

c.execute("insert into accom (client,room,date_in,date_out,notes) values(?,?,?,?,?)", (client,room,date_in,date_out,notes))

Conn.commit()

def addclient(self):

clname = raw_input("Enter client's name: ")

b = True

while b:

try:

c = int(clname)

clname = raw_input("Enter correct client's name: ")

except:

b = False

clientcodes = []

for c in self.__clients:

Clientcodes.append(c.getcode())

Clientcodes.sort()

clcode = clientcodes[-1] + 1

clfamily = raw_input("Enter client's family: ")

clpatronym = raw_input("Enter client's patronym: ")

clcomment = raw_input("Enter comment about the client: ")

clpassport = raw_input("Enter client's passport: ")

Print clcode, clname, clfamily, clpatronym, clcomment, clpassport