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
+15.9k Golang : Update database with GORM example
+3.7k Golang : Switch Redis database redis.NewClient
+13.3k Golang : Date and Time formatting
+5.6k Golang : Detect words using using consecutive letters in a given string
+7.7k Golang : Generate human readable password
+14.4k Golang : How to convert a number to words
+10.9k Golang : How to transmit update file to client by HTTP request example
+12.5k Golang : "https://" not allowed in import path
+26.4k Golang : Convert(cast) string to uint8 type and back to string
+26.8k Golang : Find files by extension
+17.8k Golang : Defer function inside init()
+21.1k Golang : For loop continue,break and range