Versions in this module Expand all Collapse all v0 v0.9.1 May 27, 2025 v0.9.0 May 26, 2025 Changes in this version + const AlertBrief + const AlertBriefPerm + const AlertDoNotCare + const AlertNone + const AlertReadNew + const AlertReadNewPerm + const AlertShowNew + const AlertShowNewPerm + func AlertString(alert int64) string + func Context() context.Context + func EffectiveAlert(user, folder int64) int64 + func FolderAlertString(alert int64) string + func InitialiseSkewChecker(db *sqlx.DB, m *migrate.Migrate) + func Open() (*sqlx.DB, error) + type AddUserParams struct + Admin int64 + Disabled int64 + Login string + Name string + type Broadcast struct + Author string + Bell int64 + CreateAt time.Time + Message string + func (b Broadcast) String() string + type CreateFolderParams struct + Alert int64 + Always int64 + Description string + Expire int64 + Name string + Owner string + System int64 + Visibility int64 + type CreateMessageParams struct + Author string + Expiration time.Time + Folder string + Message string + Permanent int64 + Shutdown int64 + Subject string + type DBTX interface + ExecContext func(context.Context, string, ...interface{}) (sql.Result, error) + PrepareContext func(context.Context, string) (*sql.Stmt, error) + QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext func(context.Context, string, ...interface{}) *sql.Row + type Folder struct + Alert int64 + Always int64 + CreateAt time.Time + Description string + Expire int64 + Name string + Owner string + System int64 + UpdateAt time.Time + Visibility int64 + func (f Folder) String() string + type FolderAccess struct + Folder string + Login string + Visibility int64 + type FolderConfig struct + Alert int64 + Always int64 + Folder string + Login string + type GetAlertMessagesRow struct + FolderAlert int64 + Message Message + UserAlert int64 + type GetExpireRow struct + DefaultExpire int64 + ExpireLimit int64 + type GetLastLoginByEnabledRow struct + LastLogin time.Time + Login string + type GetLastLoginByLoginRow struct + LastLogin time.Time + Login string + type GetLastLoginRow struct + LastLogin time.Time + Login string + type GetLastReadByEnabledRow struct + Author string + ID int64 + type GetLastReadByUserRow struct + Author string + ID int64 + type GetLastReadRow struct + Author string + ID int64 + type ListFolderRow struct + Count int64 + Description string + Name string + type Mark struct + Folder string + Login string + Msgid int64 + type Message struct + Author string + CreateAt time.Time + Expiration time.Time + Folder string + ID int64 + Message string + Permanent int64 + Shutdown int64 + Subject string + System int64 + UpdateAt time.Time + func (m *Message) AlertLine() string + func (m *Message) OneLine(expire bool) string + func (m *Message) String() string + type Queries struct + func New(db DBTX) *Queries + func (q *Queries) AddMark(ctx context.Context, folder string, login string, msgid int64) error + func (q *Queries) AddUser(ctx context.Context, arg AddUserParams) (User, error) + func (q *Queries) CreateBroadcast(ctx context.Context, author string, bell int64, message string) error + func (q *Queries) CreateFolder(ctx context.Context, arg CreateFolderParams) error + func (q *Queries) CreateMessage(ctx context.Context, arg CreateMessageParams) error + func (q *Queries) DeleteAllExpiredMessages(ctx context.Context) (int64, error) + func (q *Queries) DeleteAllMessages(ctx context.Context, folder string) error + func (q *Queries) DeleteAllShutdownMessages(ctx context.Context) (int64, error) + func (q *Queries) DeleteFolder(ctx context.Context, name string) error + func (q *Queries) DeleteFolderAccess(ctx context.Context, login string, folder string) error + func (q *Queries) DeleteMark(ctx context.Context, folder string, login string, msgid int64) error + func (q *Queries) DeleteMessage(ctx context.Context, iD int64, folder string) error + func (q *Queries) DeleteUser(ctx context.Context, login string) error + func (q *Queries) FindFolderExact(ctx context.Context, name string) (Folder, error) + func (q *Queries) FindFolderPrefix(ctx context.Context, name sql.NullString) (Folder, error) + func (q *Queries) GetAlertMessages(ctx context.Context, login string, createAt time.Time) ([]GetAlertMessagesRow, error) + func (q *Queries) GetBroadcasts(ctx context.Context, createAt time.Time) ([]Broadcast, error) + func (q *Queries) GetExpire(ctx context.Context) (GetExpireRow, error) + func (q *Queries) GetFolder(ctx context.Context, name string) (Folder, error) + func (q *Queries) GetFolderExpire(ctx context.Context, name string) (int64, error) + func (q *Queries) GetLastLogin(ctx context.Context) ([]GetLastLoginRow, error) + func (q *Queries) GetLastLoginByEnabled(ctx context.Context, disabled int64) ([]GetLastLoginByEnabledRow, error) + func (q *Queries) GetLastLoginByLogin(ctx context.Context, login string) (GetLastLoginByLoginRow, error) + func (q *Queries) GetLastRead(ctx context.Context, folder string) ([]GetLastReadRow, error) + func (q *Queries) GetLastReadByEnabled(ctx context.Context, folder string, disabled int64) ([]GetLastReadByEnabledRow, error) + func (q *Queries) GetLastReadByUser(ctx context.Context, folder string, author string) (GetLastReadByUserRow, error) + func (q *Queries) GetMessage(ctx context.Context, iD int64, folder string) (Message, error) + func (q *Queries) GetSystem(ctx context.Context) (System, error) + func (q *Queries) GetUser(ctx context.Context, login string) (User, error) + func (q *Queries) IsFolderOwner(ctx context.Context, name string, owner string) (int64, error) + func (q *Queries) IsFolderReadable(ctx context.Context, name string, owner string) (int64, error) + func (q *Queries) IsFolderWriteable(ctx context.Context, name string, owner string) (int64, error) + func (q *Queries) IsUserAdmin(ctx context.Context, login string) (int64, error) + func (q *Queries) LastMsgidIgnoringSeen(ctx context.Context, folder string) (int64, error) + func (q *Queries) ListFolder(ctx context.Context) ([]ListFolderRow, error) + func (q *Queries) ListMessageIDs(ctx context.Context, folder string) ([]int64, error) + func (q *Queries) ListMessages(ctx context.Context, folder string) ([]Message, error) + func (q *Queries) ListUsers(ctx context.Context) ([]User, error) + func (q *Queries) NextMsgid(ctx context.Context, folder string, iD int64, login string) (int64, error) + func (q *Queries) NextMsgidIgnoringSeen(ctx context.Context, folder string, iD int64) (int64, error) + func (q *Queries) PrevMsgid(ctx context.Context, folder string, iD int64, login string) (int64, error) + func (q *Queries) ReadMessage(ctx context.Context, folder string, iD int64) (Message, error) + func (q *Queries) ReapBroadcasts(ctx context.Context) error + func (q *Queries) Search(ctx context.Context, column1 sql.NullString, iD int64, folder string) ([]Message, error) + func (q *Queries) SearchReply(ctx context.Context, arg SearchReplyParams) ([]Message, error) + func (q *Queries) SearchReplyReverse(ctx context.Context, arg SearchReplyReverseParams) ([]Message, error) + func (q *Queries) SearchReverse(ctx context.Context, column1 sql.NullString, iD int64, folder string) ([]Message, error) + func (q *Queries) SearchSubject(ctx context.Context, column1 sql.NullString, iD int64, folder string) ([]Message, error) + func (q *Queries) SearchSubjectReverse(ctx context.Context, column1 sql.NullString, iD int64, folder string) ([]Message, error) + func (q *Queries) SeedCreateMessage(ctx context.Context, arg SeedCreateMessageParams) error + func (q *Queries) SeedFolderGeneral(ctx context.Context) error + func (q *Queries) SeedUserSystem(ctx context.Context) error + func (q *Queries) SetMessageSeen(ctx context.Context, login string, folder string, msgid int64) error + func (q *Queries) SetSystem(ctx context.Context, name string, defaultExpire int64, expireLimit int64) error + func (q *Queries) UnsetMessageSeen(ctx context.Context, login string, folder string, msgid int64) error + func (q *Queries) UpdateDefaultExpire(ctx context.Context, defaultExpire int64) error + func (q *Queries) UpdateExpireLimit(ctx context.Context, expireLimit int64) error + func (q *Queries) UpdateFolderAccess(ctx context.Context, login string, folder string, visibility int64) error + func (q *Queries) UpdateFolderAlert(ctx context.Context, alert int64, name string) error + func (q *Queries) UpdateFolderAlways(ctx context.Context, always int64, name string) error + func (q *Queries) UpdateFolderMain(ctx context.Context, arg UpdateFolderMainParams) error + func (q *Queries) UpdateFolderSystem(ctx context.Context, system int64, name string) error + func (q *Queries) UpdateFolderVisibility(ctx context.Context, visibility int64, name string) error + func (q *Queries) UpdateLastActivity(ctx context.Context, lastActivity time.Time, login string) error + func (q *Queries) UpdateMessage(ctx context.Context, arg UpdateMessageParams) error + func (q *Queries) UpdateUserAdmin(ctx context.Context, admin int64, login string) error + func (q *Queries) UpdateUserAlert(ctx context.Context, login string, folder string, alert int64) error + func (q *Queries) UpdateUserDisabled(ctx context.Context, disabled int64, login string) error + func (q *Queries) UpdateUserLastLogin(ctx context.Context, login string) (time.Time, error) + func (q *Queries) UpdateUserMod(ctx context.Context, moderator int64, login string) error + func (q *Queries) UpdateUserName(ctx context.Context, name string, login string) error + func (q *Queries) UpdateUserPrompt(ctx context.Context, prompt int64, login string) error + func (q *Queries) WithTx(tx *sql.Tx) *Queries + type SearchReplyParams struct + Column1 sql.NullString + Folder string + ID int64 + Subject string + type SearchReplyReverseParams struct + Column1 sql.NullString + Folder string + ID int64 + Subject string + type SeedCreateMessageParams struct + Author string + CreateAt time.Time + Expiration time.Time + Folder string + Message string + Subject string + type Seen struct + CreateAt time.Time + Folder string + Login string + Msgid int64 + type SkewChecker struct + var Skew SkewChecker + func (skew *SkewChecker) Safe() bool + type System struct + DefaultExpire int64 + ExpireLimit int64 + Name string + type UpdateFolderMainParams struct + Description string + NewName string + OldName string + Owner string + type UpdateMessageParams struct + Expiration time.Time + ID int64 + Message string + Permanent int64 + Shutdown int64 + Subject string + System int64 + type User struct + Admin int64 + CreateAt time.Time + Disabled int64 + LastActivity time.Time + LastLogin time.Time + Login string + Moderator int64 + Name string + Prompt int64 + Signature interface{} + UpdateAt time.Time + func (u User) String() string