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
+10k CodeIgniter : Load different view for mobile devices
+5.4k Gogland : Datasource explorer
+6k Golang : How to verify input is rune?
+8.2k How to show different content from website server when AdBlock is detected?
+29.5k Golang : Login(Authenticate) with Facebook example
+10.6k RPM : error: db3 error(-30974) from dbenv->failchk: DB_RUNRECOVERY: Fatal error, run database recovery
+12.2k Golang : Get remaining text such as id or filename after last segment in URL path
+6k Linux/MacOSX : Search for files by filename and extension with find command
+6.3k Golang : Test input string for unicode example
+8.9k Golang : GMail API create and send draft with simple upload attachment example
+8.9k Golang : What is the default port number for connecting to MySQL/MariaDB database ?