| 59 | } |
| 60 | |
| 61 | func (q *Queries) ListCFDomains(ctx context.Context) ([]ListCFDomainsRow, error) { |
| 62 | rows, err := q.db.Query(ctx, listCFDomains) |
| 63 | if err != nil { |
| 64 | return nil, err |
| 65 | } |
| 66 | defer rows.Close() |
| 67 | items := []ListCFDomainsRow{} |
| 68 | for rows.Next() { |
| 69 | var i ListCFDomainsRow |
| 70 | if err := rows.Scan( |
| 71 | &i.ID, |
| 72 | &i.CfToken, |
| 73 | &i.ZoneID, |
| 74 | &i.ZoneName, |
| 75 | &i.Remark, |
| 76 | ); err != nil { |
| 77 | return nil, err |
| 78 | } |
| 79 | items = append(items, i) |
| 80 | } |
| 81 | if err := rows.Err(); err != nil { |
| 82 | return nil, err |
| 83 | } |
| 84 | return items, nil |
| 85 | } |
| 86 | |
| 87 | const upsertCFDomain = `-- name: UpsertCFDomain :exec |
| 88 | INSERT INTO cf_domains (id, cf_token, zone_id, zone_name, remark) |