db

Documentation

Index

• func Init(mysqlDSN string)
• func InsertComment(comment *entity.Comment) error
• func InsertOrder(orderNum string, orderPrice float32, mhId int64, userId int64, movieId int64, ...) error
• func InsertWantSeeRecord(movieId int64, userId int64) error
• func SelectCinemaByCid(cinemaId int64) (*entity.Cinema, error)
• func SelectFilmActorByMid(mid int64) ([]*entity.FilmActor, error)
• func SelectFilmDetail(movieId int64) (*entity.Film, error)
• func SelectFilmMessage(movieId int64) (*entity.Film, error)
• func SelectFilmNameCinemaName(hallId int64, filmId int64) (*entity.CinemaFilm, error)
• func SelectFilmPrice(movieId int64) (float32, error)
• func SelectLookAlreadyOrders(userId int64) ([]*entity.Order, error)
• func SelectMHNameMHId(mhId int64) (*entity.MovieHall, error)
• func SelectOrderMessage(orderNum string, userId int64) (*entity.Order, error)
• func SelectOrderNumMovieIdMHIdStartTime(userId int64) ([]*entity.Order, error)
• func SelectOrderScore(orderNum string, userId int64) (*entity.Order, error)
• func SelectUserNameByUserId(userId int64) (*entity.User, error)
• func SelectUserPhoneByUserId(userId int64) (*entity.User, error)
• func UpdateFilmScore(movieId int64, score int64) error
• func UpdateOrderScore(orderScore int64, userId int64, orderNum string) error
• func UpdateOrderStatus(orderNum string, userId int64) error
• func UpdateUserPhone(userID int64, phone int64) error

Functions

func Init

func Init(mysqlDSN string)

Init 初始化

func InsertComment

func InsertComment(comment *entity.Comment) error

func InsertOrder

func InsertOrder(orderNum string, orderPrice float32, mhId int64, userId int64, movieId int64, x int64, y int64, startTime string, endTime string) error

func InsertWantSeeRecord

func InsertWantSeeRecord(movieId int64, userId int64) error

func SelectCinemaByCid

func SelectCinemaByCid(cinemaId int64) (*entity.Cinema, error)

func SelectFilmActorByMid

func SelectFilmActorByMid(mid int64) ([]*entity.FilmActor, error)

func SelectFilmDetail

func SelectFilmDetail(movieId int64) (*entity.Film, error)

获取影片详情

func SelectFilmMessage

func SelectFilmMessage(movieId int64) (*entity.Film, error)

func SelectFilmNameCinemaName

func SelectFilmNameCinemaName(hallId int64, filmId int64) (*entity.CinemaFilm, error)

func SelectFilmPrice

func SelectFilmPrice(movieId int64) (float32, error)

func SelectLookAlreadyOrders

func SelectLookAlreadyOrders(userId int64) ([]*entity.Order, error)

func SelectMHNameMHId

func SelectMHNameMHId(mhId int64) (*entity.MovieHall, error)

func SelectOrderMessage

func SelectOrderMessage(orderNum string, userId int64) (*entity.Order, error)

func SelectOrderNumMovieIdMHIdStartTime

func SelectOrderNumMovieIdMHIdStartTime(userId int64) ([]*entity.Order, error)

func SelectOrderScore

func SelectOrderScore(orderNum string, userId int64) (*entity.Order, error)

func SelectUserNameByUserId

func SelectUserNameByUserId(userId int64) (*entity.User, error)

func SelectUserPhoneByUserId

func SelectUserPhoneByUserId(userId int64) (*entity.User, error)

func UpdateFilmScore

func UpdateFilmScore(movieId int64, score int64) error

更新影片评分

func UpdateOrderScore

func UpdateOrderScore(orderScore int64, userId int64, orderNum string) error

func UpdateOrderStatus

func UpdateOrderStatus(orderNum string, userId int64) error

func UpdateUserPhone

func UpdateUserPhone(userID int64, phone int64) error