Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
- API
  
  Reference documentation for the pkg.go.dev API
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

zdpgo_postgres

package module

Go to main page

Versions in this module

v1

v1.0.3

Dec 24, 2021

Changes in this version

type Postgres

+ func (p *Postgres) Add(sql string, args ...interface{}) (affected int64)

+ func (p *Postgres) Delete(table string, id int) (flag bool)

+ func (p *Postgres) DeleteIds(table string, ids ...int) (flag bool)

+ func (p *Postgres) FindIds(table string, columns []string, ids []int) (rows pgx.Rows)

+ func (p *Postgres) FindPages(table string, columns []string, page, size int) (rows pgx.Rows)

+ func (p *Postgres) Query(sql string, args ...interface{}) pgx.Row

+ func (p *Postgres) QueryMany(sql string, args ...interface{}) (rows pgx.Rows, err error)

+ func (p *Postgres) Update(sql string, args ...interface{}) (flag bool)

v1.0.2

Dec 24, 2021

Changes in this version

+ type CrudSql interface

+ Add func(sql string, args ...interface{}) int64

+ Delete func(table string, id int) bool

+ DeleteIds func(table string, ids ...int) bool

+ Find func(table string, columns []string, id int) *sql.Row

+ FindIds func(table string, columns []string, ids []int) *sql.Rows

+ FindPages func(table string, columns []string, page, size int) *sql.Rows

+ Update func(sql string, args ...interface{}) bool

+ type Postgres struct

+ func New(host string, port int, user, password, database, logPath string, debug bool) *Postgres

+ func (p *Postgres) Execute(sql string, args ...interface{}) int64

+ func (p *Postgres) Find(sql string, args ...interface{}) pgx.Row

+ func (p *Postgres) FindMany(sql string, args ...interface{}) (rows pgx.Rows, err error)

+ func (p *Postgres) SetDebug(debug bool)

+ func (p *Postgres) SetLogPath(logPath string)

v1.0.0

Dec 6, 2021

Changes in this version

+ func GetDB(host string, port int, user, password, database string) (*sql.DB, error)