/
githubmirror
/
goose
Обзор
Документация
Войти
/
githubmirror
/
goose
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
testdata/no-versioning/seed/00002_b.sql
15 строк
409 B
Michael Fridman
feat: Add goose provider (#635)
09 ноя 2023, 17:23
Не верифицирован
09 ноя 2023, 17:23
04e12b8
Код
Авторство
О чём код?
-- +goose Up -- Insert 150 more owners. INSERT INTO owners (owner_name) WITH numbers AS ( SELECT 101 AS n UNION ALL SELECT n + 1 FROM numbers WHERE n < 250 ) SELECT 'seed-user-' || n FROM numbers; -- +goose Down -- NOTE: there are 4 migration owners and 100 seed owners, that's why owner_id starts at 105 DELETE FROM owners WHERE owner_name LIKE 'seed-user-%' AND owner_id BETWEEN 105 AND 254;