{"id":332503,"date":"2022-04-27T21:00:08","date_gmt":"2022-04-27T21:00:08","guid":{"rendered":"http:\/\/savepearlharbor.com\/?p=332503"},"modified":"-0001-11-30T00:00:00","modified_gmt":"-0001-11-29T21:00:00","slug":"","status":"publish","type":"post","link":"https:\/\/savepearlharbor.com\/?p=332503","title":{"rendered":"<span>Bun: \u0434\u0440\u0443\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043a SQL Golang ORM<\/span>"},"content":{"rendered":"<div><\/div>\n<div id=\"post-content-body\">\n<div>\n<div class=\"article-formatted-body article-formatted-body article-formatted-body_version-2\">\n<div xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\">\n<p>Bun \u044d\u0442\u043e \u0434\u0440\u0443\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043a SQL <a href=\"https:\/\/bun.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">Golang ORM<\/a> \u0434\u043b\u044f PostgreSQL, MySQL\/MariaDB, MSSQL, \u0438 SQLite. \u0414\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0430\u0442\u044c\u044f \u043f\u0440\u0438\u0437\u0432\u0430\u043d\u0430 \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c \u0432\u0430\u0441 \u0441 \u0431\u0430\u0437\u043e\u0432\u044b\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u044d\u0442\u043e\u0439 ORM.<\/p>\n<h3>\u0420\u0430\u0431\u043e\u0442\u0430 \u0441 SQL<\/h3>\n<p>\u0414\u0440\u0443\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043a SQL \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442 \u0447\u0442\u043e \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u044d\u043b\u0435\u0433\u0430\u043d\u0442\u043d\u043e \u043f\u0438\u0441\u0430\u0442\u044c \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u044f\u0437\u044b\u043a Go. \u041a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 Bun \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n<pre><code class=\"go\">var num int err := db.NewSelect().     TableExpr(\"generate_series(1, 3)\").     Where(\"generate_series = ?\", 3).     Limit(10).     Scan(ctx, &amp;num)<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u043e\u0439 SQL:<\/p>\n<pre><code class=\"sql\">SELECT * FROM generate_series(1, 3) WHERE generate_series = 123 LIMIT 10<\/code><\/pre>\n<p>\u041a\u0430\u043a \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0438\u0434\u0435\u0442\u044c, Bun \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u0441\u0435 \u0435\u0449\u0435 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u0443\u0437\u043d\u0430\u0432\u0430\u0435\u043c\u044b\u0439 SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a \u0442\u043e\u043c\u0443 \u0435\u0449\u0435 \u0437\u0430\u0449\u0438\u0449\u0435\u043d \u043e\u0442 SQL \u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439 \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 <code>?<\/code> <a href=\"https:\/\/bun.uptrace.dev\/guide\/placeholders.html\" rel=\"noopener noreferrer nofollow\">placeholders<\/a>:<\/p>\n<pre><code class=\"go\">Where(\"id = ?\", 123)     \/\/ WHERE id = 123 Where(\"id >= ?\", 123)    \/\/ WHERE id >= 123 Where(\"id = ?\", \"hello\") \/\/ WHERE id = 'hello'  Where(\"id IN (?)\", bun.In([]int{1, 2, 3})) \/\/ WHERE id IN (1, 2, 3)  Where(\"? = ?\", bun.Ident(\"column\"), \"value\") \/\/ WHERE \"column\" = 'value'<\/code><\/pre>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f Bun, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043f\u0438\u0441\u0430\u0442\u044c \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u043b\u043e\u0436\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 Bun \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n<pre><code class=\"go\">regionalSales := db.NewSelect(). ColumnExpr(\"region\"). ColumnExpr(\"SUM(amount) AS total_sales\"). TableExpr(\"orders\"). GroupExpr(\"region\")  topRegions := db.NewSelect(). ColumnExpr(\"region\"). TableExpr(\"regional_sales\"). Where(\"total_sales > (SELECT SUM(total_sales) \/ 10 FROM regional_sales)\")  var []items map[string]interface{}  err := db.NewSelect(). With(\"regional_sales\", regionalSales). With(\"top_regions\", topRegions). ColumnExpr(\"region\"). ColumnExpr(\"product\"). ColumnExpr(\"SUM(quantity) AS product_units\"). ColumnExpr(\"SUM(amount) AS product_sales\"). TableExpr(\"orders\"). Where(\"region IN (SELECT region FROM top_regions)\"). GroupExpr(\"region\"). GroupExpr(\"product\"). Scan(ctx, &amp;items)<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u043e\u0439 SQL:<\/p>\n<pre><code class=\"sql\">WITH regional_sales AS (     SELECT region, SUM(amount) AS total_sales     FROM orders     GROUP BY region ), top_regions AS (     SELECT region     FROM regional_sales     WHERE total_sales > (SELECT SUM(total_sales)\/10 FROM regional_sales) ) SELECT region,        product,        SUM(quantity) AS product_units,        SUM(amount) AS product_sales FROM orders WHERE region IN (SELECT region FROM top_regions) GROUP BY region, product<\/code><\/pre>\n<h3>\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/h3>\n<p>Bun \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u0442\u044c Go \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0438 SQL \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f <a href=\"https:\/\/bun.uptrace.dev\/guide\/models.html\" rel=\"noopener noreferrer nofollow\">\u043c\u043e\u0434\u0435\u043b\u0438<\/a>, \u043a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434:<\/p>\n<pre><code class=\"go\">type Model struct {     ID        int64 `bun:\",pk,autoincrement\"`     Name      string `bun:\",notnull\"`     CreatedAt time.Time `bun:\",nullzero,default:now()\"` }  err := db.ResetModel(ctx, &amp;Model{})<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443:<\/p>\n<pre><code class=\"sql\">CREATE TABLE \"models\" (   \"id\" BIGSERIAL NOT NULL,   \"name\" VARCHAR NOT NULL,   \"created_at\" TIMESTAMPTZ DEFAULT now(),   PRIMARY KEY (\"id\"), )<\/code><\/pre>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043e\u0431\u044a\u044f\u0432\u043b\u0435\u043d\u043d\u0443\u044e \u043c\u043e\u0434\u0435\u043b\u044c, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c select\/insert\/update\/delete \u0437\u0430\u043f\u0440\u043e\u0441\u044b:<\/p>\n<pre><code class=\"go\">model := new(Model) err := db.NewSelect().Model().Where(\"id = ?\", 123).Scan(ctx)  model.ID = 0 res, err := db.NewInsert().Model(model).Exec(ctx)  res, err := db.NewUpdate().     Model(model).     Set(\"name = ?\", \"updated name\").     WherePK().     Exec(ctx)  res, err := db.NewDelete().Model(model).WherePK().Exec(ctx)<\/code><\/pre>\n<p>\u041e\u0431\u0440\u0430\u0449\u0430\u0439\u0442\u0435\u0441\u044c \u043a <a href=\"https:\/\/bun.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">Bun \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438<\/a> \u0437\u0430 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u044f\u043c\u0438.<\/p>\n<h3>Golang ORM<\/h3>\n<p>\u041a\u0430\u043a \u043d\u0430\u0441\u0447\u0435\u0442 \u0447\u0430\u0441\u0442\u0438 \u043f\u0440\u043e <a href=\"https:\/\/bun.uptrace.dev\/guide\/golang-orm.html\" rel=\"noopener noreferrer nofollow\">Golang ORM<\/a>? Bun \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0442\u044c \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0435 \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f Go \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b. \u041a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043e\u043f\u0438\u0441\u0430\u0442\u044c <code>Author<\/code> \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0438\u0442 \u043a <code>Book<\/code> \u0442\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n<pre><code class=\"go\">type Book struct { ID int64 AuthorID int64 Author Author `bun:\"rel:belongs-to,join:author_id=id\"` }  type Author struct { ID int64 }<\/code><\/pre>\n<p>\u0410 \u0437\u0430\u0442\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <code>Relation<\/code> \u043c\u0435\u0442\u043e\u0434 \u0434\u043b\u044f \u0434\u0436\u043e\u0439\u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u044b:<\/p>\n<pre><code class=\"go\">err := db.NewSelect(). Model(book). Relation(\"Author\"). Where(\"id = ?\", 123). Scan(ctx)<\/code><\/pre>\n<pre><code class=\"go\">SELECT   \"book\".\"id\", \"book\".\"title\", \"book\".\"text\",   \"author\".\"id\" AS \"author__id\", \"author\".\"name\" AS \"author__name\" FROM \"books\" LEFT JOIN \"users\" AS \"author\" ON \"author\".\"id\" = \"book\".\"author_id\" WHERE id = 1<\/code><\/pre>\n<p>\u0417\u0430 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u043e\u0431\u0440\u0430\u0449\u0430\u0439\u0442\u0435\u0441\u044c \u043a <a href=\"https:\/\/bun.uptrace.dev\/guide\/relations.html\" rel=\"noopener noreferrer nofollow\">ORM: Table relationships<\/a>.<\/p>\n<h3>\u0421\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445<\/h3>\n<p>Bun \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043f\u043e\u0432\u0435\u0440\u0445 database\/sql \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 PostgreSQL, MySQL\/MariaDB, MSSQL, \u0438 SQLite.<\/p>\n<p>\u0414\u043b\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0441 <a href=\"https:\/\/bun.uptrace.dev\/postgres\/\" rel=\"noopener noreferrer nofollow\">PostgreSQL<\/a> \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n<pre><code class=\"go\">import ( \"github.com\/uptrace\/bun\" \"github.com\/uptrace\/bun\/dialect\/pgdialect\"     \"github.com\/uptrace\/bun\/driver\/pgdriver\" )  dsn := \"postgres:\/\/postgres:@localhost:5432\/test?sslmode=disable\" sqldb := sql.OpenDB(pgdriver.NewConnector(pgdriver.WithDSN(dsn)))  db := bun.NewDB(sqldb, pgdialect.New())<\/code><\/pre>\n<p>\u0414\u043b\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0441 <a href=\"https:\/\/bun.uptrace.dev\/guide\/drivers.html#mysql\" rel=\"noopener noreferrer nofollow\">MySQL<\/a> \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n<pre><code class=\"go\">import ( \"github.com\/uptrace\/bun\" \"github.com\/uptrace\/bun\/dialect\/mysqldialect\" _ \"github.com\/go-sql-driver\/mysql\" )  sqldb, err := sql.Open(\"mysql\", \"root:pass@\/test\") if err != nil { panic(err) }  db := bun.NewDB(sqldb, mysqldialect.New())<\/code><\/pre>\n<p>\u0414\u043b\u044f \u043b\u043e\u0433\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0441\u0435\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c <a href=\"https:\/\/bun.uptrace.dev\/guide\/debugging.html\" rel=\"noopener noreferrer nofollow\">bundebug<\/a> \u043f\u043b\u0430\u0433\u0438\u043d:<\/p>\n<pre><code class=\"go\">import \"github.com\/uptrace\/bun\/extra\/bundebug\"  db.AddQueryHook(bundebug.NewQueryHook( bundebug.WithVerbose(true), \/\/ log everything ))<\/code><\/pre>\n<h3>\u0412\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432<\/h3>\n<p>\u041f\u043e\u0441\u043b\u0435 \u0442\u043e\u0433\u043e \u043a\u0430\u043a \u0432\u044b \u043e\u0431\u044a\u044f\u0432\u0438\u043b\u0438 <a href=\"https:\/\/bun.uptrace.dev\/guide\/models.html\" rel=\"noopener noreferrer nofollow\">\u043c\u043e\u0434\u0435\u043b\u044c<\/a>, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0447\u0438\u043d\u0430\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b:<\/p>\n<pre><code class=\"go\">\/\/ Select a user by a primary key. user := new(User) err := db.NewSelect().Model(user).Where(\"id = ?\", 1).Scan(ctx)  \/\/ Select first 10 users. var users []User err := db.NewSelect().Model(&amp;users).OrderExpr(\"id ASC\").Limit(10).Scan(ctx)<\/code><\/pre>\n<p>\u041a\u043e\u0433\u0434\u0430 \u0440\u0435\u0447\u044c \u0438\u0434\u0435\u0442 \u043e <a href=\"https:\/\/bun.uptrace.dev\/queries.html#scan-and-exec\" rel=\"noopener noreferrer nofollow\">\u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438<\/a> \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, Bun \u043e\u0447\u0435\u043d\u044c \u0433\u0438\u0431\u043e\u043a \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441\u043e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430\u043c\u0438:<\/p>\n<pre><code class=\"go\">user := new(User) err := db.NewSelect().Model(user).Limit(1).Scan(ctx)<\/code><\/pre>\n<p>\u0421\u043a\u0430\u043b\u044f\u0440\u0430\u043c\u0438:<\/p>\n<pre><code class=\"go\">var id int64 var name string err := db.NewSelect().Model((*User)(nil)).Column(\"id\", \"name\").Limit(1).Scan(ctx, &amp;id, &amp;name)<\/code><\/pre>\n<p>\u0425\u044d\u0448 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0442\u0438\u043f\u0430 <code>map[string]interface{}<\/code>:<\/p>\n<pre><code class=\"go\">var m map[string]interface{} err := db.NewSelect().Model((*User)(nil)).Limit(1).Scan(ctx, &amp;m)<\/code><\/pre>\n<p>\u0418 \u043c\u0430\u0441\u0441\u0438\u0432\u0430\u043c\u0438 \u0432\u0441\u0435\u0445 \u0440\u0430\u043d\u0435\u0435 \u0443\u043f\u043e\u043c\u044f\u043d\u0443\u0442\u044b\u0445 \u0442\u0438\u043f\u043e\u0432:<\/p>\n<pre><code class=\"go\">var users []User err := db.NewSelect().Model(&amp;users).Limit(1).Scan(ctx)  var ids []int64 var names []string err := db.NewSelect().Model((*User)(nil)).Column(\"id\", \"name\").Limit(1).Scan(ctx, &amp;ids, &amp;names)  var ms []map[string]interface{} err := db.NewSelect().Model((*User)(nil)).Scan(ctx, &amp;ms)<\/code><\/pre>\n<p>\u0412\u044b \u0442\u0430\u043a\u0436\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b insert\/update\/delete \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432:<\/p>\n<pre><code class=\"go\">var ids []int64 res, err := db.NewDelete().Model((*User)(nil)).Returning(\"id\").Exec(ctx, &amp;ids)<\/code><\/pre>\n<h3>\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0435\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438<\/h3>\n<p>Bun \u0438\u043c\u0435\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043f\u043b\u0430\u0433\u0438\u043d\u043e\u0432 \u0432\u043a\u043b\u044e\u0447\u0430\u044f <a href=\"https:\/\/opentelemetry.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">OpenTelemetry<\/a> \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u044e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0443\u044e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/distributed-tracing.html\" rel=\"noopener noreferrer nofollow\">distributed tracing<\/a> \u0438 <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/metrics.html\" rel=\"noopener noreferrer nofollow\">\u043c\u0435\u0442\u0440\u0438\u043a\u0438<\/a>.<\/p>\n<p>\u0422\u0440\u044d\u0439\u0441\u0438\u043d\u0433 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0432\u0430\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0411\u0414 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e <a href=\"https:\/\/get.uptrace.dev\/compare\/distributed-tracing-tools.html\" rel=\"noopener noreferrer nofollow\">open source tracing tools<\/a> \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0445 OpenTelemetry. \u041c\u043d\u043e\u0433\u0438\u0435 \u043f\u043b\u0430\u0442\u043d\u044b\u0435 <a href=\"https:\/\/get.uptrace.dev\/compare\/datadog-competitors.html\" rel=\"noopener noreferrer nofollow\">DataDog competitors<\/a> \u0442\u0430\u043a\u0436\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442 OpenTelemetry.<\/p>\n<p>\u041a\u0440\u043e\u043c\u0435 \u0442\u043e\u0433\u043e, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u044d\u043a\u0441\u043f\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c OpenTelemetry \u043c\u0435\u0442\u0440\u0438\u043a\u0438 \u0432 <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/opentelemetry-prometheus.html\" rel=\"noopener noreferrer nofollow\">Prometheus<\/a> \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f <a href=\"https:\/\/get.uptrace.dev\/compare\/grafana-alternatives.html\" rel=\"noopener noreferrer nofollow\">Grafana<\/a> \u0438\u043b\u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0435 \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u044b.<\/p>\n<h3>\u0427\u0442\u043e \u0434\u0430\u043b\u044c\u0448\u0435<\/h3>\n<p>\u0427\u0442\u043e\u0431\u044b \u043d\u0430\u0447\u0430\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 Bun, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 <a href=\"https:\/\/bun.uptrace.dev\/guide\/golang-orm.html\" rel=\"noopener noreferrer nofollow\">\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u044e<\/a> \u0438 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u0435 <a href=\"https:\/\/github.com\/uptrace\/bun\/tree\/master\/example\" rel=\"noopener noreferrer nofollow\">\u043f\u0440\u0438\u043c\u0435\u0440\u044b<\/a> c GitHub.<\/p>\n<p>\u0415\u0441\u043b\u0438 \u0432\u044b \u0443\u0436\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435 database\/sql, \u0442\u043e \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0447\u0430\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c Bun \u043d\u0435 \u0438\u0437\u043c\u0435\u043d\u044f\u044f \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434. Bun \u0442\u0430\u043a\u0436\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 Go \u0438 SQL <a href=\"https:\/\/bun.uptrace.dev\/guide\/migrations.html\" rel=\"noopener noreferrer nofollow\">\u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438<\/a>, fixtures, \u0445\u0443\u043a\u0438, \u0438 \u043c\u043d\u043e\u0433\u043e\u0435 \u0434\u0440\u0443\u0433\u043e\u0435.<\/p>\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"v-portal\" style=\"display:none;\"><\/div>\n<\/div>\n<p> <!----> <!----><br \/> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"https:\/\/habr.com\/ru\/post\/663332\/\"> https:\/\/habr.com\/ru\/post\/663332\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<div><\/div>\n<div id=\"post-content-body\">\n<div>\n<div class=\"article-formatted-body article-formatted-body article-formatted-body_version-2\">\n<div xmlns=\"http:\/\/www.w3.org\/1999\/xhtml\">\n<p>Bun \u044d\u0442\u043e \u0434\u0440\u0443\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043a SQL <a href=\"https:\/\/bun.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">Golang ORM<\/a> \u0434\u043b\u044f PostgreSQL, MySQL\/MariaDB, MSSQL, \u0438 SQLite. \u0414\u0430\u043d\u043d\u0430\u044f \u0441\u0442\u0430\u0442\u044c\u044f \u043f\u0440\u0438\u0437\u0432\u0430\u043d\u0430 \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c \u0432\u0430\u0441 \u0441 \u0431\u0430\u0437\u043e\u0432\u044b\u043c\u0438 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u044d\u0442\u043e\u0439 ORM.<\/p>\n<h3>\u0420\u0430\u0431\u043e\u0442\u0430 \u0441 SQL<\/h3>\n<p>\u0414\u0440\u0443\u0436\u0435\u0441\u0442\u0432\u0435\u043d\u043d\u044b\u0439 \u043a SQL \u043e\u0437\u043d\u0430\u0447\u0430\u0435\u0442 \u0447\u0442\u043e \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u044d\u043b\u0435\u0433\u0430\u043d\u0442\u043d\u043e \u043f\u0438\u0441\u0430\u0442\u044c \u0441\u0442\u0430\u043d\u0434\u0430\u0440\u0442\u043d\u044b\u0435 SQL \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u044f\u0437\u044b\u043a Go. \u041a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 Bun \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n<pre><code class=\"go\">var num int err := db.NewSelect().     TableExpr(\"generate_series(1, 3)\").     Where(\"generate_series = ?\", 3).     Limit(10).     Scan(ctx, &amp;num)<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u043e\u0439 SQL:<\/p>\n<pre><code class=\"sql\">SELECT * FROM generate_series(1, 3) WHERE generate_series = 123 LIMIT 10<\/code><\/pre>\n<p>\u041a\u0430\u043a \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0432\u0438\u0434\u0435\u0442\u044c, Bun \u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0432\u0441\u0435 \u0435\u0449\u0435 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442 \u0443\u0437\u043d\u0430\u0432\u0430\u0435\u043c\u044b\u0439 SQL, \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043a \u0442\u043e\u043c\u0443 \u0435\u0449\u0435 \u0437\u0430\u0449\u0438\u0449\u0435\u043d \u043e\u0442 SQL \u0438\u043d\u044a\u0435\u043a\u0446\u0438\u0439 \u0431\u043b\u0430\u0433\u043e\u0434\u0430\u0440\u044f \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044e \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 <code>?<\/code> <a href=\"https:\/\/bun.uptrace.dev\/guide\/placeholders.html\" rel=\"noopener noreferrer nofollow\">placeholders<\/a>:<\/p>\n<pre><code class=\"go\">Where(\"id = ?\", 123)     \/\/ WHERE id = 123 Where(\"id >= ?\", 123)    \/\/ WHERE id >= 123 Where(\"id = ?\", \"hello\") \/\/ WHERE id = 'hello'  Where(\"id IN (?)\", bun.In([]int{1, 2, 3})) \/\/ WHERE id IN (1, 2, 3)  Where(\"? = ?\", bun.Ident(\"column\"), \"value\") \/\/ WHERE \"column\" = 'value'<\/code><\/pre>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f Bun, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043f\u0438\u0441\u0430\u0442\u044c \u0434\u0435\u0439\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u043e \u0441\u043b\u043e\u0436\u043d\u044b\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u044b, \u043a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 Bun \u0437\u0430\u043f\u0440\u043e\u0441:<\/p>\n<pre><code class=\"go\">regionalSales := db.NewSelect(). ColumnExpr(\"region\"). ColumnExpr(\"SUM(amount) AS total_sales\"). TableExpr(\"orders\"). GroupExpr(\"region\")  topRegions := db.NewSelect(). ColumnExpr(\"region\"). TableExpr(\"regional_sales\"). Where(\"total_sales > (SELECT SUM(total_sales) \/ 10 FROM regional_sales)\")  var []items map[string]interface{}  err := db.NewSelect(). With(\"regional_sales\", regionalSales). With(\"top_regions\", topRegions). ColumnExpr(\"region\"). ColumnExpr(\"product\"). ColumnExpr(\"SUM(quantity) AS product_units\"). ColumnExpr(\"SUM(amount) AS product_sales\"). TableExpr(\"orders\"). Where(\"region IN (SELECT region FROM top_regions)\"). GroupExpr(\"region\"). GroupExpr(\"product\"). Scan(ctx, &amp;items)<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u043e\u0439 SQL:<\/p>\n<pre><code class=\"sql\">WITH regional_sales AS (     SELECT region, SUM(amount) AS total_sales     FROM orders     GROUP BY region ), top_regions AS (     SELECT region     FROM regional_sales     WHERE total_sales > (SELECT SUM(total_sales)\/10 FROM regional_sales) ) SELECT region,        product,        SUM(quantity) AS product_units,        SUM(amount) AS product_sales FROM orders WHERE region IN (SELECT region FROM top_regions) GROUP BY region, product<\/code><\/pre>\n<h3>\u0421\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0438 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/h3>\n<p>Bun \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0442\u043e\u0431\u0440\u0430\u0436\u0430\u0442\u044c Go \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b \u0438 SQL \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f <a href=\"https:\/\/bun.uptrace.dev\/guide\/models.html\" rel=\"noopener noreferrer nofollow\">\u043c\u043e\u0434\u0435\u043b\u0438<\/a>, \u043a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434:<\/p>\n<pre><code class=\"go\">type Model struct {     ID        int64 `bun:\",pk,autoincrement\"`     Name      string `bun:\",notnull\"`     CreatedAt time.Time `bun:\",nullzero,default:now()\"` }  err := db.ResetModel(ctx, &amp;Model{})<\/code><\/pre>\n<p>\u0413\u0435\u043d\u0435\u0440\u0438\u0440\u0443\u0435\u0442 \u0442\u0430\u043a\u0443\u044e \u0442\u0430\u0431\u043b\u0438\u0446\u0443:<\/p>\n<pre><code class=\"sql\">CREATE TABLE \"models\" (   \"id\" BIGSERIAL NOT NULL,   \"name\" VARCHAR NOT NULL,   \"created_at\" TIMESTAMPTZ DEFAULT now(),   PRIMARY KEY (\"id\"), )<\/code><\/pre>\n<p>\u0418\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043e\u0431\u044a\u044f\u0432\u043b\u0435\u043d\u043d\u0443\u044e \u043c\u043e\u0434\u0435\u043b\u044c, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0433\u0435\u043d\u0435\u0440\u0438\u0440\u043e\u0432\u0430\u0442\u044c select\/insert\/update\/delete \u0437\u0430\u043f\u0440\u043e\u0441\u044b:<\/p>\n<pre><code class=\"go\">model := new(Model) err := db.NewSelect().Model().Where(\"id = ?\", 123).Scan(ctx)  model.ID = 0 res, err := db.NewInsert().Model(model).Exec(ctx)  res, err := db.NewUpdate().     Model(model).     Set(\"name = ?\", \"updated name\").     WherePK().     Exec(ctx)  res, err := db.NewDelete().Model(model).WherePK().Exec(ctx)<\/code><\/pre>\n<p>\u041e\u0431\u0440\u0430\u0449\u0430\u0439\u0442\u0435\u0441\u044c \u043a <a href=\"https:\/\/bun.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">Bun \u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u0438<\/a> \u0437\u0430 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u044f\u043c\u0438.<\/p>\n<h3>Golang ORM<\/h3>\n<p>\u041a\u0430\u043a \u043d\u0430\u0441\u0447\u0435\u0442 \u0447\u0430\u0441\u0442\u0438 \u043f\u0440\u043e <a href=\"https:\/\/bun.uptrace.dev\/guide\/golang-orm.html\" rel=\"noopener noreferrer nofollow\">Golang ORM<\/a>? Bun \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u043e\u0431\u044a\u044f\u0432\u043b\u044f\u0442\u044c \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0435 \u043e\u0442\u043d\u043e\u0448\u0435\u043d\u0438\u044f \u043c\u0435\u0436\u0434\u0443 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f Go \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u044b. \u041a \u043f\u0440\u0438\u043c\u0435\u0440\u0443, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043e\u043f\u0438\u0441\u0430\u0442\u044c <code>Author<\/code> \u043f\u0440\u0438\u043d\u0430\u0434\u043b\u0435\u0436\u0438\u0442 \u043a <code>Book<\/code> \u0442\u0430\u043a\u0438\u043c \u043e\u0431\u0440\u0430\u0437\u043e\u043c:<\/p>\n<pre><code class=\"go\">type Book struct { ID int64 AuthorID int64 Author Author `bun:\"rel:belongs-to,join:author_id=id\"` }  type Author struct { ID int64 }<\/code><\/pre>\n<p>\u0410 \u0437\u0430\u0442\u0435\u043c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <code>Relation<\/code> \u043c\u0435\u0442\u043e\u0434 \u0434\u043b\u044f \u0434\u0436\u043e\u0439\u043d\u0430 \u0442\u0430\u0431\u043b\u0438\u0446\u044b:<\/p>\n<pre><code class=\"go\">err := db.NewSelect(). Model(book). Relation(\"Author\"). Where(\"id = ?\", 123). Scan(ctx)<\/code><\/pre>\n<pre><code class=\"go\">SELECT   \"book\".\"id\", \"book\".\"title\", \"book\".\"text\",   \"author\".\"id\" AS \"author__id\", \"author\".\"name\" AS \"author__name\" FROM \"books\" LEFT JOIN \"users\" AS \"author\" ON \"author\".\"id\" = \"book\".\"author_id\" WHERE id = 1<\/code><\/pre>\n<p>\u0417\u0430 \u043f\u043e\u0434\u0440\u043e\u0431\u043d\u043e\u0441\u0442\u044f\u043c\u0438 \u043e\u0431\u0440\u0430\u0449\u0430\u0439\u0442\u0435\u0441\u044c \u043a <a href=\"https:\/\/bun.uptrace.dev\/guide\/relations.html\" rel=\"noopener noreferrer nofollow\">ORM: Table relationships<\/a>.<\/p>\n<h3>\u0421\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 \u0441 \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445<\/h3>\n<p>Bun \u0440\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u043f\u043e\u0432\u0435\u0440\u0445 database\/sql \u0438 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 PostgreSQL, MySQL\/MariaDB, MSSQL, \u0438 SQLite.<\/p>\n<p>\u0414\u043b\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0441 <a href=\"https:\/\/bun.uptrace.dev\/postgres\/\" rel=\"noopener noreferrer nofollow\">PostgreSQL<\/a> \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n<pre><code class=\"go\">import ( \"github.com\/uptrace\/bun\" \"github.com\/uptrace\/bun\/dialect\/pgdialect\"     \"github.com\/uptrace\/bun\/driver\/pgdriver\" )  dsn := \"postgres:\/\/postgres:@localhost:5432\/test?sslmode=disable\" sqldb := sql.OpenDB(pgdriver.NewConnector(pgdriver.WithDSN(dsn)))  db := bun.NewDB(sqldb, pgdialect.New())<\/code><\/pre>\n<p>\u0414\u043b\u044f \u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u044f \u0441 <a href=\"https:\/\/bun.uptrace.dev\/guide\/drivers.html#mysql\" rel=\"noopener noreferrer nofollow\">MySQL<\/a> \u0431\u0430\u0437\u043e\u0439 \u0434\u0430\u043d\u043d\u044b\u0445:<\/p>\n<pre><code class=\"go\">import ( \"github.com\/uptrace\/bun\" \"github.com\/uptrace\/bun\/dialect\/mysqldialect\" _ \"github.com\/go-sql-driver\/mysql\" )  sqldb, err := sql.Open(\"mysql\", \"root:pass@\/test\") if err != nil { panic(err) }  db := bun.NewDB(sqldb, mysqldialect.New())<\/code><\/pre>\n<p>\u0414\u043b\u044f \u043b\u043e\u0433\u0433\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0432\u0441\u0435\u0445 \u043e\u0431\u0440\u0430\u0431\u043e\u0442\u0430\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u0442\u044c <a href=\"https:\/\/bun.uptrace.dev\/guide\/debugging.html\" rel=\"noopener noreferrer nofollow\">bundebug<\/a> \u043f\u043b\u0430\u0433\u0438\u043d:<\/p>\n<pre><code class=\"go\">import \"github.com\/uptrace\/bun\/extra\/bundebug\"  db.AddQueryHook(bundebug.NewQueryHook( bundebug.WithVerbose(true), \/\/ log everything ))<\/code><\/pre>\n<h3>\u0412\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432<\/h3>\n<p>\u041f\u043e\u0441\u043b\u0435 \u0442\u043e\u0433\u043e \u043a\u0430\u043a \u0432\u044b \u043e\u0431\u044a\u044f\u0432\u0438\u043b\u0438 <a href=\"https:\/\/bun.uptrace.dev\/guide\/models.html\" rel=\"noopener noreferrer nofollow\">\u043c\u043e\u0434\u0435\u043b\u044c<\/a>, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0447\u0438\u043d\u0430\u0442\u044c \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c \u0437\u0430\u043f\u0440\u043e\u0441\u044b:<\/p>\n<pre><code class=\"go\">\/\/ Select a user by a primary key. user := new(User) err := db.NewSelect().Model(user).Where(\"id = ?\", 1).Scan(ctx)  \/\/ Select first 10 users. var users []User err := db.NewSelect().Model(&amp;users).OrderExpr(\"id ASC\").Limit(10).Scan(ctx)<\/code><\/pre>\n<p>\u041a\u043e\u0433\u0434\u0430 \u0440\u0435\u0447\u044c \u0438\u0434\u0435\u0442 \u043e <a href=\"https:\/\/bun.uptrace.dev\/queries.html#scan-and-exec\" rel=\"noopener noreferrer nofollow\">\u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u0438<\/a> \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432, Bun \u043e\u0447\u0435\u043d\u044c \u0433\u0438\u0431\u043e\u043a \u0438 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441\u043e \u0441\u0442\u0440\u0443\u043a\u0442\u0443\u0440\u0430\u043c\u0438:<\/p>\n<pre><code class=\"go\">user := new(User) err := db.NewSelect().Model(user).Limit(1).Scan(ctx)<\/code><\/pre>\n<p>\u0421\u043a\u0430\u043b\u044f\u0440\u0430\u043c\u0438:<\/p>\n<pre><code class=\"go\">var id int64 var name string err := db.NewSelect().Model((*User)(nil)).Column(\"id\", \"name\").Limit(1).Scan(ctx, &amp;id, &amp;name)<\/code><\/pre>\n<p>\u0425\u044d\u0448 \u0442\u0430\u0431\u043b\u0438\u0446\u0430\u043c\u0438 \u0442\u0438\u043f\u0430 <code>map[string]interface{}<\/code>:<\/p>\n<pre><code class=\"go\">var m map[string]interface{} err := db.NewSelect().Model((*User)(nil)).Limit(1).Scan(ctx, &amp;m)<\/code><\/pre>\n<p>\u0418 \u043c\u0430\u0441\u0441\u0438\u0432\u0430\u043c\u0438 \u0432\u0441\u0435\u0445 \u0440\u0430\u043d\u0435\u0435 \u0443\u043f\u043e\u043c\u044f\u043d\u0443\u0442\u044b\u0445 \u0442\u0438\u043f\u043e\u0432:<\/p>\n<pre><code class=\"go\">var users []User err := db.NewSelect().Model(&amp;users).Limit(1).Scan(ctx)  var ids []int64 var names []string err := db.NewSelect().Model((*User)(nil)).Column(\"id\", \"name\").Limit(1).Scan(ctx, &amp;ids, &amp;names)  var ms []map[string]interface{} err := db.NewSelect().Model((*User)(nil)).Scan(ctx, &amp;ms)<\/code><\/pre>\n<p>\u0412\u044b \u0442\u0430\u043a\u0436\u0435 \u043c\u043e\u0436\u0435\u0442\u0435 \u0441\u043a\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u0442\u044c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u044b insert\/update\/delete \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432:<\/p>\n<pre><code class=\"go\">var ids []int64 res, err := db.NewDelete().Model((*User)(nil)).Returning(\"id\").Exec(ctx, &amp;ids)<\/code><\/pre>\n<h3>\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0435\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u0438<\/h3>\n<p>Bun \u0438\u043c\u0435\u0435\u0442 \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e \u043f\u043b\u0430\u0433\u0438\u043d\u043e\u0432 \u0432\u043a\u043b\u044e\u0447\u0430\u044f <a href=\"https:\/\/opentelemetry.uptrace.dev\/\" rel=\"noopener noreferrer nofollow\">OpenTelemetry<\/a> \u0438\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u044e \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0449\u0443\u044e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/distributed-tracing.html\" rel=\"noopener noreferrer nofollow\">distributed tracing<\/a> \u0438 <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/metrics.html\" rel=\"noopener noreferrer nofollow\">\u043c\u0435\u0442\u0440\u0438\u043a\u0438<\/a>.<\/p>\n<p>\u0422\u0440\u044d\u0439\u0441\u0438\u043d\u0433 \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0432\u0430\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u0442\u044c \u043f\u0440\u043e\u0438\u0437\u0432\u043e\u0434\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0411\u0414 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f \u043c\u043d\u043e\u0436\u0435\u0441\u0442\u0432\u043e <a href=\"https:\/\/get.uptrace.dev\/compare\/distributed-tracing-tools.html\" rel=\"noopener noreferrer nofollow\">open source tracing tools<\/a> \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0449\u0438\u0445 OpenTelemetry. \u041c\u043d\u043e\u0433\u0438\u0435 \u043f\u043b\u0430\u0442\u043d\u044b\u0435 <a href=\"https:\/\/get.uptrace.dev\/compare\/datadog-competitors.html\" rel=\"noopener noreferrer nofollow\">DataDog competitors<\/a> \u0442\u0430\u043a\u0436\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u044e\u0442 OpenTelemetry.<\/p>\n<p>\u041a\u0440\u043e\u043c\u0435 \u0442\u043e\u0433\u043e, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u044d\u043a\u0441\u043f\u043e\u0440\u0442\u0438\u0440\u043e\u0432\u0430\u0442\u044c OpenTelemetry \u043c\u0435\u0442\u0440\u0438\u043a\u0438 \u0432 <a href=\"https:\/\/opentelemetry.uptrace.dev\/guide\/opentelemetry-prometheus.html\" rel=\"noopener noreferrer nofollow\">Prometheus<\/a> \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044f <a href=\"https:\/\/get.uptrace.dev\/compare\/grafana-alternatives.html\" rel=\"noopener noreferrer nofollow\">Grafana<\/a> \u0438\u043b\u0438 \u0434\u0440\u0443\u0433\u0438\u0435 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u044b\u0435 \u0430\u043b\u044c\u0442\u0435\u0440\u043d\u0430\u0442\u0438\u0432\u044b.<\/p>\n<h3>\u0427\u0442\u043e \u0434\u0430\u043b\u044c\u0448\u0435<\/h3>\n<p>\u0427\u0442\u043e\u0431\u044b \u043d\u0430\u0447\u0430\u0442\u044c \u0440\u0430\u0431\u043e\u0442\u0430\u0442\u044c \u0441 Bun, \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0439\u0442\u0435 <a href=\"https:\/\/bun.uptrace.dev\/guide\/golang-orm.html\" rel=\"noopener noreferrer nofollow\">\u0434\u043e\u043a\u0443\u043c\u0435\u043d\u0442\u0430\u0446\u0438\u044e<\/a> \u0438 \u0437\u0430\u043f\u0443\u0441\u0442\u0438\u0442\u0435 <a href=\"https:\/\/github.com\/uptrace\/bun\/tree\/master\/example\" rel=\"noopener noreferrer nofollow\">\u043f\u0440\u0438\u043c\u0435\u0440\u044b<\/a> c GitHub.<\/p>\n<p>\u0415\u0441\u043b\u0438 \u0432\u044b \u0443\u0436\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0435 database\/sql, \u0442\u043e \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u043d\u0430\u0447\u0430\u0442\u044c \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c Bun \u043d\u0435 \u0438\u0437\u043c\u0435\u043d\u044f\u044f \u0441\u0443\u0449\u0435\u0441\u0442\u0432\u0443\u044e\u0449\u0438\u0439 \u043a\u043e\u0434. Bun \u0442\u0430\u043a\u0436\u0435 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u0442 Go \u0438 SQL <a href=\"https:\/\/bun.uptrace.dev\/guide\/migrations.html\" rel=\"noopener noreferrer nofollow\">\u043c\u0438\u0433\u0440\u0430\u0446\u0438\u0438<\/a>, fixtures, \u0445\u0443\u043a\u0438, \u0438 \u043c\u043d\u043e\u0433\u043e\u0435 \u0434\u0440\u0443\u0433\u043e\u0435.<\/p>\n<\/p>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"v-portal\" style=\"display:none;\"><\/div>\n<\/div>\n<p> <!----> <!----><br \/> \u0441\u0441\u044b\u043b\u043a\u0430 \u043d\u0430 \u043e\u0440\u0438\u0433\u0438\u043d\u0430\u043b \u0441\u0442\u0430\u0442\u044c\u0438 <a href=\"https:\/\/habr.com\/ru\/post\/663332\/\"> https:\/\/habr.com\/ru\/post\/663332\/<\/a><br \/><\/br><\/br><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-332503","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/332503","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=332503"}],"version-history":[{"count":0,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=\/wp\/v2\/posts\/332503\/revisions"}],"wp:attachment":[{"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=332503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=332503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/savepearlharbor.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=332503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}