golang sqlx catch errors-Golang-php.cn

Home

Backend Development

Golang

golang sqlx catch errors

(*-*)浩

Dec 14, 2019 am 11:57 AM

golang

golang sqlx catch errors

sqlxThis third-party library is indeed much more fun to use. Here are the learning and usage experiences

Installation:

Use commands (Recommended learning: Go )

go get github.com/jmoiron/sqlx

## Introduction:

The general idea is that sqlx is an extension of golang's standard database/sql. The interface using sqlx is no different from the original interface method, but has the following extensions:

1. Row records can be mapped such as struct (embedded struct Also supported), map and slices 2. Supports the use of named parameters in prepared statements, and adds many extensions to the built-in database/sql package. Simplify the writing of database operation code.

3. Get and Select query results to struct/slice are faster

sqlx has also added many interfaces to facilitate developers to use, which will be discussed later.

package main
 
import (
	"database/sql"
	_"github.com/go-sql-driver/mysql"
	"github.com/jmoiron/sqlx"
	"log"
	"fmt"
)
 
type Student struct {
	Id         int    `db:"id"`
	Name       string `db:"name"`
	Nick       string `db:"nick"`
	Country    string `db:"country"`
	Province   string `db:"province"`
	City       string `db:"city"`
	ImgUrl     string `db:"img_url"`
	Status     int    `db:"status"`
	CreateTime string `db:"create_time"`
}
 
func main()  {
	dns := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8", dbuser, dbpwd, dbhost, dbname)
	db, err := sqlx.Connect("mysql", dns)
	if err != nil {
        log.Fatalln(err)
	}
	defer db.Close()
 
	tx := db.MustBegin()
	tx.MustExec(`INSERT INTO student VALUES (&#39;1&#39;, &#39;Jack&#39;, &#39;Jack&#39;, &#39;England&#39;, &#39;&#39;, &#39;&#39;, &#39;http://img2.imgtn.bdimg.com/it/u=3588772980,2454248748&fm=27&gp=0.jpg&#39;, &#39;1&#39;, &#39;2018-06-26 17:08:35&#39;);`)
	tx.MustExec(`INSERT INTO student VALUES (&#39;2&#39;, &#39;Emily&#39;, &#39;Emily&#39;, &#39;England&#39;, &#39;&#39;, &#39;&#39;, &#39;http://img2.imgtn.bdimg.com/it/u=3588772980,2454248748&fm=27&gp=0.jpg&#39;, &#39;2&#39;, null);`)
	err = tx.Commit()
	if err != nil {
		log.Fatalln(err)
	}
 
}

The above is the detailed content of golang sqlx catch errors. For more information, please follow other related articles on the PHP Chinese website!

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Golang vs. C : Code Examples and Performance AnalysisApr 15, 2025 am 12:03 AM

Golang is suitable for rapid development and concurrent programming, while C is more suitable for projects that require extreme performance and underlying control. 1) Golang's concurrency model simplifies concurrency programming through goroutine and channel. 2) C's template programming provides generic code and performance optimization. 3) Golang's garbage collection is convenient but may affect performance. C's memory management is complex but the control is fine.

Golang's Impact: Speed, Efficiency, and SimplicityApr 14, 2025 am 12:11 AM

Goimpactsdevelopmentpositivelythroughspeed,efficiency,andsimplicity.1)Speed:Gocompilesquicklyandrunsefficiently,idealforlargeprojects.2)Efficiency:Itscomprehensivestandardlibraryreducesexternaldependencies,enhancingdevelopmentefficiency.3)Simplicity:

C and Golang: When Performance is CrucialApr 13, 2025 am 12:11 AM

C is more suitable for scenarios where direct control of hardware resources and high performance optimization is required, while Golang is more suitable for scenarios where rapid development and high concurrency processing are required. 1.C's advantage lies in its close to hardware characteristics and high optimization capabilities, which are suitable for high-performance needs such as game development. 2.Golang's advantage lies in its concise syntax and natural concurrency support, which is suitable for high concurrency service development.

Golang in Action: Real-World Examples and ApplicationsApr 12, 2025 am 12:11 AM

Golang excels in practical applications and is known for its simplicity, efficiency and concurrency. 1) Concurrent programming is implemented through Goroutines and Channels, 2) Flexible code is written using interfaces and polymorphisms, 3) Simplify network programming with net/http packages, 4) Build efficient concurrent crawlers, 5) Debugging and optimizing through tools and best practices.

Golang: The Go Programming Language ExplainedApr 10, 2025 am 11:18 AM

The core features of Go include garbage collection, static linking and concurrency support. 1. The concurrency model of Go language realizes efficient concurrent programming through goroutine and channel. 2. Interfaces and polymorphisms are implemented through interface methods, so that different types can be processed in a unified manner. 3. The basic usage demonstrates the efficiency of function definition and call. 4. In advanced usage, slices provide powerful functions of dynamic resizing. 5. Common errors such as race conditions can be detected and resolved through getest-race. 6. Performance optimization Reuse objects through sync.Pool to reduce garbage collection pressure.

Golang's Purpose: Building Efficient and Scalable SystemsApr 09, 2025 pm 05:17 PM

Go language performs well in building efficient and scalable systems. Its advantages include: 1. High performance: compiled into machine code, fast running speed; 2. Concurrent programming: simplify multitasking through goroutines and channels; 3. Simplicity: concise syntax, reducing learning and maintenance costs; 4. Cross-platform: supports cross-platform compilation, easy deployment.

Why do the results of ORDER BY statements in SQL sorting sometimes seem random?Apr 02, 2025 pm 05:24 PM

Confused about the sorting of SQL query results. In the process of learning SQL, you often encounter some confusing problems. Recently, the author is reading "MICK-SQL Basics"...

Is technology stack convergence just a process of technology stack selection?Apr 02, 2025 pm 05:21 PM

The relationship between technology stack convergence and technology selection In software development, the selection and management of technology stacks are a very critical issue. Recently, some readers have proposed...

See all articles