Golang database/sql.Prepare function examples
package database/sql
Prepare creates a prepared statement for use within a transaction.
The returned statement operates within the transaction and can no longer be used once the transaction has been committed or rolled back.
To use an existing prepared statement on this transaction, see Tx.Stmt.
Golang database/sql.Prepare function usage examples
Example 1:
createCategory = "INSERT INTO BlogCategories (name,slug,active) VALUES (?,?,?)"
func (c *Category) Create() error {
db, err := sql.Open("mysql", database.ConnectionString())
if err != nil {
return err
}
defer db.Close()
tx, err := db.Begin()
if err != nil {
return err
}
stmt, err := tx.Prepare(createCategory)
res, err := stmt.Exec(c.Name, c.Slug, c.Active)
if err != nil {
tx.Rollback()
return err
}
id, err := res.LastInsertId()
c.ID = int(id)
if err != nil {
tx.Rollback()
return err
}
tx.Commit()
return nil
}
Example 2:
stmt, err := tx.Prepare(`insert or replace into plusplus (nick, score) values (?, ?)`)
if err != nil {
fmt.Printf("Database error: %v\n", err)
return
}
Reference :
Advertisement
Something interesting
Tutorials
+15.3k Golang : Delete certain files in a directory
+11.2k Golang : Calculate Relative Strength Index(RSI) example
+29.5k Golang : Login(Authenticate) with Facebook example
+30.5k Get client IP Address in Go
+5k Golang : Calculate a pip value and distance to target profit example
+8.6k Python : Fix SyntaxError: Non-ASCII character in file, but no encoding declared
+6k Javascript : Get operating system and browser information
+8.3k Useful methods to access blocked websites
+11.5k Golang : Change date format to yyyy-mm-dd
+10.5k Golang : Generate 403 Forbidden to protect a page or prevent indexing by search engine
+8.1k Golang : Multiplexer with net/http and map
+25.3k Golang : Convert uint value to string type