Golang Time Examples

Example #1

File: native_test.go Project: bhuvan/go-sql-test

func TestDate(t *testing.T) {
	myConnect(t, true, 0)
	query("drop table D") // Drop test table if exists
	checkResult(t,
		query("create table D (id int, dd date, dt datetime, tt time)"),
		cmdOK(0, false, true),
	)

	dd := "2011-12-13"
	dt := "2010-12-12 11:24:00"
	tt := -mysql.Time((124*3600+4*3600+3*60+2)*1e9 + 1)

	ins, err := my.Prepare("insert D values (?, ?, ?, ?)")
	checkErr(t, err, nil)

	sel, err := my.Prepare("select id, tt from D where dd <= ? && dt <= ?")
	checkErr(t, err, nil)

	_, err = ins.Run(1, dd, dt, tt)
	checkErr(t, err, nil)

	rows, _, err := sel.Exec(mysql.StrToDatetime(dd), mysql.StrToDate(dd))
	checkErr(t, err, nil)
	if rows == nil {
		t.Fatal("nil result")
	}
	if rows[0].Int(0) != 1 {
		t.Fatal("Bad id", rows[0].Int(1))
	}
	if rows[0][1].(mysql.Time) != tt+1 {
		t.Fatal("Bad tt", rows[0][1].(mysql.Time))
	}

	checkResult(t, query("drop table D"), cmdOK(0, false, true))
	myClose(t)
}

Example #2

File: bind_test.go Project: bhuvan/go-sql-test

import (
	"bytes"
	"github.com/ziutek/mymysql/mysql"
	"math"
	"reflect"
	"testing"
)

var (
	Bytes  = []byte("Ala ma Kota!")
	String = "ssss" //"A kot ma Alę!"
	blob   = mysql.Blob{1, 2, 3}
	dateT  = mysql.Datetime{Year: 2010, Month: 12, Day: 30, Hour: 17, Minute: 21}
	tstamp = mysql.Timestamp{Year: 2001, Month: 2, Day: 3, Hour: 7, Minute: 2}
	date   = mysql.Date{Year: 2011, Month: 2, Day: 3}
	tim    = -mysql.Time((5*24*3600+4*3600+3*60+2)*1e9 + 1)

	pBytes  *[]byte
	pString *string
	pBlob   *mysql.Blob
	pDateT  *mysql.Datetime
	pTstamp *mysql.Timestamp
	pDate   *mysql.Date
	pTim    *mysql.Time

	raw = mysql.Raw{MYSQL_TYPE_INT24, &[]byte{3, 2, 1}}

	Int8   = int8(1)
	Uint8  = uint8(2)
	Int16  = int16(3)
	Uint16 = uint16(4)