{"id":44450,"date":"2023-01-10T04:32:53","date_gmt":"2024-01-16T02:25:55","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/"},"modified":"2024-04-29T09:18:50","modified_gmt":"2024-04-29T01:18:50","slug":"%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/","title":{"rendered":"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API"},"content":{"rendered":"

\u524d\u8a00<\/h1>\n

\u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5df2\u7d93\u5b8c\u6210\u4e86Goa\u5c08\u6848\u7684\u74b0\u5883\u8a2d\u7f6e\u3002\u5728\u9019\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u4f7f\u7528golang-migration\u548cgorm\u5728goa\u5c08\u6848\u4e2d\u5be6\u73feCRUD API\u7684\u529f\u80fd\u3002<\/p>\n

1. \u4f7f\u7528 Docker Compose \u542f\u52a8 PostgreSQL \u5bb9\u5668
\n2. \u4f7f\u7528 golang-migration \u521b\u5efa\u6570\u636e\u5e93\u6a21\u5f0f
\n3. \u4f7f\u7528 gorm \u521b\u5efa\u5b9e\u4f53\u3001\u8fde\u63a5\u6570\u636e\u5e93\u5e76\u5b9e\u73b0 CRUD \u64cd\u4f5c
\n4. \u8fdb\u884c\u64cd\u4f5c\u786e\u8ba4<\/p>\n

\u9002\u5408\u53ea\u60f3\u770b\u6e90\u4ee3\u7801\u7684\u4eba\u3002<\/p>\n

 <\/p>\n

\u6211\u5728Goa\u7684GitHub\u4e0a\u6709\u4e00\u4e9b\u793a\u4f8b\u9879\u76ee\uff0c\u53ef\u4ee5\u53c2\u8003\u9879\u76ee\u7ed3\u6784\u548c\u7f16\u7801\u7b49\u65b9\u9762\uff0c\u4e0b\u9762\u662f\u94fe\u63a5\u3002<\/p>\n

 <\/p>\n

\u9879\u76ee\u7ed3\u6784<\/h1>\n
  \/api\r\n\u3000\u3000\/model\r\n\u3000\u3000\u3000\/database\r\n\u3000\u3000\u3000\u3000\/repository\u3000\r\n\u3000\u3000\u3000\u3000\u3000product.go\u3010DB\u306eCRUD\u51e6\u7406\u3011\r\n\u3000\u3000\u3000\u3000\/entity\r\n\u3000\u3000\u3000\u3000\u3000product.go\u3010Entity\u5b9a\u7fa9\u3011\r\n\u3000\u3000\u3000\u3000connection.go\u3010DB\u63a5\u7d9a\u51e6\u7406\u3011\r\n\u3000\u3000\/svc\r\n     \/design\u3000\r\n       product.go\u3010\u30c7\u30b6\u30a4\u30f3\u5b9a\u7fa9\u3011\r\n       \/request\r\n         product.go\u3010\u30ea\u30af\u30a8\u30b9\u30c8\u30d1\u30e9\u30e1\u30fc\u30bf\u3011\r\n       \/response\r\n         product.go\u3010\u30ec\u30b9\u30dd\u30f3\u30b9\u30d1\u30e9\u30e1\u30fc\u30bf\u3011\r\n  \/gen\u3000\u3000 \u2190 goa gen \u3067\u751f\u6210\u3055\u308c\u308b\u3002\u624b\u3067\u3044\u3058\u3089\u306a\u3044\u3002\r\n  \/cmd\u3000\u3000 \u2190 goa example \u3067\u751f\u6210\u3055\u308c\u308b\u3002\r\n    \/inventory_system\r\n      main.go\u3010\u30a2\u30d7\u30ea\u8d77\u52d5\u6642\u306b\u5b9f\u884c\u3055\u308c\u308bmain\u95a2\u6570\u3042\u308a\u3011\r\n  inventory.go \u2190 goa example \u3067\u751f\u6210\u3055\u308c\u308b\u3002\r\n\r\n\u3000\/db\/migrations\u3010golang-migration\u7528\u30d5\u30a1\u30a4\u30eb\u3092\u683c\u7d0d\u3011\r\n    000001_create_product_table.up.sql\r\n    000001_create_product_table.down.sql\r\n    000002_add_product.up.sql\r\n    000002_add_product.down.sql\r\n\r\n\u3000docker-compose.yml\r\n\u3000.env\u3010godotenv\u3067\u30a2\u30d7\u30ea\u8d77\u52d5\u6642\u306b\u8aad\u307f\u8fbc\u3080\/docker-compose up\u6642\u306b\u8aad\u307f\u8fbc\u3080\u3011\r\n\u3000.env_template \u203b .env\u306fGitHub\u306b\u3042\u3052\u305a\u3053\u308c\u3092\u3042\u3052\u308b\u3002\u5229\u7528\u3059\u308b\u6642\u306f\u300c.env\u300d\u306b\u30ea\u30cd\u30fc\u30e0\r\n<\/code><\/pre>\n
\u4f7f\u7528docker compose up\u547d\u4ee4\u6765\u542f\u52a8PostgreSQL\u5bb9\u5668\u3002<\/h1>\n
\u5c06\u7528\u4e8e\u5bb9\u5668\u542f\u52a8\u7684YAML\u548c.env\u6587\u4ef6\u653e\u7f6e\u5728\u4efb\u610f\u76ee\u5f55\u4e2d\uff0c\u4f7f\u7528docker compose up -d\u547d\u4ee4\u542f\u52a8\u3002<\/p>\n
docker-compose.yml \u6587\u4ef6<\/p>\n
version<\/span>:<\/span> \"<\/span>3.8\"<\/span>\r\nservices<\/span>:<\/span>\r\n  dbms<\/span>:<\/span>\r\n    image<\/span>:<\/span> postgres:latest<\/span>\r\n    restart<\/span>:<\/span> always<\/span>\r\n    environment<\/span>:<\/span>\r\n      TZ<\/span>:<\/span> ${OS_TIMEZONE}<\/span>\r\n      POSTGRES_USER<\/span>:<\/span> ${POSTGRES_USER}<\/span>\r\n      POSTGRES_PASSWORD<\/span>:<\/span> ${POSTGRES_PASSWORD}<\/span>\r\n    healthcheck<\/span>:<\/span>\r\n      test<\/span>:<\/span> [<\/span>\"<\/span>CMD-SHELL\"<\/span>,<\/span> \"<\/span>pg_isready<\/span> -d<\/span> postgres<\/span> -U<\/span> postgres\"<\/span>]<\/span>\r\n      interval<\/span>:<\/span> 10s<\/span>\r\n      timeout<\/span>:<\/span> 10s<\/span>\r\n      retries<\/span>:<\/span> 5<\/span>\r\n    ports<\/span>:<\/span>\r\n      -<\/span> ${POSTGRES_PORT}:5432<\/span>\r\n<\/code><\/pre>\n
\u5728\u5c06.env\u4e0a\u4f20\u5230\u5b58\u50a8\u5e93\u65f6\uff0c\u8bf7\u5c06\u5176\u6539\u540d\u4e3a”.env.template”\u5e76\u4e0a\u4f20\u3002<\/p>\n
OS_TIMEZONE=Asia\/Tokyo\r\nPOSTGRES_USER=postgres\r\nPOSTGRES_PASSWORD=postgres\r\nPOSTGRES_PORT=5435\r\n<\/code><\/pre>\n
\u2461 \u4f7f\u7528golang-migration\u5de5\u5177\u521b\u5efa\u6570\u636e\u5e93\u6a21\u5f0f\u3002<\/h1>\n
\u6211\u4f1a\u6309\u7167\u5b98\u65b9\u7684\u5165\u95e8\u6307\u5357\u6765\u4f7f\u7528golang-migration\uff0c\u56e0\u4e3a\u6211\u5bf9\u5176\u4e2d\u7684\u7ec6\u8282\u4e00\u65e0\u6240\u77e5\u3002<\/p>\n
 <\/p>\n
\u8fc1\u79fbCLI\u5b89\u88c5<\/h2>\n
 <\/p>\n
# Mac<\/span>\r\nbrew install <\/span>golang-migrate\r\n# \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u78ba\u8a8d<\/span>\r\n% migrate -version<\/span>\r\nv4.15.2\r\n<\/code><\/pre>\n
 <\/p>\n
\u521b\u5efa\u8fc1\u79fb\u6587\u4ef6<\/h2>\n
\u901a\u8fc7\u6267\u884c\u63d0\u4f9b\u7684\u8fc1\u79fb\u547d\u4ee4\u884c\u754c\u9762\uff08CLI\uff09\u547d\u4ee4\uff0c\u53ef\u4ee5\u751f\u6210\u7528\u4e8e\u8fc1\u79fb\u7684SQL\u6587\u4ef6\u3002<\/p>\n
\u4ea7\u54c1\u8868<\/h3>\n
migrate create -ext sql -dir db\/migrations -seq create_product_table\r\n<\/code><\/pre>\n
\u6267\u884c\u4e0a\u8ff0\u547d\u4ee4\u540e\uff0c\u5c06\u521b\u5efa\u4e24\u4e2a\u6587\u4ef6up\u548cdown\u3002<\/p>\n
000001_\u521b\u5efa\u4ea7\u54c1\u8868.up.sql
\n000001_\u521b\u5efa\u4ea7\u54c1\u8868.down.sql<\/p><\/blockquote>\n
\u30fb\u56e0\u4e3a\u5185\u90e8\u662f\u7a7a\u7684\uff0c\u6240\u4ee5\u9700\u8981\u5bf9\u5b83\u4eec\u5206\u522b\u8fdb\u884c\u5b9a\u4e49\u3002<\/p>\n
000001_create_product_table.up.sql\u7684\u610f\u601d\u662f\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a”product”\u7684\u6570\u636e\u5e93\u8868\u3002<\/p>\n
CREATE<\/span> TABLE<\/span> IF<\/span> NOT<\/span> EXISTS<\/span> product<\/span>(<\/span>\r\n   product_id<\/span> serial<\/span> PRIMARY<\/span> KEY<\/span>,<\/span>\r\n   product_name<\/span> VARCHAR<\/span> (<\/span>50<\/span>)<\/span> UNIQUE<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n   product_description<\/span> VARCHAR<\/span>(<\/span>500<\/span>),<\/span>\r\n   product_min_stock<\/span> INTEGER<\/span>\r\n);<\/span>\r\n<\/code><\/pre>\n
\u521b\u5efa\u4ea7\u54c1\u8868\u7684down\u811a\u672c\u3002<\/p>\n
DROP<\/span> TABLE<\/span> IF<\/span> EXISTS<\/span> product<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u7522\u54c1\u8cc7\u6599<\/h3>\n
migrate create -ext sql -dir db\/migrations -seq add_product\r\n<\/code><\/pre>\n
\u4f7f\u7528\u76f8\u540c\u7684\u547d\u4ee4\uff0c\u5728\u6570\u636e\u5e93\u4e2d\u521b\u5efa\u4e00\u4e2aSQL\u6587\u4ef6\uff0c\u5c31\u50cfproduct\u8868\u4e00\u6837\u3002<\/p>\n
000002_\u65b0\u589e\u4ea7\u54c1.up.sql
\n000002_\u65b0\u589e\u4ea7\u54c1.down.sql<\/p><\/blockquote>\n
\u7531\u4e8e\u5185\u5bb9\u4e3a\u7a7a\uff0c\u6240\u4ee5\u9700\u8981\u5bf9\u5176\u8fdb\u884c\u76f8\u5e94\u7684\u5b9a\u4e49\u3002<\/p>\n
000002_add_product.up.sql
\n000002_\u65b0\u589e\u4ea7\u54c1.\u4e0a\u5347.sql<\/p>\n
INSERT<\/span> INTO<\/span> product<\/span> \r\n(<\/span>product_name<\/span>,<\/span> product_description<\/span>,<\/span> product_min_stock<\/span>)<\/span>\r\nVALUES<\/span>\r\n(<\/span>'\u88fd\u54c1A'<\/span>,<\/span> '\u88fd\u54c1A\u306e\u8aac\u660e'<\/span>,<\/span> '10'<\/span>),<\/span>\r\n(<\/span>'\u88fd\u54c1B'<\/span>,<\/span> '\u88fd\u54c1B\u306e\u8aac\u660e'<\/span>,<\/span> '20'<\/span>),<\/span>\r\n(<\/span>'\u88fd\u54c1C'<\/span>,<\/span> '\u88fd\u54c1C\u306e\u8aac\u660e'<\/span>,<\/span> '30'<\/span>);<\/span>\r\n<\/code><\/pre>\n
000002_add_product.down.sql \u7684\u4e2d\u6587\u91ca\u4e49\u53ea\u9700\u8981\u63d0\u4f9b\u4e00\u4e2a\u9009\u9879 :<\/p>\n
000002_add_product.down.sql – \u6dfb\u52a0\u4ea7\u54c1.down.sql<\/p>\n
DELETE<\/span> FROM<\/span> product<\/span>;<\/span>\r\n<\/code><\/pre>\n
\u79fb\u6c11\u6267\u884c\uff08\u5411\u4e0a\uff09<\/h2>\n
# \u30d5\u30a9\u30fc\u30de\u30c3\u30c8<\/span>\r\nmigrate -database<\/span> ${<\/span>POSTGRESQL_URL<\/span>}<\/span> -path<\/span> db\/migrations up\r\n# \u5b9f\u884c\u30b3\u30de\u30f3\u30c9<\/span>\r\nmigrate -database<\/span> \"postgres:\/\/postgres:postgres@localhost:5435\/postgres?sslmode=disable\"<\/span> -path<\/span> db\/migrations up\r\n<\/code><\/pre>\n
\u6267\u884c\u7ed3\u679c<\/p>\n
1\/u create_product_table (42.524774ms)\r\n2\/u add_product (81.520087ms)\r\n<\/code><\/pre>\n
\"image.png\"<\/div>\n
\u8fc1\u79fb\u5b9e\u65bd\uff08\u4e0b\u884c\uff09<\/h2>\n
\u4f7f\u7528up\u547d\u4ee4\u521b\u5efa\u7684\u8868\u683c\/\u6570\u636e\u9700\u8981\u4f7f\u7528down\u547d\u4ee4\u64a4\u9500\u3002<\/p>\n
% migrate -database<\/span> \"postgres:\/\/postgres:postgres@localhost:5435\/postgres?sslmode=disable\"<\/span> -path<\/span> db\/migrations down\r\n<\/code><\/pre>\n
\u6267\u884c\u7ed3\u679c (sh\u00ed ji\u00e9 gu\u01d2)<\/p>\n
Are you sure you want to apply all down migrations? [<\/span>y\/N]\r\ny\r\nApplying all down migrations\r\n2\/d add_product (<\/span>39.820023ms)<\/span>\r\n1\/d create_product_table (<\/span>73.951284ms)<\/span>\r\n<\/code><\/pre>\n
\"image.png\"<\/div>\n
\u6570\u636e\u5e93\u8fde\u63a5URL\u683c\u5f0f\u3002<\/h3>\n
 <\/p>\n
\u7528gorm\u521b\u5efa\u5b9e\u4f53\u3001\u5b9e\u73b0\u6570\u636e\u5e93\u8fde\u63a5\u548cCRUD\u64cd\u4f5c\u3002<\/h1>\n
Golang\u7684ORM\u7684\u6d41\u884c\u5ea6\u5728\u4ee5\u4e0b\u4ee3\u7801\u5e93\u4e2d\u6709\u7edf\u8ba1\u3002\u76ee\u524d\uff082022\/05\/02\uff09\uff0c\u6211\u4eec\u5c06\u4f7f\u7528\u7b2c\u4e8c\u540d\u7684gorm\u3002<\/p>\n
 <\/p>\n
\u6570\u636e\u5e93\u8fde\u63a5<\/h2>\n
\u5b89\u88c5\u5fc5\u8981\u7684\u4f9d\u8d56<\/p>\n
go get gorm.io\/gorm\r\ngo get gorm.io\/driver\/postgres\r\n<\/code><\/pre>\n
\u521b\u5efa\u4e00\u4e2a\u540d\u4e3a `inventory-system\/api\/model\/database\/connection.go` \u7684\u6587\u4ef6\u3002<\/p>\n
package<\/span> database<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t\"log\"<\/span>\r\n\r\n\t\"gorm.io\/driver\/postgres\"<\/span>\r\n\t\"gorm.io\/gorm\"<\/span>\r\n)<\/span>\r\n\r\nvar<\/span> Db<\/span> *<\/span>gorm<\/span>.<\/span>DB<\/span>\r\nvar<\/span> err<\/span> error<\/span>\r\n\r\n\/\/ \u30a2\u30d7\u30ea\u8d77\u52d5\u6642\u306b\u3053\u306e\u95a2\u6570\u3092\u547c\u3073\u51fa\u3059\u3002<\/span>\r\nfunc<\/span> SetupDb<\/span>()<\/span> {<\/span>\r\n\tvar<\/span> host<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"DB_HOST\"<\/span>)<\/span>\r\n\tvar<\/span> user<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"DB_USER\"<\/span>)<\/span>\r\n\tvar<\/span> password<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"DB_PASSWORD\"<\/span>)<\/span>\r\n\tvar<\/span> name<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"DB_NAME\"<\/span>)<\/span>\r\n\tvar<\/span> port<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"DB_PORT\"<\/span>)<\/span>\r\n\tvar<\/span> timezone<\/span> =<\/span> os<\/span>.<\/span>Getenv<\/span>(<\/span>\"OS_TIMEZONE\"<\/span>)<\/span>\r\n\r\n\tdsn<\/span> :=<\/span> \"host=\"<\/span> +<\/span> host<\/span> +<\/span> \" user=\"<\/span> +<\/span> user<\/span> +<\/span> \" password=\"<\/span> +<\/span> password<\/span> +<\/span> \" dbname=\"<\/span> +<\/span> name<\/span> +<\/span> \" port=\"<\/span> +<\/span> port<\/span> +<\/span> \" sslmode=disable TimeZone=\"<\/span> +<\/span> timezone<\/span>\r\n\tDb<\/span>,<\/span> err<\/span> =<\/span> gorm<\/span>.<\/span>Open<\/span>(<\/span>postgres<\/span>.<\/span>Open<\/span>(<\/span>dsn<\/span>),<\/span> &<\/span>gorm<\/span>.<\/span>Config<\/span>{})<\/span>\r\n\tif<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"FAILED TO CONNECT TO DB\"<\/span>)<\/span>\r\n\t}<\/span> else<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Println<\/span>(<\/span>\"CONNECTED TO DB\"<\/span>)<\/span>\r\n\t}<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u6839\u76ee\u5f55\u4e0b\u7684.env\u6587\u4ef6<\/p>\n
DB_HOST=localhost\r\nDB_USER=postgres\r\nDB_PASSWORD=postgres\r\nDB_NAME=postgres\r\nDB_PORT=5435\r\nOS_TIMEZONE=Asia\/Tokyo\r\n<\/code><\/pre>\n
\u203b\u5168\u7403\u53d8\u91cf\u7684\u6ce8\u610f\u4e8b\u9879<\/p>\n
 <\/p>\n
\u5173\u4e8e\u7531gorm.Open()\u8fd4\u56de\u7684DB\u5bf9\u8c61<\/h3>\n
DB\u5bf9\u8c61\u7684\u771f\u5b9e\u8eab\u4efd\u662fGolang\u6807\u51c6\u5e93database\/sql\u7684DB\u7ed3\u6784\u3002<\/p>\n
\u4e00\u4e2a\u6570\u636e\u5e93\u5bf9\u8c61\u53ef\u4ee5\u540c\u65f6\u88ab\u591a\u4e2agoroutine\u5229\u7528\u548c\u8fde\u63a5\u6c60\u652f\u6301\uff0c\u6240\u4ee5\u5728\u6574\u4e2a\u5e94\u7528\u4e2d\u53ea\u9700\u8981\u5728\u4e00\u4e2a\u5730\u65b9\u4f7f\u7528gorm.Open()\u6765\u83b7\u53d6\u6570\u636e\u5e93\u5bf9\u8c61\u5373\u53ef\u3002<\/p>\n
\u8fd4\u56de\u7684\u6570\u636e\u5e93\u5bf9\u591a\u4e2a goroutine \u7684\u5e76\u53d1\u4f7f\u7528\u662f\u5b89\u5168\u7684\uff0c\u5e76\u4e14\u7ef4\u62a4\u7740\u81ea\u5df1\u7684\u7a7a\u95f2\u8fde\u63a5\u6c60\u3002\u56e0\u6b64\uff0c\u53ea\u9700\u8981\u8c03\u7528\u4e00\u6b21 Open \u51fd\u6570\u3002\u5173\u95ed\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u5f88\u5c11\u9700\u8981\u3002<\/p><\/blockquote>\n
 <\/p>\n
Entity\u7684\u542b\u7fa9<\/h2>\n
\u5efa\u7acbinventory-system\/api\/model\/database\/entity\/product.go\u3002<\/p>\n
package<\/span> entity<\/span>\r\n\r\ntype<\/span> Product<\/span> struct<\/span> {<\/span>\r\n\tProductID<\/span>          uint<\/span> `gorm:\"primaryKey\"`<\/span>\r\n\tProductName<\/span>        string<\/span>\r\n\tProductDescription<\/span> string<\/span>\r\n\tProductMinStock<\/span>    int32<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u5bf9CRUD\u7684\u5b9e\u73b0<\/h2>\n
\u521b\u5efa\u8bf7\u6c42\u548c\u54cd\u5e94<\/h3>\n
\u5728\u5b9a\u4e49Design\u4e4b\u524d\uff0c\u5148\u521b\u5efaCreate\u548cUpdate\u8bf7\u6c42\u53c2\u6570\uff0c\u4ee5\u53caFind\u54cd\u5e94\u53c2\u6570\u3002<\/p>\n
\u521b\u5efa inventory-system\/api\/svc\/design\/request\/product.go\u3002<\/p>\n
package<\/span> request<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t.<\/span> \"goa.design\/goa\/v3\/dsl\"<\/span>\r\n)<\/span>\r\n\r\nvar<\/span> CreateProductPayload<\/span> =<\/span> Type<\/span>(<\/span>\"CreateProductPayload\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n\tField<\/span>(<\/span>1<\/span>,<\/span> \"productName\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>2<\/span>,<\/span> \"productDescription\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>3<\/span>,<\/span> \"productMinStock\"<\/span>,<\/span> Int32<\/span>)<\/span>\r\n\tRequired<\/span>(<\/span>\"productName\"<\/span>)<\/span>\r\n})<\/span>\r\n\r\nvar<\/span> UpdateProductPayload<\/span> =<\/span> Type<\/span>(<\/span>\"UpdateProductPayload\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n\tField<\/span>(<\/span>1<\/span>,<\/span> \"productId\"<\/span>,<\/span> Int<\/span>)<\/span>\r\n\tField<\/span>(<\/span>2<\/span>,<\/span> \"productName\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>3<\/span>,<\/span> \"productDescription\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>4<\/span>,<\/span> \"productMinStock\"<\/span>,<\/span> Int32<\/span>)<\/span>\r\n\tRequired<\/span>(<\/span>\"productId\"<\/span>)<\/span>\r\n})<\/span>\r\n<\/code><\/pre>\n
\u521b\u5efa\u4e00\u4e2a inventory-system\/api\/svc\/design\/response\/product.go \u6587\u4ef6\u3002<\/p>\n
package<\/span> response<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t.<\/span> \"goa.design\/goa\/v3\/dsl\"<\/span>\r\n)<\/span>\r\n\r\nvar<\/span> FindProductResult<\/span> =<\/span> ResultType<\/span>(<\/span>\"FindProductResult\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n\tField<\/span>(<\/span>1<\/span>,<\/span> \"productId\"<\/span>,<\/span> Int<\/span>)<\/span>\r\n\tField<\/span>(<\/span>2<\/span>,<\/span> \"productName\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>3<\/span>,<\/span> \"productDescription\"<\/span>,<\/span> String<\/span>)<\/span>\r\n\tField<\/span>(<\/span>4<\/span>,<\/span> \"productMinStock\"<\/span>,<\/span> Int32<\/span>)<\/span>\r\n})<\/span>\r\n<\/code><\/pre>\n
\u8bbe\u8ba1\u51fa\u6765<\/h3>\n
\u521b\u5efa inventory-system\/api\/svc\/design\/product.go \u6587\u4ef6\u3002
\n\u5b9a\u4e49\u5bf9\u4e8e products \u7684 CRUD \u8bbe\u8ba1\u3002
\n\u6ce8\u518c \/products POST
\n\u66f4\u65b0 \/products\/{productId} PUT
\n\u83b7\u53d6 \/products\/{productId} GET
\n\u5220\u9664 \/products\/{productId} DELETE<\/p>\n
package<\/span> design<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t\"inventory-system\/api\/svc\/design\/request\"<\/span>\r\n\t\"inventory-system\/api\/svc\/design\/response\"<\/span>\r\n\r\n\t.<\/span> \"goa.design\/goa\/v3\/dsl\"<\/span>\r\n)<\/span>\r\n\r\n\/\/ API\u30b5\u30fc\u30d0\u5b9a\u7fa9<\/span>\r\nvar<\/span> _<\/span> =<\/span> API<\/span>(<\/span>\"inventory-system\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n    \/\/ API \u306e\u8aac\u660e\uff08\u30bf\u30a4\u30c8\u30eb\u3068\u8aac\u660e\uff09<\/span>\r\n    Title<\/span>(<\/span>\"Inteventory System Service\"<\/span>)<\/span>\r\n    Description<\/span>(<\/span>\"Service for inventory\"<\/span>)<\/span>\r\n\r\n    \/\/ \u30db\u30b9\u30c8\u60c5\u5831<\/span>\r\n    Server<\/span>(<\/span>\"inventory-system\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n        Host<\/span>(<\/span>\"localhost\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n            URI<\/span>(<\/span>\"http:\/\/localhost:8008\"<\/span>)<\/span> \/\/ HTTP REST API<\/span>\r\n            URI<\/span>(<\/span>\"grpc:\/\/localhost:8088\"<\/span>)<\/span> \/\/ gRPC<\/span>\r\n        })<\/span>\r\n    })<\/span>\r\n})<\/span>\r\n\r\n\/\/ \u30b5\u30fc\u30d3\u30b9\u5b9a\u7fa9<\/span>\r\nvar<\/span> _<\/span> =<\/span> Service<\/span>(<\/span>\"inventory\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n    Description<\/span>(<\/span>\"The inventory service\"<\/span>)<\/span>\r\n\r\n    \/\/ Create<\/span>\r\n    Method<\/span>(<\/span>\"create\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n        Payload<\/span>(<\/span>request<\/span>.<\/span>CreateProductPayload<\/span>)<\/span>\r\n        Result<\/span>(<\/span>String<\/span>)<\/span>\r\n        HTTP<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            POST<\/span>(<\/span>\"\/products\"<\/span>)<\/span>\r\n        })<\/span>\r\n        GRPC<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            Response<\/span>(<\/span>CodeOK<\/span>)<\/span>\r\n        })<\/span>\r\n    })<\/span>\r\n    \/\/ Update<\/span>\r\n    Method<\/span>(<\/span>\"update\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n        Payload<\/span>(<\/span>request<\/span>.<\/span>UpdateProductPayload<\/span>)<\/span>\r\n        Result<\/span>(<\/span>String<\/span>)<\/span>\r\n        HTTP<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            PUT<\/span>(<\/span>\"\/products\/{productId}\"<\/span>)<\/span>\r\n        })<\/span>\r\n        GRPC<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            Response<\/span>(<\/span>CodeOK<\/span>)<\/span>\r\n        })<\/span>\r\n    })<\/span>\r\n    \/\/ Find<\/span>\r\n    Method<\/span>(<\/span>\"find\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n        Payload<\/span>(<\/span>func<\/span>(){<\/span>\r\n            Field<\/span>(<\/span>1<\/span>,<\/span> \"productId\"<\/span>,<\/span> Int<\/span>)<\/span>\r\n            Required<\/span>(<\/span>\"productId\"<\/span>)<\/span>\r\n        })<\/span>\r\n        Result<\/span>(<\/span>response<\/span>.<\/span>FindProductResult<\/span>)<\/span>\r\n        HTTP<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            GET<\/span>(<\/span>\"\/products\/{productId}\"<\/span>)<\/span>\r\n        })<\/span>\r\n        GRPC<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            Response<\/span>(<\/span>CodeOK<\/span>)<\/span>\r\n        })<\/span>\r\n    })<\/span>\r\n    \/\/ Delete<\/span>\r\n    Method<\/span>(<\/span>\"delete\"<\/span>,<\/span> func<\/span>()<\/span> {<\/span>\r\n        Payload<\/span>(<\/span>func<\/span>(){<\/span>\r\n            Field<\/span>(<\/span>1<\/span>,<\/span> \"productId\"<\/span>,<\/span> Int<\/span>)<\/span>\r\n            Required<\/span>(<\/span>\"productId\"<\/span>)<\/span>\r\n        })<\/span>\r\n        Result<\/span>(<\/span>String<\/span>)<\/span>\r\n        HTTP<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            DELETE<\/span>(<\/span>\"\/products\/{productId}\"<\/span>)<\/span>\r\n        })<\/span>\r\n        GRPC<\/span>(<\/span>func<\/span>()<\/span> {<\/span>\r\n            Response<\/span>(<\/span>CodeOK<\/span>)<\/span>\r\n        })<\/span>\r\n    })<\/span>\r\n\r\n})<\/span>\r\n<\/code><\/pre>\n
\u4ece\u8bbe\u8ba1\u5230\u7f16\u7801\u5b9e\u73b0<\/h3>\n
\u6839\u636e\u4e4b\u524d\u7684\u5de5\u7a0b\u521b\u5efa\u7684\u8bbe\u8ba1\uff0c\u4f7f\u7528goa\u751f\u6210\u6a21\u677f\u6587\u4ef6\u3002<\/p>\n
\/\/ gen\u30d5\u30a9\u30eb\u30c0\u751f\u6210\r\ngoa gen inventory-system\/api\/svc\/design\r\n\r\n\/\/ cmd\u30d5\u30a9\u30eb\u30c0 + inventory.go\u751f\u6210\r\ngoa example inventory-system\/api\/svc\/design\r\n<\/code><\/pre>\n
inventory.go\u8fd9\u4e2a\u6587\u4ef6\u7684\u5927\u81f4\u5185\u5bb9\u5982\u4e0b\u3002<\/p>\n
package<\/span> inventorysystem<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t\"context\"<\/span>\r\n\t\"inventory-system\/api\/model\/database\/repository\"<\/span>\r\n\tinventory<\/span> \"inventory-system\/gen\/inventory\"<\/span>\r\n\t\"log\"<\/span>\r\n)<\/span>\r\n\r\n\/\/ inventory service example implementation.<\/span>\r\n\/\/ The example methods log the requests and return zero values.<\/span>\r\ntype<\/span> inventorysrvc<\/span> struct<\/span> {<\/span>\r\n\tlogger<\/span> *<\/span>log<\/span>.<\/span>Logger<\/span>\r\n}<\/span>\r\n\r\n\/\/ NewInventory returns the inventory service implementation.<\/span>\r\nfunc<\/span> NewInventory<\/span>(<\/span>logger<\/span> *<\/span>log<\/span>.<\/span>Logger<\/span>)<\/span> inventory<\/span>.<\/span>Service<\/span> {<\/span>\r\n\treturn<\/span> &<\/span>inventorysrvc<\/span>{<\/span>logger<\/span>}<\/span>\r\n}<\/span>\r\n\r\n\/\/ Create implements create.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Create<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>CreateProductPayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.create\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Update implements update.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Update<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>UpdateProductPayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.update\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Find implements find.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Find<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>FindPayload<\/span>)<\/span> (<\/span>res<\/span> *<\/span>inventory<\/span>.<\/span>Findproductresult<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.find\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Delete implements delete.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Delete<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>DeletePayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.delete\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u5f00\u53d1\u4eba\u5458\u5c06\u6839\u636e\u5df2\u786e\u5b9a\u7684API\u7684\u8bf7\u6c42\/\u54cd\u5e94\u72b6\u6001\u751f\u6210\u76f8\u5e94\u7684\u6587\u4ef6\u3002\u5f00\u53d1\u4eba\u5458\u5c06\u6839\u636e\u786e\u5b9a\u7684\u63a5\u53e3\u89c4\u8303\uff0c\u5728\u8fd9\u4e2a\u6a21\u677f\u6587\u4ef6\u4e2d\u5b9e\u73b0\u903b\u8f91\u3002<\/p>\n
\u8bf7\u5728cmd\/inventory_system\/main.go\u4e2d\u6dfb\u52a0\u2460DB\u8fde\u63a5\u5904\u7406\u548c\u2461.env\u8bfb\u53d6\u5904\u7406\u3002<\/h3>\n
\u53ea\u9700\u8981\u4e00\u4e2a\u9009\u9879\u5417\uff1f\u8bf7\u6267\u884c\u4ee5\u4e0b\u4efb\u52a1\uff1a\u5728\u7531goa example\u547d\u4ee4\u751f\u6210\u7684cmd\/inventory_system\/main.go\u6587\u4ef6\u4e2d\u7684main\u51fd\u6570\u662f\u5728\u5e94\u7528\u542f\u52a8\u65f6\u6267\u884c\u7684\u51fd\u6570\u3002
\n\u4e3a\u4e86\u5728\u5e94\u7528\u542f\u52a8\u65f6\u6267\u884c\u2460\u6570\u636e\u5e93\u8fde\u63a5\u5904\u7406\u548c\u2461\u8bfb\u53d6.env\u6587\u4ef6\u7684\u5904\u7406\uff0c\u9700\u8981\u5c06\u8fd9\u4e9b\u5904\u7406\u6dfb\u52a0\u5230main\u51fd\u6570\u4e2d\u3002<\/p>\n
\u6570\u636e\u5e93\u8fde\u63a5\u5904\u7406<\/h4>\n
package<\/span> main<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"inventory-system\/api\/model\/database\"<\/span>\r\n    \/\/ \u305d\u306e\u4ed6import\u5272\u611b<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> main<\/span>()<\/span> {<\/span>\r\n    \/\/ \u2460DB\u63a5\u7d9a\u51e6\u7406<\/span>\r\n    database<\/span>.<\/span>SetupDb<\/span>()<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u8bfb\u53d6.env\u6587\u4ef6\u7684\u5904\u7406<\/h4>\n
\u4f7f\u7528godotenv\u6765\u8bfb\u53d6\u6839\u76ee\u5f55\u4e0b\u7684.env\u6587\u4ef6\u3002<\/p>\n
 <\/p>\n
\u5b89\u88c5<\/p>\n
go get github.com\/joho\/godotenv\r\n<\/code><\/pre>\n
\u5c06\u4ee5\u4e0b\u5185\u5bb9\u8ffd\u52a0\u5230\u4e3b\u51fd\u6570\u4e2d<\/p>\n
package<\/span> main<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"github.com\/joho\/godotenv\"<\/span>\r\n    \/\/ \u305d\u306e\u4ed6import\u5272\u611b<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> main<\/span>()<\/span> {<\/span>\r\n    \/\/ \u2461.env\u30ed\u30fc\u30c9\u51e6\u7406<\/span>\r\n\terr<\/span> :=<\/span> godotenv<\/span>.<\/span>Load<\/span>()<\/span>\r\n\tif<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"Error loading .env file\"<\/span>)<\/span>\r\n\t}<\/span> else<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Println<\/span>(<\/span>\"LOAD .env file\"<\/span>)<\/span>\r\n\t}<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u6700\u540e\u7684\u7ed3\u679c\u662f\u8fd9\u6837\u7684\u3002<\/p>\n
package<\/span> main<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n    \"inventory-system\/api\/model\/database\"<\/span>\r\n\t\"github.com\/joho\/godotenv\"<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> main<\/span>()<\/span> {<\/span>\r\n\t\/\/ Load .env file<\/span>\r\n\terr<\/span> :=<\/span> godotenv<\/span>.<\/span>Load<\/span>()<\/span>\r\n\tif<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"Error loading .env file\"<\/span>)<\/span>\r\n\t}<\/span> else<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Println<\/span>(<\/span>\"LOAD .env file\"<\/span>)<\/span>\r\n\t}<\/span>\r\n\t\/\/ Setup Database<\/span>\r\n\tdatabase<\/span>.<\/span>SetupDb<\/span>()<\/span>\r\n\r\n}<\/span>\r\n<\/code><\/pre>\n
\u521b\u5efa\u4ee3\u7801\u4ed3\u5e93<\/h3>\n
\u521b\u5efa inventory-system\/api\/model\/database\/repository\/product.go\u3002<\/p>\n
package<\/span> repository<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t\"inventory-system\/api\/model\/database\"<\/span>\r\n\t\"inventory-system\/api\/model\/database\/entity\"<\/span>\r\n\tinventory<\/span> \"inventory-system\/gen\/inventory\"<\/span>\r\n\t\"log\"<\/span>\r\n)<\/span>\r\n\r\nfunc<\/span> SaveProduct<\/span>(<\/span>p<\/span> *<\/span>inventory<\/span>.<\/span>CreateProductPayload<\/span>)<\/span> {<\/span>\r\n\tproduct<\/span> :=<\/span> entity<\/span>.<\/span>Product<\/span>{<\/span>\r\n\t\tProductName<\/span>:<\/span>        p<\/span>.<\/span>ProductName<\/span>,<\/span>\r\n\t\tProductDescription<\/span>:<\/span> *<\/span>p<\/span>.<\/span>ProductDescription<\/span>,<\/span>\r\n\t\tProductMinStock<\/span>:<\/span>    *<\/span>p<\/span>.<\/span>ProductMinStock<\/span>,<\/span>\r\n\t}<\/span>\r\n\tdatabase<\/span>.<\/span>Db<\/span>.<\/span>Create<\/span>(<\/span>&<\/span>product<\/span>)<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> UpdateProduct<\/span>(<\/span>p<\/span> *<\/span>inventory<\/span>.<\/span>UpdateProductPayload<\/span>)<\/span> {<\/span>\r\n\t\/\/ find<\/span>\r\n\tvar<\/span> product<\/span> entity<\/span>.<\/span>Product<\/span>\r\n\tif<\/span> err<\/span> :=<\/span> database<\/span>.<\/span>Db<\/span>.<\/span>Where<\/span>(<\/span>\"product_id = ?\"<\/span>,<\/span> p<\/span>.<\/span>ProductID<\/span>)<\/span>.<\/span>First<\/span>(<\/span>&<\/span>product<\/span>)<\/span>.<\/span>Error<\/span>;<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"NOT FOUND PRODUCT\"<\/span>)<\/span>\r\n\t}<\/span>\r\n\t\/\/ update<\/span>\r\n\tproduct<\/span>.<\/span>ProductName<\/span> =<\/span> *<\/span>p<\/span>.<\/span>ProductName<\/span>\r\n\tproduct<\/span>.<\/span>ProductDescription<\/span> =<\/span> *<\/span>p<\/span>.<\/span>ProductDescription<\/span>\r\n\tproduct<\/span>.<\/span>ProductMinStock<\/span> =<\/span> *<\/span>p<\/span>.<\/span>ProductMinStock<\/span>\r\n\tdatabase<\/span>.<\/span>Db<\/span>.<\/span>Save<\/span>(<\/span>&<\/span>product<\/span>)<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> FindProduct<\/span>(<\/span>id<\/span> int<\/span>)<\/span> entity<\/span>.<\/span>Product<\/span> {<\/span>\r\n\tvar<\/span> product<\/span> entity<\/span>.<\/span>Product<\/span>\r\n\tif<\/span> err<\/span> :=<\/span> database<\/span>.<\/span>Db<\/span>.<\/span>Where<\/span>(<\/span>\"product_id = ?\"<\/span>,<\/span> id<\/span>)<\/span>.<\/span>First<\/span>(<\/span>&<\/span>product<\/span>)<\/span>.<\/span>Error<\/span>;<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"NOT FOUND PRODUCT\"<\/span>)<\/span>\r\n\t}<\/span>\r\n\treturn<\/span> product<\/span>\r\n}<\/span>\r\n\r\nfunc<\/span> DeleteProduct<\/span>(<\/span>id<\/span> int<\/span>)<\/span> {<\/span>\r\n\t\/\/ find<\/span>\r\n\tvar<\/span> product<\/span> entity<\/span>.<\/span>Product<\/span>\r\n\tif<\/span> err<\/span> :=<\/span> database<\/span>.<\/span>GetDb<\/span>()<\/span>.<\/span>Where<\/span>(<\/span>\"product_id = ?\"<\/span>,<\/span> id<\/span>)<\/span>.<\/span>First<\/span>(<\/span>&<\/span>product<\/span>)<\/span>.<\/span>Error<\/span>;<\/span> err<\/span> !=<\/span> nil<\/span> {<\/span>\r\n\t\tlog<\/span>.<\/span>Fatal<\/span>(<\/span>\"NOT FOUND PRODUCT\"<\/span>)<\/span>\r\n\t}<\/span>\r\n\t\/\/ delete<\/span>\r\n\tdatabase<\/span>.<\/span>Db<\/span>.<\/span>Delete<\/span>(<\/span>&<\/span>product<\/span>)<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u4fee\u6539inventory.go\uff08\u539f\u578b\u6587\u4ef6\uff09\u3002<\/h3>\n
\u4fee\u6539\u4ee3\u7801\uff0c\u4ece\u6bcf\u4e2a\u7aef\u70b9\u8c03\u7528\u5b58\u50a8\u5e93\u63d0\u4f9b\u7684CRUD\u64cd\u4f5c\u3002<\/p>\n
package<\/span> inventorysystem<\/span>\r\n\r\nimport<\/span> (<\/span>\r\n\t\"context\"<\/span>\r\n\t\"inventory-system\/api\/model\/database\/repository\"<\/span>\r\n\tinventory<\/span> \"inventory-system\/gen\/inventory\"<\/span>\r\n\t\"log\"<\/span>\r\n)<\/span>\r\n\r\n\/\/ inventory service example implementation.<\/span>\r\n\/\/ The example methods log the requests and return zero values.<\/span>\r\ntype<\/span> inventorysrvc<\/span> struct<\/span> {<\/span>\r\n\tlogger<\/span> *<\/span>log<\/span>.<\/span>Logger<\/span>\r\n}<\/span>\r\n\r\n\/\/ NewInventory returns the inventory service implementation.<\/span>\r\nfunc<\/span> NewInventory<\/span>(<\/span>logger<\/span> *<\/span>log<\/span>.<\/span>Logger<\/span>)<\/span> inventory<\/span>.<\/span>Service<\/span> {<\/span>\r\n\treturn<\/span> &<\/span>inventorysrvc<\/span>{<\/span>logger<\/span>}<\/span>\r\n}<\/span>\r\n\r\n\/\/ Create implements create.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Create<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>CreateProductPayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\trepository<\/span>.<\/span>SaveProduct<\/span>(<\/span>p<\/span>)<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.create\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Update implements update.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Update<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>UpdateProductPayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\trepository<\/span>.<\/span>UpdateProduct<\/span>(<\/span>p<\/span>)<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.update\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Find implements find.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Find<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>FindPayload<\/span>)<\/span> (<\/span>res<\/span> *<\/span>inventory<\/span>.<\/span>Findproductresult<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\tvar<\/span> product<\/span> =<\/span> repository<\/span>.<\/span>FindProduct<\/span>(<\/span>p<\/span>.<\/span>ProductID<\/span>)<\/span>\r\n\tres<\/span> =<\/span> &<\/span>inventory<\/span>.<\/span>Findproductresult<\/span>{<\/span>\r\n\t\tProductID<\/span>:<\/span>          &<\/span>p<\/span>.<\/span>ProductID<\/span>,<\/span>\r\n\t\tProductName<\/span>:<\/span>        &<\/span>product<\/span>.<\/span>ProductName<\/span>,<\/span>\r\n\t\tProductDescription<\/span>:<\/span> &<\/span>product<\/span>.<\/span>ProductDescription<\/span>,<\/span>\r\n\t\tProductMinStock<\/span>:<\/span>    &<\/span>product<\/span>.<\/span>ProductMinStock<\/span>,<\/span>\r\n\t}<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.find\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n\r\n\/\/ Delete implements delete.<\/span>\r\nfunc<\/span> (<\/span>s<\/span> *<\/span>inventorysrvc<\/span>)<\/span> Delete<\/span>(<\/span>ctx<\/span> context<\/span>.<\/span>Context<\/span>,<\/span> p<\/span> *<\/span>inventory<\/span>.<\/span>DeletePayload<\/span>)<\/span> (<\/span>res<\/span> string<\/span>,<\/span> err<\/span> error<\/span>)<\/span> {<\/span>\r\n\trepository<\/span>.<\/span>DeleteProduct<\/span>(<\/span>p<\/span>.<\/span>ProductID<\/span>)<\/span>\r\n\ts<\/span>.<\/span>logger<\/span>.<\/span>Print<\/span>(<\/span>\"inventory.delete\"<\/span>)<\/span>\r\n\treturn<\/span>\r\n}<\/span>\r\n<\/code><\/pre>\n
\u8bf7\u53c2\u8003\u4ee5\u4e0b\u5bf9gorm\u7684\u4f7f\u7528\u65b9\u6cd5\u3002<\/p>\n
 <\/p>\n
\u786e\u8ba4\u52a8\u4f5c<\/h1>\n
\u4e00\u5207\u5c31\u7eea\uff0c\u5f00\u59cb\u6784\u5efa\u5e76\u5c1d\u8bd5\u6267\u884c\u3002<\/p>\n
\/\/ \u5b9f\u884c\u30d5\u30a1\u30a4\u30eb(inventory_system)\u3092\u751f\u6210\r\ngo build .\/cmd\/inventory_system\r\n\r\n\/\/\u3000\u5b9f\u884c\r\n.\/inventory_system\r\n<\/code><\/pre>\n
\u5f00\u59cb\u884c\u52a8\uff01<\/p>\n
% go build .\/cmd\/inventory_system\r\n% .\/inventory_system \r\n2022\/05\/05 16:01:49 LOAD .env file\r\n2022\/05\/05 16:01:49 CONNECTED TO DB\r\n[inventorysystem] 16:01:49 HTTP \"Create\" mounted on POST \/products\r\n[inventorysystem] 16:01:49 HTTP \"Update\" mounted on PUT \/products\/{productId}\r\n[inventorysystem] 16:01:49 HTTP \"Find\" mounted on GET \/products\/{productId}\r\n[inventorysystem] 16:01:49 HTTP \"Delete\" mounted on DELETE \/products\/{productId}\r\n[inventorysystem] 16:01:49 serving gRPC method inventory.Inventory\/Create\r\n[inventorysystem] 16:01:49 serving gRPC method inventory.Inventory\/Update\r\n[inventorysystem] 16:01:49 serving gRPC method inventory.Inventory\/Find\r\n[inventorysystem] 16:01:49 serving gRPC method inventory.Inventory\/Delete\r\n[inventorysystem] 16:01:49 HTTP server listening on \"localhost:8008\"\r\n[inventorysystem] 16:01:49 gRPC server listening on \"localhost:8088\"\r\n<\/code><\/pre>\n
\u5728\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\u65f6\u53ef\u4ee5\u786e\u8ba4.env\u6587\u4ef6\u8bfb\u53d6\u5904\u7406\u6b63\u5728\u8fd0\u884c\u3002
\n\u5728\u5e94\u7528\u7a0b\u5e8f\u542f\u52a8\u65f6\u53ef\u4ee5\u786e\u8ba4\u6570\u636e\u5e93\u8fde\u63a5\u5904\u7406\u6b63\u5728\u8fd0\u884c\u3002<\/p>\n
\u5728\u4e2d\u56fd\uff0c\u4f7f\u7528\u4ee5\u4e0bcurl\u547d\u4ee4\u8fdb\u884c\u64cd\u4f5c\u786e\u8ba4\u3002<\/p>\n
\u521b\u5efa<\/p>\n
curl -X POST -H \"Content-Type: application\/json\" -d '{\"productName\": \"createTest\",\"productDescription\": \"createTest\",\"productMinStock\": 111}' localhost:8008\/products\r\n<\/code><\/pre>\n
\u66f4\u65b0<\/p>\n
curl -X PUT -H \"Content-Type: application\/json\" -d '{\"productName\": \"updateTest\",\"productDescription\": \"updateTest\",\"productMinStock\": 99911}' localhost:8008\/products\/1\r\n<\/code><\/pre>\n
\u627e\u5230<\/p>\n
curl localhost:8008\/products\/1\r\n<\/code><\/pre>\n
\u5220\u9664<\/p>\n
curl -X DELETE localhost:8008\/products\/1\r\n<\/code><\/pre>\n
\u6211\u81ea\u5df1\u7528\u4fbf\u7b7e<\/h1>\n
init\u51fd\u6570\u548cmain\u51fd\u6570\u7684\u533a\u522b<\/p>\n
\u4ee5\u4e0b\u662f\u5728Golang\u4e2d\u7684\u4e3b\u8981\u51fd\u6570\u548cinit\u51fd\u6570\u7684\u4e3b\u8981\u76ee\u7684\u3002\u4e3b\u51fd\u6570\u662f\u7a0b\u5e8f\u7684\u5165\u53e3\u70b9\uff0c\u5f53\u7a0b\u5e8f\u8fd0\u884c\u65f6\uff0c\u5b83\u5c06\u9996\u5148\u88ab\u6267\u884c\u3002init\u51fd\u6570\u662f\u5728main\u51fd\u6570\u6267\u884c\u4e4b\u524d\u88ab\u81ea\u52a8\u8c03\u7528\u7684\u51fd\u6570\u3002\u5b83\u7528\u4e8e\u6267\u884c\u5fc5\u8981\u7684\u521d\u59cb\u5316\u64cd\u4f5c\uff0c\u4f8b\u5982\u8bbe\u7f6e\u53d8\u91cf\u6216\u914d\u7f6e\u7a0b\u5e8f\u3002\u5b83\u5728\u5168\u5c40\u4e0a\u4e0b\u6587\u4e2d\u88ab\u521d\u59cb\u5316\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u524d\u8a00 \u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5df2\u7d93\u5b8c\u6210\u4e86Goa\u5c08\u6848\u7684\u74b0\u5883\u8a2d\u7f6e\u3002\u5728\u9019\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u4f7f\u7528golang-migrati […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-44450","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\n\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010golang\u3011\u4f7f\u7528goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0crud-api\u3002\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API\" \/>\n<meta property=\"og:description\" content=\"\u524d\u8a00 \u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5df2\u7d93\u5b8c\u6210\u4e86Goa\u5c08\u6848\u7684\u74b0\u5883\u8a2d\u7f6e\u3002\u5728\u9019\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u4f7f\u7528golang-migrati […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u3010golang\u3011\u4f7f\u7528goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0crud-api\u3002\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-16T02:25:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-29T01:18:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d587337434c4406ce09ea\/46-0.png\" \/>\n<meta name=\"author\" content=\"\u6e05, \u5b87\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u5b87\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/\",\"name\":\"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2024-01-16T02:25:55+00:00\",\"dateModified\":\"2024-04-29T01:18:50+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e\",\"name\":\"\u6e05, \u5b87\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u5b87\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010golang\u3011\u4f7f\u7528goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0crud-api\u3002\/","og_locale":"zh_CN","og_type":"article","og_title":"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API","og_description":"\u524d\u8a00 \u5728\u4e4b\u524d\u7684\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5df2\u7d93\u5b8c\u6210\u4e86Goa\u5c08\u6848\u7684\u74b0\u5883\u8a2d\u7f6e\u3002\u5728\u9019\u7bc7\u6587\u7ae0\u4e2d\uff0c\u6211\u5011\u5c07\u4f7f\u7528golang-migrati […]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u3010golang\u3011\u4f7f\u7528goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0crud-api\u3002\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2024-01-16T02:25:55+00:00","article_modified_time":"2024-04-29T01:18:50+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d587337434c4406ce09ea\/46-0.png"}],"author":"\u6e05, \u5b87","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u5b87","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/","name":"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2024-01-16T02:25:55+00:00","dateModified":"2024-04-29T01:18:50+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u3010Golang\u3011\u4f7f\u7528Goa\u2716\ufe0fgolang-migration\u2716\ufe0fgorm\u5b9e\u73b0CRUD API"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/1a6ecd3d914d22a5ac32791ffc1fbd8e","name":"\u6e05, \u5b87","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b2016c18459a605fc469c7566608f5686491baa112d0871ee613f61b7210565?s=96&d=mm&r=g","caption":"\u6e05, \u5b87"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyu\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e3%80%90golang%e3%80%91%e4%bd%bf%e7%94%a8goa%e2%9c%96%ef%b8%8fgolang-migration%e2%9c%96%ef%b8%8fgorm%e5%ae%9e%e7%8e%b0crud-api%e3%80%82\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=44450"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44450\/revisions"}],"predecessor-version":[{"id":84397,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/44450\/revisions\/84397"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=44450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=44450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=44450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}