store

type AuditEntry struct {
	ID        string    `db:"id" json:"id"`
	Action    string    `db:"action" json:"action"` // connection_created, query_executed, etc.
	Detail    string    `db:"detail" json:"detail"`
	Level     string    `db:"level" json:"level"` // info, warning, error
	IPAddress string    `db:"ip_address" json:"ip_address"`
	CreatedAt time.Time `db:"created_at" json:"created_at"`
}

type ConnectionProfile struct {
	ID                string    `db:"id" json:"id"`
	Name              string    `db:"name" json:"name"`
	DBType            string    `db:"db_type" json:"db_type"` // postgres, mysql
	Host              string    `db:"host" json:"host"`
	Port              int       `db:"port" json:"port"`
	Database          string    `db:"database" json:"database"`
	Username          string    `db:"username" json:"username"`
	EncryptedPassword string    `db:"encrypted_password" json:"-"`
	CreatedAt         time.Time `db:"created_at" json:"created_at"`
	UpdatedAt         time.Time `db:"updated_at" json:"updated_at"`
}

type QueryRecord struct {
	ID              string    `db:"id" json:"id"`
	ConnectionID    string    `db:"connection_id" json:"connection_id"`
	Question        string    `db:"question" json:"question"`
	GeneratedSQL    string    `db:"generated_sql" json:"generated_sql"`
	ExecutionTimeMs int64     `db:"execution_time_ms" json:"execution_time_ms"`
	RowCount        int       `db:"row_count" json:"row_count"`
	Status          string    `db:"status" json:"status"` // success, error
	Error           string    `db:"error" json:"error,omitempty"`
	CreatedAt       time.Time `db:"created_at" json:"created_at"`
}

type Store struct {
	// contains filtered or unexported fields
}