SqlReader

Are writing like this:

err := db.Exec("SELECT * FROM some_table")

or like this?

const FleetUpdateStatus = `
  UPDATE fleets
  SET status = 3
  WHERE id = ?
`

err := db.Exec(FleetUpdateStatus)

I don't like writing sql statements in code. It has many disadvantages: no syntax-highliting, no auto-complete, etc. This little library helps you to use *.sql files instead of const strings

Install

go get "github.com/ndrewnee/sqlreader"

Usage

Import the package:

import (
	"github.com/ndrewnee/sqlreader"
)

Example

// First param is path with sqls
// Then names of sqls that are required (Optional)
sqls, err := sqlreader.New("path-with-sqls", "required_sql")
if err != nil {
  panic(err)
}

sql := sqls.Get("required_sql")
db.Exec(sql)

For more examples have a look at sqlreader_test.go

Running tests:

go test "github.com/ndrewnee/sqlreader"

License

MIT (see LICENSE file)