database

Documentation

Index

• func CreateTable(db *sql.DB)
• func GetStudentsFrom(db *sql.DB, city, promotion *string) []models.Student
• func Init(path string) (*sql.DB, error)
• func InsertData(db *sql.DB, students []models.Student) error

Functions

func CreateTable

func CreateTable(db *sql.DB)

CreateTable creates student table if not existing in current database

func GetStudentsFrom

func GetStudentsFrom(db *sql.DB, city, promotion *string) []models.Student

GetStudentsFrom retrieve students by their Promotion and City Orders them by their Bachelor's gpa if they are in Tek[1,2,3,4] and the Master one if they are in Tek5

func Init

func Init(path string) (*sql.DB, error)

Init database

func InsertData

func InsertData(db *sql.DB, students []models.Student) error

InsertData insert students in database Replace existing value with new one if present