mysql

func Close(db *sql.DB) error

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

func CreateDataBase(db *sql.DB) error

func CreateTables(db *sql.DB) error

func InsertAction(db *sql.DB, videoId int64, typeId int64, userId int64, time int, start int, end int) error

func InsertActionType(db *sql.DB, name string) (int64, error)

func InsertUser(db *sql.DB, password string, udid int64, uoid int64) (int64, error)

func InsertUserDevice(db *sql.DB, device string) (int64, error)

func InsertUserOS(db *sql.DB, os string) (int64, error)

func InsertVideo(db *sql.DB, name string, typeId int64) (int64, error)

func InsertVideoType(db *sql.DB, name string) (int64, error)

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

func SelectActionTypeById(db *sql.DB, id int) (string, error)

func SelectActionTypeByName(db *sql.DB, name string) (int, error)

func SelectDataBase(db *sql.DB) error

func SelectUser(db *sql.DB, id int64) (string, error)

func SelectUserDevice(db *sql.DB, device string) (int64, error)

func SelectUserOS(db *sql.DB, os string) (int64, error)

func SelectVideoId(db *sql.DB, name string) (int64, error)

func SelectVideoType(db *sql.DB, name string) (int64, error)

func ValidateUser(db *sql.DB, id int64, password string) error

func ValidateUserByStr(db *sql.DB, id string, password string) (int64, error)