Giter Club home page Giter Club logo

go_mysql_tools's Introduction

go_mysql_tools

common db operation patterns (esp. for mysql)

Sample Usage

  import gmtools "github.com/tt7/go_mysql_tools"
  
  dbcfg, err := gmtools.ReadConfigFromJsonFile(configFilename)
  if err!= nil{
    /* ... */
  }
  
  err = gmtools.UseDb(dbcfg, func(db *sql.DB) error {
    if err:=doSomething(); err != nil{
      return err
    }
    return nil
  })
  /* process err ... */
  
  //query
  err = gmtools.QueryDb(db,
    "select a,b,c,d from `sometable` where a=? or b=?",
    []interface{}{1, 2},
    func(rowno int, rows *sql.Rows) error{
      var a,b,c,d int
      err := rows.Scan(&a, &b, &c, &d)
      /* ... */
      return nil  
  })
  
  // transaction
  err = gmtools.InTxWithDB(db, []func(tx *sql.Tx) error {
    func(tx *sql.Tx) error{
      /* do some thing first */
    },
    func(tx *sql.Tx) error{
      /* do some other things */
    }})

go_mysql_tools's People

Contributors

tt7 avatar

Watchers

 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.