db

Documentation

Index

• func CreateTable(db *sql.DB, tableName string) error
• func DB() (*sql.DB, error)
• func Insert(db *sql.DB, id int, phoneNumber, tableName string) (int, error)
• func Report(db *sql.DB, tableName string) (*sql.Rows, error)
• func Reset(db *sql.DB, tableName string) (*sql.DB, error)

Functions

func CreateTable

func CreateTable(db *sql.DB, tableName string) error

CreateTable creates the table 'tableName' in the database 'db'

func DB

func DB() (*sql.DB, error)

DB initalises a sqlite3 DB and returns it

func Insert

func Insert(db *sql.DB, id int, phoneNumber, tableName string) (int, error)

Insert inserts phoneNumber into db

func Report

func Report(db *sql.DB, tableName string) (*sql.Rows, error)

Report returns the present state of the table 'tableName'

func Reset

func Reset(db *sql.DB, tableName string) (*sql.DB, error)

Reset resets the given database 'db'