db

type AddDependencyParams struct {
	IssueID     string         `json:"issue_id"`
	DependsOnID string         `json:"depends_on_id"`
	Type        string         `json:"type"`
	CreatedAt   time.Time      `json:"created_at"`
	CreatedBy   sql.NullString `json:"created_by"`
}

type AddLabelToIssueParams struct {
	IssueID string `json:"issue_id"`
	Label   string `json:"label"`
}

type AiAgent struct {
	ID           string         `json:"id"`
	SessionID    string         `json:"session_id"`
	Description  sql.NullString `json:"description"`
	Prompt       sql.NullString `json:"prompt"`
	AgentType    sql.NullString `json:"agent_type"`
	Model        sql.NullString `json:"model"`
	Status       string         `json:"status"`
	DurationMs   sql.NullInt64  `json:"duration_ms"`
	TotalTokens  sql.NullInt64  `json:"total_tokens"`
	ToolUseCount sql.NullInt64  `json:"tool_use_count"`
	CreatedAt    time.Time      `json:"created_at"`
}

type AiSession struct {
	ID             string         `json:"id"`
	TranscriptPath string         `json:"transcript_path"`
	Cwd            sql.NullString `json:"cwd"`
	StartedAt      time.Time      `json:"started_at"`
}

type BlockedIssuesCache struct {
	IssueID        string         `json:"issue_id"`
	BlockedByCount int64          `json:"blocked_by_count"`
	BlockedByIds   sql.NullString `json:"blocked_by_ids"`
	UpdatedAt      time.Time      `json:"updated_at"`
}

type ChildCounter struct {
	ParentID  string `json:"parent_id"`
	LastChild int64  `json:"last_child"`
}

type CloseIssueParams struct {
	ClosedAt    sql.NullTime   `json:"closed_at"`
	CloseReason sql.NullString `json:"close_reason"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ID          string         `json:"id"`
}

type Comment struct {
	ID        int64        `json:"id"`
	IssueID   string       `json:"issue_id"`
	Author    string       `json:"author"`
	Text      string       `json:"text"`
	CreatedAt time.Time    `json:"created_at"`
	UpdatedAt sql.NullTime `json:"updated_at"`
}

type Config struct {
	ProjectID string         `json:"project_id"`
	Key       string         `json:"key"`
	Value     sql.NullString `json:"value"`
}

type CountDependenciesParams struct {
	IssueID     string `json:"issue_id"`
	DependsOnID string `json:"depends_on_id"`
}

type CountIssuesByStatusParams struct {
	ProjectID string `json:"project_id"`
	Status    string `json:"status"`
}

type CreateAIAgentParams struct {
	ID           string         `json:"id"`
	SessionID    string         `json:"session_id"`
	Description  sql.NullString `json:"description"`
	Prompt       sql.NullString `json:"prompt"`
	AgentType    sql.NullString `json:"agent_type"`
	Model        sql.NullString `json:"model"`
	Status       string         `json:"status"`
	DurationMs   sql.NullInt64  `json:"duration_ms"`
	TotalTokens  sql.NullInt64  `json:"total_tokens"`
	ToolUseCount sql.NullInt64  `json:"tool_use_count"`
	CreatedAt    time.Time      `json:"created_at"`
}

type CreateAISessionParams struct {
	ID             string         `json:"id"`
	TranscriptPath string         `json:"transcript_path"`
	Cwd            sql.NullString `json:"cwd"`
	StartedAt      time.Time      `json:"started_at"`
}

type CreateCommentParams struct {
	IssueID   string    `json:"issue_id"`
	Author    string    `json:"author"`
	Text      string    `json:"text"`
	CreatedAt time.Time `json:"created_at"`
}

type CreateEventParams struct {
	IssueID   string         `json:"issue_id"`
	EventType string         `json:"event_type"`
	Actor     string         `json:"actor"`
	OldValue  sql.NullString `json:"old_value"`
	NewValue  sql.NullString `json:"new_value"`
	Comment   sql.NullString `json:"comment"`
	CreatedAt time.Time      `json:"created_at"`
}

type CreateIssueParams struct {
	ID          string         `json:"id"`
	ProjectID   string         `json:"project_id"`
	Title       string         `json:"title"`
	Description sql.NullString `json:"description"`
	Status      string         `json:"status"`
	Priority    int64          `json:"priority"`
	IssueType   string         `json:"issue_type"`
	Assignee    sql.NullString `json:"assignee"`
	AiSessionID sql.NullString `json:"ai_session_id"`
	ExternalRef sql.NullString `json:"external_ref"`
	CreatedAt   time.Time      `json:"created_at"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ClosedAt    sql.NullTime   `json:"closed_at"`
	CloseReason sql.NullString `json:"close_reason"`
}

type CreateLabelParams struct {
	Name        string         `json:"name"`
	Color       sql.NullString `json:"color"`
	Description sql.NullString `json:"description"`
}

type CreatePlanCommentParams struct {
	ID         string        `json:"id"`
	PlanID     string        `json:"plan_id"`
	LineNumber sql.NullInt64 `json:"line_number"`
	Content    string        `json:"content"`
	CreatedAt  time.Time     `json:"created_at"`
}

type CreatePlanParams struct {
	ID        string    `json:"id"`
	FilePath  string    `json:"file_path"`
	Status    string    `json:"status"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type CreateProjectParams struct {
	ID          string         `json:"id"`
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
	Prefix      string         `json:"prefix"`
	CreatedAt   time.Time      `json:"created_at"`
	UpdatedAt   time.Time      `json:"updated_at"`
}

type CreateWorkspaceParams struct {
	ID             string         `json:"id"`
	ProjectID      string         `json:"project_id"`
	Path           string         `json:"path"`
	Label          sql.NullString `json:"label"`
	Hostname       sql.NullString `json:"hostname"`
	GitRemote      sql.NullString `json:"git_remote"`
	PathType       string         `json:"path_type"`
	LastAccessedAt sql.NullTime   `json:"last_accessed_at"`
	CreatedAt      time.Time      `json:"created_at"`
	UpdatedAt      time.Time      `json:"updated_at"`
}

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 DeleteConfigParams struct {
	ProjectID string `json:"project_id"`
	Key       string `json:"key"`
}

type DeleteDependenciesByIssueParams struct {
	IssueID     string `json:"issue_id"`
	DependsOnID string `json:"depends_on_id"`
}

type Dependency struct {
	IssueID     string         `json:"issue_id"`
	DependsOnID string         `json:"depends_on_id"`
	Type        string         `json:"type"`
	CreatedAt   time.Time      `json:"created_at"`
	CreatedBy   sql.NullString `json:"created_by"`
}

type Event struct {
	ID        int64          `json:"id"`
	IssueID   string         `json:"issue_id"`
	EventType string         `json:"event_type"`
	Actor     string         `json:"actor"`
	OldValue  sql.NullString `json:"old_value"`
	NewValue  sql.NullString `json:"new_value"`
	Comment   sql.NullString `json:"comment"`
	CreatedAt time.Time      `json:"created_at"`
}

type GetAllConfigRow struct {
	Key   string         `json:"key"`
	Value sql.NullString `json:"value"`
}

type GetBlockedIssuesInProjectParams struct {
	ProjectID string `json:"project_id"`
	Limit     int64  `json:"limit"`
}

type GetBlockedIssuesInProjectRow struct {
	ID             string         `json:"id"`
	ProjectID      string         `json:"project_id"`
	Title          string         `json:"title"`
	Description    sql.NullString `json:"description"`
	Status         string         `json:"status"`
	Priority       int64          `json:"priority"`
	IssueType      string         `json:"issue_type"`
	Assignee       sql.NullString `json:"assignee"`
	ExternalRef    sql.NullString `json:"external_ref"`
	Rank           int64          `json:"rank"`
	CreatedAt      time.Time      `json:"created_at"`
	UpdatedAt      time.Time      `json:"updated_at"`
	ClosedAt       sql.NullTime   `json:"closed_at"`
	CloseReason    sql.NullString `json:"close_reason"`
	BlockedByCount int64          `json:"blocked_by_count"`
}

type GetConfigParams struct {
	ProjectID string `json:"project_id"`
	Key       string `json:"key"`
}

type GetEventsParams struct {
	IssueID string `json:"issue_id"`
	Limit   int64  `json:"limit"`
}

type GetOpenNonBlockedIssuesParams struct {
	ProjectID string `json:"project_id"`
	Limit     int64  `json:"limit"`
}

type GetProjectStatsRow struct {
	ProjectID        interface{} `json:"project_id"`
	TotalIssues      int64       `json:"total_issues"`
	OpenIssues       int64       `json:"open_issues"`
	InProgressIssues int64       `json:"in_progress_issues"`
	ClosedIssues     int64       `json:"closed_issues"`
	BlockedIssues    int64       `json:"blocked_issues"`
	DeferredIssues   int64       `json:"deferred_issues"`
}

type GetReadyIssuesHybridParams struct {
	ProjectID string `json:"project_id"`
	Limit     int64  `json:"limit"`
}

type GetReadyIssuesOldestParams struct {
	ProjectID string `json:"project_id"`
	Limit     int64  `json:"limit"`
}

type GetReadyIssuesPriorityParams struct {
	ProjectID string `json:"project_id"`
	Limit     int64  `json:"limit"`
}

type GlobalConfig struct {
	Key   string         `json:"key"`
	Value sql.NullString `json:"value"`
}

type Issue struct {
	ID          string         `json:"id"`
	ProjectID   string         `json:"project_id"`
	Title       string         `json:"title"`
	Description sql.NullString `json:"description"`
	Status      string         `json:"status"`
	Priority    int64          `json:"priority"`
	IssueType   string         `json:"issue_type"`
	Assignee    sql.NullString `json:"assignee"`
	AiSessionID sql.NullString `json:"ai_session_id"`
	ExternalRef sql.NullString `json:"external_ref"`
	Rank        int64          `json:"rank"`
	CreatedAt   time.Time      `json:"created_at"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ClosedAt    sql.NullTime   `json:"closed_at"`
	CloseReason sql.NullString `json:"close_reason"`
}

type IssueLabel struct {
	IssueID string `json:"issue_id"`
	Label   string `json:"label"`
}

type Label struct {
	Name        string         `json:"name"`
	Color       sql.NullString `json:"color"`
	Description sql.NullString `json:"description"`
}

type ListAISessionsParams struct {
	Limit  int64 `json:"limit"`
	Offset int64 `json:"offset"`
}

type ListIssuesFilteredParams struct {
	ProjectID   string      `json:"project_id"`
	Statuses    []string    `json:"statuses"`
	IssueTypes  []string    `json:"issue_types"`
	Priorities  []int64     `json:"priorities"`
	Assignee    interface{} `json:"assignee"`
	AiSessionID interface{} `json:"ai_session_id"`
	ParentID    interface{} `json:"parent_id"`
	Offset      int64       `json:"offset"`
	Limit       int64       `json:"limit"`
}

type MoveIssuesToProjectParams struct {
	ProjectID   string `json:"project_id"`
	ProjectID_2 string `json:"project_id_2"`
}

type Plan struct {
	ID        string    `json:"id"`
	FilePath  string    `json:"file_path"`
	Status    string    `json:"status"`
	CreatedAt time.Time `json:"created_at"`
	UpdatedAt time.Time `json:"updated_at"`
}

type PlanComment struct {
	ID         string        `json:"id"`
	PlanID     string        `json:"plan_id"`
	LineNumber sql.NullInt64 `json:"line_number"`
	Content    string        `json:"content"`
	CreatedAt  time.Time     `json:"created_at"`
}

type Project struct {
	ID          string         `json:"id"`
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
	Prefix      string         `json:"prefix"`
	CreatedAt   time.Time      `json:"created_at"`
	UpdatedAt   time.Time      `json:"updated_at"`
}

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

type RemoveDependencyParams struct {
	IssueID     string `json:"issue_id"`
	DependsOnID string `json:"depends_on_id"`
}

type RemoveLabelFromIssueParams struct {
	IssueID string `json:"issue_id"`
	Label   string `json:"label"`
}

type ReopenIssueParams struct {
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type SearchIssuesParams struct {
	ProjectID   string         `json:"project_id"`
	Title       string         `json:"title"`
	Description sql.NullString `json:"description"`
	Limit       int64          `json:"limit"`
	Offset      int64          `json:"offset"`
}

type SetConfigParams struct {
	ProjectID string         `json:"project_id"`
	Key       string         `json:"key"`
	Value     sql.NullString `json:"value"`
}

type SetGlobalConfigParams struct {
	Key   string         `json:"key"`
	Value sql.NullString `json:"value"`
}

type UpdateCommentParams struct {
	Text      string       `json:"text"`
	UpdatedAt sql.NullTime `json:"updated_at"`
	ID        int64        `json:"id"`
}

type UpdateIssueAISessionIDParams struct {
	AiSessionID sql.NullString `json:"ai_session_id"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ID          string         `json:"id"`
}

type UpdateIssueAssigneeParams struct {
	Assignee  sql.NullString `json:"assignee"`
	UpdatedAt time.Time      `json:"updated_at"`
	ID        string         `json:"id"`
}

type UpdateIssueDescriptionParams struct {
	Description sql.NullString `json:"description"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ID          string         `json:"id"`
}

type UpdateIssueExternalRefParams struct {
	ExternalRef sql.NullString `json:"external_ref"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ID          string         `json:"id"`
}

type UpdateIssuePriorityParams struct {
	Priority  int64     `json:"priority"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateIssueRankParams struct {
	Rank      int64     `json:"rank"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateIssueStatusParams struct {
	Status    string    `json:"status"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateIssueTitleParams struct {
	Title     string    `json:"title"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateIssueTypeParams struct {
	IssueType string    `json:"issue_type"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateLabelParams struct {
	Color       sql.NullString `json:"color"`
	Description sql.NullString `json:"description"`
	Name        string         `json:"name"`
}

type UpdatePlanStatusParams struct {
	Status    string    `json:"status"`
	UpdatedAt time.Time `json:"updated_at"`
	ID        string    `json:"id"`
}

type UpdateProjectParams struct {
	Name        string         `json:"name"`
	Description sql.NullString `json:"description"`
	UpdatedAt   time.Time      `json:"updated_at"`
	ID          string         `json:"id"`
}

type UpdateWorkspaceLastAccessedParams struct {
	LastAccessedAt sql.NullTime `json:"last_accessed_at"`
	UpdatedAt      time.Time    `json:"updated_at"`
	ID             string       `json:"id"`
}

type UpdateWorkspaceParams struct {
	Label     sql.NullString `json:"label"`
	Hostname  sql.NullString `json:"hostname"`
	GitRemote sql.NullString `json:"git_remote"`
	PathType  string         `json:"path_type"`
	UpdatedAt time.Time      `json:"updated_at"`
	ID        string         `json:"id"`
}

type Workspace struct {
	ID             string         `json:"id"`
	ProjectID      string         `json:"project_id"`
	Path           string         `json:"path"`
	Label          sql.NullString `json:"label"`
	Hostname       sql.NullString `json:"hostname"`
	GitRemote      sql.NullString `json:"git_remote"`
	PathType       string         `json:"path_type"`
	LastAccessedAt sql.NullTime   `json:"last_accessed_at"`
	CreatedAt      time.Time      `json:"created_at"`
	UpdatedAt      time.Time      `json:"updated_at"`
}