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 // WithForeignKeys enables creating foreign-key in schema DDL. This defaults to true. WithForeignKeys = schema.WithForeignKeys )
View Source
var ( // AllTypesColumns holds the columns for the "all_types" table. AllTypesColumns = []*schema.Column{ {Name: "id", Type: field.TypeUint32, Increment: true}, {Name: "int", Type: field.TypeInt}, {Name: "int8", Type: field.TypeInt8}, {Name: "int16", Type: field.TypeInt16}, {Name: "int32", Type: field.TypeInt32}, {Name: "int64", Type: field.TypeInt64}, {Name: "uint", Type: field.TypeUint}, {Name: "uint8", Type: field.TypeUint8}, {Name: "uint16", Type: field.TypeUint16}, {Name: "uint32", Type: field.TypeUint32}, {Name: "uint64", Type: field.TypeUint64}, {Name: "float32", Type: field.TypeFloat32}, {Name: "float64", Type: field.TypeFloat64}, {Name: "string_type", Type: field.TypeString}, {Name: "bool", Type: field.TypeBool}, {Name: "uuid", Type: field.TypeUUID}, {Name: "time", Type: field.TypeTime}, {Name: "text", Type: field.TypeString, Size: 2147483647}, {Name: "state", Type: field.TypeEnum, Enums: []string{"on", "off"}}, {Name: "bytes", Type: field.TypeBytes}, {Name: "nilable", Type: field.TypeString, Size: 2147483647}, } // AllTypesTable holds the schema information for the "all_types" table. AllTypesTable = &schema.Table{ Name: "all_types", Columns: AllTypesColumns, PrimaryKey: []*schema.Column{AllTypesColumns[0]}, } // CategoriesColumns holds the columns for the "categories" table. CategoriesColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "name", Type: field.TypeString}, {Name: "readonly", Type: field.TypeString, Nullable: true}, } // CategoriesTable holds the schema information for the "categories" table. CategoriesTable = &schema.Table{ Name: "categories", Columns: CategoriesColumns, PrimaryKey: []*schema.Column{CategoriesColumns[0]}, } // HatsColumns holds the columns for the "hats" table. HatsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "name", Type: field.TypeString}, {Name: "type", Type: field.TypeEnum, Enums: []string{"dad", "trucker", "snapback"}}, {Name: "user_favorite_hat", Type: field.TypeInt, Unique: true, Nullable: true}, } // HatsTable holds the schema information for the "hats" table. HatsTable = &schema.Table{ Name: "hats", Columns: HatsColumns, PrimaryKey: []*schema.Column{HatsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "hats_users_favorite_hat", Columns: []*schema.Column{HatsColumns[3]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, } // PetsColumns holds the columns for the "pets" table. PetsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "name", Type: field.TypeString}, {Name: "weight", Type: field.TypeInt, Nullable: true}, {Name: "birthday", Type: field.TypeTime, Nullable: true}, {Name: "tag_id", Type: field.TypeBytes, Nullable: true}, {Name: "height", Type: field.TypeInt, Nullable: true}, {Name: "user_pets", Type: field.TypeInt}, } // PetsTable holds the schema information for the "pets" table. PetsTable = &schema.Table{ Name: "pets", Columns: PetsColumns, PrimaryKey: []*schema.Column{PetsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pets_users_pets", Columns: []*schema.Column{PetsColumns[6]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.NoAction, }, }, } // UsersColumns holds the columns for the "users" table. UsersColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "name", Type: field.TypeString}, {Name: "age", Type: field.TypeUint}, {Name: "height", Type: field.TypeUint, Nullable: true}, {Name: "favorite_cat_breed", Type: field.TypeEnum, Enums: []string{"siamese", "bengal", "lion", "tiger", "leopard", "other"}}, {Name: "favorite_color", Type: field.TypeEnum, Enums: []string{"red", "green", "blue"}, Default: "red"}, {Name: "favorite_dog_breed", Type: field.TypeEnum, Nullable: true, Enums: []string{"Kuro"}}, {Name: "favorite_fish_breed", Type: field.TypeEnum, Nullable: true, Enums: []string{"gold", "koi", "shark"}}, {Name: "user_best_friend", Type: field.TypeInt, Unique: true, Nullable: true}, } // UsersTable holds the schema information for the "users" table. UsersTable = &schema.Table{ Name: "users", Columns: UsersColumns, PrimaryKey: []*schema.Column{UsersColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "users_users_best_friend", Columns: []*schema.Column{UsersColumns[8]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, } // CategoryPetsColumns holds the columns for the "category_pets" table. CategoryPetsColumns = []*schema.Column{ {Name: "category_id", Type: field.TypeInt}, {Name: "pet_id", Type: field.TypeInt}, } // CategoryPetsTable holds the schema information for the "category_pets" table. CategoryPetsTable = &schema.Table{ Name: "category_pets", Columns: CategoryPetsColumns, PrimaryKey: []*schema.Column{CategoryPetsColumns[0], CategoryPetsColumns[1]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "category_pets_category_id", Columns: []*schema.Column{CategoryPetsColumns[0]}, RefColumns: []*schema.Column{CategoriesColumns[0]}, OnDelete: schema.Cascade, }, { Symbol: "category_pets_pet_id", Columns: []*schema.Column{CategoryPetsColumns[1]}, RefColumns: []*schema.Column{PetsColumns[0]}, OnDelete: schema.Cascade, }, }, } // PetFriendsColumns holds the columns for the "pet_friends" table. PetFriendsColumns = []*schema.Column{ {Name: "pet_id", Type: field.TypeInt}, {Name: "friend_id", Type: field.TypeInt}, } // PetFriendsTable holds the schema information for the "pet_friends" table. PetFriendsTable = &schema.Table{ Name: "pet_friends", Columns: PetFriendsColumns, PrimaryKey: []*schema.Column{PetFriendsColumns[0], PetFriendsColumns[1]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "pet_friends_pet_id", Columns: []*schema.Column{PetFriendsColumns[0]}, RefColumns: []*schema.Column{PetsColumns[0]}, OnDelete: schema.Cascade, }, { Symbol: "pet_friends_friend_id", Columns: []*schema.Column{PetFriendsColumns[1]}, RefColumns: []*schema.Column{PetsColumns[0]}, OnDelete: schema.Cascade, }, }, } // UserAnimalsSavedColumns holds the columns for the "user_animals_saved" table. UserAnimalsSavedColumns = []*schema.Column{ {Name: "user_id", Type: field.TypeInt}, {Name: "pet_id", Type: field.TypeInt}, } // UserAnimalsSavedTable holds the schema information for the "user_animals_saved" table. UserAnimalsSavedTable = &schema.Table{ Name: "user_animals_saved", Columns: UserAnimalsSavedColumns, PrimaryKey: []*schema.Column{UserAnimalsSavedColumns[0], UserAnimalsSavedColumns[1]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "user_animals_saved_user_id", Columns: []*schema.Column{UserAnimalsSavedColumns[0]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.Cascade, }, { Symbol: "user_animals_saved_pet_id", Columns: []*schema.Column{UserAnimalsSavedColumns[1]}, RefColumns: []*schema.Column{PetsColumns[0]}, OnDelete: schema.Cascade, }, }, } // Tables holds all the tables in the schema. Tables = []*schema.Table{ AllTypesTable, CategoriesTable, HatsTable, PetsTable, UsersTable, CategoryPetsTable, PetFriendsTable, UserAnimalsSavedTable, } )
Functions ¶
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.