{"id":18075,"date":"2024-03-15T16:12:25","date_gmt":"2024-03-15T16:12:25","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/"},"modified":"2024-03-21T12:26:23","modified_gmt":"2024-03-21T12:26:23","slug":"how-do-you-use-gorm-to-operate-a-database-in-go-language","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/","title":{"rendered":"How do you use GORM to operate a database in Go language?"},"content":{"rendered":"<p>To manipulate databases using GORM in Go language, the first step is to install the GORM library. This can be done by using the following command:<\/p>\n<pre class=\"post-pre\"><code>go get -u gorm.io\/gorm\r\ngo get -u gorm.io\/driver\/mysql\r\n<\/code><\/pre>\n<p>After installation, you can create a database connection and instantiate a gorm.DB object for database operations. Example code is as follows:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> (\r\n\t<span class=\"hljs-string\">\"gorm.io\/driver\/mysql\"<\/span>\r\n\t<span class=\"hljs-string\">\"gorm.io\/gorm\"<\/span>\r\n)\r\n\r\n<span class=\"hljs-function\"><span class=\"hljs-keyword\">func<\/span> <span class=\"hljs-title\">main<\/span><span class=\"hljs-params\">()<\/span><\/span> {\r\n\tdsn := <span class=\"hljs-string\">\"username:password@tcp(localhost:3306)\/database?charset=utf8mb4&amp;parseTime=True&amp;loc=Local\"<\/span>\r\n\tdb, err := gorm.Open(mysql.Open(dsn), &amp;gorm.Config{})\r\n\t<span class=\"hljs-keyword\">if<\/span> err != <span class=\"hljs-literal\">nil<\/span> {\r\n\t\t<span class=\"hljs-built_in\">panic<\/span>(<span class=\"hljs-string\">\"failed to connect database\"<\/span>)\r\n\t}\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u5b9a\u4e49\u6a21\u578b\u7ed3\u6784<\/span>\r\n\t<span class=\"hljs-keyword\">type<\/span> User <span class=\"hljs-keyword\">struct<\/span> {\r\n\t\tgorm.Model\r\n\t\tName  <span class=\"hljs-type\">string<\/span>\r\n\t\tEmail <span class=\"hljs-type\">string<\/span>\r\n\t}\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u521b\u5efa\u8868<\/span>\r\n\terr = db.AutoMigrate(&amp;User{})\r\n\t<span class=\"hljs-keyword\">if<\/span> err != <span class=\"hljs-literal\">nil<\/span> {\r\n\t\t<span class=\"hljs-built_in\">panic<\/span>(<span class=\"hljs-string\">\"failed to migrate database\"<\/span>)\r\n\t}\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u521b\u5efa\u8bb0\u5f55<\/span>\r\n\tuser := User{Name: <span class=\"hljs-string\">\"John\"<\/span>, Email: <span class=\"hljs-string\">\"john@example.com\"<\/span>}\r\n\tdb.Create(&amp;user)\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u67e5\u8be2\u8bb0\u5f55<\/span>\r\n\t<span class=\"hljs-keyword\">var<\/span> result User\r\n\tdb.First(&amp;result, user.ID)\r\n\tfmt.Println(result)\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u66f4\u65b0\u8bb0\u5f55<\/span>\r\n\tdb.Model(&amp;result).Update(<span class=\"hljs-string\">\"Name\"<\/span>, <span class=\"hljs-string\">\"Tom\"<\/span>)\r\n\r\n\t<span class=\"hljs-comment\">\/\/ \u5220\u9664\u8bb0\u5f55<\/span>\r\n\tdb.Delete(&amp;result)\r\n}\r\n<\/code><\/pre>\n<p>The example code above demonstrates how to use GORM to create connections, tables, records, query records, update records, and delete records. It can be adjusted and expanded based on your own needs.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To manipulate databases using GORM in Go language, the first step is to install the GORM library. This can be done by using the following command: go get -u gorm.io\/gorm go get -u gorm.io\/driver\/mysql After installation, you can create a database connection and instantiate a gorm.DB object for database operations. Example code is as follows: [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-18075","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How do you use GORM to operate a database in Go language? - 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\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How do you use GORM to operate a database in Go language?\" \/>\n<meta property=\"og:description\" content=\"To manipulate databases using GORM in Go language, the first step is to install the GORM library. This can be done by using the following command: go get -u gorm.io\/gorm go get -u gorm.io\/driver\/mysql After installation, you can create a database connection and instantiate a gorm.DB object for database operations. Example code is as follows: [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T16:12:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T12:26:23+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How do you use GORM to operate a database in Go language?\",\"datePublished\":\"2024-03-15T16:12:25+00:00\",\"dateModified\":\"2024-03-21T12:26:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\"},\"wordCount\":92,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\",\"name\":\"How do you use GORM to operate a database in Go language? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T16:12:25+00:00\",\"dateModified\":\"2024-03-21T12:26:23+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How do you use GORM to operate a database in Go language?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How do you use GORM to operate a database in Go language? - 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\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/","og_locale":"en_US","og_type":"article","og_title":"How do you use GORM to operate a database in Go language?","og_description":"To manipulate databases using GORM in Go language, the first step is to install the GORM library. This can be done by using the following command: go get -u gorm.io\/gorm go get -u gorm.io\/driver\/mysql After installation, you can create a database connection and instantiate a gorm.DB object for database operations. Example code is as follows: [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T16:12:25+00:00","article_modified_time":"2024-03-21T12:26:23+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How do you use GORM to operate a database in Go language?","datePublished":"2024-03-15T16:12:25+00:00","dateModified":"2024-03-21T12:26:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/"},"wordCount":92,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/","name":"How do you use GORM to operate a database in Go language? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T16:12:25+00:00","dateModified":"2024-03-21T12:26:23+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-use-gorm-to-operate-a-database-in-go-language\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How do you use GORM to operate a database in Go language?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18075","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=18075"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18075\/revisions"}],"predecessor-version":[{"id":51729,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18075\/revisions\/51729"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=18075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=18075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=18075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}