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 ( // AchievementsColumns holds the columns for the "achievements" table. AchievementsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "status", Type: field.TypeString, Default: "current"}, {Name: "thumbnail_img_url", Type: field.TypeString, Default: "https://images.unsplash.com/photo-1546069901-ba9599a7e63c?ixlib=rb-4.0.3&ixid=MnwxMjA3fDB8MHxleHBsb3JlLWZlZWR8MXx8fGVufDB8fHx8&w=1000&q=80"}, {Name: "bfp_goal", Type: field.TypeFloat64}, {Name: "created_at", Type: field.TypeTime}, {Name: "user_achievements", Type: field.TypeInt, Nullable: true}, } // AchievementsTable holds the schema information for the "achievements" table. AchievementsTable = &schema.Table{ Name: "achievements", Columns: AchievementsColumns, PrimaryKey: []*schema.Column{AchievementsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "achievements_users_achievements", Columns: []*schema.Column{AchievementsColumns[5]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, } // ArticlesColumns holds the columns for the "articles" table. ArticlesColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "thumbnail_img_url", Type: field.TypeString, Default: "https://media.istockphoto.com/id/1316145932/photo/table-top-view-of-spicy-food.jpg?b=1&s=170667a&w=0&k=20&c=P3jIQq8gVqlXjd4kP2OrXYyzqEXSWCwwYtwrd81psDY="}, {Name: "title", Type: field.TypeString}, {Name: "content", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, } // ArticlesTable holds the schema information for the "articles" table. ArticlesTable = &schema.Table{ Name: "articles", Columns: ArticlesColumns, PrimaryKey: []*schema.Column{ArticlesColumns[0]}, } // BfpDataPointsColumns holds the columns for the "bfp_data_points" table. BfpDataPointsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "fat_percentage", Type: field.TypeFloat64}, {Name: "total_weight", Type: field.TypeInt}, {Name: "created_at", Type: field.TypeTime}, {Name: "user_bf_ps", Type: field.TypeInt, Nullable: true}, } // BfpDataPointsTable holds the schema information for the "bfp_data_points" table. BfpDataPointsTable = &schema.Table{ Name: "bfp_data_points", Columns: BfpDataPointsColumns, PrimaryKey: []*schema.Column{BfpDataPointsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "bfp_data_points_users_BFPs", Columns: []*schema.Column{BfpDataPointsColumns[4]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, } // MealsColumns holds the columns for the "meals" table. MealsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "meal_type", Type: field.TypeString}, {Name: "image_url", Type: field.TypeString, Default: "https://upload.wikimedia.org/wikipedia/commons/thumb/0/03/Japanese_SilkyTofu_%28Kinugoshi_Tofu%29.JPG/440px-Japanese_SilkyTofu_%28Kinugoshi_Tofu%29.JPG"}, {Name: "created_at", Type: field.TypeTime}, {Name: "user_meals", Type: field.TypeInt, Nullable: true}, } // MealsTable holds the schema information for the "meals" table. MealsTable = &schema.Table{ Name: "meals", Columns: MealsColumns, PrimaryKey: []*schema.Column{MealsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "meals_users_meals", Columns: []*schema.Column{MealsColumns[4]}, RefColumns: []*schema.Column{UsersColumns[0]}, OnDelete: schema.SetNull, }, }, } // TagsColumns holds the columns for the "tags" table. TagsColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "tag_name", Type: field.TypeString}, {Name: "created_at", Type: field.TypeTime}, {Name: "article_tags", Type: field.TypeInt, Nullable: true}, } // TagsTable holds the schema information for the "tags" table. TagsTable = &schema.Table{ Name: "tags", Columns: TagsColumns, PrimaryKey: []*schema.Column{TagsColumns[0]}, ForeignKeys: []*schema.ForeignKey{ { Symbol: "tags_articles_tags", Columns: []*schema.Column{TagsColumns[3]}, RefColumns: []*schema.Column{ArticlesColumns[0]}, OnDelete: schema.SetNull, }, }, } // UsersColumns holds the columns for the "users" table. UsersColumns = []*schema.Column{ {Name: "id", Type: field.TypeInt, Increment: true}, {Name: "user_name", Type: field.TypeString, Unique: true}, {Name: "password", Type: field.TypeString}, } // UsersTable holds the schema information for the "users" table. UsersTable = &schema.Table{ Name: "users", Columns: UsersColumns, PrimaryKey: []*schema.Column{UsersColumns[0]}, } // Tables holds all the tables in the schema. Tables = []*schema.Table{ AchievementsTable, ArticlesTable, BfpDataPointsTable, MealsTable, TagsTable, UsersTable, } )
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.