db

Documentation

Index

• Constants
• Variables
• func CreateTaskTable(db SQLDB)
• func SQLExec(sqlStatement string, db SQLDB) error
• type FileCreatorHelper
• type SQLDB
  • func CreateSQLiteDB(filepath string, fc fileCreator) SQLDB
  • func DBOpen(filepath string) SQLDB
• type TaskStruct
  • func GetTasks(db SQLDB, done bool) []TaskStruct

Constants

const SelectStatement = "SELECT taskID, title, done FROM Task WHERE done = ?"

Variables

var FileCreate = os.Create

Functions

func CreateTaskTable

func CreateTaskTable(db SQLDB)

func SQLExec

func SQLExec(sqlStatement string, db SQLDB) error

Types

type FileCreatorHelper

type FileCreatorHelper struct{}

type SQLDB

type SQLDB interface {
	Exec(query string, args ...interface{}) (sql.Result, error)
	Query(query string, args ...interface{}) (rowScanner, error)
	Close() error
}

func CreateSQLiteDB

func CreateSQLiteDB(filepath string, fc fileCreator) SQLDB

func DBOpen

func DBOpen(filepath string) SQLDB

type TaskStruct

type TaskStruct struct {
	// contains filtered or unexported fields
}

func GetTasks

func GetTasks(db SQLDB, done bool) []TaskStruct

Use struct for return val instead