sql

SQL

One sql service for fns.

Features

• Global transaction
• Proxy
• Support master slaver kind
• Support cluster kind

Install

go get github.com/aacfactory/fns-contrib/databases/sql

Usage

Config

• Standalone type
  • masterSlaverMode = false
  • dsn size is one
• Master slaver type
  • masterSlaverMode = true
  • first of dsn is master, afters are slavers
• Cluster type
  • masterSlaverMode = false
  • all in dsn is members

Example:

sql:
  masterSlaverMode: false,
  driver: "postgres",
  dsn:
    - "username:password@tcp(ip:port)/databases"
  maxIdles: 0
  maxOpens: 0
  enableDebugLog: true
  gtmCleanUpSecond: 120
  isolation: 2
  dialect: "postgres"

Import driver

import _ "github.com/go-sql-driver/mysql"

Deploy

app.Deply(sql.Service())

Proxy usage

See proxy.go

// begin transaction 
sql.BeginTransaction(ctx)
// commit transaction
sql.CommitTransaction(ctx)
// query
sql.Query(ctx, querySQL, ...)
// execute
sql.Execute(ctx, executeSQL, ...)

ORM usage

• database access layer

Multi database source

use multi database service to implements

Config:

postgres1:
  masterSlaverMode: false,
  driver: "postgres",
  dsn:
    - "username:password@tcp(ip:port)/databases"

mysql1:
  masterSlaverMode: false,
  driver: "mysql",
  dsn:
    - "username:password@tcp(ip:port)/databases"

Deploy:

app.Deploy(sql.Service(sql.Name("postgres1")))
app.Deploy(sql.Service(sql.Name("mysql1")))

Proxy

sql.Query(sql.WithOptions(ctx, sql.Database("postgres1")), querySQL, ...)
sql.Query(sql.WithOptions(ctx, sql.Database("mysql1")), querySQL, ...)