customizing service in starter kit derived projects about subzero-cli HOT 10 CLOSED

template1=# GRANT ALL PRIVILEGES ON DATABASE app to rkoberg;
GRANT

$ pg_dump -c --if-exists  -f app.ddl -h 0.0.0.0 -p 5432 -U rkoberg -d app
Password: 
pg_dump: [archiver (db)] query failed: ERROR:  permission denied for schema settings
pg_dump: [archiver (db)] query was: LOCK TABLE settings.secrets IN ACCESS SHARE MODE

template1=# \c app
You are now connected to database "app" as user "postgres".
app=# GRANT ALL PRIVILEGES ON SCHEMA auth to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA settings to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA pgjwt to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA request to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA util to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA data to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON SCHEMA api to rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA auth  TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA settings TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA pgjwt TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA request TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA util TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA data TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA api TO rkoberg;
GRANT
app=# GRANT ALL PRIVILEGES ON DATABASE app TO rkoberg;
GRANT

$ pg_dump -c --if-exists  -f app.ddl -h 0.0.0.0 -p 5432 -U rkoberg -d app
Password: 
pg_dump: [archiver (db)] query failed: ERROR:  permission denied for relation user_id_seq
pg_dump: [archiver (db)] query was: SELECT last_value, is_called FROM user_id_seq

app=# GRANT ALL PRIVILEGES ON SEQUENCE user_id_seq TO rkoberg;
ERROR:  relation "user_id_seq" does not exist

$ dropdb app -h my.rds.amazonaws.com -U superuser
Password: 
$ createdb app -h my.rds.amazonaws.com -U superuser
Password: 
$ psql -f db/app.ddl -h my.rds.amazonaws.com -U superuser -d app
Password: 

psql:db/app.ddl:293: ERROR:  role "postgres" does not exist

ALTER SCHEMA public OWNER TO postgres;

psql:db/app.ddl:340: ERROR:  must be owner of extension plpgsql

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

psql:db/app.ddl:354: ERROR:  must be owner of extension pgcrypto

COMMENT ON EXTENSION pgcrypto IS 'cryptographic functions';

psql:db/app.ddl:1363: ERROR:  syntax error at or near "AS"
LINE 2:     AS integer
            ^
psql:db/app.ddl:1366: ERROR:  relation "user_id_seq" does not exist
psql:db/app.ddl:1372: ERROR:  relation "user_id_seq" does not exist

--
-- Name: user; Type: TABLE; Schema: data; Owner: superuser
--

CREATE TABLE "user" (
    id integer NOT NULL,
    name text NOT NULL,
    email text NOT NULL,
    password text NOT NULL,
    role user_role DEFAULT (settings.get('auth.default-role'::text))::user_role NOT NULL,
    CONSTRAINT user_email_check CHECK ((email ~* '^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+[.][A-Za-z]+$'::text)),
    CONSTRAINT user_name_check CHECK ((length(name) > 2))
);


ALTER TABLE "user" OWNER TO superuser;

--
-- Name: user_id_seq; Type: SEQUENCE; Schema: data; Owner: superuser
--

CREATE SEQUENCE user_id_seq
    AS integer          -- THIS IS LINE 1363 !!!!!*******
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE user_id_seq OWNER TO superuser;

--
-- Name: user_id_seq; Type: SEQUENCE OWNED BY; Schema: data; Owner: superuser
--

ALTER SEQUENCE user_id_seq OWNED BY "user".id;

psql:db/app.ddl:1395: ERROR:  relation "user_id_seq" does not exist

ALTER TABLE ONLY "user" ALTER COLUMN id SET DEFAULT nextval('user_id_seq'::regclass);

psql:db/app.ddl:1626: ERROR:  relation "user_id_seq" does not exist
LINE 1: SELECT pg_catalog.setval('user_id_seq', 1, false);

SELECT pg_catalog.setval('user_id_seq', 1, false);

  + 0000000002-data .. psql:deploy/0000000002-data.sql:19: ERROR:  missing data for column "value"
CONTEXT:  COPY secrets, line 1: "jwt_lifetime '3600'"
not ok
"psql" unexpectedly returned exit value 3

Deploy failed

COPY secrets (key, value) FROM stdin;
jwt_lifetime 3600

$ psql -U superuser -f db/migrations/revert/0000000002-data.sql -d app -h my.rds.amazonaws.com
Password for user superuser: 
BEGIN
SET
TRUNCATE TABLE
COMMIT
$