Go (golang)的 Firebird RDBMS SQL驱动程序

Go (golang)的 Firebird RDBMS SQL驱动程序

firebirdsql (Go firebird sql driver)

Firebird RDBMS http://firebirdsql.org SQL driver for Go

Requirements

Firebird 2.5 or higherGolang 1.7 or higher

Modules get (go version < 1.11)

$ go get github.com/cznic/mathutil$ go get github.com/kardianos/osext$ go get github.com/shopspring/decimal$ go get github.com/nakagami/firebirdsql$ go get gitlab.com/nyarla/go-crypt

Example

package mainimport ( "fmt" "database/sql" _ "github.com/nakagami/firebirdsql")func main() { var n int conn, _ := sql.Open("firebirdsql", "user:password@servername/foo/bar.fdb") defer conn.Close() conn.QueryRow("SELECT Count(*) FROM rdb$relations").Scan(&n) fmt.Println("Relations count=", n)}

See also driver_test.go

package main import ( "fmt" "github.com/nakagami/firebirdsql")func main() { dsn := "user:password@servername/foo/bar.fdb" events := []string{"my_event", "order_created"} fbEvent, _ := firebirdsql.NewFBEvent(dsn) defer fbEvent.Close() sbr, _ := fbEvent.Subscribe(events, func(event firebirdsql.Event) { //or use SubscribeChan fmt.Printf("event: %s, count: %d, id: %d, remote id:%d \n", event.Name, event.Count, event.ID, event.RemoteID) }) defer sbr.Unsubscribe() go func() { fbEvent.PostEvent(events[0]) fbEvent.PostEvent(events[1]) }() <- make(chan struct{}) //wait}

See also _example

Connection string

user:password@servername[:port_number]/database_name_or_file[?params1=value1[¶m2=value2]...]

General

user: login userpassword: login passwordservername: Firebird server's host name or IP address.port_number: Port number. default value is 3050.database_name_or_file: Database path (or alias name).

Optional

param1, param2... are

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。