Go database operations

The following go/golang snippet:

connect to a MS-SQL database via ODBC;
INSERTs a new record into a table;
disconnects from the database.

package main

import _ "github.com/denisenkom/go-mssqldb" // SQL Server driver
import "database/sql"
import "fmt"
import "time"

var insertReadingsSql = `
  INSERT INTO <TABLE_NAME> (<STR_COLUMN>, <TIMESTAMP_COLUMN>, <NUMERIC_COLUMN>)
    VALUES ('%s', '%s', %f);`

func main() {
  // `log=63` parameter is to make the SQL connector verbose while executing SQL statements
  odbcStr := "server=<SERVER_URL>;user id=<USERNAME>;password=<PSW>;database=<DB_NAME>;log=63"
  rawDB, connStrError := sql.Open("mssql", odbcStr)
  if connStrError != nil {
    rawDB.Close()
    panic(connStrError)
  }

  sqlStr = fmt.Sprintf(insertReadingsSql, "foo", time.Now().Format(time.RFC3339Nano), 42.0)

  _, err := rawDB.Exec(sqlStr)
  if err != nil {
    rawDB.Close()
    panic(err)
  }

  rawDB.Close()
}

tappoz/go-code-snippets.md

Go database operations