db

type Database struct {
	ReaderDb *sqlx.DB // Database connection for read operations
	// contains filtered or unexported fields
}

type DatabaseStats struct {
	TotalQueries      int64         // Total queries from SQL driver stats
	Transactions      int64         // Total transactions executed
	OpenConnections   int           // Current number of open connections
	InUse             int           // Connections currently in use
	Idle              int           // Connections currently idle
	WaitCount         int64         // Total number of times waited for a connection
	WaitDuration      time.Duration // Total time blocked waiting for connections
	MaxIdleClosed     int64         // Total connections closed due to SetMaxIdleConns
	MaxLifetimeClosed int64         // Total connections closed due to SetConnMaxLifetime
}

type Node struct {
	NodeID       []byte        `db:"nodeid"`        // 32-byte node ID
	IP           []byte        `db:"ip"`            // IPv4 address (4 bytes)
	IPv6         []byte        `db:"ipv6"`          // IPv6 address (16 bytes)
	Port         int           `db:"port"`          // UDP port
	Seq          uint64        `db:"seq"`           // ENR sequence number
	ForkDigest   []byte        `db:"fork_digest"`   // 4-byte fork digest
	FirstSeen    int64         `db:"first_seen"`    // Unix timestamp
	LastSeen     sql.NullInt64 `db:"last_seen"`     // Unix timestamp (nullable)
	LastActive   sql.NullInt64 `db:"last_active"`   // Unix timestamp (nullable)
	ENR          []byte        `db:"enr"`           // RLP-encoded ENR
	SuccessCount int           `db:"success_count"` // Successful pings
	FailureCount int           `db:"failure_count"` // Failed pings
	AvgRTT       int           `db:"avg_rtt"`       // Average RTT in milliseconds
}

type SqliteDatabaseConfig struct {
	File         string `yaml:"file"`         // Database file path
	MaxOpenConns int    `yaml:"maxOpenConns"` // Maximum number of open connections to the database
	MaxIdleConns int    `yaml:"maxIdleConns"` // Maximum number of idle connections in the pool
}

type State struct {
	Key   string `db:"key"`   // State key identifier
	Value []byte `db:"value"` // State value (raw bytes)
}