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
+23.2k Golang : Print out struct values in string format
+16.4k CodeIgniter/PHP : Create directory if does not exist example
+23k Golang : Calculate time different
+17.6k Golang : Parse date string and convert to dd-mm-yyyy format
+14.9k Golang : Basic authentication with .htpasswd file
+13.5k Golang : Read XML elements data with xml.CharData example
+7.9k Swift : Convert (cast) String to Float
+15.6k Golang : ROT47 (Caesar cipher by 47 characters) example
+7.1k Golang : Validate credit card example
+12k Golang : Find and draw contours with OpenCV example
+8.2k Golang : Find relative luminance or color brightness
+6.5k Golang : Combine slices of complex numbers and operation example