#!/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()