# gsql

**Repository Path**: 2you/gsql

## Basic Information

- **Project Name**: gsql
- **Description**: No description available
- **Primary Language**: Go
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-02-16
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

gsql
======
------
example

```golang
dbx, _ := gsql.New(`sqlite3`, `db00.sqlite`)
qry0 := dbx.NewQuery()
qry0.SetSQL(`SELECT * FROM t00`)
qry0.Open()
for qry0.Next() {
    for id := 0; id < qry0.FieldCount(); id++ {
        s0 := fmt.Sprintln(qry0.FieldById(id).AsString())
        log.Printf("[%d] %s", id, s0)
    }
}
//query row
qry0.GetOne()
for id := 0; id < qry0.FieldCount(); id++ {
    s0 := fmt.Sprintln(qry0.FieldById(id).AsString())
    log.Printf("[%d] %s", id, s0)
}
qry0.Close()

//use prepare
qry1 := dbx.NewQuery(true)
qry1.SetSQL(`SELECT * FROM t00 WHERE c00=?`)
qry1.GetOne(1)
qry1.GetOne(2)
```