-
Notifications
You must be signed in to change notification settings - Fork 0
Keep production db in sync with development db
Tom R edited this page Jun 18, 2020
·
2 revisions
Get data from heroko via durability in database. pg_restore with C:\Program Files\PostgreSQL\12\bin>pg_restore --verbose --clean --no-acl --no-owner -h localhost -U hlwtadmin -d hlwtadmin c:\Users\Tom\Downloads<file>
Data model
- Concert
- Artist
- ConcertAnnouncement
- Country
- Genre
- GigFinder
- GigFinderURL
- Location
- Organisation
- Organisation types model
- Venue
Relations
- Relation Concert - Artist
- Relation Concert - Organisation
- Relation Concert - Concert
- Relation Artist - Artist
- Relation Organisation - Organisation
- Relation Organisation - External Identifier
Semantics
- Organisation types semantics
- Concert - Organisation semantics
- Concert - Artist semantics
- Artist - Artist semantics
- Concert - Concert semantics
- Organisation - Organisation semantics
Merge functionalities
Automation
- Venue to Organisation
- Venue to Location
- Concert Announcement to Concert
- Delete concerts and ignore ConcertAnnouncements
- Delete concerts and delete ConcertAnnouncements
QA Lists and procedures
- Concerts without Organisations
- Concerts without Artists
- Organisations without Concerts
- Concerts with multiple organisations in different locations
- Organisations without latitude and longitude
- Organisations without genre
- Organisations without disambiguation
- Concerts without latitude and longitude
- Concerts without genre
- Concerts without titles
- Artists without genre
- Announcements wo/ concert
- Concerts wo/ announcements
- Venues wo/ organisation
- Organisations wo/ venues
- Organisations without locations
- Organisations without concerts
- Cities without countries
Batch operations
Development