init-tables.go

package dbutils

import (
	"database/sql"
	"log"
)

// Initialize the database and create required table
func Initialize(dbDriver *sql.DB) {
	statement, driverError := dbDriver.Prepare(clubs)
	if driverError != nil {
		log.Println("driverError ", driverError)
	}

	// Create player table
	_, statementError := statement.Exec()
	if statementError != nil {
		log.Println("Table already exists!")
	}

	statement, statementError = dbDriver.Prepare(players)
	if statementError != nil {
		log.Println("statementError", statementError)
	}
	statement.Exec()

	log.Println("All tables created/initialized successfully!")
}

models.go

package dbutils

const clubs = `
	CREATE TABLE IF NOT EXISTS clubs (
		ID INTEGER PRIMARY KEY AUTOINCREMENT,
		NAME VARCHAR(64) NOT NULL, 
		COUNTRY VARCHAR(64) NOT NULL, 
		STADIUM VARCHAR(64) NOT NULL,
		CreatedAt TIME NULL
	)
`

const players = `
	CREATE TABLE IF NOT EXISTS players (
		ID INTEGER PRIMARY KEY AUTOINCREMENT,
		NAME VARCHAR(64) NOT NULL, 
		ClubID INT, 
		AGE INTEGER, 
		POSITION VARCHAR(64) NOT NULL,
		CreatedAt TIME NULL,
		FOREIGN KEY (ClubID) REFERENCES clubs(ID)
	)
`