Golang database/sql.Stmt.Exec function examples

package database/sql

Exec executes a prepared statement with the given arguments and returns a Result summarizing the effect of the statement.

Golang database/sql.Stmt.Exec function usage examples

Example 1:

 var queries = [...]struct {
  in string
  codes []string
 }{
  {"DROP TABLE IF EXISTS no_such_table", []string{"1051"}},
  {"INSERT INTO test VALUES(10,'mysql'),(NULL,'test'),(300,'Open Source')", []string{"1265", "1048", "1264", "1265"}},
 }

 var stmt *sql.Stmt
 var err error

 for i := range queries {
 stmt, err = dbt.db.Prepare(queries[i].in)
  if err != nil {
 dbt.Errorf("Error on preparing query %s: %s", queries[i].in, err.Error())
  }
  _, err = stmt.Exec()
 ...

Example 2:

 var params ...interface{}
 var sql string

 stmt, err := this.connection.Prepare(sql)
 if err != nil {
 fmt.Println(err)
 os.Exit(1)
 }

 result, err := stmt.Exec(params...) // <---- here
 if err != nil {
 fmt.Println(err)
 os.Exit(1)
 stmt.Close()
 }

References :

https://github.com/go-sql-driver/mysql/blob/master/driver_test.go

http://golang.org/pkg/database/sql/#Stmt.Exec

Advertisement

Something interesting

Tutorials