database

package

v1.0.0-alpha Latest Latest Go to latest Published: Dec 10, 2021 License: Apache-2.0 Imports: 9 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/bxtkezhan/funnylesson

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func AddContent(ctx context.Context, course, lesson, index int) error
func AddCourse(ctx context.Context, course *Course) error
func AddLesson(ctx context.Context, lesson *Lesson) error
func AddUser(ctx context.Context, user *User) error
func BuyLesson(ctx context.Context, user, lesson int) error
func CountFollowers(ctx context.Context, course int) (int, error)
func DelContent(ctx context.Context, course, lesson int) error
func DelCourse(ctx context.Context, id int) error
func DelLesson(ctx context.Context, id int) error
func DelUser(ctx context.Context, id int) error
func Follow(ctx context.Context, user, course int) error
func GenMime(ctx context.Context, total, count int) error
func GetCoursesPageTotal(ctx context.Context, size int, category string) (int, error)
func GetCoursesTotal(ctx context.Context, category string) (int, error)
func GetLessonsPageTotal(ctx context.Context, size int, owner int) (int, error)
func GetLessonsTotal(ctx context.Context, owner int) (int, error)
func GetMaxIndex(ctx context.Context, course int) (int, error)
func GetMimes(ctx context.Context, total, count int) ([]string, error)
func GetUsersPageTotal(ctx context.Context, size int) (int, error)
func GetUsersTotal(ctx context.Context) (int, error)
func HashString(text string) string
func IsBought(ctx context.Context, user, lesson int) (bool, error)
func IsExistContent(ctx context.Context, course, lesson int) (bool, error)
func IsFollowed(ctx context.Context, user, course int) (bool, error)
func Mining(ctx context.Context, user int, code string) (int, error)
func SetCourse(ctx context.Context, course *Course) error
func SetLesson(ctx context.Context, lesson *Lesson) error
func SetUser(ctx context.Context, user *User) error
func SetUserTicket(ctx context.Context, user *User) error
func UnFollow(ctx context.Context, user, course int) error
func ValidEmail(ctx context.Context, email string) bool
func ValidPassword(ctx context.Context, email, password string) int
type Course
- func GetCourseById(ctx context.Context, id int) (*Course, error)
- func GetLikes(ctx context.Context, user int) ([]*Course, error)
type CourseSummary
- func GetCourses(ctx context.Context, limit int, offset int, where string, args ...interface{}) ([]*CourseSummary, error)
- func GetCoursesByPage(ctx context.Context, page int, size int, category string) ([]*CourseSummary, error)
type Lesson
- func GetBoughts(ctx context.Context, user int) ([]*Lesson, error)
- func GetContents(ctx context.Context, course int) ([]*Lesson, error)
- func GetLessonById(ctx context.Context, id int) (*Lesson, error)
type LessonSummary
- func GetLessons(ctx context.Context, limit int, offset int, where string, args ...interface{}) ([]*LessonSummary, error)
- func GetLessonsByPage(ctx context.Context, page int, size int, owner int) ([]*LessonSummary, error)
type User
- func GetUserById(ctx context.Context, id int) (*User, error)
type UserSummary
- func GetUsers(ctx context.Context, limit int, offset int, where string, args ...interface{}) ([]*UserSummary, error)
- func GetUsersByPage(ctx context.Context, page int, size int) ([]*UserSummary, error)

Constants ¶

View Source

const Source string = "./fl.db"

Variables ¶

View Source

var DB *sql.DB

Functions ¶

func AddContent ¶

func AddContent(ctx context.Context, course, lesson, index int) error

func AddCourse ¶

func AddCourse(ctx context.Context, course *Course) error

func AddLesson ¶

func AddLesson(ctx context.Context, lesson *Lesson) error

func AddUser ¶

func AddUser(ctx context.Context, user *User) error

func BuyLesson ¶

func BuyLesson(ctx context.Context, user, lesson int) error

func CountFollowers ¶

func CountFollowers(ctx context.Context, course int) (int, error)

func DelContent ¶

func DelContent(ctx context.Context, course, lesson int) error

func DelCourse ¶

func DelCourse(ctx context.Context, id int) error

func DelLesson ¶

func DelLesson(ctx context.Context, id int) error

func DelUser ¶

func DelUser(ctx context.Context, id int) error

func Follow ¶

func Follow(ctx context.Context, user, course int) error

func GenMime ¶

func GenMime(ctx context.Context, total, count int) error

func GetCoursesPageTotal ¶

func GetCoursesPageTotal(ctx context.Context, size int, category string) (int, error)

func GetCoursesTotal ¶

func GetCoursesTotal(ctx context.Context, category string) (int, error)

func GetLessonsPageTotal ¶

func GetLessonsPageTotal(ctx context.Context, size int, owner int) (int, error)

func GetLessonsTotal ¶

func GetLessonsTotal(ctx context.Context, owner int) (int, error)

func GetMaxIndex ¶

func GetMaxIndex(ctx context.Context, course int) (int, error)

func GetMimes ¶

func GetMimes(ctx context.Context, total, count int) ([]string, error)

func GetUsersPageTotal ¶

func GetUsersPageTotal(ctx context.Context, size int) (int, error)

func GetUsersTotal ¶

func GetUsersTotal(ctx context.Context) (int, error)

func HashString ¶

func HashString(text string) string

func IsBought ¶

func IsBought(ctx context.Context, user, lesson int) (bool, error)

func IsExistContent ¶

func IsExistContent(ctx context.Context, course, lesson int) (bool, error)

func IsFollowed ¶

func IsFollowed(ctx context.Context, user, course int) (bool, error)

func Mining ¶

func Mining(ctx context.Context, user int, code string) (int, error)

func SetCourse ¶

func SetCourse(ctx context.Context, course *Course) error

func SetLesson ¶

func SetLesson(ctx context.Context, lesson *Lesson) error

func SetUser ¶

func SetUser(ctx context.Context, user *User) error

func SetUserTicket ¶

func SetUserTicket(ctx context.Context, user *User) error

func UnFollow ¶

func UnFollow(ctx context.Context, user, course int) error

func ValidEmail ¶

func ValidEmail(ctx context.Context, email string) bool

func ValidPassword ¶

func ValidPassword(ctx context.Context, email, password string) int

Types ¶

type Course ¶

type Course struct {
	Id           int
	Time         int64
	Title        string
	Introduction string
	Keywords     string
	Image        string
	Category     string
	Owner        int
	Total        int
	Level        int
}

CREATE TABLE "course" (

"id"	INTEGER NOT NULL,
"time"	INTEGER NOT NULL,
"title"	TEXT NOT NULL,
"introduction"	TEXT NOT NULL,
"keywords"	TEXT NOT NULL,
"image"	TEXT NOT NULL,
"category"	TEXT NOT NULL,
"total"	INTEGER NOT NULL DEFAULT 0,
"owner"	INTEGER NOT NULL,
"level"	INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY("id")

);

func GetCourseById ¶

func GetCourseById(ctx context.Context, id int) (*Course, error)

func GetLikes ¶

func GetLikes(ctx context.Context, user int) ([]*Course, error)

type CourseSummary ¶

type CourseSummary struct {
	Id           int
	Time         int64
	Title        string
	Introduction string
	Image        string
	Level        int
}

func GetCourses ¶

func GetCourses(
	ctx context.Context,
	limit int, offset int, where string,
	args ...interface{}) ([]*CourseSummary, error)

func GetCoursesByPage ¶

func GetCoursesByPage(
	ctx context.Context,
	page int, size int, category string) ([]*CourseSummary, error)

type Lesson ¶

type Lesson struct {
	Id           int
	Time         int64
	Title        string
	Introduction string
	Keywords     string
	Image        string
	Source       string
	Type         int
	Owner        int
	Ticket       int
	Level        int
}

CREATE TABLE "lesson" (

"id"	INTEGER NOT NULL,
"time"	INTEGER NOT NULL,
"title"	TEXT NOT NULL,
"introduction"	TEXT NOT NULL,
"keywords"	TEXT NOT NULL,
"image"	TEXT NOT NULL,
"source"	TEXT NOT NULL,
"type"	INTEGER NOT NULL DEFAULT 0,
"owner"	INTEGER NOT NULL,
"level"	INTEGER NOT NULL DEFAULT 0,
PRIMARY KEY("id")

);

func GetBoughts ¶

func GetBoughts(ctx context.Context, user int) ([]*Lesson, error)

func GetContents ¶

func GetContents(ctx context.Context, course int) ([]*Lesson, error)

func GetLessonById ¶

func GetLessonById(ctx context.Context, id int) (*Lesson, error)

type LessonSummary ¶

type LessonSummary struct {
	Id           int
	Time         int64
	Title        string
	Introduction string
	Image        string
	Ticket       int
	Level        int
}

func GetLessons ¶

func GetLessons(
	ctx context.Context,
	limit int, offset int, where string,
	args ...interface{}) ([]*LessonSummary, error)

func GetLessonsByPage ¶

func GetLessonsByPage(
	ctx context.Context,
	page int, size int, owner int) ([]*LessonSummary, error)

type User ¶

type User struct {
	Id           int
	Username     string
	Password     string
	Email        string
	Introduction string
	Image        string
	Ticket       int
	Time         int64
	Level        int
}

CREATE TABLE "user" (

	"id"	INTEGER NOT NULL,
	"username"	TEXT NOT NULL,
	"password"	TEXT NOT NULL,
	"email"	TEXT NOT NULL,
	"introduction"	TEXT,
	"image"	TEXT,
    "time" INTEGER NOT NULL,
	"level"	INTEGER NOT NULL DEFAULT 0,
	PRIMARY KEY("id")

);

func GetUserById ¶

func GetUserById(ctx context.Context, id int) (*User, error)

type UserSummary ¶

type UserSummary struct {
	Id           int
	Username     string
	Email        string
	Introduction string
	Image        string
	Ticket       int
	Time         int64
	Level        int
}

func GetUsers ¶

func GetUsers(
	ctx context.Context,
	limit int, offset int, where string,
	args ...interface{}) ([]*UserSummary, error)

func GetUsersByPage ¶

func GetUsersByPage(ctx context.Context, page int, size int) ([]*UserSummary, error)

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL