database

type Account struct {
	ID               string
	CreatedAt        time.Time
	UpdatedAt        time.Time
	Name             string
	Type             string
	Subtype          sql.NullString
	Mask             sql.NullString
	OfficialName     sql.NullString
	AvailableBalance sql.NullString
	CurrentBalance   sql.NullString
	IsoCurrencyCode  sql.NullString
	ItemID           string
	UserID           uuid.UUID
}

type CreateAccountParams struct {
	ID               string
	Name             string
	Type             string
	Subtype          sql.NullString
	Mask             sql.NullString
	OfficialName     sql.NullString
	AvailableBalance sql.NullString
	CurrentBalance   sql.NullString
	IsoCurrencyCode  sql.NullString
	ItemID           string
	UserID           uuid.UUID
}

type CreateDelegationParams struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	ExpiresAt time.Time
}

type CreateItemParams struct {
	ID                    string
	UserID                uuid.UUID
	AccessToken           string
	InstitutionName       string
	Nickname              sql.NullString
	TransactionSyncCursor sql.NullString
}

type CreatePlaidWebhookRecordParams struct {
	ID          uuid.UUID
	WebhookType string
	WebhookCode string
	ItemID      string
	UserID      uuid.UUID
}

type CreateTagParams struct {
	ID     uuid.UUID
	Name   string
	UserID uuid.UUID
}

type CreateTokenParams struct {
	ID           uuid.UUID
	HashedToken  string
	UserID       uuid.UUID
	DelegationID uuid.UUID
	ExpiresAt    time.Time
}

type CreateTransactionParams struct {
	ID                      string
	AccountID               string
	Amount                  string
	IsoCurrencyCode         sql.NullString
	Date                    sql.NullTime
	MerchantName            sql.NullString
	PaymentChannel          string
	PersonalFinanceCategory string
}

type CreateTransactionToTagRecordParams struct {
	TransactionID string
	TagID         uuid.UUID
}

type CreateUserParams struct {
	ID             uuid.UUID
	Name           string
	HashedPassword string
	Email          string
	IsVerified     sql.NullBool
}

type CreateVerificationRecordParams struct {
	UserID           uuid.UUID
	VerificationCode string
	ExpiryTime       time.Time
}

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 Delegation struct {
	ID        uuid.UUID
	UserID    uuid.UUID
	CreatedAt time.Time
	ExpiresAt time.Time
	RevokedAt sql.NullTime
	IsRevoked bool
	LastUsed  time.Time
}

type DeleteAccountParams struct {
	ID     string
	UserID uuid.UUID
}

type DeleteItemParams struct {
	ID     string
	UserID uuid.UUID
}

type DeleteTagParams struct {
	Name   string
	UserID uuid.UUID
}

type DeleteTransactionParams struct {
	ID        string
	AccountID string
}

type GetAccountByIdParams struct {
	ID     string
	UserID uuid.UUID
}

type GetCursorParams struct {
	ID          string
	AccessToken string
}

type GetMerchantSummaryByMonthParams struct {
	AccountID string
	Year      int32
	Month     int32
}

type GetMerchantSummaryByMonthRow struct {
	Merchant    sql.NullString
	TxnCount    int64
	Category    string
	TotalAmount float64
	Month       string
}

type GetMerchantSummaryRow struct {
	Merchant    sql.NullString
	TxnCount    int64
	Category    string
	TotalAmount float64
	Month       string
}

type GetMonetaryDataForAllMonthsRow struct {
	Year      int32
	Month     int32
	Income    string
	Expenses  string
	NetIncome string
}

type GetMonetaryDataForMonthParams struct {
	Year      int32
	Month     int32
	AccountID string
}

type GetMonetaryDataForMonthRow struct {
	Income    string
	Expenses  string
	NetIncome string
}

type GetTagParams struct {
	Name   string
	UserID uuid.UUID
}

type PlaidItem struct {
	ID                    string
	UserID                uuid.UUID
	AccessToken           string
	InstitutionName       string
	Nickname              sql.NullString
	TransactionSyncCursor sql.NullString
	CreatedAt             time.Time
	UpdatedAt             time.Time
}

type PlaidWebhookRecord struct {
	ID          uuid.UUID
	WebhookType string
	WebhookCode string
	ItemID      string
	UserID      uuid.UUID
	CreatedAt   time.Time
	Processed   bool
	ProcessedAt sql.NullTime
}

type ProcessWebhookRecordsByTypeParams struct {
	ItemID      string
	UserID      uuid.UUID
	WebhookType string
	WebhookCode string
	CreatedAt   time.Time
}

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

type RefreshToken struct {
	ID           uuid.UUID
	HashedToken  string
	UserID       uuid.UUID
	DelegationID uuid.UUID
	CreatedAt    time.Time
	ExpiresAt    time.Time
	IsUsed       bool
	UsedAt       sql.NullTime
}

type Transaction struct {
	ID                      string
	AccountID               string
	Amount                  string
	IsoCurrencyCode         sql.NullString
	Date                    sql.NullTime
	MerchantName            sql.NullString
	PaymentChannel          string
	PersonalFinanceCategory string
	CreatedAt               time.Time
	UpdatedAt               time.Time
}

type TransactionTag struct {
	ID        uuid.UUID
	Name      string
	UserID    uuid.UUID
	CreatedAt time.Time
}

type TransactionsToTag struct {
	TransactionID string
	TagID         uuid.UUID
}

type UpdateBalancesParams struct {
	AvailableBalance sql.NullString
	CurrentBalance   sql.NullString
	ID               string
	ItemID           string
}

type UpdateCursorParams struct {
	TransactionSyncCursor sql.NullString
	ID                    string
}

type UpdateNicknameParams struct {
	Nickname sql.NullString
	ID       string
	UserID   uuid.UUID
}

type UpdatePasswordParams struct {
	HashedPassword string
	ID             uuid.UUID
}

type User struct {
	ID             uuid.UUID
	Name           string
	CreatedAt      time.Time
	UpdatedAt      time.Time
	HashedPassword string
	Email          string
	IsVerified     sql.NullBool
	IsMember       bool
	FreeCalls      int32
}

type VerificationRecord struct {
	UserID           uuid.UUID
	VerificationCode string
	ExpiryTime       time.Time
}