database

package

v0.0.0-...-47e3236 Latest Latest Go to latest Published: Mar 24, 2025 License: MIT Imports: 7 Imported by: 0

Details

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

Repository

github.com/CnTeng/rx-todo

Links

Open Source Insights

Documentation ¶

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

This section is empty.

Types ¶

type DB ¶

type DB struct {
	*sql.DB
}

func NewDB ¶

func NewDB(dsn string) (DB, error)

func (*DB) CreateLabel ¶

func (db *DB) CreateLabel(label *model.Label) (*model.Label, error)

func (*DB) CreateProject ¶

func (db *DB) CreateProject(project *model.Project) (*model.Project, error)

func (*DB) CreateReminder ¶

func (db *DB) CreateReminder(reminder *model.Reminder) (*model.Reminder, error)

func (*DB) CreateTask ¶

func (db *DB) CreateTask(task *model.Task) (*model.Task, error)

func (*DB) CreateToken ¶

func (db *DB) CreateToken(token *model.Token) (*model.Token, error)

func (*DB) CreateUser ¶

func (db *DB) CreateUser(user *model.User) (*model.User, error)

func (*DB) DeleteLabel ¶

func (db *DB) DeleteLabel(id, userID int64) error

func (*DB) DeleteProject ¶

func (db *DB) DeleteProject(id, userID int64) error

func (*DB) DeleteReminder ¶

func (db *DB) DeleteReminder(reminder *model.Reminder) error

func (*DB) DeleteTask ¶

func (db *DB) DeleteTask(task *model.Task) error

func (*DB) DeleteToken ¶

func (db *DB) DeleteToken(token *model.Token) error

func (*DB) DeleteUser ¶

func (db *DB) DeleteUser(id int64) error

func (*DB) GetLabelByID ¶

func (db *DB) GetLabelByID(id, userID int64) (*model.Label, error)

func (*DB) GetLabelByName ¶

func (db *DB) GetLabelByName(name string, userID int64) (*model.Label, error)

func (*DB) GetLabels ¶

func (db *DB) GetLabels(userID int64) ([]*model.Label, error)

func (*DB) GetLabelsByTaskID ¶

func (db *DB) GetLabelsByTaskID(taskID, userID int64) ([]*model.Label, error)

func (*DB) GetLabelsByUpdateTime ¶

func (db *DB) GetLabelsByUpdateTime(updateTime *time.Time, userID int64) ([]*model.Label, error)

func (*DB) GetProjectByID ¶

func (db *DB) GetProjectByID(id, userID int64) (*model.Project, error)

func (*DB) GetProjects ¶

func (db *DB) GetProjects(userID int64) ([]*model.Project, error)

func (*DB) GetProjectsByUpdateTime ¶

func (db *DB) GetProjectsByUpdateTime(userID int64, updateTime *time.Time) ([]*model.Project, error)

func (*DB) GetReminderByID ¶

func (db *DB) GetReminderByID(userID, id int64) (*model.Reminder, error)

func (*DB) GetReminderByTaskID ¶

func (db *DB) GetReminderByTaskID(userID, taskID int64) (*model.Reminder, error)

func (*DB) GetReminders ¶

func (db *DB) GetReminders(userID int64) ([]*model.Reminder, error)

func (*DB) GetRemindersByUpdateTime ¶

func (db *DB) GetRemindersByUpdateTime(userID int64, updateTime *time.Time) ([]*model.Reminder, error)

func (*DB) GetTaskByID ¶

func (db *DB) GetTaskByID(userID, id int64) (*model.Task, error)

func (*DB) GetTasks ¶

func (db *DB) GetTasks(user int64) ([]*model.Task, error)

func (*DB) GetTasksByUpdateTime ¶

func (db *DB) GetTasksByUpdateTime(user int64, updateTime *time.Time) ([]*model.Task, error)

func (*DB) GetTokenByID ¶

func (db *DB) GetTokenByID(userID, id int64) (*model.Token, error)

func (*DB) GetTokens ¶

func (db *DB) GetTokens(userID int64) ([]*model.Token, error)

func (*DB) GetUserByEmail ¶

func (db *DB) GetUserByEmail(email string) (*model.User, error)

func (*DB) GetUserByID ¶

func (db *DB) GetUserByID(id int64) (*model.User, error)

func (*DB) GetUserByUpdateTime ¶

func (db *DB) GetUserByUpdateTime(id int64, updateTime *time.Time) (*model.User, error)

func (*DB) GetUserIDByToken ¶

func (db *DB) GetUserIDByToken(token *string) (int64, error)

func (*DB) GetUserInboxID ¶

func (db *DB) GetUserInboxID(id int64) (int64, error)

func (*DB) Migrate ¶

func (db *DB) Migrate() error

func (*DB) UpdateLabel ¶

func (db *DB) UpdateLabel(label *model.Label) (*model.Label, error)

func (*DB) UpdateProject ¶

func (db *DB) UpdateProject(project *model.Project) (*model.Project, error)

func (*DB) UpdateProjectPosition ¶

func (db *DB) UpdateProjectPosition(project *model.Project, previousID int64) (*model.Project, error)

func (*DB) UpdateProjectStatus ¶

func (db *DB) UpdateProjectStatus(project *model.Project) (*model.Project, error)

func (*DB) UpdateReminder ¶

func (db *DB) UpdateReminder(reminder *model.Reminder) (*model.Reminder, error)

func (*DB) UpdateTask ¶

func (db *DB) UpdateTask(task *model.Task) (*model.Task, error)

func (*DB) UpdateTaskArchivedStatus ¶

func (db *DB) UpdateTaskArchivedStatus(task *model.Task) (*model.Task, error)

func (*DB) UpdateTaskDoneStatus ¶

func (db *DB) UpdateTaskDoneStatus(task *model.Task) (*model.Task, error)

func (*DB) UpdateTaskPosition ¶

func (db *DB) UpdateTaskPosition(task *model.Task, previousID int64) (*model.Task, error)

func (*DB) UpdateToken ¶

func (db *DB) UpdateToken(token *model.Token) (*model.Token, error)

func (*DB) UpdateUser ¶

func (db *DB) UpdateUser(user *model.User) (*model.User, error)

func (*DB) VerifyUser ¶

func (db *DB) VerifyUser(id int64, password string) error

Source Files ¶

View all Source files

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