Documentation
¶
Index ¶
- type DatabaseManager
- func (dm *DatabaseManager) Close() error
- func (dm *DatabaseManager) Connect(dbType, dsn string) error
- func (dm *DatabaseManager) Exec(sql string, args ...interface{}) (*QueryResult, error)
- func (dm *DatabaseManager) GetLastResult() *QueryResult
- func (dm *DatabaseManager) GetLastResultJSON() (string, error)
- func (dm *DatabaseManager) IsConnected() bool
- func (dm *DatabaseManager) Query(sql string, args ...interface{}) (*QueryResult, error)
- func (dm *DatabaseManager) QueryRow(sql string, args ...interface{}) (*QueryResult, error)
- type QueryResult
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type DatabaseManager ¶
type DatabaseManager struct {
// contains filtered or unexported fields
}
DatabaseManager manages database connections and operations
func NewDatabaseManager ¶
func NewDatabaseManager() *DatabaseManager
NewDatabaseManager creates a new database manager
func (*DatabaseManager) Close ¶
func (dm *DatabaseManager) Close() error
Close closes the database connection
func (*DatabaseManager) Connect ¶
func (dm *DatabaseManager) Connect(dbType, dsn string) error
Connect connects to a database dbType: "mysql", "postgres", or "sqlite" dsn: connection string
func (*DatabaseManager) Exec ¶
func (dm *DatabaseManager) Exec(sql string, args ...interface{}) (*QueryResult, error)
Exec executes a non-query SQL statement (INSERT, UPDATE, DELETE)
func (*DatabaseManager) GetLastResult ¶
func (dm *DatabaseManager) GetLastResult() *QueryResult
GetLastResult returns the last query result
func (*DatabaseManager) GetLastResultJSON ¶
func (dm *DatabaseManager) GetLastResultJSON() (string, error)
GetLastResultJSON returns the last query result as JSON
func (*DatabaseManager) IsConnected ¶
func (dm *DatabaseManager) IsConnected() bool
IsConnected checks if the database is connected
func (*DatabaseManager) Query ¶
func (dm *DatabaseManager) Query(sql string, args ...interface{}) (*QueryResult, error)
Query executes a SELECT query and returns results
func (*DatabaseManager) QueryRow ¶
func (dm *DatabaseManager) QueryRow(sql string, args ...interface{}) (*QueryResult, error)
QueryRow executes a SELECT query and returns a single row
type QueryResult ¶
type QueryResult struct {
Rows []map[string]interface{} `json:"rows"`
Row map[string]interface{} `json:"row,omitempty"`
Count int `json:"count"`
LastID int64 `json:"lastId,omitempty"`
// contains filtered or unexported fields
}
QueryResult holds the result of a database query
func (*QueryResult) ToJSON ¶
func (qr *QueryResult) ToJSON() (string, error)
ToJSON converts a QueryResult to JSON string
Source Files
Click to show internal directories.
Click to hide internal directories.