dbo

package
v0.0.66 Latest Latest
Warning

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

Go to latest
Published: Nov 3, 2024 License: GPL-3.0 Imports: 17 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 base2.Id) (n base2.Count, err error)

func (*DatabaseObject) CountMessagesById

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

func (*DatabaseObject) CountRootSections

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

func (*DatabaseObject) CountSectionsById

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

func (*DatabaseObject) CountThreadsById

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

func (*DatabaseObject) DeleteForumById

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

func (*DatabaseObject) DeleteMessageById

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

func (*DatabaseObject) DeleteSectionById

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

func (*DatabaseObject) DeleteThreadById

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

func (*DatabaseObject) GetForumById

func (dbo *DatabaseObject) GetForumById(forumId base2.Id) (forum derived2.IForum, err error)

func (*DatabaseObject) GetForumSectionById

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

func (*DatabaseObject) GetForumThreadsById

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

func (*DatabaseObject) GetMessageById

func (dbo *DatabaseObject) GetMessageById(messageId base2.Id) (message derived2.IMessage, err error)

func (*DatabaseObject) GetMessageCreatorAndTimeById

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

func (*DatabaseObject) GetMessageThreadById

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

func (*DatabaseObject) GetPreparedStatementByIndex

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

func (*DatabaseObject) GetSectionById

func (dbo *DatabaseObject) GetSectionById(sectionId base2.Id) (section derived2.ISection, err error)

func (*DatabaseObject) GetSectionChildTypeById

func (dbo *DatabaseObject) GetSectionChildTypeById(sectionId base2.Id) (childType derived1.ISectionChildType, err error)

func (*DatabaseObject) GetSectionChildrenById

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

func (*DatabaseObject) GetSectionParentById

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

func (*DatabaseObject) GetThreadById

func (dbo *DatabaseObject) GetThreadById(threadId base2.Id) (thread derived2.IThread, err error)

func (*DatabaseObject) GetThreadForumById

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

func (*DatabaseObject) GetThreadMessagesById

func (dbo *DatabaseObject) GetThreadMessagesById(threadId base2.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 base2.Id, name cm.Name, creatorUserId base2.Id) (lastInsertedId base2.Id, err error)

func (*DatabaseObject) InsertNewMessage

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

func (*DatabaseObject) InsertNewSection

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

func (*DatabaseObject) InsertNewThread

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

func (*DatabaseObject) ReadForums

func (dbo *DatabaseObject) ReadForums() (forums []derived2.IForum, 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 []derived2.IMessage, err error)

func (*DatabaseObject) ReadSections

func (dbo *DatabaseObject) ReadSections() (sections []derived2.ISection, 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 []derived2.IThread, err error)

func (*DatabaseObject) SetForumNameById

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

func (*DatabaseObject) SetForumSectionById

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

func (*DatabaseObject) SetForumThreadsById

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

func (*DatabaseObject) SetMessageTextById

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

func (*DatabaseObject) SetMessageThreadById

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

func (*DatabaseObject) SetSectionChildTypeById

func (dbo *DatabaseObject) SetSectionChildTypeById(sectionId base2.Id, childType derived1.ISectionChildType) (err error)

func (*DatabaseObject) SetSectionChildrenById

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

func (*DatabaseObject) SetSectionNameById

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

func (*DatabaseObject) SetSectionParentById

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

func (*DatabaseObject) SetThreadForumById

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

func (*DatabaseObject) SetThreadMessagesById

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

func (*DatabaseObject) SetThreadNameById

func (dbo *DatabaseObject) SetThreadNameById(threadId base2.Id, name cm.Name, editorUserId base2.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