Documentation ¶
Index ¶
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 // WithFixture sets the foreign-key renaming option to the migration when upgrading // ent from v0.1.0 (issue-#285). Defaults to true. WithFixture = schema.WithFixture )
View Source
var ( // ItemsColumns holds the columns for the "items" table. ItemsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "create_time", Type: field.TypeTime}, {Name: "update_time", Type: field.TypeTime}, {Name: "source", Type: field.TypeString}, {Name: "hash", Type: field.TypeString}, {Name: "data", Type: field.TypeJSON, Nullable: true}, {Name: "task_items", Type: field.TypeInt, Nullable: true}, } // ItemsTable holds the schema information for the "items" table. ItemsTable = &schema.Table{ Name: "items", Columns: ItemsColumns, PrimaryKey: []*schema.Column{ItemsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "items_tasks_items", Columns: []*schema.Column{ItemsColumns[6]}, RefColumns: []*schema.Column{TasksColumns[0]}, OnDelete: schema.SetNull, }, }, } // SystemSummariesColumns holds the columns for the "system_summaries" table. SystemSummariesColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "create_time", Type: field.TypeTime}, {Name: "users", Type: field.TypeInt}, {Name: "tasks", Type: field.TypeInt}, {Name: "active_tasks", Type: field.TypeInt}, {Name: "items", Type: field.TypeInt}, {Name: "avg_items_per_task", Type: field.TypeFloat64}, } // SystemSummariesTable holds the schema information for the "system_summaries" table. SystemSummariesTable = &schema.Table{ Name: "system_summaries", Columns: SystemSummariesColumns, PrimaryKey: []*schema.Column{SystemSummariesColumns[0]}, ForeignKeys: []*schema.ForeignKey{}, } // TasksColumns holds the columns for the "tasks" table. TasksColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "create_time", Type: field.TypeTime}, {Name: "update_time", Type: field.TypeTime}, {Name: "slug", Type: field.TypeString}, {Name: "title", Type: field.TypeString}, {Name: "description", Type: field.TypeString, Nullable: true}, {Name: "code", Type: field.TypeString, Unique: true}, {Name: "active", Type: field.TypeBool}, {Name: "delete_time", Type: field.TypeTime, Nullable: true}, {Name: "params", Type: field.TypeJSON, Nullable: true}, {Name: "meta", Type: field.TypeJSON, Nullable: true}, {Name: "task_type_tasks", Type: field.TypeInt, Nullable: true}, {Name: "user_tasks", Type: field.TypeInt, Nullable: true}, } // TasksTable holds the schema information for the "tasks" table. TasksTable = &schema.Table{ Name: "tasks", Columns: TasksColumns, PrimaryKey: []*schema.Column{TasksColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "tasks_task_types_tasks", Columns: []*schema.Column{TasksColumns[11]}, RefColumns: []*schema.Column{TaskTypesColumns[0]}, OnDelete: schema.SetNull, }, { Symbol: "tasks_users_tasks", Columns: []*schema.Column{TasksColumns[12]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, Indexes: []*schema.Index{ { Name: "task_slug_user_tasks", Unique: true, Columns: []*schema.Column{TasksColumns[3], TasksColumns[12]}, }, { Name: "task_title_user_tasks", Unique: true, Columns: []*schema.Column{TasksColumns[4], TasksColumns[12]}, }, }, } // TaskTypesColumns holds the columns for the "task_types" table. TaskTypesColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "code", Type: field.TypeString, Unique: true}, {Name: "title", Type: field.TypeString, Unique: true}, } // TaskTypesTable holds the schema information for the "task_types" table. TaskTypesTable = &schema.Table{ Name: "task_types", Columns: TaskTypesColumns, PrimaryKey: []*schema.Column{TaskTypesColumns[0]}, ForeignKeys: []*schema.ForeignKey{}, } // UsersColumns holds the columns for the "users" table. UsersColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "create_time", Type: field.TypeTime}, {Name: "update_time", Type: field.TypeTime}, {Name: "username", Type: field.TypeString, Unique: true}, {Name: "email", Type: field.TypeString, Unique: true}, {Name: "password_hash", Type: field.TypeString}, {Name: "service", Type: field.TypeBool}, } // UsersTable holds the schema information for the "users" table. UsersTable = &schema.Table{ Name: "users", Columns: UsersColumns, PrimaryKey: []*schema.Column{UsersColumns[0]}, ForeignKeys: []*schema.ForeignKey{}, } // Tables holds all the tables in the schema. Tables = []*schema.Table{ ItemsTable, SystemSummariesTable, TasksTable, TaskTypesTable, UsersTable, } )
Functions ¶
This section is empty.
Types ¶
type Schema ¶
type Schema struct {
// contains filtered or unexported fields
}
Schema is the API for creating, migrating and dropping a schema.
Click to show internal directories.
Click to hide internal directories.