functions.h

#include <iostream>
#include <array>
#include <string>
#include "libsqlite.hpp"

using namespace std;

int showLecturers(){
    sqlite::sqlite db("4007database.db");
    
    auto cur = db.get_statement();
    cur->set_sql("SELECT * FROM LecturerTable;");
    cur->prepare();
   
    while( cur->step()){
        cout <<" "<< cur->get_int(0) << "     " << cur->get_text(1) <<endl;
        
    }
}

int showStudents(){
    sqlite::sqlite db("4007database.db");
    
    auto cur = db get_statement();
    cur->set_sql( "SELECT * FROM StudentTable" );
    cur->prepare();  

    while( cur->step()){
          cout <<" "<< cur->get_int(0) << "     " << cur->get_text(1) << "     " << cur->get_int(2)<<endl;
    }
}
 
int showModules(){
    sqlite::sqlite db("4007database.db");
    
    auto cur = db.get_statement();
    cur->set_sql( "SELECT * FROM ModuleTable" );
    cur->prepare();   
    
    while( cur->step()){
        cout <<" "<< cur->get_int(0) << "     " << cur->get_text(1) <<endl;
    }    
}