本文整理汇总了Golang中code/google/com/p/go-sqlite/go1/sqlite3.Conn.Exec方法的典型用法代码示例。如果您正苦于以下问题:Golang Conn.Exec方法的具体用法?Golang Conn.Exec怎么用?Golang Conn.Exec使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类code/google/com/p/go-sqlite/go1/sqlite3.Conn
的用法示例。
在下文中一共展示了Conn.Exec方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Golang代码示例。
示例1: notifyNewCache
func notifyNewCache(db *sqlite3.Conn, cacheUrl, title string, settings SettingsObject) {
if sendPush(title, cacheUrl, settings) {
sql := fmt.Sprintf("INSERT INTO notifications (url, title, userid) VALUES ('%s', '%s', '%s');", cacheUrl, title, settings.GeocachingUserId)
db.Exec(sql)
}
}
示例2: Finish
// Finish should be called for a cyclus database after all walkers have
// completed processing inventory data. It creates final indexes and other
// finishing tasks.
func Finish(conn *sqlite3.Conn) (err error) {
fmt.Println("Creating inventory indexes...")
for _, sql := range postExecStmts {
if err := conn.Exec(sql); err != nil {
return err
}
}
return nil
}
示例3: Prepare
// Prepare creates necessary indexes and tables required for efficient
// calculation of cyclus simulation inventory information. Should be called
// once before walking begins.
func Prepare(conn *sqlite3.Conn) (err error) {
fmt.Println("Creating indexes and inventory table...")
for _, sql := range preExecStmts {
if err := conn.Exec(sql); err != nil {
fmt.Println(" ", err)
}
}
return nil
}
示例4: createDatabaseSchema
func createDatabaseSchema(db *sqlite3.Conn) {
query := "SELECT name FROM sqlite_master WHERE type='table' AND name='notifications';"
_, err := db.Query(query)
if err != nil {
db.Exec("CREATE TABLE notifications (id INTEGER PRIMARY KEY AUTOINCREMENT, userid VARCHAR(36), url VARCHAR(256), title VARCHAR(256));")
}
}
示例5: InsertSessionActivity
// InsertSessionActivity blah
func InsertSessionActivity(conn *sqlite.Conn, personID int) (err error) {
args := sqlite.NamedArgs{
"$personId": personID,
}
err = conn.Exec(
`INSERT OR IGNORE INTO mem.sessionActivity (personId)
VALUES($personId);
`, args)
return
}
示例6: InsertPerson
// InsertPerson blah
func InsertPerson(conn *sqlite.Conn, id int, name string) (err error) {
args := sqlite.NamedArgs{
"$id": id,
"$name": name,
}
err = conn.Exec(
`INSERT OR IGNORE INTO main.person (id, name)
VALUES($id, $name);
`, args)
return
}