func LoadClients(limit, offset int, sort map[string]int) (clients []*models.Client, err error) {
if limit < 1 {
limit = 1
}
if offset < 0 {
offset = 0
}
var orders []string
for k, v := range sort {
if inArray(k, clients_sortable_fields) {
var o string
if v == ASCENDING {
o = "ASC"
} else {
o = "DESC"
}
orders = append(orders, k+" "+o)
}
}
str := `SELECT id, name, code, secret, redirect_uri, created
, allowed_grant_types, allowed_response_types, allowed_scopes
FROM oauth_client `
if len(orders) > 0 {
str = str + " ORDER BY " + strings.Join(orders, ",")
}
str = fmt.Sprintf("%s LIMIT %d OFFSET %d", str, limit, offset)
clients = make([]*models.Client, 0)
qs := func(db *sql.DB) error {
rows, err := db.Query(str)
if err != nil {
log.Printf("db query error: %s for sql %s", err, str)
return err
}
defer rows.Close()
for rows.Next() {
c := new(models.Client)
var (
grandTypes, responseTypes, scopes string
)
err = rows.Scan(&c.Id, &c.Name, &c.Code, &c.Secret, &c.RedirectUri, &c.CreatedAt,
&grandTypes, &responseTypes, &scopes)
if err != nil {
log.Printf("rows scan error: %s", err)
continue
}
c.AllowedGrantTypes = strings.Split(grandTypes, ",")
c.AllowedResponseTypes = strings.Split(responseTypes, ",")
c.AllowedScopes = strings.Split(scopes, ",")
clients = append(clients, c)
}
return rows.Err()
}
if err := withDbQuery(qs); err != nil {
return nil, err
}
return clients, nil
}
