| 22 | } |
| 23 | |
| 24 | func Prepare(ctx context.Context, db DBTX) (*Queries, error) { |
| 25 | q := Queries{db: db} |
| 26 | var err error |
| 27 | if q.createCityStmt, err = db.PrepareContext(ctx, createCity); err != nil { |
| 28 | return nil, fmt.Errorf("error preparing query CreateCity: %w", err) |
| 29 | } |
| 30 | if q.createVenueStmt, err = db.PrepareContext(ctx, createVenue); err != nil { |
| 31 | return nil, fmt.Errorf("error preparing query CreateVenue: %w", err) |
| 32 | } |
| 33 | if q.deleteVenueStmt, err = db.PrepareContext(ctx, deleteVenue); err != nil { |
| 34 | return nil, fmt.Errorf("error preparing query DeleteVenue: %w", err) |
| 35 | } |
| 36 | if q.getCityStmt, err = db.PrepareContext(ctx, getCity); err != nil { |
| 37 | return nil, fmt.Errorf("error preparing query GetCity: %w", err) |
| 38 | } |
| 39 | if q.getVenueStmt, err = db.PrepareContext(ctx, getVenue); err != nil { |
| 40 | return nil, fmt.Errorf("error preparing query GetVenue: %w", err) |
| 41 | } |
| 42 | if q.listCitiesStmt, err = db.PrepareContext(ctx, listCities); err != nil { |
| 43 | return nil, fmt.Errorf("error preparing query ListCities: %w", err) |
| 44 | } |
| 45 | if q.listVenuesStmt, err = db.PrepareContext(ctx, listVenues); err != nil { |
| 46 | return nil, fmt.Errorf("error preparing query ListVenues: %w", err) |
| 47 | } |
| 48 | if q.updateCityNameStmt, err = db.PrepareContext(ctx, updateCityName); err != nil { |
| 49 | return nil, fmt.Errorf("error preparing query UpdateCityName: %w", err) |
| 50 | } |
| 51 | if q.updateVenueNameStmt, err = db.PrepareContext(ctx, updateVenueName); err != nil { |
| 52 | return nil, fmt.Errorf("error preparing query UpdateVenueName: %w", err) |
| 53 | } |
| 54 | if q.venueCountByCityStmt, err = db.PrepareContext(ctx, venueCountByCity); err != nil { |
| 55 | return nil, fmt.Errorf("error preparing query VenueCountByCity: %w", err) |
| 56 | } |
| 57 | return &q, nil |
| 58 | } |
| 59 | |
| 60 | func (q *Queries) Close() error { |
| 61 | var err error |