def create_fees_table(): execute_query(query=''' CREATE TABLE fees ( ID SERIAL PRIMARY KEY, REGNO VARCHAR(255) REFERENCES students(REGNO), FEE_PAYMENT REAL ); ''')
def create_master_students_table(): execute_query(query='''CREATE TABLE students2 ( ID SERIAL, REGNO VARCHAR(255) PRIMARY KEY, CAMPUS TEXT NOT NULL, YEAROFSTUDY INT NOT NULL ); ''')
def create_projects_table(): execute_query(query=''' CREATE TABLE projects ( ID SERIAL PRIMARY KEY, REGNO VARCHAR(255) REFERENCES students(REGNO), PROJECT_NAME VARCHAR NOT NULL, DEPARTMENT VARCHAR NOT NULL, SUPERVISOR VARCHAR NOT NULL ); ''')
def fetch_fragment_chiromo(): execute_query( query="select * from students_chiromo", host=site_chiromo['host'], ) # FETCH PARAMETARIZED DATA execute_query( query="select * from students_chiromo where id = 1", host=site_chiromo['host'], )
def create_fragment_chiromo(): students_records = execute_query( query="select * from students where campus = 'CHIROMO'", host=master_students_db['host']) execute_query(query='''CREATE TABLE students_chiromo ( ID INT UNIQUE NOT NULL, REGNO VARCHAR UNIQUE NOT NULL, CAMPUS TEXT NOT NULL, YEAROFSTUDY INT NOT NULL ); ''', host=site_chiromo['host']) insert_records_query(records_to_insert=students_records, query=""" INSERT INTO students_chiromo ( ID, REGNO, CAMPUS, YEAROFSTUDY ) VALUES %s """, host=site_chiromo['host'])
def create_fragment_kabete(): students = [] students_records = execute_query( query="select * from students where campus = 'KABETE'", host=master_students_db['host']) execute_query(query='''CREATE TABLE students_kabete ( ID INT UNIQUE NOT NULL, REGNO VARCHAR UNIQUE NOT NULL, CAMPUS TEXT NOT NULL, YEAROFSTUDY INT NOT NULL ); ''', host=site_kabete['host']) # TODO: Create A Mass Insert Function insert_records_query(records_to_insert=students_records, query=""" INSERT INTO students_kabete ( ID, REGNO, CAMPUS, YEAROFSTUDY ) VALUES %s """, host=site_kabete['host'])
def fetch_fee_data(): execute_query(query="select * from fees")
def fetch_master_data(): execute_query(query="select * from students")
def fetch_projects_data(): execute_query(query="select * from projects")
def delete_data_from_master(): execute_query(query="Delete from students where id = 10")