def __init__(self): self._dbConnect = DBConnect() self._root = Tk() tv = ttk.Treeview(self._root) tv.pack() tv.heading("#0", text="ID") tv.configure(column=('Name', 'Gender', 'Comment')) tv.heading("Name", text='Full Name') tv.heading("Gender", text='Gender') tv.heading("Comment", text='Comment') cursor = self._dbConnect.listInfo() for row in cursor: tv.insert('', 'end', '#{}'.format(row["ID"]), text=row["ID"]) tv.set('#{}'.format(row["ID"]), 'Name', row["FullName"]) tv.set('#{}'.format(row["ID"]), 'Gender', row["Gender"]) tv.set('#{}'.format(row["ID"]), 'Comment', row["Comment"]) def deleteButton(): delRecord = deleteRecord() delButton = ttk.Button(self._root, text='Delete') delButton.pack() delButton.config(command=deleteButton) self._root.mainloop()
def continues(self): a = str(self.txtid.get()) b = str(self.txtname.get()) c = str(self.txtmeter.get()) d = str(self.txtward.get()) e = str(self.txthousetax.get()) f = str(self.txthealthtax.get()) g = str(self.txtlighttax.get()) h = str(self.txtwatertax.get()) i = str(self.txttotal.get()) database = DBConnect(host='localhost', user='******', password='******', database='etax2019') new_user = { 'idnumber': a, 'meternumber': c, 'wardnumber': d, 'name': b, 'housetax': e, 'healthtax': f, 'lighttax': g, 'watertax': h, 'total': i } database.insert(new_user, 'kalamwadiinfo') tkinter.messagebox.showinfo('etax-2019', 'Data was entered successfully')
def delete_student(id): db = DBConnect() result = db.execute("DELETE FROM students WHERE id='{}'".format(id)) response_object = {'method': 'deleted {}'.format(id)} db.close() return json.dumps(response_object)
def setUp(self): """Prepare for Test.""" environment = os.environ.get('CI_ENV', "local") if environment == "local": self.database = DBConnect('test/test_credentials.json') elif environment == "Gitlab": self.database = DBConnect('test/gitlab_credentials.json') elif environment == "Travis": self.database = DBConnect('test/travis_credentials.json')
class dbTest(TestCase): def setUp(self): """ Prepare for Test """ self.database = DBConnect('travis_credentials.json') def tearDown(self): """ Finish Testing """ # Delete all created rows self.database.cursor.execute("truncate test") self.database.commit() # Disconnect from database self.database.disconnect() def test_insert(self): """ Test inserting information into database """ new_user = { 'name': 'Emin Mastizada', 'email': '*****@*****.**', 'views': 6, } result = self.database.insert(new_user, 'test') self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) def test_commit(self): """ Test committing all users at once """ for user in USERS: result = self.database.insert(user, 'test', commit=False) self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) self.database.commit() # Now there should be 3 users in table with views=0 result = self.database.fetch( 'test', fields=['count(id)'], filters={'views': 0} ) self.assertTrue(len(result), "Fetch returned empty results") if len(result): self.assertTrue('count(id)' in result[0].keys(), "Requested field 'count(id)' missing in result keys") if 'count(id)' in result[0].keys(): self.assertEqual(result[0]['count(id)'], 3, "Number of new users in table should be 3") def test_fetch(self): """ Test fetching information from database """ pass
class dbTest(TestCase): def setUp(self): """ Prepare for Test """ self.database = DBConnect('travis_credentials.json') def tearDown(self): """ Finish Testing """ # Delete all created rows self.database.cursor.execute("truncate test") self.database.commit() # Disconnect from database self.database.disconnect() def test_insert(self): """ Test inserting information into database """ new_user = { 'name': 'Emin Mastizada', 'email': '*****@*****.**', 'views': 6, } result = self.database.insert(new_user, 'test') self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) def test_commit(self): """ Test committing all users at once """ for user in USERS: result = self.database.insert(user, 'test', commit=False) self.assertTrue( result["status"], "Insert Failed with message %s" % result["message"]) self.database.commit() # Now there should be 3 users in table with views=0 result = self.database.fetch('test', fields=['count(id)'], filters={'views': 0}) self.assertTrue(len(result), "Fetch returned empty results") if len(result): self.assertTrue( 'count(id)' in result[0].keys(), "Requested field 'count(id)' missing in result keys") if 'count(id)' in result[0].keys(): self.assertEqual(result[0]['count(id)'], 3, "Number of new users in table should be 3") def test_fetch(self): """ Test fetching information from database """ pass
def update_student(id): request_data = get_request_data(request) if len(request_data) == 0: return json.dumps({'error': 'no data'}) db = DBConnect() result = db.execute("UPDATE students SET {} WHERE id='{}'".format(to_string(request_data), id)) response_object = {'method': 'updated {}'.format(id)} db.close() return json.dumps(response_object)
def __init__(self): self._dbConnect = DBConnect() self._root = Tk() ttk.Label(self._root, text='Enter ID to delete: ').grid(row=0, column=0, pady=10, padx=10) entry = ttk.Entry(self._root, width=30, font=('Arial', 14)) entry.grid(row=0, column=1) delButton = ttk.Button(self._root, text='Delete') delButton.grid(row=0, column=2) def delete(): idEntry = int(entry.get()) self._dbConnect.deleteRecord(idEntry) entry.delete() messagebox.showinfo(title="Record deleted", message="Record with ID {} was successfully deleted!".format(idEntry)) delButton.config(command=delete)
def add_student(): request_data = get_request_data(request) if len(request_data) == 0: return json.dumps({'error': 'no data'}) db = DBConnect() values = ( request_data.get('name'), request_data.get('phone'), request_data.get('email'), request_data.get('address'), ) result = db.execute("INSERT INTO students (name, phone, email, address) VALUES (%s,%s,%s,%s)", values) response_object = {'method': 'created {}'.format(id)} db.close() return json.dumps(response_object)
def insert(type1, ammount1): ''' type1 --> str ammount1 --> integer ''' database = DBConnect(host=hostname, user=MYSQLusername, password=MYSQLpass, database=dbname) new_user = {'type': type1, 'ammount': ammount1} database.insert(new_user, 'Maintainance') database.commit()
def insert(year1,month1,day1,type1,ammount1): ''' year1 --> integer month1 --> integer day1 --> integer type1 --> str ammount1 --> integer ''' database = DBConnect(host=hostname,user=MYSQLusername,password=MYSQLpass, database=dbname) new_user = {'year': year1,'month': month1,'day': day1,'type': type1,'ammount': ammount1} database.insert(new_user,'Expences') database.commit()
def insert(fname1, lname1, Role1, exp1, salary1, att_today1, att_total1): ''' fname1 --> str lname1 --> str Role1 --> str exp1 --> int salary1 --> integer att_today1 --> integer att_total1 --> integer ''' database = DBConnect(host=hostname,user=MYSQLusername,password=MYSQLpass, database=dbname) new_user = {'fname' : fname1, 'lname' : lname1, 'Role' : Role1, 'exp' : exp1, 'salary' : salary1, 'att_today' : att_today1, 'att_total' : att_total1} database.insert(new_user,'workers') database.commit()
def submit4(self): a=str(self.txt_idnumber.get()); b=str(self.txt_name.get()); c=str(self.txt_meternumber.get()); d=str(self.txt_wardnumber.get()); e=str(self.txt_house.get()); f=str(self.txt_health.get()); g=str(self.txt_light.get()); h=str(self.txt_water.get()); i=str(self.txt_total.get()); j=str(self.txt_reciept.get()); k=str(self.txt_housepaid.get()); l=str(self.txt_healthpaid.get()); m=str(self.txt_lightpaid.get()); n=str(self.txt_waterpaid.get()); o=str(self.txt_totalpaid.get()); v=str(self.txt_village.get()); localtime=str(time.asctime(time.localtime(time.time()))) t=int(i) u=int(o) p=str(t-u) database = DBConnect(host='localhost',user='******',password='******',database='etax2019') new_user = {'village':v,'idnumber': a,'meternumber': c,'wardnumber': d,'name': b,'housetax': e,'healthtax': f,'lighttax': g,'watertax': h,'total': i,'reciptnumber':j,'housetaxpaid':k,'healthtaxpaid':l,'lighttaxpaid':m,'watertaxpaid':n,'totalpaid':o,'rest':p} database.insert(new_user,'updateddata') database.commit() content1="WARNING !!!!!! \n\n\n Hi there is a New request to modify eTAX 2019 database \n Here are details: \n Village Name : "+v+"\n\n" content2="\nReciept Number :"+j+"\nName :"+b+"\nID Number :"+a+"\nMeter Number :"+c+"\nWard Number :"+d+"\nHouse Tax :"+e+"\nHealth Tax :"+f+"\nLight Tax :"+g+"\nWater Tax :"+h+"\nTotal Ammount of tax to be paid :"+i+"\nPaid House Tax :"+k+"\nPaid Health Tax :"+l+"\nPaid Light Tax :"+m+"\nPiad Water Tax :"+n+"\nTotal Tax paid :"+o totcontaint=content1+content2 mail= smtplib.SMTP('smtp.gmail.com',587) mail.ehlo() mail.starttls() mail.login('*****@*****.**','Pass@123') mail.sendmail('*****@*****.**','*****@*****.**',totcontaint) mail.close() messagebox.showinfo("etax-2019","Data Deleted Successfully") root.destroy()
def setUp(self): """ Prepare for Test """ self.database = DBConnect('travis_credentials.json')
class DBTest(TestCase): def setUp(self): """Prepare for Test.""" environment = os.environ.get('CI_ENV', "local") if environment == "local": self.database = DBConnect('test/test_credentials.json') elif environment == "Gitlab": self.database = DBConnect('test/gitlab_credentials.json') elif environment == "Travis": self.database = DBConnect('test/travis_credentials.json') def tearDown(self): """Finish Testing.""" # Delete all created rows self.database.cursor.execute("truncate test") self.database.commit() # Disconnect from database self.database.disconnect() def test_insert(self): """Test inserting information into database.""" new_user = { 'name': 'Emin Mastizada', 'email': '*****@*****.**', 'views': 6, } result = self.database.insert(new_user, 'test') self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) def test_commit(self): """Test committing all users at once.""" for user in USERS: result = self.database.insert(user, 'test', commit=False) self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) self.database.commit() # Now there should be 3 users in table with views=0 result = self.database.fetch( 'test', fields=['count(id)'], filters={'views': 0} ) self.assertTrue(len(result), "Fetch returned empty results") if len(result): self.assertTrue('count(id)' in result[0].keys(), "Requested field 'count(id)' missing in result keys") if 'count(id)' in result[0].keys(): self.assertEqual(result[0]['count(id)'], 3, "Number of new users in table should be 3") def test_fetch(self): """Test fetching information from database.""" pass def test_sum(self): """Test value_sum functionality.""" counter = 1 for user in USERS[:3]: user['views'] = counter self.database.insert(user, 'test') counter += 1 sum_result = self.database.value_sum( 'test', fields=['views'] ) # views = 1 + 2 + 3 = 6 self.assertEqual( sum_result['views'], 6, "Sum of 3 new users should be 6" )
class DBTest(TestCase): def setUp(self): """Prepare for Test.""" environment = os.environ.get('CI_ENV', "local") if environment == "local": self.database = DBConnect('test/test_credentials.json') elif environment == "Gitlab": self.database = DBConnect('test/gitlab_credentials.json') elif environment == "Travis": self.database = DBConnect('test/travis_credentials.json') def tearDown(self): """Finish Testing.""" # Delete all created rows self.database.cursor.execute("truncate test") self.database.commit() # Disconnect from database self.database.disconnect() def test_insert(self): """Test inserting information into database.""" new_user = { 'name': 'Emin Mastizada', 'email': '*****@*****.**', 'views': 6, } result = self.database.insert(new_user, 'test') self.assertTrue(result["status"], "Insert Failed with message %s" % result["message"]) def test_commit(self): """Test committing all users at once.""" for user in USERS: result = self.database.insert(user, 'test', commit=False) self.assertTrue( result["status"], "Insert Failed with message %s" % result["message"]) self.database.commit() # Now there should be 3 users in table with views=0 result = self.database.fetch('test', fields=['count(id)'], filters={'views': 0}) self.assertTrue(len(result), "Fetch returned empty results") if len(result): self.assertTrue( 'count(id)' in result[0].keys(), "Requested field 'count(id)' missing in result keys") if 'count(id)' in result[0].keys(): self.assertEqual(result[0]['count(id)'], 3, "Number of new users in table should be 3") def test_fetch(self): """Test fetching information from database.""" pass def test_sum(self): """Test value_sum functionality.""" counter = 1 for user in USERS[:3]: user['views'] = counter self.database.insert(user, 'test') counter += 1 sum_result = self.database.value_sum('test', fields=['views']) # views = 1 + 2 + 3 = 6 self.assertEqual(sum_result['views'], 6, "Sum of 3 new users should be 6")
# from bs4 import BeautifulSoup from DBModels import JsonData from dbConnect import DBConnect import pandas as pd import json global session def add_json(json_file): with open(json_file) as f: json_input = json.load(f) for i in json_input: d = JsonData(id = i['thread_id'], json_data = i) session.add(d) session.commit() if __name__ == '__main__': config_file = "configuration.json" json_file = "json_outputs.json" global session # get connection engine and session db_connect = DBConnect() db_connect.start_db(config_file) engine = db_connect.get_engine() session = db_connect.get_session() add_json(json_file)
def submit5(self): a = str(self.txt_idnumber.get()) b = str(self.txt_name.get()) c = str(self.txt_meternumber.get()) d = str(self.txt_wardnumber.get()) e = str(self.txt_house.get()) f = str(self.txt_health.get()) g = str(self.txt_light.get()) h = str(self.txt_water.get()) i = str(self.txt_total.get()) j = str(self.txt_reciept.get()) k = str(self.txt_housepaid.get()) l = str(self.txt_healthpaid.get()) m = str(self.txt_lightpaid.get()) n = str(self.txt_waterpaid.get()) o = str(self.txt_totalpaid.get()) v = str(self.txt_village.get()) localtime = str(time.asctime(time.localtime(time.time()))) t = int(i) u = int(o) p = str(t - u) mydb = mysql.connector.connect(host='localhost', user='******', passwd='Pass@123', database='etax2019') mycursor = mydb.cursor() query = ("DELETE from updateddata where idnumber = %s" % (a)) mycursor.execute(query) mydb.commit() mydb = mysql.connector.connect(host='localhost', user='******', passwd='Pass@123', database='etax2019') mycursor = mydb.cursor() query = ("DELETE from %s where idnumber = %s" % (v, a)) mycursor.execute(query) mydb.commit() database = DBConnect(host='localhost', user='******', password='******', database='etax2019') new_user = { 'village': v, 'idnumber': a, 'meternumber': c, 'wardnumber': d, 'name': b, 'housetax': e, 'healthtax': f, 'lighttax': g, 'watertax': h, 'total': i, 'reciptnumber': j, 'housetaxpaid': k, 'healthtaxpaid': l, 'lighttaxpaid': m, 'watertaxpaid': n, 'totalpaid': o, 'rest': p } database.insert(new_user, 'updateddataper') mydb.commit() database = DBConnect(host='localhost', user='******', password='******', database='etax2019') new_user = { 'idnumber': a, 'meternumber': c, 'wardnumber': d, 'name': b, 'housetax': e, 'healthtax': f, 'lighttax': g, 'watertax': h, 'total': i, 'reciptnumber': j, 'housetaxpaid': k, 'healthtaxpaid': l, 'lighttaxpaid': m, 'watertaxpaid': n, 'totalpaid': o, 'rest': p } database.insert(new_user, v) mydb.commit() messagebox.showinfo("etax-2019", "Data Deleted Successfully")
from tkinter import * from tkinter import ttk from tkinter import messagebox from dbConnect import DBConnect from listReservation import listUsers dbConnect = DBConnect() root = Tk() root.configure(background='#015692') root.title('Reservation') #style style = ttk.Style() style.theme_use('classic') style.configure('TLabel', background='#015692', foreground='white') style.configure('TButton', background='#015692', foreground='white') style.configure('TRadiobutton', background='#015692', foreground='white') ttk.Label(root, text='Full name: ').grid(row=0, column=0, pady=10, padx=10) ttk.Label(root, text='Gender: ').grid(row=1, column=0) ttk.Label(root, text='Comment: ').grid(row=2, column=0) etFullName = ttk.Entry(root, width=30, font=('Arial', 14)) etFullName.grid(row=0, column=1, columnspan=3, pady=10) spanGender = StringVar() spanGender.set('Male') ttk.Radiobutton(root, text='Male', variable=spanGender, value='Male').grid(row=1, column=1) ttk.Radiobutton(root, text='Female', variable=spanGender,
def get_student(id): db = DBConnect() result = db.query("SELECT * FROM students WHERE id='{}'".format(id)) db.close() return json.dumps(result)
def get_students(): db = DBConnect() result = db.query("SELECT * FROM students") db.close() return json.dumps(result)
def connect_db(): """ Connects to database :return: DBConnect database """ return DBConnect('credentials.json')