listComp.py

from tkinter import *
from tkinter.ttk import *
from db import DBConnect
import sqlite3

class ListComp:
	def __init__(self):
		self._dbconnect = DBConnect()
		self._dbconnect.row_factory = sqlite3.Row
		self._root = Tk()
		self._root.title('List of Complaints')
		tv = Treeview(self._root)
		tv.pack()
		tv.heading('#0', text='ID')
		tv.configure(column=('#Name', '#Gender','#Phone No.','#Adhar No.', '#Comment'))
		tv.heading('#Name', text='Name')
		tv.heading('#Gender', text='Gender')
		tv.heading('#Phone No.', text='Phone No.')
		tv.heading('#Adhar No.', text='Adhar No.')
		tv.heading('#Comment', text='Comment')
		cursor = self._dbconnect.ListRequest()
		for row in cursor:
			tv.insert('', 'end', '#{}'.format(row['ID']),text=row['ID'])
			tv.set('#{}'.format(row['ID']),'#Name',row['Name'])
			tv.set('#{}'.format(row['ID']),'#Gender',row['Gender'])
			tv.set('#{}'.format(row['ID']),'#Phone No.',row['Phone_No'])
			tv.set('#{}'.format(row['ID']),'#Adhar No.',row['Adhar_No'])
			tv.set('#{}'.format(row['ID']),'#Comment',row['Comment'])