db

package

v0.0.0-...-2025082 Latest Latest Go to latest Published: Jun 7, 2026 License: MIT Imports: 6 Imported by: 0

Details

This section is empty.

This section is empty.

This section is empty.

type Database struct {
	Conn *sql.DB
}

func Connect(databaseURL string) *Database

func (db *Database) Close() error

Ensure the connection is closed when the application shuts down

func (db *Database) GetCommandsRunCount(ctx context.Context) (int, error)

GetCommandsRunCount returns the total number of commands run from the command_logs table

func (db *Database) GetGuildConfig(ctx context.Context, guildID string) (*GuildConfig, error)

func (db *Database) IncrementCommandRun(ctx context.Context, guildID, userID, commandName string) error

IncrementCommandRun logs a command execution for tracking

func (db *Database) Migrate()

func (db *Database) Ping() error

func (db *Database) SetLogChannel(ctx context.Context, guildID string, channelID string) error

type GuildConfig struct {
	GuildID      string
	LogChannelID *string
}