# Quickstart
### Init Project
First, use `go mod init` to initialize the project and add GoooQo by:
```
go get -u github.com/doytowin/goooqo/rdb
```
Then, initialize the database connection and transaction manager as follows:
```go
package main
import (
"database/sql"
"github.com/doytowin/goooqo/rdb"
_ "github.com/mattn/go-sqlite3"
)
func main() {
db := rdb.Connect("app.properties")
defer rdb.Disconnect(db)
tm := rdb.NewTransactionManager(db)
//...
}
```
### Build DataAccess
Suppose we have the following user table in `test.db`:
| id | name | score | memo |
|---|
| 1 | Alley | 80 | Good |
| 2 | Dave | 75 | Well |
| 3 | Bob | 60 | |
| 4 | Tim | 92 | Great |
| 5 | Emy | 100 | Great |
We define an entity object and a query object for the table:
{% code title="user.go" %}
```go
package main
import (
. "github.com/doytowin/goooqo/core"
)
type UserEntity struct {
Int64Id
Name *string `json:"name"`
Score *int `json:"score"`
Memo *string `json:"memo"`
}
func (u UserEntity) GetTableName() string {
return "t_user"
}
type UserQuery struct {
PageQuery
ScoreLt *int
MemoStart *string
// ...
}
```
{% endcode %}
The fields of the entity object correspond to the columns of the table, and the fields of the query object are based on the query conditions of the requirements.
Then we define a `userDataAccess` to access the table:
```go
userDataAccess := rdb.NewTxDataAccess[UserEntity](tm)
userQuery := UserQuery{PageQuery: PageQuery{Page: 5, Size: 10}, ScoreLt: P(80)}
userEntities, err := userDataAccess.Query(ctx, userQuery)
```
This will generate and execute the following SQL:
```sql
SELECT id, name, score, memo FROM t_user WHERE score < ? LIMIT 10 OFFSET 40
```
### Related Documents