print.py

import mysql.connector as sql
from tabulate import tabulate as tub
mycon=sql.connect(host='localhost',user='root',passwd='7654321',database='kvsfee')
cursor=mycon.cursor()
cursor.execute('select unque_id,student_name,gender,sgsc,admission_no,dob,class,stream,fathers_name,mothers_name from class_1;')
data=cursor.fetchall()
for i in data:
    print(i)
    print(tub(data,headers=['UNQUE_ID','STUDENT NAME','GENDER','SGSC','ADMISSION NO','DOB','CLASS','STREAM','FATHERS NAME','MOTHERS NAME'],tablefmt='psql'))
import mysql.connector as sql
from tabulate import tabulate as tub
mycon=sql.connect(host='localhost',user='root',passwd='7654321',database='kvsfee')
cursor=mycon.cursor()
cursor.execute('select unque_id,student_name,fee_status from class_1;')
data=cursor.fetchall()
for i in data:
    print(tub(data,headers=['UNQUE_ID','STUDENT NAME','FEE_STATUS'],tablefmt='psql'))
import mysql.connector as sql
from tabulate import tabulate as tub
mycon=sql.connect(host='localhost',user='root',passwd='7654321',database='kvsfee')
cursor=mycon.cursor()
cursor.execute("select unque_id,student_name,fee_status from class_1 WHERE FEE_STATUS = '{}'".format('PENDING'))
data=cursor.fetchall()
for i in data:
    print(tub(data,headers=['UNQUE_ID','STUDENT NAME','FEE_STATUS'],tablefmt='psql'))