Mercurial > gemma
changeset 138:c79709af2c76
Demo Data: make user.sql atomic and use copy everywhere.
| author | Sascha Wilde <wilde@intevation.de> |
|---|---|
| date | Fri, 29 Jun 2018 17:24:14 +0200 |
| parents | 433a992befdb |
| children | 6eeaf9682c78 |
| files | schema/demo-data/users.sql |
| diffstat | 1 files changed, 11 insertions(+), 7 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/demo-data/users.sql Fri Jun 29 17:15:17 2018 +0200 +++ b/schema/demo-data/users.sql Fri Jun 29 17:24:14 2018 +0200 @@ -1,3 +1,5 @@ +BEGIN; + -- PREREQUISITES -- Setup Country Codes @@ -24,10 +26,12 @@ CREATE ROLE vanja IN ROLE waterway_user LOGIN PASSWORD 'va2Nja3'; -- Fill in Profiles -INSERT INTO gemma.user_profiles (username, country, email_adress) - VALUES - ('sophie', 'AT', 'sophie@example.com'), - ('lucian', 'RO', 'lucian@example.com'), - ('oana', 'RO', 'oana@example.com'), - ('penka', 'BG', 'penka@example.com'), - ('vanja', 'BG', 'vanja@example.com'); +COPY gemma.user_profiles (username, country, email_adress) FROM stdin; +sophie AT sophie@example.com +lucian RO lucian@example.com +oana RO oana@example.com +penka BG penka@example.com +vanja BG vanja@example.com +\. + +COMMIT;