db

func Init(mysqlDSN string)

func InsertComment(comment *entity.Comment) error

func InsertOrder(orderNum string, orderPrice float32, mhId int64, userId int64, movieId int64, x int64, y int64, startTime string, endTime string) 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