db

type AcknowledgeAgencyWakeSignalParams struct {
	AcknowledgedAt sql.NullInt64 `json:"acknowledged_at"`
	DeliveredAt    sql.NullInt64 `json:"delivered_at"`
	ID             string        `json:"id"`
}

type AgencyAgent struct {
	ID               string         `json:"id"`
	OfficeID         string         `json:"office_id"`
	ConstitutionID   sql.NullString `json:"constitution_id"`
	ParentAgentID    sql.NullString `json:"parent_agent_id"`
	IdentityJson     string         `json:"identity_json"`
	RoleName         string         `json:"role_name"`
	RuntimeStatus    string         `json:"runtime_status"`
	LifecyclePhase   string         `json:"lifecycle_phase"`
	WorkspacePath    string         `json:"workspace_path"`
	InboxChannel     string         `json:"inbox_channel"`
	LastSnapshotID   sql.NullString `json:"last_snapshot_id"`
	LastWakeSignalID sql.NullString `json:"last_wake_signal_id"`
	CapabilitiesJson string         `json:"capabilities_json"`
	Metadata         string         `json:"metadata"`
	UpdatedAt        int64          `json:"updated_at"`
	CreatedAt        int64          `json:"created_at"`
}

type AgencyConsensusVote struct {
	ID            string `json:"id"`
	OfficeID      string `json:"office_id"`
	LedgerEntryID string `json:"ledger_entry_id"`
	AgentID       string `json:"agent_id"`
	QuorumKey     string `json:"quorum_key"`
	Decision      string `json:"decision"`
	Rationale     string `json:"rationale"`
	Weight        int64  `json:"weight"`
	Metadata      string `json:"metadata"`
	CreatedAt     int64  `json:"created_at"`
}

type AgencyConstitution struct {
	ID              string `json:"id"`
	OfficeID        string `json:"office_id"`
	Name            string `json:"name"`
	Kind            string `json:"kind"`
	IsActive        bool   `json:"is_active"`
	OrgIntent       string `json:"org_intent"`
	Governance      string `json:"governance"`
	RoleSpecs       string `json:"role_specs"`
	CapabilityPacks string `json:"capability_packs"`
	SchedulePolicy  string `json:"schedule_policy"`
	Metadata        string `json:"metadata"`
	UpdatedAt       int64  `json:"updated_at"`
	CreatedAt       int64  `json:"created_at"`
}

type AgencyContextSnapshot struct {
	ID            string         `json:"id"`
	OfficeID      string         `json:"office_id"`
	SourceEntryID sql.NullString `json:"source_entry_id"`
	SnapshotKind  string         `json:"snapshot_kind"`
	Payload       string         `json:"payload"`
	CreatedAt     int64          `json:"created_at"`
}

type AgencyLedgerEntry struct {
	ID                 string         `json:"id"`
	OfficeID           string         `json:"office_id"`
	AgentID            sql.NullString `json:"agent_id"`
	EntryType          string         `json:"entry_type"`
	ProposalKind       string         `json:"proposal_kind"`
	SnapshotID         sql.NullString `json:"snapshot_id"`
	ParentEntryID      sql.NullString `json:"parent_entry_id"`
	Status             string         `json:"status"`
	QuorumKey          string         `json:"quorum_key"`
	QuorumState        string         `json:"quorum_state"`
	ActionPayload      string         `json:"action_payload"`
	ObservationPayload string         `json:"observation_payload"`
	CommitCertificate  string         `json:"commit_certificate"`
	Metadata           string         `json:"metadata"`
	CommittedAt        sql.NullInt64  `json:"committed_at"`
	CreatedAt          int64          `json:"created_at"`
}

type AgencyOffice struct {
	ID               string `json:"id"`
	Name             string `json:"name"`
	Slug             string `json:"slug"`
	Mode             string `json:"mode"`
	Status           string `json:"status"`
	BusDriver        string `json:"bus_driver"`
	ConsensusMode    string `json:"consensus_mode"`
	WorkspacePath    string `json:"workspace_path"`
	SharedVolumePath string `json:"shared_volume_path"`
	RedisAddr        string `json:"redis_addr"`
	LedgerDriver     string `json:"ledger_driver"`
	Metadata         string `json:"metadata"`
	UpdatedAt        int64  `json:"updated_at"`
	CreatedAt        int64  `json:"created_at"`
}

type AgencySchedule struct {
	ID          string         `json:"id"`
	OfficeID    string         `json:"office_id"`
	AgentID     sql.NullString `json:"agent_id"`
	Name        string         `json:"name"`
	Timezone    string         `json:"timezone"`
	CronExpr    string         `json:"cron_expr"`
	WakeEvent   string         `json:"wake_event"`
	Enabled     bool           `json:"enabled"`
	LastFiredAt sql.NullInt64  `json:"last_fired_at"`
	NextFireAt  sql.NullInt64  `json:"next_fire_at"`
	Metadata    string         `json:"metadata"`
	UpdatedAt   int64          `json:"updated_at"`
	CreatedAt   int64          `json:"created_at"`
}

type AgencyWakeSignal struct {
	ID             string         `json:"id"`
	OfficeID       string         `json:"office_id"`
	AgentID        sql.NullString `json:"agent_id"`
	ScheduleID     sql.NullString `json:"schedule_id"`
	SignalType     string         `json:"signal_type"`
	Channel        string         `json:"channel"`
	Payload        string         `json:"payload"`
	Status         string         `json:"status"`
	AvailableAt    int64          `json:"available_at"`
	DeliveredAt    sql.NullInt64  `json:"delivered_at"`
	AcknowledgedAt sql.NullInt64  `json:"acknowledged_at"`
	CreatedAt      int64          `json:"created_at"`
}

type AppendAgencyLedgerEntryParams struct {
	ID                 string         `json:"id"`
	OfficeID           string         `json:"office_id"`
	AgentID            sql.NullString `json:"agent_id"`
	EntryType          string         `json:"entry_type"`
	ProposalKind       string         `json:"proposal_kind"`
	SnapshotID         sql.NullString `json:"snapshot_id"`
	ParentEntryID      sql.NullString `json:"parent_entry_id"`
	Status             string         `json:"status"`
	QuorumKey          string         `json:"quorum_key"`
	QuorumState        string         `json:"quorum_state"`
	ActionPayload      string         `json:"action_payload"`
	ObservationPayload string         `json:"observation_payload"`
	CommitCertificate  string         `json:"commit_certificate"`
	Metadata           string         `json:"metadata"`
	CommittedAt        sql.NullInt64  `json:"committed_at"`
}

type CommitAgencyLedgerEntryParams struct {
	Status            string        `json:"status"`
	QuorumState       string        `json:"quorum_state"`
	CommitCertificate string        `json:"commit_certificate"`
	Metadata          string        `json:"metadata"`
	CommittedAt       sql.NullInt64 `json:"committed_at"`
	ID                string        `json:"id"`
}

type CreateAgencyAgentParams struct {
	ID               string         `json:"id"`
	OfficeID         string         `json:"office_id"`
	ConstitutionID   sql.NullString `json:"constitution_id"`
	ParentAgentID    sql.NullString `json:"parent_agent_id"`
	IdentityJson     string         `json:"identity_json"`
	RoleName         string         `json:"role_name"`
	RuntimeStatus    string         `json:"runtime_status"`
	LifecyclePhase   string         `json:"lifecycle_phase"`
	WorkspacePath    string         `json:"workspace_path"`
	InboxChannel     string         `json:"inbox_channel"`
	LastSnapshotID   sql.NullString `json:"last_snapshot_id"`
	LastWakeSignalID sql.NullString `json:"last_wake_signal_id"`
	CapabilitiesJson string         `json:"capabilities_json"`
	Metadata         string         `json:"metadata"`
}

type CreateAgencyConsensusVoteParams struct {
	ID            string `json:"id"`
	OfficeID      string `json:"office_id"`
	LedgerEntryID string `json:"ledger_entry_id"`
	AgentID       string `json:"agent_id"`
	QuorumKey     string `json:"quorum_key"`
	Decision      string `json:"decision"`
	Rationale     string `json:"rationale"`
	Weight        int64  `json:"weight"`
	Metadata      string `json:"metadata"`
}

type CreateAgencyConstitutionParams struct {
	ID              string `json:"id"`
	OfficeID        string `json:"office_id"`
	Name            string `json:"name"`
	Kind            string `json:"kind"`
	IsActive        bool   `json:"is_active"`
	OrgIntent       string `json:"org_intent"`
	Governance      string `json:"governance"`
	RoleSpecs       string `json:"role_specs"`
	CapabilityPacks string `json:"capability_packs"`
	SchedulePolicy  string `json:"schedule_policy"`
	Metadata        string `json:"metadata"`
}

type CreateAgencyContextSnapshotParams struct {
	ID            string         `json:"id"`
	OfficeID      string         `json:"office_id"`
	SourceEntryID sql.NullString `json:"source_entry_id"`
	SnapshotKind  string         `json:"snapshot_kind"`
	Payload       string         `json:"payload"`
}

type CreateAgencyOfficeParams struct {
	ID               string `json:"id"`
	Name             string `json:"name"`
	Slug             string `json:"slug"`
	Mode             string `json:"mode"`
	Status           string `json:"status"`
	BusDriver        string `json:"bus_driver"`
	ConsensusMode    string `json:"consensus_mode"`
	WorkspacePath    string `json:"workspace_path"`
	SharedVolumePath string `json:"shared_volume_path"`
	RedisAddr        string `json:"redis_addr"`
	LedgerDriver     string `json:"ledger_driver"`
	Metadata         string `json:"metadata"`
}

type CreateAgencyScheduleParams struct {
	ID          string         `json:"id"`
	OfficeID    string         `json:"office_id"`
	AgentID     sql.NullString `json:"agent_id"`
	Name        string         `json:"name"`
	Timezone    string         `json:"timezone"`
	CronExpr    string         `json:"cron_expr"`
	WakeEvent   string         `json:"wake_event"`
	Enabled     bool           `json:"enabled"`
	LastFiredAt sql.NullInt64  `json:"last_fired_at"`
	NextFireAt  sql.NullInt64  `json:"next_fire_at"`
	Metadata    string         `json:"metadata"`
}

type CreateAgencyWakeSignalParams struct {
	ID             string         `json:"id"`
	OfficeID       string         `json:"office_id"`
	AgentID        sql.NullString `json:"agent_id"`
	ScheduleID     sql.NullString `json:"schedule_id"`
	SignalType     string         `json:"signal_type"`
	Channel        string         `json:"channel"`
	Payload        string         `json:"payload"`
	Status         string         `json:"status"`
	AvailableAt    int64          `json:"available_at"`
	DeliveredAt    sql.NullInt64  `json:"delivered_at"`
	AcknowledgedAt sql.NullInt64  `json:"acknowledged_at"`
}

type CreateFileParams struct {
	ID        string `json:"id"`
	SessionID string `json:"session_id"`
	Path      string `json:"path"`
	Content   string `json:"content"`
	Version   string `json:"version"`
}

type CreateMessageParams struct {
	ID        string         `json:"id"`
	SessionID string         `json:"session_id"`
	Role      string         `json:"role"`
	Parts     string         `json:"parts"`
	Model     sql.NullString `json:"model"`
}

type CreateSessionParams struct {
	ID               string         `json:"id"`
	ParentSessionID  sql.NullString `json:"parent_session_id"`
	Title            string         `json:"title"`
	MessageCount     int64          `json:"message_count"`
	PromptTokens     int64          `json:"prompt_tokens"`
	CompletionTokens int64          `json:"completion_tokens"`
	Cost             float64        `json:"cost"`
}

type DBTX interface {
	ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
	PrepareContext(context.Context, string) (*sql.Stmt, error)
	QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
	QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

type File struct {
	ID        string `json:"id"`
	SessionID string `json:"session_id"`
	Path      string `json:"path"`
	Content   string `json:"content"`
	Version   string `json:"version"`
	CreatedAt int64  `json:"created_at"`
	UpdatedAt int64  `json:"updated_at"`
}

type GetFileByPathAndSessionParams struct {
	Path      string `json:"path"`
	SessionID string `json:"session_id"`
}

type InsertRoutingLogParams struct {
	ID              string
	AgentID         string
	OrgID           string
	Provider        string
	ModelID         string
	ExecutionIntent string
	LatencyMs       int64
	TokensUsed      int
	GateReason      string
}

type ListAgencyConsensusVotesByQuorumParams struct {
	OfficeID  string `json:"office_id"`
	QuorumKey string `json:"quorum_key"`
}

type ListPendingAgencyWakeSignalsByAgentParams struct {
	AgentID     string `json:"agent_id"`
	AvailableAt int64  `json:"available_at"`
}

type ListPendingAgencyWakeSignalsByOfficeParams struct {
	OfficeID    string `json:"office_id"`
	AvailableAt int64  `json:"available_at"`
}

type MarkAgencyWakeSignalDeliveredParams struct {
	DeliveredAt sql.NullInt64 `json:"delivered_at"`
	ID          string        `json:"id"`
}

type Message struct {
	ID         string         `json:"id"`
	SessionID  string         `json:"session_id"`
	Role       string         `json:"role"`
	Parts      string         `json:"parts"`
	Model      sql.NullString `json:"model"`
	CreatedAt  int64          `json:"created_at"`
	UpdatedAt  int64          `json:"updated_at"`
	FinishedAt sql.NullInt64  `json:"finished_at"`
}

type Querier interface {
	AcknowledgeAgencyWakeSignal(ctx context.Context, arg AcknowledgeAgencyWakeSignalParams) (AgencyWakeSignal, error)
	ActivateAgencyConstitution(ctx context.Context, id string) (AgencyConstitution, error)
	AppendAgencyLedgerEntry(ctx context.Context, arg AppendAgencyLedgerEntryParams) (AgencyLedgerEntry, error)
	CommitAgencyLedgerEntry(ctx context.Context, arg CommitAgencyLedgerEntryParams) (AgencyLedgerEntry, error)
	CreateFile(ctx context.Context, arg CreateFileParams) (File, error)
	CreateAgencyAgent(ctx context.Context, arg CreateAgencyAgentParams) (AgencyAgent, error)
	CreateAgencyConsensusVote(ctx context.Context, arg CreateAgencyConsensusVoteParams) (AgencyConsensusVote, error)
	CreateAgencyConstitution(ctx context.Context, arg CreateAgencyConstitutionParams) (AgencyConstitution, error)
	CreateAgencyContextSnapshot(ctx context.Context, arg CreateAgencyContextSnapshotParams) (AgencyContextSnapshot, error)
	CreateAgencyOffice(ctx context.Context, arg CreateAgencyOfficeParams) (AgencyOffice, error)
	CreateAgencySchedule(ctx context.Context, arg CreateAgencyScheduleParams) (AgencySchedule, error)
	CreateAgencyWakeSignal(ctx context.Context, arg CreateAgencyWakeSignalParams) (AgencyWakeSignal, error)
	CreateMessage(ctx context.Context, arg CreateMessageParams) (Message, error)
	CreateSession(ctx context.Context, arg CreateSessionParams) (Session, error)
	DeactivateAgencyConstitutionsByOffice(ctx context.Context, officeID string) error
	DeleteFile(ctx context.Context, id string) error
	DeleteMessage(ctx context.Context, id string) error
	DeleteSession(ctx context.Context, id string) error
	DeleteSessionFiles(ctx context.Context, sessionID string) error
	DeleteSessionMessages(ctx context.Context, sessionID string) error
	GetActiveAgencyConstitutionByOffice(ctx context.Context, officeID string) (AgencyConstitution, error)
	GetAgencyAgentByID(ctx context.Context, id string) (AgencyAgent, error)
	GetAgencyConstitutionByID(ctx context.Context, id string) (AgencyConstitution, error)
	GetAgencyConsensusVoteByID(ctx context.Context, id string) (AgencyConsensusVote, error)
	GetAgencyContextSnapshotByID(ctx context.Context, id string) (AgencyContextSnapshot, error)
	GetAgencyLedgerEntryByID(ctx context.Context, id string) (AgencyLedgerEntry, error)
	GetAgencyOfficeByID(ctx context.Context, id string) (AgencyOffice, error)
	GetAgencyOfficeBySlug(ctx context.Context, slug string) (AgencyOffice, error)
	GetAgencyScheduleByID(ctx context.Context, id string) (AgencySchedule, error)
	GetAgencyWakeSignalByID(ctx context.Context, id string) (AgencyWakeSignal, error)
	GetFile(ctx context.Context, id string) (File, error)
	GetFileByPathAndSession(ctx context.Context, arg GetFileByPathAndSessionParams) (File, error)
	GetMessage(ctx context.Context, id string) (Message, error)
	GetSessionByID(ctx context.Context, id string) (Session, error)
	GetLatestAgencyContextSnapshotByOffice(ctx context.Context, officeID string) (AgencyContextSnapshot, error)
	ListAgencyAgentsByOffice(ctx context.Context, officeID string) ([]AgencyAgent, error)
	ListAgencyChildAgents(ctx context.Context, parentAgentID string) ([]AgencyAgent, error)
	ListAgencyConstitutionsByOffice(ctx context.Context, officeID string) ([]AgencyConstitution, error)
	ListAgencyConsensusVotesByLedgerEntry(ctx context.Context, ledgerEntryID string) ([]AgencyConsensusVote, error)
	ListAgencyConsensusVotesByQuorum(ctx context.Context, arg ListAgencyConsensusVotesByQuorumParams) ([]AgencyConsensusVote, error)
	ListAgencyContextSnapshotsByOffice(ctx context.Context, officeID string) ([]AgencyContextSnapshot, error)
	ListAgencyLedgerEntriesByOffice(ctx context.Context, officeID string) ([]AgencyLedgerEntry, error)
	ListAgencyOffices(ctx context.Context) ([]AgencyOffice, error)
	ListAgencyOfficesByStatus(ctx context.Context, status string) ([]AgencyOffice, error)
	ListAgencySchedulesByOffice(ctx context.Context, officeID string) ([]AgencySchedule, error)
	ListDueAgencySchedules(ctx context.Context, nextFireAt int64) ([]AgencySchedule, error)
	ListFilesByPath(ctx context.Context, path string) ([]File, error)
	ListFilesBySession(ctx context.Context, sessionID string) ([]File, error)
	ListLatestSessionFiles(ctx context.Context, sessionID string) ([]File, error)
	ListMessagesBySession(ctx context.Context, sessionID string) ([]Message, error)
	ListNewFiles(ctx context.Context) ([]File, error)
	ListPendingAgencyLedgerEntries(ctx context.Context, officeID string) ([]AgencyLedgerEntry, error)
	ListPendingAgencyWakeSignalsByAgent(ctx context.Context, arg ListPendingAgencyWakeSignalsByAgentParams) ([]AgencyWakeSignal, error)
	ListPendingAgencyWakeSignalsByOffice(ctx context.Context, arg ListPendingAgencyWakeSignalsByOfficeParams) ([]AgencyWakeSignal, error)
	ListSessions(ctx context.Context) ([]Session, error)
	MarkAgencyWakeSignalDelivered(ctx context.Context, arg MarkAgencyWakeSignalDeliveredParams) (AgencyWakeSignal, error)
	RejectAgencyLedgerEntry(ctx context.Context, arg RejectAgencyLedgerEntryParams) (AgencyLedgerEntry, error)
	UpdateFile(ctx context.Context, arg UpdateFileParams) (File, error)
	UpdateAgencyAgentRuntime(ctx context.Context, arg UpdateAgencyAgentRuntimeParams) (AgencyAgent, error)
	UpdateAgencyOfficeStatus(ctx context.Context, arg UpdateAgencyOfficeStatusParams) (AgencyOffice, error)
	UpdateAgencyScheduleFireTimes(ctx context.Context, arg UpdateAgencyScheduleFireTimesParams) (AgencySchedule, error)
	UpdateMessage(ctx context.Context, arg UpdateMessageParams) error
	UpdateSession(ctx context.Context, arg UpdateSessionParams) (Session, error)
}

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

type RejectAgencyLedgerEntryParams struct {
	QuorumState string `json:"quorum_state"`
	Metadata    string `json:"metadata"`
	ID          string `json:"id"`
}

type Session struct {
	ID               string         `json:"id"`
	ParentSessionID  sql.NullString `json:"parent_session_id"`
	Title            string         `json:"title"`
	MessageCount     int64          `json:"message_count"`
	PromptTokens     int64          `json:"prompt_tokens"`
	CompletionTokens int64          `json:"completion_tokens"`
	Cost             float64        `json:"cost"`
	UpdatedAt        int64          `json:"updated_at"`
	CreatedAt        int64          `json:"created_at"`
	SummaryMessageID sql.NullString `json:"summary_message_id"`
}

type UpdateAgencyAgentRuntimeParams struct {
	RuntimeStatus    string         `json:"runtime_status"`
	LifecyclePhase   string         `json:"lifecycle_phase"`
	LastSnapshotID   sql.NullString `json:"last_snapshot_id"`
	LastWakeSignalID sql.NullString `json:"last_wake_signal_id"`
	Metadata         string         `json:"metadata"`
	ID               string         `json:"id"`
}

type UpdateAgencyOfficeStatusParams struct {
	Status   string `json:"status"`
	Metadata string `json:"metadata"`
	ID       string `json:"id"`
}

type UpdateAgencyScheduleFireTimesParams struct {
	LastFiredAt sql.NullInt64 `json:"last_fired_at"`
	NextFireAt  sql.NullInt64 `json:"next_fire_at"`
	Metadata    string        `json:"metadata"`
	ID          string        `json:"id"`
}

type UpdateFileParams struct {
	Content string `json:"content"`
	Version string `json:"version"`
	ID      string `json:"id"`
}

type UpdateMessageParams struct {
	Parts      string        `json:"parts"`
	FinishedAt sql.NullInt64 `json:"finished_at"`
	ID         string        `json:"id"`
}

type UpdateSessionParams struct {
	Title            string         `json:"title"`
	PromptTokens     int64          `json:"prompt_tokens"`
	CompletionTokens int64          `json:"completion_tokens"`
	SummaryMessageID sql.NullString `json:"summary_message_id"`
	Cost             float64        `json:"cost"`
	ID               string         `json:"id"`
}