database

func DeletePostById(id int64) error

func DeletePostTagsForPostId(post_id int64) error

func Initialize() error

func InsertPost(title []byte, slug string, markdown []byte, html []byte, featured bool, isPage bool, published bool, image []byte, created_at time.Time, created_by int64) (int64, error)

func InsertPostTag(post_id int64, tag_id int64) error

func InsertRoleUser(role_id int, user_id int64) error

func InsertTag(name []byte, slug string, created_at time.Time, created_by int64) (int64, error)

func InsertUser(name []byte, slug string, password string, email []byte, image []byte, cover []byte, created_at time.Time, created_by int64) (int64, error)

func RetrieveActiveTheme() (*string, error)

func RetrieveBlog() (*structure.Blog, error)

func RetrieveHashedPasswordForUser(name []byte) ([]byte, error)

func RetrieveNumberOfPosts() (int64, error)

func RetrieveNumberOfPostsByTag(tag_id int64) (int64, error)

func RetrieveNumberOfPostsByUser(user_id int64) (int64, error)

func RetrievePostById(id int64) (*structure.Post, error)

func RetrievePostBySlug(slug string) (*structure.Post, error)

func RetrievePostsByTag(tag_id int64, limit int64, offset int64) ([]structure.Post, error)

func RetrievePostsByUser(user_id int64, limit int64, offset int64) ([]structure.Post, error)

func RetrievePostsForApi(limit int64, offset int64) ([]structure.Post, error)

func RetrievePostsForIndex(limit int64, offset int64) ([]structure.Post, error)

func RetrieveTag(tagId int64) (*structure.Tag, error)

func RetrieveTagBySlug(slug string) (*structure.Tag, error)

func RetrieveTagIdBySlug(slug string) (int64, error)

func RetrieveTags(postId int64) ([]structure.Tag, error)

func RetrieveUser(id int64) (*structure.User, error)

func RetrieveUserByName(name []byte) (*structure.User, error)

func RetrieveUserBySlug(slug string) (*structure.User, error)

func RetrieveUsersCount() int

func UpdatePost(id int64, title []byte, slug string, markdown []byte, html []byte, featured bool, isPage bool, published bool, image []byte, updated_at time.Time, updated_by int64) error

func UpdateSettings(title []byte, description []byte, logo []byte, cover []byte, postsPerPage int64, activeTheme string, updated_at time.Time, updated_by int64) error

func UpdateUser(id int64, email []byte, image []byte, cover []byte, bio []byte, website []byte, location []byte, updated_at time.Time, updated_by int64) error

func UpdateUserPassword(id int64, password string, updated_at time.Time, updated_by int64) error