HzDXWi0Z

1import sqlite3 as db
2
3def init(name):
4    conn=db.connect(("{xyz}.db").format(xyz=name,))
5    cur=conn.cursor()
6    sql = '''
7    create table if not exists credit(
8    date string,
9    title string,
10    amount number
11    )
12    '''
13    sql2 = '''
14    create table if not exists debit(
15    date string,
16    title string,
17    amount number
18    )
19    '''
20    cur.execute(sql)
21    cur.execute(sql2)
22    conn.commit()
23
24def addCredit(name,title,amount):
25    conn=db.connect(("{xyz}.db").format(xyz=name,))
26    cur=conn.cursor()
27    from datetime import date
28    date = str(date.today())
29    sql='''
30    insert into credit values(
31        '{}',
32        '{}',
33         {}
34        )
35    '''.format(date, title, amount)
36    cur.execute(sql)
37    conn.commit()
38
39def addDebit(name,title,amount):
40    conn=db.connect(("{xyz}.db").format(xyz=name,))
41    cur=conn.cursor()
42    from datetime import date
43    date = str(date.today())
44    sql='''
45    insert into debit values(
46        '{}',
47        '{}',
48         {}
49        )
50    '''.format(date, title, amount)
51    cur.execute(sql)
52    conn.commit()
53
54def viewCredit(name):
55    conn=db.connect(("{xyz}.db").format(xyz=name,))
56    cur=conn.cursor()
57    sql='''
58        select * from credit
59        '''
60    cur.execute(sql)
61    data= cur.fetchall()
62    #cur.execute(sql2)
63    #totalCredit= cur.fetchone()[0]
64    conn.commit()
65
66    return data
67
68def viewDebit(name):
69    conn=db.connect(("{xyz}.db").format(xyz=name,))
70    cur=conn.cursor()
71
72    sql='''
73        select * from debit
74        '''
75
76    cur.execute(sql)
77    data= cur.fetchall()
78    #cur.execute(sql2)
79    #totalDebit= cur.fetchone()[0]
80    conn.commit()
81
82    return data
83
84init('xyz')
85addCredit('xyz','anc',100)
86print (viewCredit('xyz'))