Documentation
¶
Index ¶
- Variables
- func Create(ctx context.Context, s *Schema, tables []*schema.Table, ...) error
- func Diff(ctx context.Context, url string, opts ...schema.MigrateOption) error
- func NamedDiff(ctx context.Context, url, name string, opts ...schema.MigrateOption) error
- type Schema
- func (s *Schema) Create(ctx context.Context, opts ...schema.MigrateOption) error
- func (s *Schema) Diff(ctx context.Context, opts ...schema.MigrateOption) error
- func (s *Schema) NamedDiff(ctx context.Context, name string, opts ...schema.MigrateOption) error
- func (s *Schema) WriteTo(ctx context.Context, w io.Writer, opts ...schema.MigrateOption) error
Constants ¶
This section is empty.
Variables ¶
View Source
var ( // WithGlobalUniqueID sets the universal ids options to the migration. // If this option is enabled, ent migration will allocate a 1<<32 range // for the ids of each entity (table). // Note that this option cannot be applied on tables that already exist. WithGlobalUniqueID = schema.WithGlobalUniqueID // WithDropColumn sets the drop column option to the migration. // If this option is enabled, ent migration will drop old columns // that were used for both fields and edges. This defaults to false. WithDropColumn = schema.WithDropColumn // WithDropIndex sets the drop index option to the migration. // If this option is enabled, ent migration will drop old indexes // that were defined in the schema. This defaults to false. // Note that unique constraints are defined using `UNIQUE INDEX`, // and therefore, it's recommended to enable this option to get more // flexibility in the schema changes. WithDropIndex = schema.WithDropIndex // WithForeignKeys enables creating foreign-key in schema DDL. This defaults to true. WithForeignKeys = schema.WithForeignKeys )
View Source
var ( // BalanceSnapshotsColumns holds the columns for the "balance_snapshots" table. BalanceSnapshotsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "grant_balances", Type: field.TypeJSON, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "balance", Type: field.TypeFloat64, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "overage", Type: field.TypeFloat64, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "at", Type: field.TypeTime}, {Name: "owner_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // BalanceSnapshotsTable holds the schema information for the "balance_snapshots" table. BalanceSnapshotsTable = &schema.Table{ Name: "balance_snapshots", Columns: BalanceSnapshotsColumns, PrimaryKey: []*schema.Column{BalanceSnapshotsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "balance_snapshots_entitlements_balance_snapshot", Columns: []*schema.Column{BalanceSnapshotsColumns[9]}, RefColumns: []*schema.Column{EntitlementsColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "balancesnapshot_namespace", Unique: false, Columns: []*schema.Column{BalanceSnapshotsColumns[1]}, }, { Name: "balancesnapshot_namespace_at", Unique: false, Columns: []*schema.Column{BalanceSnapshotsColumns[1], BalanceSnapshotsColumns[8]}, }, { Name: "balancesnapshot_namespace_balance", Unique: false, Columns: []*schema.Column{BalanceSnapshotsColumns[1], BalanceSnapshotsColumns[6]}, }, { Name: "balancesnapshot_namespace_balance_at", Unique: false, Columns: []*schema.Column{BalanceSnapshotsColumns[1], BalanceSnapshotsColumns[6], BalanceSnapshotsColumns[8]}, }, }, } // BillingCustomerOverridesColumns holds the columns for the "billing_customer_overrides" table. BillingCustomerOverridesColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "collection_alignment", Type: field.TypeEnum, Nullable: true, Enums: []string{"subscription"}}, {Name: "item_collection_period_seconds", Type: field.TypeInt64, Nullable: true}, {Name: "invoice_auto_advance", Type: field.TypeBool, Nullable: true}, {Name: "invoice_draft_period_seconds", Type: field.TypeInt64, Nullable: true}, {Name: "invoice_due_after_seconds", Type: field.TypeInt64, Nullable: true}, {Name: "invoice_collection_method", Type: field.TypeEnum, Nullable: true, Enums: []string{"charge_automatically", "send_invoice"}}, {Name: "invoice_item_resolution", Type: field.TypeEnum, Nullable: true, Enums: []string{"day", "period"}}, {Name: "invoice_item_per_subject", Type: field.TypeBool, Nullable: true}, {Name: "billing_profile_id", Type: field.TypeString, Nullable: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "customer_id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, } // BillingCustomerOverridesTable holds the schema information for the "billing_customer_overrides" table. BillingCustomerOverridesTable = &schema.Table{ Name: "billing_customer_overrides", Columns: BillingCustomerOverridesColumns, PrimaryKey: []*schema.Column{BillingCustomerOverridesColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "billing_customer_overrides_billing_profiles_billing_customer_override", Columns: []*schema.Column{BillingCustomerOverridesColumns[13]}, RefColumns: []*schema.Column{BillingProfilesColumns[0]}, OnDelete: schema.SetNull, }, { Symbol: "billing_customer_overrides_customers_billing_customer_override", Columns: []*schema.Column{BillingCustomerOverridesColumns[14]}, RefColumns: []*schema.Column{CustomersColumns[0]}, OnDelete: schema.Cascade, }, }, Indexes: []*schema.Index{ { Name: "billingcustomeroverride_id", Unique: true, Columns: []*schema.Column{BillingCustomerOverridesColumns[0]}, }, { Name: "billingcustomeroverride_namespace", Unique: false, Columns: []*schema.Column{BillingCustomerOverridesColumns[1]}, }, { Name: "billingcustomeroverride_namespace_id", Unique: true, Columns: []*schema.Column{BillingCustomerOverridesColumns[1], BillingCustomerOverridesColumns[0]}, }, { Name: "billingcustomeroverride_namespace_customer_id", Unique: true, Columns: []*schema.Column{BillingCustomerOverridesColumns[1], BillingCustomerOverridesColumns[14]}, }, }, } // BillingInvoicesColumns holds the columns for the "billing_invoices" table. BillingInvoicesColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "series", Type: field.TypeString, Nullable: true}, {Name: "code", Type: field.TypeString, Nullable: true}, {Name: "customer_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "voided_at", Type: field.TypeTime, Nullable: true}, {Name: "currency", Type: field.TypeString, SchemaType: map[string]string{"postgres": "varchar(3)"}}, {Name: "due_date", Type: field.TypeTime}, {Name: "status", Type: field.TypeEnum, Enums: []string{"created", "draft", "draft_sync", "draft_sync_failed", "issuing", "issued", "issuing_failed", "manual_approval_needed"}}, {Name: "tax_provider", Type: field.TypeEnum, Nullable: true, Enums: []string{"openmeter_sandbox", "stripe"}}, {Name: "invoicing_provider", Type: field.TypeEnum, Nullable: true, Enums: []string{"openmeter_sandbox", "stripe"}}, {Name: "payment_provider", Type: field.TypeEnum, Nullable: true, Enums: []string{"openmeter_sandbox", "stripe_payments"}}, {Name: "period_start", Type: field.TypeTime}, {Name: "period_end", Type: field.TypeTime}, {Name: "billing_profile_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "workflow_config_id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, } // BillingInvoicesTable holds the schema information for the "billing_invoices" table. BillingInvoicesTable = &schema.Table{ Name: "billing_invoices", Columns: BillingInvoicesColumns, PrimaryKey: []*schema.Column{BillingInvoicesColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "billing_invoices_billing_profiles_billing_invoices", Columns: []*schema.Column{BillingInvoicesColumns[18]}, RefColumns: []*schema.Column{BillingProfilesColumns[0]}, OnDelete: schema.NoAction, }, { Symbol: "billing_invoices_billing_workflow_configs_billing_invoices", Columns: []*schema.Column{BillingInvoicesColumns[19]}, RefColumns: []*schema.Column{BillingWorkflowConfigsColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "billinginvoice_id", Unique: true, Columns: []*schema.Column{BillingInvoicesColumns[0]}, }, { Name: "billinginvoice_namespace", Unique: false, Columns: []*schema.Column{BillingInvoicesColumns[1]}, }, { Name: "billinginvoice_namespace_id", Unique: false, Columns: []*schema.Column{BillingInvoicesColumns[1], BillingInvoicesColumns[0]}, }, { Name: "billinginvoice_namespace_customer_id", Unique: false, Columns: []*schema.Column{BillingInvoicesColumns[1], BillingInvoicesColumns[8]}, }, { Name: "billinginvoice_namespace_due_date", Unique: false, Columns: []*schema.Column{BillingInvoicesColumns[1], BillingInvoicesColumns[11]}, }, { Name: "billinginvoice_namespace_status", Unique: false, Columns: []*schema.Column{BillingInvoicesColumns[1], BillingInvoicesColumns[12]}, }, { Name: "billinginvoice_namespace_customer_id_series_code", Unique: true, Columns: []*schema.Column{BillingInvoicesColumns[1], BillingInvoicesColumns[8], BillingInvoicesColumns[6], BillingInvoicesColumns[7]}, }, }, } // BillingInvoiceItemsColumns holds the columns for the "billing_invoice_items" table. BillingInvoiceItemsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "customer_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "period_start", Type: field.TypeTime}, {Name: "period_end", Type: field.TypeTime}, {Name: "invoice_at", Type: field.TypeTime}, {Name: "type", Type: field.TypeEnum, Enums: []string{"static", "usage"}}, {Name: "name", Type: field.TypeString}, {Name: "quantity", Type: field.TypeOther, Nullable: true, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "unit_price", Type: field.TypeOther, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "currency", Type: field.TypeString, SchemaType: map[string]string{"postgres": "varchar(3)"}}, {Name: "tax_code_override", Type: field.TypeJSON, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "invoice_id", Type: field.TypeString, Nullable: true, SchemaType: map[string]string{"postgres": "char(26)"}}, } // BillingInvoiceItemsTable holds the schema information for the "billing_invoice_items" table. BillingInvoiceItemsTable = &schema.Table{ Name: "billing_invoice_items", Columns: BillingInvoiceItemsColumns, PrimaryKey: []*schema.Column{BillingInvoiceItemsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "billing_invoice_items_billing_invoices_billing_invoice_items", Columns: []*schema.Column{BillingInvoiceItemsColumns[16]}, RefColumns: []*schema.Column{BillingInvoicesColumns[0]}, OnDelete: schema.SetNull, }, }, Indexes: []*schema.Index{ { Name: "billinginvoiceitem_id", Unique: true, Columns: []*schema.Column{BillingInvoiceItemsColumns[0]}, }, { Name: "billinginvoiceitem_namespace", Unique: false, Columns: []*schema.Column{BillingInvoiceItemsColumns[1]}, }, { Name: "billinginvoiceitem_namespace_id", Unique: false, Columns: []*schema.Column{BillingInvoiceItemsColumns[1], BillingInvoiceItemsColumns[0]}, }, { Name: "billinginvoiceitem_namespace_invoice_id", Unique: false, Columns: []*schema.Column{BillingInvoiceItemsColumns[1], BillingInvoiceItemsColumns[16]}, }, { Name: "billinginvoiceitem_namespace_customer_id", Unique: false, Columns: []*schema.Column{BillingInvoiceItemsColumns[1], BillingInvoiceItemsColumns[6]}, }, }, } // BillingProfilesColumns holds the columns for the "billing_profiles" table. BillingProfilesColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "supplier_address_country", Type: field.TypeString, Nullable: true, Size: 2}, {Name: "supplier_address_postal_code", Type: field.TypeString, Nullable: true}, {Name: "supplier_address_state", Type: field.TypeString, Nullable: true}, {Name: "supplier_address_city", Type: field.TypeString, Nullable: true}, {Name: "supplier_address_line1", Type: field.TypeString, Nullable: true}, {Name: "supplier_address_line2", Type: field.TypeString, Nullable: true}, {Name: "supplier_address_phone_number", Type: field.TypeString, Nullable: true}, {Name: "tax_provider", Type: field.TypeEnum, Enums: []string{"openmeter_sandbox", "stripe"}}, {Name: "invoicing_provider", Type: field.TypeEnum, Enums: []string{"openmeter_sandbox", "stripe"}}, {Name: "payment_provider", Type: field.TypeEnum, Enums: []string{"openmeter_sandbox", "stripe_payments"}}, {Name: "default", Type: field.TypeBool, Default: false}, {Name: "supplier_name", Type: field.TypeString}, {Name: "workflow_config_id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, } // BillingProfilesTable holds the schema information for the "billing_profiles" table. BillingProfilesTable = &schema.Table{ Name: "billing_profiles", Columns: BillingProfilesColumns, PrimaryKey: []*schema.Column{BillingProfilesColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "billing_profiles_billing_workflow_configs_billing_profile", Columns: []*schema.Column{BillingProfilesColumns[18]}, RefColumns: []*schema.Column{BillingWorkflowConfigsColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "billingprofile_id", Unique: true, Columns: []*schema.Column{BillingProfilesColumns[0]}, }, { Name: "billingprofile_namespace", Unique: false, Columns: []*schema.Column{BillingProfilesColumns[1]}, }, { Name: "billingprofile_namespace_id", Unique: true, Columns: []*schema.Column{BillingProfilesColumns[1], BillingProfilesColumns[0]}, }, { Name: "billingprofile_namespace_default_deleted_at", Unique: true, Columns: []*schema.Column{BillingProfilesColumns[1], BillingProfilesColumns[16], BillingProfilesColumns[5]}, }, }, } // BillingWorkflowConfigsColumns holds the columns for the "billing_workflow_configs" table. BillingWorkflowConfigsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "timezone", Type: field.TypeString, Nullable: true}, {Name: "collection_alignment", Type: field.TypeEnum, Enums: []string{"subscription"}}, {Name: "item_collection_period_seconds", Type: field.TypeInt64}, {Name: "invoice_auto_advance", Type: field.TypeBool}, {Name: "invoice_draft_period_seconds", Type: field.TypeInt64}, {Name: "invoice_due_after_seconds", Type: field.TypeInt64}, {Name: "invoice_collection_method", Type: field.TypeEnum, Enums: []string{"charge_automatically", "send_invoice"}}, {Name: "invoice_item_resolution", Type: field.TypeEnum, Enums: []string{"day", "period"}}, {Name: "invoice_item_per_subject", Type: field.TypeBool}, } // BillingWorkflowConfigsTable holds the schema information for the "billing_workflow_configs" table. BillingWorkflowConfigsTable = &schema.Table{ Name: "billing_workflow_configs", Columns: BillingWorkflowConfigsColumns, PrimaryKey: []*schema.Column{BillingWorkflowConfigsColumns[0]}, Indexes: []*schema.Index{ { Name: "billingworkflowconfig_id", Unique: true, Columns: []*schema.Column{BillingWorkflowConfigsColumns[0]}, }, { Name: "billingworkflowconfig_namespace", Unique: false, Columns: []*schema.Column{BillingWorkflowConfigsColumns[1]}, }, { Name: "billingworkflowconfig_namespace_id", Unique: false, Columns: []*schema.Column{BillingWorkflowConfigsColumns[1], BillingWorkflowConfigsColumns[0]}, }, }, } // CustomersColumns holds the columns for the "customers" table. CustomersColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "billing_address_country", Type: field.TypeString, Nullable: true, Size: 2}, {Name: "billing_address_postal_code", Type: field.TypeString, Nullable: true}, {Name: "billing_address_state", Type: field.TypeString, Nullable: true}, {Name: "billing_address_city", Type: field.TypeString, Nullable: true}, {Name: "billing_address_line1", Type: field.TypeString, Nullable: true}, {Name: "billing_address_line2", Type: field.TypeString, Nullable: true}, {Name: "billing_address_phone_number", Type: field.TypeString, Nullable: true}, {Name: "name", Type: field.TypeString}, {Name: "primary_email", Type: field.TypeString, Nullable: true}, {Name: "timezone", Type: field.TypeString, Nullable: true}, {Name: "currency", Type: field.TypeString, Nullable: true, Size: 3}, {Name: "external_mapping_stripe_customer_id", Type: field.TypeString, Nullable: true}, } // CustomersTable holds the schema information for the "customers" table. CustomersTable = &schema.Table{ Name: "customers", Columns: CustomersColumns, PrimaryKey: []*schema.Column{CustomersColumns[0]}, Indexes: []*schema.Index{ { Name: "customer_id", Unique: true, Columns: []*schema.Column{CustomersColumns[0]}, }, { Name: "customer_namespace", Unique: false, Columns: []*schema.Column{CustomersColumns[1]}, }, { Name: "customer_namespace_id", Unique: true, Columns: []*schema.Column{CustomersColumns[1], CustomersColumns[0]}, }, }, } // CustomerSubjectsColumns holds the columns for the "customer_subjects" table. CustomerSubjectsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "namespace", Type: field.TypeString}, {Name: "subject_key", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "customer_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // CustomerSubjectsTable holds the schema information for the "customer_subjects" table. CustomerSubjectsTable = &schema.Table{ Name: "customer_subjects", Columns: CustomerSubjectsColumns, PrimaryKey: []*schema.Column{CustomerSubjectsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "customer_subjects_customers_subjects", Columns: []*schema.Column{CustomerSubjectsColumns[4]}, RefColumns: []*schema.Column{CustomersColumns[0]}, OnDelete: schema.Cascade, }, }, Indexes: []*schema.Index{ { Name: "customersubjects_namespace", Unique: false, Columns: []*schema.Column{CustomerSubjectsColumns[1]}, }, { Name: "customersubjects_customer_id_subject_key", Unique: true, Columns: []*schema.Column{CustomerSubjectsColumns[4], CustomerSubjectsColumns[2]}, }, { Name: "customersubjects_namespace_subject_key", Unique: true, Columns: []*schema.Column{CustomerSubjectsColumns[1], CustomerSubjectsColumns[2]}, }, }, } // EntitlementsColumns holds the columns for the "entitlements" table. EntitlementsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "entitlement_type", Type: field.TypeEnum, Enums: []string{"metered", "static", "boolean"}}, {Name: "feature_key", Type: field.TypeString}, {Name: "subject_key", Type: field.TypeString}, {Name: "measure_usage_from", Type: field.TypeTime, Nullable: true}, {Name: "issue_after_reset", Type: field.TypeFloat64, Nullable: true}, {Name: "issue_after_reset_priority", Type: field.TypeUint8, Nullable: true}, {Name: "is_soft_limit", Type: field.TypeBool, Nullable: true}, {Name: "preserve_overage_at_reset", Type: field.TypeBool, Nullable: true}, {Name: "config", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "usage_period_interval", Type: field.TypeEnum, Nullable: true, Enums: []string{"DAY", "WEEK", "MONTH", "YEAR"}}, {Name: "usage_period_anchor", Type: field.TypeTime, Nullable: true}, {Name: "current_usage_period_start", Type: field.TypeTime, Nullable: true}, {Name: "current_usage_period_end", Type: field.TypeTime, Nullable: true}, {Name: "feature_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // EntitlementsTable holds the schema information for the "entitlements" table. EntitlementsTable = &schema.Table{ Name: "entitlements", Columns: EntitlementsColumns, PrimaryKey: []*schema.Column{EntitlementsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "entitlements_features_entitlement", Columns: []*schema.Column{EntitlementsColumns[19]}, RefColumns: []*schema.Column{FeaturesColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "entitlement_id", Unique: true, Columns: []*schema.Column{EntitlementsColumns[0]}, }, { Name: "entitlement_namespace", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1]}, }, { Name: "entitlement_namespace_id", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1], EntitlementsColumns[0]}, }, { Name: "entitlement_namespace_subject_key", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1], EntitlementsColumns[8]}, }, { Name: "entitlement_namespace_id_subject_key", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1], EntitlementsColumns[0], EntitlementsColumns[8]}, }, { Name: "entitlement_namespace_feature_id_id", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1], EntitlementsColumns[19], EntitlementsColumns[0]}, }, { Name: "entitlement_namespace_current_usage_period_end", Unique: false, Columns: []*schema.Column{EntitlementsColumns[1], EntitlementsColumns[18]}, }, { Name: "entitlement_current_usage_period_end_deleted_at", Unique: false, Columns: []*schema.Column{EntitlementsColumns[18], EntitlementsColumns[5]}, }, }, } // FeaturesColumns holds the columns for the "features" table. FeaturesColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "namespace", Type: field.TypeString}, {Name: "name", Type: field.TypeString}, {Name: "key", Type: field.TypeString}, {Name: "meter_slug", Type: field.TypeString, Nullable: true}, {Name: "meter_group_by_filters", Type: field.TypeJSON, Nullable: true}, {Name: "archived_at", Type: field.TypeTime, Nullable: true}, } // FeaturesTable holds the schema information for the "features" table. FeaturesTable = &schema.Table{ Name: "features", Columns: FeaturesColumns, PrimaryKey: []*schema.Column{FeaturesColumns[0]}, Indexes: []*schema.Index{ { Name: "feature_id", Unique: true, Columns: []*schema.Column{FeaturesColumns[0]}, }, { Name: "feature_namespace_id", Unique: false, Columns: []*schema.Column{FeaturesColumns[5], FeaturesColumns[0]}, }, }, } // GrantsColumns holds the columns for the "grants" table. GrantsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "metadata", Type: field.TypeJSON, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "amount", Type: field.TypeFloat64, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "priority", Type: field.TypeUint8, Default: 0}, {Name: "effective_at", Type: field.TypeTime}, {Name: "expiration", Type: field.TypeJSON, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "expires_at", Type: field.TypeTime}, {Name: "voided_at", Type: field.TypeTime, Nullable: true}, {Name: "reset_max_rollover", Type: field.TypeFloat64, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "reset_min_rollover", Type: field.TypeFloat64, SchemaType: map[string]string{"postgres": "numeric"}}, {Name: "recurrence_period", Type: field.TypeEnum, Nullable: true, Enums: []string{"DAY", "WEEK", "MONTH", "YEAR"}}, {Name: "recurrence_anchor", Type: field.TypeTime, Nullable: true}, {Name: "owner_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // GrantsTable holds the schema information for the "grants" table. GrantsTable = &schema.Table{ Name: "grants", Columns: GrantsColumns, PrimaryKey: []*schema.Column{GrantsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "grants_entitlements_grant", Columns: []*schema.Column{GrantsColumns[16]}, RefColumns: []*schema.Column{EntitlementsColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "grant_id", Unique: true, Columns: []*schema.Column{GrantsColumns[0]}, }, { Name: "grant_namespace", Unique: false, Columns: []*schema.Column{GrantsColumns[1]}, }, { Name: "grant_namespace_owner_id", Unique: false, Columns: []*schema.Column{GrantsColumns[1], GrantsColumns[16]}, }, { Name: "grant_effective_at_expires_at", Unique: false, Columns: []*schema.Column{GrantsColumns[8], GrantsColumns[10]}, }, }, } // NotificationChannelsColumns holds the columns for the "notification_channels" table. NotificationChannelsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "type", Type: field.TypeEnum, Enums: []string{"WEBHOOK"}}, {Name: "name", Type: field.TypeString}, {Name: "disabled", Type: field.TypeBool, Nullable: true, Default: false}, {Name: "config", Type: field.TypeString, SchemaType: map[string]string{"postgres": "jsonb"}}, } // NotificationChannelsTable holds the schema information for the "notification_channels" table. NotificationChannelsTable = &schema.Table{ Name: "notification_channels", Columns: NotificationChannelsColumns, PrimaryKey: []*schema.Column{NotificationChannelsColumns[0]}, Indexes: []*schema.Index{ { Name: "notificationchannel_id", Unique: true, Columns: []*schema.Column{NotificationChannelsColumns[0]}, }, { Name: "notificationchannel_namespace", Unique: false, Columns: []*schema.Column{NotificationChannelsColumns[1]}, }, { Name: "notificationchannel_namespace_id", Unique: false, Columns: []*schema.Column{NotificationChannelsColumns[1], NotificationChannelsColumns[0]}, }, { Name: "notificationchannel_namespace_type", Unique: false, Columns: []*schema.Column{NotificationChannelsColumns[1], NotificationChannelsColumns[5]}, }, }, } // NotificationEventsColumns holds the columns for the "notification_events" table. NotificationEventsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "type", Type: field.TypeEnum, Enums: []string{"entitlements.balance.threshold"}}, {Name: "payload", Type: field.TypeString, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "annotations", Type: field.TypeString, Nullable: true, SchemaType: map[string]string{"postgres": "jsonb"}}, {Name: "rule_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // NotificationEventsTable holds the schema information for the "notification_events" table. NotificationEventsTable = &schema.Table{ Name: "notification_events", Columns: NotificationEventsColumns, PrimaryKey: []*schema.Column{NotificationEventsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "notification_events_notification_rules_events", Columns: []*schema.Column{NotificationEventsColumns[6]}, RefColumns: []*schema.Column{NotificationRulesColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "notificationevent_id", Unique: true, Columns: []*schema.Column{NotificationEventsColumns[0]}, }, { Name: "notificationevent_namespace", Unique: false, Columns: []*schema.Column{NotificationEventsColumns[1]}, }, { Name: "notificationevent_namespace_id", Unique: false, Columns: []*schema.Column{NotificationEventsColumns[1], NotificationEventsColumns[0]}, }, { Name: "notificationevent_namespace_type", Unique: false, Columns: []*schema.Column{NotificationEventsColumns[1], NotificationEventsColumns[3]}, }, { Name: "notificationevent_annotations", Unique: false, Columns: []*schema.Column{NotificationEventsColumns[5]}, Annotation: &entsql.IndexAnnotation{ Types: map[string]string{ "postgres": "GIN", }, }, }, }, } // NotificationEventDeliveryStatusColumns holds the columns for the "notification_event_delivery_status" table. NotificationEventDeliveryStatusColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "event_id", Type: field.TypeString}, {Name: "channel_id", Type: field.TypeString}, {Name: "state", Type: field.TypeEnum, Enums: []string{"SUCCESS", "FAILED", "SENDING", "PENDING"}, Default: "PENDING"}, {Name: "reason", Type: field.TypeString, Nullable: true}, } // NotificationEventDeliveryStatusTable holds the schema information for the "notification_event_delivery_status" table. NotificationEventDeliveryStatusTable = &schema.Table{ Name: "notification_event_delivery_status", Columns: NotificationEventDeliveryStatusColumns, PrimaryKey: []*schema.Column{NotificationEventDeliveryStatusColumns[0]}, Indexes: []*schema.Index{ { Name: "notificationeventdeliverystatus_id", Unique: true, Columns: []*schema.Column{NotificationEventDeliveryStatusColumns[0]}, }, { Name: "notificationeventdeliverystatus_namespace", Unique: false, Columns: []*schema.Column{NotificationEventDeliveryStatusColumns[1]}, }, { Name: "notificationeventdeliverystatus_namespace_id", Unique: false, Columns: []*schema.Column{NotificationEventDeliveryStatusColumns[1], NotificationEventDeliveryStatusColumns[0]}, }, { Name: "notificationeventdeliverystatus_namespace_event_id_channel_id", Unique: false, Columns: []*schema.Column{NotificationEventDeliveryStatusColumns[1], NotificationEventDeliveryStatusColumns[4], NotificationEventDeliveryStatusColumns[5]}, }, { Name: "notificationeventdeliverystatus_namespace_state", Unique: false, Columns: []*schema.Column{NotificationEventDeliveryStatusColumns[1], NotificationEventDeliveryStatusColumns[6]}, }, }, } // NotificationRulesColumns holds the columns for the "notification_rules" table. NotificationRulesColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "type", Type: field.TypeEnum, Enums: []string{"entitlements.balance.threshold"}}, {Name: "name", Type: field.TypeString}, {Name: "disabled", Type: field.TypeBool, Nullable: true, Default: false}, {Name: "config", Type: field.TypeString, SchemaType: map[string]string{"postgres": "jsonb"}}, } // NotificationRulesTable holds the schema information for the "notification_rules" table. NotificationRulesTable = &schema.Table{ Name: "notification_rules", Columns: NotificationRulesColumns, PrimaryKey: []*schema.Column{NotificationRulesColumns[0]}, Indexes: []*schema.Index{ { Name: "notificationrule_id", Unique: true, Columns: []*schema.Column{NotificationRulesColumns[0]}, }, { Name: "notificationrule_namespace", Unique: false, Columns: []*schema.Column{NotificationRulesColumns[1]}, }, { Name: "notificationrule_namespace_id", Unique: false, Columns: []*schema.Column{NotificationRulesColumns[1], NotificationRulesColumns[0]}, }, { Name: "notificationrule_namespace_type", Unique: false, Columns: []*schema.Column{NotificationRulesColumns[1], NotificationRulesColumns[5]}, }, }, } // UsageResetsColumns holds the columns for the "usage_resets" table. UsageResetsColumns = []*schema.Column{ {Name: "id", Type: field.TypeString, Unique: true, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "namespace", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "updated_at", Type: field.TypeTime}, {Name: "deleted_at", Type: field.TypeTime, Nullable: true}, {Name: "reset_time", Type: field.TypeTime}, {Name: "entitlement_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // UsageResetsTable holds the schema information for the "usage_resets" table. UsageResetsTable = &schema.Table{ Name: "usage_resets", Columns: UsageResetsColumns, PrimaryKey: []*schema.Column{UsageResetsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "usage_resets_entitlements_usage_reset", Columns: []*schema.Column{UsageResetsColumns[6]}, RefColumns: []*schema.Column{EntitlementsColumns[0]}, OnDelete: schema.NoAction, }, }, Indexes: []*schema.Index{ { Name: "usagereset_id", Unique: true, Columns: []*schema.Column{UsageResetsColumns[0]}, }, { Name: "usagereset_namespace", Unique: false, Columns: []*schema.Column{UsageResetsColumns[1]}, }, { Name: "usagereset_namespace_entitlement_id", Unique: false, Columns: []*schema.Column{UsageResetsColumns[1], UsageResetsColumns[6]}, }, { Name: "usagereset_namespace_entitlement_id_reset_time", Unique: false, Columns: []*schema.Column{UsageResetsColumns[1], UsageResetsColumns[6], UsageResetsColumns[5]}, }, }, } // NotificationChannelRulesColumns holds the columns for the "notification_channel_rules" table. NotificationChannelRulesColumns = []*schema.Column{ {Name: "notification_channel_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "notification_rule_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // NotificationChannelRulesTable holds the schema information for the "notification_channel_rules" table. NotificationChannelRulesTable = &schema.Table{ Name: "notification_channel_rules", Columns: NotificationChannelRulesColumns, PrimaryKey: []*schema.Column{NotificationChannelRulesColumns[0], NotificationChannelRulesColumns[1]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "notification_channel_rules_notification_channel_id", Columns: []*schema.Column{NotificationChannelRulesColumns[0]}, RefColumns: []*schema.Column{NotificationChannelsColumns[0]}, OnDelete: schema.Cascade, }, { Symbol: "notification_channel_rules_notification_rule_id", Columns: []*schema.Column{NotificationChannelRulesColumns[1]}, RefColumns: []*schema.Column{NotificationRulesColumns[0]}, OnDelete: schema.Cascade, }, }, } // NotificationEventDeliveryStatusEventsColumns holds the columns for the "notification_event_delivery_status_events" table. NotificationEventDeliveryStatusEventsColumns = []*schema.Column{ {Name: "notification_event_delivery_status_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, {Name: "notification_event_id", Type: field.TypeString, SchemaType: map[string]string{"postgres": "char(26)"}}, } // NotificationEventDeliveryStatusEventsTable holds the schema information for the "notification_event_delivery_status_events" table. NotificationEventDeliveryStatusEventsTable = &schema.Table{ Name: "notification_event_delivery_status_events", Columns: NotificationEventDeliveryStatusEventsColumns, PrimaryKey: []*schema.Column{NotificationEventDeliveryStatusEventsColumns[0], NotificationEventDeliveryStatusEventsColumns[1]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "notification_event_delivery_status_events_notification_event_delivery_status_id", Columns: []*schema.Column{NotificationEventDeliveryStatusEventsColumns[0]}, RefColumns: []*schema.Column{NotificationEventDeliveryStatusColumns[0]}, OnDelete: schema.Cascade, }, { Symbol: "notification_event_delivery_status_events_notification_event_id", Columns: []*schema.Column{NotificationEventDeliveryStatusEventsColumns[1]}, RefColumns: []*schema.Column{NotificationEventsColumns[0]}, OnDelete: schema.Cascade, }, }, } // Tables holds all the tables in the schema. Tables = []*schema.Table{ BalanceSnapshotsTable, BillingCustomerOverridesTable, BillingInvoicesTable, BillingInvoiceItemsTable, BillingProfilesTable, BillingWorkflowConfigsTable, CustomersTable, CustomerSubjectsTable, EntitlementsTable, FeaturesTable, GrantsTable, NotificationChannelsTable, NotificationEventsTable, NotificationEventDeliveryStatusTable, NotificationRulesTable, UsageResetsTable, NotificationChannelRulesTable, NotificationEventDeliveryStatusEventsTable, } )
Functions ¶
func Create ¶
func Create(ctx context.Context, s *Schema, tables []*schema.Table, opts ...schema.MigrateOption) error
Create creates all table resources using the given schema driver.
Types ¶
type Schema ¶
type Schema struct {
// contains filtered or unexported fields
}
Schema is the API for creating, migrating and dropping a schema.
func (*Schema) Diff ¶
Diff creates a migration file containing the statements to resolve the diff between the Ent schema and the connected database.
func (*Schema) NamedDiff ¶
NamedDiff creates a named migration file containing the statements to resolve the diff between the Ent schema and the connected database.
Click to show internal directories.
Click to hide internal directories.