schema

type CouponFieldMap struct {
	Code          string `yaml:"code"`           // Default: "code"
	DiscountType  string `yaml:"discount_type"`  // Default: "discount_type"
	DiscountValue string `yaml:"discount_value"` // Default: "discount_value"
	Currency      string `yaml:"currency"`       // Default: "currency"
	Scope         string `yaml:"scope"`          // Default: "scope"
	ProductIDs    string `yaml:"product_ids"`    // Default: "product_ids" (array/JSONB)
	PaymentMethod string `yaml:"payment_method"` // Default: "payment_method"
	AutoApply     string `yaml:"auto_apply"`     // Default: "auto_apply"
	AppliesAt     string `yaml:"applies_at"`     // Default: "applies_at"
	UsageLimit    string `yaml:"usage_limit"`    // Default: "usage_limit"
	UsageCount    string `yaml:"usage_count"`    // Default: "usage_count"
	StartsAt      string `yaml:"starts_at"`      // Default: "starts_at"
	ExpiresAt     string `yaml:"expires_at"`     // Default: "expires_at"
	Active        string `yaml:"active"`         // Default: "active"
	Metadata      string `yaml:"metadata"`       // Default: "metadata"
	CreatedAt     string `yaml:"created_at"`     // Default: "created_at"
	UpdatedAt     string `yaml:"updated_at"`     // Default: "updated_at"
}

type CouponMapping struct {
	TableName  string               `yaml:"table_name"`
	FieldMap   CouponFieldMap       `yaml:"field_map"`
	CustomSQL  *CustomSQLQueries    `yaml:"custom_sql"`
	Transforms map[string]Transform `yaml:"transforms"`
}

type CouponSQLQueries struct {
	TableName       string
	SelectOne       string
	ListActive      string
	SelectAutoApply string
	Insert          string
	Update          string
	IncrementUsage  string
	Delete          string
	ColumnMap       CouponFieldMap
}

type CustomSQLQueries struct {
	Select     string `yaml:"select"`      // Custom SELECT query (use $1, $2 for params)
	Insert     string `yaml:"insert"`      // Custom INSERT query
	Update     string `yaml:"update"`      // Custom UPDATE query
	Delete     string `yaml:"delete"`      // Custom DELETE query
	ListActive string `yaml:"list_active"` // Custom query for listing active records
}

type Mapping struct {
	Products        ProductMapping         `yaml:"products"`
	Coupons         CouponMapping          `yaml:"coupons"`
	PaymentTracking PaymentTrackingMapping `yaml:"payment_tracking"`
}

type PaymentTrackingMapping struct {
	CartQuotes        TableMapping `yaml:"cart_quotes"`
	RefundQuotes      TableMapping `yaml:"refund_quotes"`
	PaymentSignatures TableMapping `yaml:"payment_signatures"`
	AdminNonces       TableMapping `yaml:"admin_nonces"`
}

type PaymentTrackingSQLQueries struct {
	CartQuotesTable        string
	RefundQuotesTable      string
	PaymentSignaturesTable string
	AdminNoncesTable       string
}

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

type ProductFieldMap struct {
	ID            string `yaml:"id"`              // Default: "id"
	Description   string `yaml:"description"`     // Default: "description"
	FiatAmount    string `yaml:"fiat_amount"`     // Default: "fiat_amount"
	FiatCurrency  string `yaml:"fiat_currency"`   // Default: "fiat_currency"
	StripePriceID string `yaml:"stripe_price_id"` // Default: "stripe_price_id"
	CryptoAmount  string `yaml:"crypto_amount"`   // Default: "crypto_amount"
	CryptoToken   string `yaml:"crypto_token"`    // Default: "crypto_token"
	CryptoAccount string `yaml:"crypto_account"`  // Default: "crypto_account"
	MemoTemplate  string `yaml:"memo_template"`   // Default: "memo_template"
	Metadata      string `yaml:"metadata"`        // Default: "metadata" (JSONB/JSON column)
	Active        string `yaml:"active"`          // Default: "active"
	CreatedAt     string `yaml:"created_at"`      // Default: "created_at"
	UpdatedAt     string `yaml:"updated_at"`      // Default: "updated_at"
}

type ProductMapping struct {
	TableName  string               `yaml:"table_name"` // Table/collection name (default: "products")
	FieldMap   ProductFieldMap      `yaml:"field_map"`  // Field mappings
	CustomSQL  *CustomSQLQueries    `yaml:"custom_sql"` // Optional custom SQL for complex mappings
	Transforms map[string]Transform `yaml:"transforms"` // Field transformations
}

type ProductSQLQueries struct {
	TableName             string
	SelectOne             string
	SelectByStripePriceID string
	ListActive            string
	Insert                string
	Update                string
	Delete                string
	ColumnMap             ProductFieldMap
}

type TableMapping struct {
	TableName string            `yaml:"table_name"`
	FieldMap  map[string]string `yaml:"field_map"` // cedros_field -> user_column
}

type Transform struct {
	Type   string      `yaml:"type"`   // "multiply", "divide", "json_field", "constant", "expression"
	Factor float64     `yaml:"factor"` // For multiply/divide
	Field  string      `yaml:"field"`  // For json_field extraction
	Value  interface{} `yaml:"value"`  // For constant transforms
	Expr   string      `yaml:"expr"`   // For SQL expressions (e.g., "CAST(price_cents AS FLOAT) / 100")
}