dto

type BulkDeleteRowsInput struct {
	UserId     string
	DatabaseId string
	RowIds     []string
}

type CreateDatabaseInput struct {
	UserId      string
	SpaceId     string
	DocumentId  *string
	Name        string
	Description string
	Icon        string
	Schema      []PropertySchema
	Type        string // "spreadsheet" or "document", defaults to "spreadsheet"
}

type CreateDatabaseOutput struct {
	Id          string
	Name        string
	Description string
	Icon        string
	Schema      []PropertySchema
	DefaultView string
	Type        string
	CreatedAt   time.Time
}

type CreateRowInput struct {
	UserId        string
	DatabaseId    string
	Properties    map[string]interface{}
	Content       map[string]interface{}
	ShowInSidebar bool
}

type CreateRowOutput struct {
	Id         string
	Properties map[string]interface{}
	CreatedAt  time.Time
}

type CreateViewInput struct {
	UserId     string
	DatabaseId string
	Name       string
	Type       string
	Filter     map[string]interface{}
	Sort       []SortConfig
	Columns    []string
}

type CreateViewOutput struct {
	Id      string
	Name    string
	Type    string
	Filter  map[string]interface{}
	Sort    []SortConfig
	Columns []string
}

type DatabaseItem struct {
	Id          string
	DocumentId  *string
	Name        string
	Description string
	Icon        string
	Type        string
	RowCount    int64
	CreatedBy   string
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type DatabasePermissionItem struct {
	Id        string  `json:"id"`
	UserId    *string `json:"user_id,omitempty"`
	Username  *string `json:"username,omitempty"`
	GroupId   *string `json:"group_id,omitempty"`
	GroupName *string `json:"group_name,omitempty"`
	Role      string  `json:"role"`
}

type DeleteDatabaseInput struct {
	UserId     string
	DatabaseId string
}

type DeleteDatabasePermissionInput struct {
	UserId       string  // The user making the request
	DatabaseId   string  // The database
	TargetUserId *string // The user to remove permission from (mutually exclusive with GroupId)
	GroupId      *string // The group to remove permission from (mutually exclusive with TargetUserId)
}

type DeleteRowInput struct {
	UserId     string
	DatabaseId string
	RowId      string
}

type DeleteViewInput struct {
	UserId     string
	DatabaseId string
	ViewId     string
}

type GetDatabaseInput struct {
	UserId     string
	DatabaseId string
}

type GetDatabaseOutput struct {
	Id          string
	SpaceId     string
	DocumentId  *string
	Name        string
	Description string
	Icon        string
	Schema      []PropertySchema
	Views       []ViewConfig
	DefaultView string
	Type        string
	CreatedBy   string
	CreatedAt   time.Time
	UpdatedAt   time.Time
}

type GetRowInput struct {
	UserId     string
	DatabaseId string
	RowId      string
}

type GetRowOutput struct {
	Id            string
	DatabaseId    string
	Properties    map[string]interface{}
	Content       map[string]interface{}
	ShowInSidebar bool
	CreatedBy     string
	CreatedByUser *UserInfo
	UpdatedBy     string
	UpdatedByUser *UserInfo
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type ListDatabasePermissionsInput struct {
	UserId     string
	DatabaseId string
}

type ListDatabasePermissionsOutput struct {
	Permissions []DatabasePermissionItem `json:"permissions"`
}

type ListDatabasesInput struct {
	UserId  string
	SpaceId string
}

type ListDatabasesOutput struct {
	Databases []DatabaseItem
}

type ListRowsInput struct {
	UserId     string
	DatabaseId string
	ViewId     string
	Limit      int
	Offset     int
}

type ListRowsOutput struct {
	Rows       []RowItem
	TotalCount int64
}

type MoveDatabaseInput struct {
	UserId     string
	DatabaseId string
	DocumentId *string // nil = move to root (no parent document)
}

type MoveDatabaseOutput struct {
	Id         string
	DocumentId *string
}

type PropertySchema struct {
	Id      string                 `json:"id"`
	Name    string                 `json:"name"`
	Type    string                 `json:"type"`
	Options map[string]interface{} `json:"options,omitempty"`
}

type RowItem struct {
	Id            string
	Properties    map[string]interface{}
	Content       map[string]interface{}
	ShowInSidebar bool
	CreatedBy     string
	CreatedByUser *UserInfo
	UpdatedBy     string
	UpdatedByUser *UserInfo
	CreatedAt     time.Time
	UpdatedAt     time.Time
}

type SearchDatabaseResultItem struct {
	Id          string
	Name        string
	Description string
	Icon        string
	Type        string
	SpaceId     string
	SpaceName   string
	UpdatedAt   time.Time
}

type SearchDatabasesInput struct {
	UserId  string
	Query   string
	SpaceId *string
	Limit   int
}

type SearchDatabasesOutput struct {
	Results []SearchDatabaseResultItem
}

type SortConfig struct {
	PropertyId string `json:"property_id"`
	Direction  string `json:"direction"` // "asc" or "desc"
}

type UpdateDatabaseInput struct {
	UserId      string
	DatabaseId  string
	Name        *string
	Description *string
	Icon        *string
	Schema      *[]PropertySchema
	DefaultView *string
}

type UpdateRowInput struct {
	UserId        string
	DatabaseId    string
	RowId         string
	Properties    map[string]interface{}
	Content       map[string]interface{}
	ShowInSidebar *bool
}

type UpdateViewInput struct {
	UserId        string
	DatabaseId    string
	ViewId        string
	Name          *string
	Type          *string
	Filter        map[string]interface{}
	Sort          []SortConfig
	Columns       []string
	HiddenColumns []string
	GroupBy       *string
}

type UpsertDatabasePermissionInput struct {
	UserId       string  // The user making the request
	DatabaseId   string  // The database to add permission to
	TargetUserId *string // The user to add permission for (mutually exclusive with GroupId)
	GroupId      *string // The group to add permission for (mutually exclusive with TargetUserId)
	Role         string  // editor, viewer, denied
}

type UserInfo struct {
	Id        string
	Username  string
	AvatarUrl string
}

type ViewConfig struct {
	Id            string                 `json:"id"`
	Name          string                 `json:"name"`
	Type          string                 `json:"type"`
	Filter        map[string]interface{} `json:"filter,omitempty"`
	Sort          []SortConfig           `json:"sort,omitempty"`
	Columns       []string               `json:"columns,omitempty"`
	HiddenColumns []string               `json:"hidden_columns,omitempty"`
	GroupBy       string                 `json:"group_by,omitempty"`
}