Jul-27-2018, 04:35 AM
Hi sir,
i have reached till here......
i am also attaching my backend code.
i have reached till here......
#C:/Users/prince.bhatia/Desktop/projects/Rera_App/project-3.py import tkinter as tk from tkinter import ttk from pandastable import Table, TableModel import sqlite3 import pandas as pd import Backend # --- classes --- class MyTable(Table): def handleCellEntry(self, row, col): super().handleCellEntry(row, col) print('changed:', row, col, "(TODO: update database)") return def save(): print(df) result = df.to_sql("crawled", conn, if_exists="replace") print(result) # --- main --- root = tk.Tk() #root.geometry("1250x650+0+0") #root.title("MAYA") #root.configure(background="black") f = tk.Frame(root) f.pack(fill="both", expand=True) conn = sqlite3.connect("99_data_increment.db") df = pd.read_sql_query("SELECT * FROM crawled", conn) pt = MyTable(f, dataframe=df, showtoolbar=True, showstatusbar=True) # <-- MyTable pt.show() f = tk.Button(root, text="Save", command=save) f.pack(fill="both", expand=True) root.mainloop()right now it is creating one index automatically and when i run the code
i am also attaching my backend code.
import sqlite3 def connect(): conn=sqlite3.connect("99_data_increment.db") cur=conn.cursor() cur.execute("CREATE TABLE IF NOT EXISTS crawled (id INTEGER PRIMARY KEY, State , XID , Project_Name , City , Main_City , Registration_Number , Promoter_Name , Rera_URL , PDF_text, Crawled_Date , Status, Names, Transaction_Date, Comments, Call_Contact_Number, Creation_Type, Builder_Website)") conn.commit() conn.close() def insert(State, XID, Project_Name, City, Main_City, Registration_Number, Promoter_Name, Rera_URL, PDF_text, Crawled_Date, Status, Names, Transaction_Date, Comments, Call_Contact_Number, Creation_Type, Builder_Website): conn=sqlite3.connect("99_data_increment.db") cur=conn.cursor() cur.execute("INSERT INTO crawled VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)",(State, XID, Project_Name, City, Main_City, Registration_Number, Promoter_Name, Rera_URL, PDF_text, Crawled_Date, Status, Names, Transaction_Date, Comments, Call_Contact_Number, Creation_Type, Builder_Website)) conn.commit() conn.close() connect()right now i have not received any error. I guess it is adding columns also when adding rows, not sure even