Golang database/sql.DB.Prepare function example
package database/sql
Prepare creates a prepared statement for later queries or executions. Multiple queries or executions may be run concurrently from the returned statement.
Golang database/sql.DB.Prepare function usage example
func (db *Config) prebuild() (err error) {
queries := []string{
`CREATE TABLE IF NOT EXISTS rules (
id BIGINT NOT NULL AUTO_INCREMENT,
host VARCHAR(128) NOT NULL DEFAULT '',
json TEXT NOT NULL,
updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
UNIQUE KEY (host)
)`,
}
for _, query := range queries {
if _, err = db.db.Exec(query); err != nil {
return
}
}
// Prepared statements for storage
if db.stmt.Check, err = db.db.Prepare(`SELECT COUNT(*) FROM rules WHERE updated > ?`); err != nil {
return
}
if db.stmt.Rules, err = db.db.Prepare(`SELECT host, json FROM rules`); err != nil {
return
}
return
}
Reference :
Advertisement
Something interesting
Tutorials
+16.3k Golang : Loop each day of the current month example
+7.4k Golang : Accessing dataframe-go element by row, column and name example
+4.7k Javascript : Access JSON data example
+3.6k Java : Get FX sentiment from website example
+11.1k Golang : Roll the dice example
+7.4k Golang : Example of custom handler for Gorilla's Path usage.
+18.6k Golang : Get download file size
+16.7k Golang : Gzip file example
+28.6k Get file path of temporary file in Go
+6.9k Nginx : Password protect a directory/folder
+10.3k Golang : Embed secret text string into binary(executable) file