#!/usr/bin/python
# -*- coding: utf-8 -*-
from Tkinter import *
import MySQLdb
def tran():
first = Tk()
label1 = Label(first, text='From')
label1.pack()
box1 = Entry(first)
box1.pack()
label2 = Label(first, text='To')
label2.pack()
box2 = Entry(first)
box2.pack()
label3 = Label(first, text='Amt')
label3.pack()
box3 = Entry(first)
box3.pack()
Button1 = Button(first, text='Next', command=func3).pack()
def func3():
conn = MySQLdb.connect(host='localhost', user='root', passwd='natty'
, db='dbms')
cursor = conn.cursor()
From = int(box1.get().strip())
To = int(box2.get().strip())
Amt = int(box3.get().strip())
cursor.execute('select bal from account where acc=' + str(From) + ''
)
a = cursor.fetchone()
fromval = int(a[0])
cursor.execute('select bal from account where acc=' + str(To) + '')
b = cursor.fetchone()
toval = int(b[0])
fromval = fromval - Amt
toval = toval + Amt
cursor.execute('update account set bal=' + str(fromval)
+ ' where acc=' + str(From) + '')
cursor.execute('update account set bal=' + str(toval)
+ ' where acc=' + str(To) + '')
cursor.close()
conn.close()
master = Tk()
Button3 = Button(master, text='Transaction', command=tran).pack()
mainloop()
IyEvdXNyL2Jpbi9weXRob24KIyAtKi0gY29kaW5nOiB1dGYtOCAtKi0KZnJvbSBUa2ludGVyIGltcG9ydCAqCmltcG9ydCBNeVNRTGRiCgpkZWYgdHJhbigpOgogICAgZmlyc3QgPSBUaygpCiAgICBsYWJlbDEgPSBMYWJlbChmaXJzdCwgdGV4dD0nRnJvbScpCiAgICBsYWJlbDEucGFjaygpCiAgICBib3gxID0gRW50cnkoZmlyc3QpCiAgICBib3gxLnBhY2soKQogICAgbGFiZWwyID0gTGFiZWwoZmlyc3QsIHRleHQ9J1RvJykKICAgIGxhYmVsMi5wYWNrKCkKICAgIGJveDIgPSBFbnRyeShmaXJzdCkKICAgIGJveDIucGFjaygpCiAgICBsYWJlbDMgPSBMYWJlbChmaXJzdCwgdGV4dD0nQW10JykKICAgIGxhYmVsMy5wYWNrKCkKICAgIGJveDMgPSBFbnRyeShmaXJzdCkKICAgIGJveDMucGFjaygpCiAgICBCdXR0b24xID0gQnV0dG9uKGZpcnN0LCB0ZXh0PSdOZXh0JywgY29tbWFuZD1mdW5jMykucGFjaygpCgpkZWYgZnVuYzMoKToKICAgIGNvbm4gPSBNeVNRTGRiLmNvbm5lY3QoaG9zdD0nbG9jYWxob3N0JywgdXNlcj0ncm9vdCcsIHBhc3N3ZD0nbmF0dHknCiAgICAgICAgICAgICAgICAgICAgICAgICAgICwgZGI9J2RibXMnKQogICAgY3Vyc29yID0gY29ubi5jdXJzb3IoKQogICAgRnJvbSA9IGludChib3gxLmdldCgpLnN0cmlwKCkpCiAgICBUbyA9IGludChib3gyLmdldCgpLnN0cmlwKCkpCiAgICBBbXQgPSBpbnQoYm94My5nZXQoKS5zdHJpcCgpKQogICAgY3Vyc29yLmV4ZWN1dGUoJ3NlbGVjdCBiYWwgZnJvbSBhY2NvdW50IHdoZXJlIGFjYz0nICsgc3RyKEZyb20pICsgJycKICAgICAgICAgICAgICAgICAgICkKICAgIGEgPSBjdXJzb3IuZmV0Y2hvbmUoKQogICAgZnJvbXZhbCA9IGludChhWzBdKQogICAgY3Vyc29yLmV4ZWN1dGUoJ3NlbGVjdCBiYWwgZnJvbSBhY2NvdW50IHdoZXJlIGFjYz0nICsgc3RyKFRvKSArICcnKQogICAgYiA9IGN1cnNvci5mZXRjaG9uZSgpCiAgICB0b3ZhbCA9IGludChiWzBdKQogICAgZnJvbXZhbCA9IGZyb212YWwgLSBBbXQKICAgIHRvdmFsID0gdG92YWwgKyBBbXQKICAgIGN1cnNvci5leGVjdXRlKCd1cGRhdGUgYWNjb3VudCBzZXQgYmFsPScgKyBzdHIoZnJvbXZhbCkKICAgICAgICAgICAgICAgICAgICsgJyB3aGVyZSBhY2M9JyArIHN0cihGcm9tKSArICcnKQogICAgY3Vyc29yLmV4ZWN1dGUoJ3VwZGF0ZSBhY2NvdW50IHNldCBiYWw9JyArIHN0cih0b3ZhbCkKICAgICAgICAgICAgICAgICAgICsgJyB3aGVyZSBhY2M9JyArIHN0cihUbykgKyAnJykKICAgIGN1cnNvci5jbG9zZSgpCiAgICBjb25uLmNsb3NlKCkKCm1hc3RlciA9IFRrKCkKQnV0dG9uMyA9IEJ1dHRvbihtYXN0ZXIsIHRleHQ9J1RyYW5zYWN0aW9uJywgY29tbWFuZD10cmFuKS5wYWNrKCkKbWFpbmxvb3AoKQo=