/sqlt

Primary LanguageGo

GoDoc

#sqlt

sqlt is a wrapper package for jmoiron/sqlx

this wrapper build based on tsenart/nap master-slave configuration

since this package is just a wrapper, you can use it 100% like sqlx, but with some differences

to connect to database, you need an appended connection string with ; delimeter, but there is some notes:

  • the first connection will always be considered as master connection
  • another connection will be considered as slave
databaseCon := "con1;" + "con2;" + "con3"
db, err := sqlt.Open("postgres", databaseCon)

or

databaseCon := "con1"
db, err := sqlt.Open("postgres", databaseCon)

for a complete sqlx features, you can use this:

err := db.Slave().Query(&struct, query)
err := db.Master().Query(&struct, query)

but if you don't want to state master or slave, you can use it like this:

err := db.Query(&struct, query)

straightforward operation like this is limited and not all features are ported into sqlt

please consider to use either db.Slave or db.Master for complex operations

preapre and statement for sql is now supported

statement := db.Prepare(query)
rows, err := statement.Query(param)
row := statement.QueryRows(param)

3rd party references: