Golang ScanAll Examples

Example #1

File: event.go Project: cwc/asset-tracker

func GetEventsByUserId(db *sql.DB, offset int, userId int64) (events []Event, err error) {
	rows, err := db.Query("SELECT * FROM events WHERE event_user = $2 LIMIT 50 OFFSET $1", offset, userId)
	if err != nil {
		return
	}

	err = crud.ScanAll(rows, &events)

	return
}

Example #2

File: user.go Project: cwc/asset-tracker

func GetUsers(db *sql.DB, offset int) (users []User, err error) {
	rows, err := db.Query("SELECT * FROM users LIMIT 50 OFFSET $1", offset)
	if err != nil {
		return
	}

	err = crud.ScanAll(rows, &users)

	return
}

Example #3

File: asset.go Project: cwc/asset-tracker

func GetAssets(db *sql.DB, offset int) (assets []Asset, err error) {
	rows, err := db.Query("SELECT * FROM assets LIMIT 50 OFFSET $1", offset)
	if err != nil {
		return
	}

	err = crud.ScanAll(rows, &assets)

	return
}