dbo

package
v0.0.62 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Oct 29, 2024 License: GPL-3.0 Imports: 9 Imported by: 1

Documentation

Index

Constants

View Source
const (
	TableSections = "Sections"
	TableForums   = "Forums"
	TableThreads  = "Threads"
	TableMessages = "Messages"
)
View Source
const (
	DbPsid_ReadSections                 = 0
	DbPsid_InsertNewForum               = 1
	DbPsid_CountForumsById              = 2
	DbPsid_DeleteSectionById            = 3
	DbPsid_GetSectionById               = 4
	DbPsid_SetForumNameById             = 5
	DbPsid_SetSectionChildTypeById      = 6
	DbPsid_SetForumSectionById          = 7
	DbPsid_GetForumSectionById          = 8
	DbPsid_InsertNewThread              = 9
	DbPsid_GetForumThreadsById          = 10
	DbPsid_SetForumThreadsById          = 11
	DbPsid_SetThreadNameById            = 12
	DbPsid_GetThreadForumById           = 13
	DbPsid_SetThreadForumById           = 14
	DbPsid_CountThreadsById             = 15
	DbPsid_GetThreadMessagesById        = 16
	DbPsid_InsertNewMessage             = 17
	DbPsid_SetThreadMessagesById        = 18
	DbPsid_SetMessageTextById           = 19
	DbPsid_GetMessageThreadById         = 20
	DbPsid_SetMessageThreadById         = 21
	DbPsid_GetMessageCreatorAndTimeById = 22
	DbPsid_GetMessageById               = 23
	DbPsid_DeleteMessageById            = 24
	DbPsid_GetThreadByIdM               = 25
	DbPsid_DeleteThreadById             = 26
	DbPsid_GetForumById                 = 27
	DbPsid_DeleteForumById              = 28
	DbPsid_ReadForums                   = 29
	DbPsid_CountRootSections            = 30
	DbPsid_InsertNewSection             = 31
	DbPsid_CountSectionsById            = 32
	DbPsid_GetSectionChildrenById       = 33
	DbPsid_SetSectionChildrenById       = 34
	DbPsid_SetSectionNameById           = 35
	DbPsid_GetSectionParentById         = 36
	DbPsid_SetSectionParentById         = 37
	DbPsid_GetSectionChildTypeById      = 38
	DbPsid_CountMessagesById            = 39
	DbPsid_ReadThreadLinks              = 40
)

Indices of prepared statements.

Variables

This section is empty.

Functions

This section is empty.

Types

type DatabaseObject

type DatabaseObject struct {
	cdbo.DatabaseObject
	// contains filtered or unexported fields
}

func NewDatabaseObject

func NewDatabaseObject(settings ms.DbSettings) (dbo *DatabaseObject)

func (*DatabaseObject) CountForumsById

func (dbo *DatabaseObject) CountForumsById(forumId cmb.Id) (n cmb.Count, err error)

func (*DatabaseObject) CountMessagesById

func (dbo *DatabaseObject) CountMessagesById(messageId cmb.Id) (n cmb.Count, err error)

func (*DatabaseObject) CountRootSections

func (dbo *DatabaseObject) CountRootSections() (n cmb.Count, err error)

func (*DatabaseObject) CountSectionsById

func (dbo *DatabaseObject) CountSectionsById(sectionId cmb.Id) (n cmb.Count, err error)

func (*DatabaseObject) CountThreadsById

func (dbo *DatabaseObject) CountThreadsById(threadId cmb.Id) (n cmb.Count, err error)

func (*DatabaseObject) DeleteForumById

func (dbo *DatabaseObject) DeleteForumById(forumId cmb.Id) (err error)

func (*DatabaseObject) DeleteMessageById

func (dbo *DatabaseObject) DeleteMessageById(messageId cmb.Id) (err error)

func (*DatabaseObject) DeleteSectionById

func (dbo *DatabaseObject) DeleteSectionById(sectionId cmb.Id) (err error)

func (*DatabaseObject) DeleteThreadById

func (dbo *DatabaseObject) DeleteThreadById(threadId cmb.Id) (err error)

func (*DatabaseObject) GetForumById

func (dbo *DatabaseObject) GetForumById(forumId cmb.Id) (forum *mm.Forum, err error)

func (*DatabaseObject) GetForumSectionById

func (dbo *DatabaseObject) GetForumSectionById(forumId cmb.Id) (sectionId cmb.Id, err error)

func (*DatabaseObject) GetForumThreadsById

func (dbo *DatabaseObject) GetForumThreadsById(forumId cmb.Id) (threads *ul.UidList, err error)

func (*DatabaseObject) GetMessageById

func (dbo *DatabaseObject) GetMessageById(messageId cmb.Id) (message *mm.Message, err error)

func (*DatabaseObject) GetMessageCreatorAndTimeById

func (dbo *DatabaseObject) GetMessageCreatorAndTimeById(messageId cmb.Id) (creatorUserId cmb.Id, ToC time.Time, ToE *time.Time, err error)

func (*DatabaseObject) GetMessageThreadById

func (dbo *DatabaseObject) GetMessageThreadById(messageId cmb.Id) (threadId cmb.Id, err error)

func (*DatabaseObject) GetPreparedStatementByIndex

func (dbo *DatabaseObject) GetPreparedStatementByIndex(i int) (ps *sql.Stmt)

func (*DatabaseObject) GetSectionById

func (dbo *DatabaseObject) GetSectionById(sectionId cmb.Id) (section *mm.Section, err error)

func (*DatabaseObject) GetSectionChildTypeById

func (dbo *DatabaseObject) GetSectionChildTypeById(sectionId cmb.Id) (childType byte, err error)

func (*DatabaseObject) GetSectionChildrenById

func (dbo *DatabaseObject) GetSectionChildrenById(sectionId cmb.Id) (children *ul.UidList, err error)

func (*DatabaseObject) GetSectionParentById

func (dbo *DatabaseObject) GetSectionParentById(sectionId cmb.Id) (parent *cmb.Id, err error)

func (*DatabaseObject) GetThreadById

func (dbo *DatabaseObject) GetThreadById(threadId cmb.Id) (thread *mm.Thread, err error)

func (*DatabaseObject) GetThreadForumById

func (dbo *DatabaseObject) GetThreadForumById(threadId cmb.Id) (forumId cmb.Id, err error)

func (*DatabaseObject) GetThreadMessagesById

func (dbo *DatabaseObject) GetThreadMessagesById(threadId cmb.Id) (messages *ul.UidList, err error)

func (*DatabaseObject) Init

func (dbo *DatabaseObject) Init() (err error)

Init connects to the database, initialises the tables and prepares SQL statements.

func (*DatabaseObject) InsertNewForum

func (dbo *DatabaseObject) InsertNewForum(sectionId cmb.Id, name cm.Name, creatorUserId cmb.Id) (lastInsertedId cmb.Id, err error)

func (*DatabaseObject) InsertNewMessage

func (dbo *DatabaseObject) InsertNewMessage(parentThread cmb.Id, messageText cmb.Text, textChecksum []byte, creatorUserId cmb.Id) (lastInsertedId cmb.Id, err error)

func (*DatabaseObject) InsertNewSection

func (dbo *DatabaseObject) InsertNewSection(parent *cmb.Id, name cm.Name, creatorUserId cmb.Id) (lastInsertedId cmb.Id, err error)

func (*DatabaseObject) InsertNewThread

func (dbo *DatabaseObject) InsertNewThread(parentForum cmb.Id, threadName cm.Name, creatorUserId cmb.Id) (lastInsertedId cmb.Id, err error)

func (*DatabaseObject) ReadForums

func (dbo *DatabaseObject) ReadForums() (forums []mm.Forum, err error)

func (*DatabaseObject) ReadMessageLinksById added in v0.0.56

func (dbo *DatabaseObject) ReadMessageLinksById(messageIds *ul.UidList) (messageLinks []mm.MessageLink, err error)

func (*DatabaseObject) ReadMessagesById

func (dbo *DatabaseObject) ReadMessagesById(messageIds *ul.UidList) (messages []mm.Message, err error)

func (*DatabaseObject) ReadSections

func (dbo *DatabaseObject) ReadSections() (sections []mm.Section, err error)
func (dbo *DatabaseObject) ReadThreadLinks() (threadLinks []mm.ThreadLink, err error)

func (*DatabaseObject) ReadThreadNamesByIds added in v0.0.51

func (dbo *DatabaseObject) ReadThreadNamesByIds(threadIds ul.UidList) (threadNames []cm.Name, err error)

func (*DatabaseObject) ReadThreadsById

func (dbo *DatabaseObject) ReadThreadsById(threadIds *ul.UidList) (threads []mm.Thread, err error)

func (*DatabaseObject) SetForumNameById

func (dbo *DatabaseObject) SetForumNameById(forumId cmb.Id, name cm.Name, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetForumSectionById

func (dbo *DatabaseObject) SetForumSectionById(forumId cmb.Id, sectionId cmb.Id, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetForumThreadsById

func (dbo *DatabaseObject) SetForumThreadsById(forumId cmb.Id, threads *ul.UidList) (err error)

func (*DatabaseObject) SetMessageTextById

func (dbo *DatabaseObject) SetMessageTextById(messageId cmb.Id, text cmb.Text, textChecksum []byte, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetMessageThreadById

func (dbo *DatabaseObject) SetMessageThreadById(messageId cmb.Id, threadId cmb.Id, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetSectionChildTypeById

func (dbo *DatabaseObject) SetSectionChildTypeById(sectionId cmb.Id, childType byte) (err error)

func (*DatabaseObject) SetSectionChildrenById

func (dbo *DatabaseObject) SetSectionChildrenById(sectionId cmb.Id, children *ul.UidList) (err error)

func (*DatabaseObject) SetSectionNameById

func (dbo *DatabaseObject) SetSectionNameById(sectionId cmb.Id, name cm.Name, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetSectionParentById

func (dbo *DatabaseObject) SetSectionParentById(sectionId cmb.Id, parent cmb.Id, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetThreadForumById

func (dbo *DatabaseObject) SetThreadForumById(threadId cmb.Id, forumId cmb.Id, editorUserId cmb.Id) (err error)

func (*DatabaseObject) SetThreadMessagesById

func (dbo *DatabaseObject) SetThreadMessagesById(threadId cmb.Id, messages *ul.UidList) (err error)

func (*DatabaseObject) SetThreadNameById

func (dbo *DatabaseObject) SetThreadNameById(threadId cmb.Id, name cm.Name, editorUserId cmb.Id) (err error)

type TableNames

type TableNames struct {
	Sections string
	Forums   string
	Threads  string
	Messages string
}

Jump to

Keyboard shortcuts

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