Steps:
$ mkdir prisma
$ cd prisma
$ prisma init
# select new database, select postgres and generate flow client
$ ls bogdan@Bogdans-MacBook-Pro
datamodel.prisma docker-compose.yml generated prisma.ymlDetails
version: '3'
services:
prisma:
image: prismagraphql/prisma:1.23
restart: always
ports:
- "4466:4466"
environment:
PRISMA_CONFIG: |
port: 4466
# uncomment the next line and provide the env var PRISMA_MANAGEMENT_API_SECRET=my-secret to activate cluster security
# managementApiSecret: my-secret
databases:
default:
connector: postgres
host: postgres
user: prisma
password: prisma
rawAccess: true
port: 5432
migrations: true
postgres:
- image: postgres
+ image: postgres:11-alpine
restart: always
+ ports:
+ - "5432:5432"
environment:
POSTGRES_USER: prisma
POSTGRES_PASSWORD: prisma
volumes:
- postgres:/var/lib/postgresql/data
volumes:
postgres:Big Bad SQL
--
-- PostgreSQL database dump
--
-- Dumped from database version 11.1
-- Dumped by pg_dump version 11.1
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;
--
-- Name: public; Type: SCHEMA; Schema: -; Owner: prisma
--
CREATE SCHEMA public;
ALTER SCHEMA public OWNER TO prisma;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: brand; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.brand (
id integer NOT NULL,
xml_id text NOT NULL,
active boolean NOT NULL,
name text NOT NULL,
picture text
);
ALTER TABLE public.brand OWNER TO prisma;
--
-- Name: brand_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.brand_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.brand_id_seq OWNER TO prisma;
--
-- Name: brand_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.brand_id_seq OWNED BY public.brand.id;
--
-- Name: category; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.category (
id integer NOT NULL,
xml_id text,
active boolean NOT NULL,
name text NOT NULL,
sort integer,
supercategory integer
);
ALTER TABLE public.category OWNER TO prisma;
--
-- Name: category_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.category_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.category_id_seq OWNER TO prisma;
--
-- Name: category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.category_id_seq OWNED BY public.category.id;
--
-- Name: categorybrandsort; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.categorybrandsort (
category integer NOT NULL,
brand integer NOT NULL,
sort integer NOT NULL
);
ALTER TABLE public.categorybrandsort OWNER TO prisma;
--
-- Name: characteristic; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.characteristic (
id integer NOT NULL,
code text NOT NULL,
name text NOT NULL,
active boolean NOT NULL,
sort integer,
type text,
multiple boolean
);
ALTER TABLE public.characteristic OWNER TO prisma;
--
-- Name: characteristic_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.characteristic_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.characteristic_id_seq OWNER TO prisma;
--
-- Name: characteristic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.characteristic_id_seq OWNED BY public.characteristic.id;
--
-- Name: charcategories; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.charcategories (
har integer NOT NULL,
category integer NOT NULL
);
ALTER TABLE public.charcategories OWNER TO prisma;
--
-- Name: charenums; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.charenums (
id integer NOT NULL,
xml_id text,
"char" integer NOT NULL,
"default" text,
sort integer NOT NULL,
value text NOT NULL
);
ALTER TABLE public.charenums OWNER TO prisma;
--
-- Name: charenums_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.charenums_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.charenums_id_seq OWNER TO prisma;
--
-- Name: charenums_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.charenums_id_seq OWNED BY public.charenums.id;
--
-- Name: charfilters; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.charfilters (
"char" integer NOT NULL,
category integer NOT NULL,
"column" text NOT NULL,
hidden boolean,
sort integer NOT NULL
);
ALTER TABLE public.charfilters OWNER TO prisma;
--
-- Name: charsorts; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.charsorts (
har integer NOT NULL,
category integer NOT NULL,
grchar integer,
hidden boolean,
sort integer NOT NULL
);
ALTER TABLE public.charsorts OWNER TO prisma;
--
-- Name: country; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.country (
id integer NOT NULL,
xml_id text,
code text NOT NULL,
active boolean,
name text NOT NULL,
sort integer
);
ALTER TABLE public.country OWNER TO prisma;
--
-- Name: country_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.country_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.country_id_seq OWNER TO prisma;
--
-- Name: country_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.country_id_seq OWNED BY public.country.id;
--
-- Name: grcharcategorysort; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.grcharcategorysort (
grchar integer NOT NULL,
category integer NOT NULL,
sort integer NOT NULL
);
ALTER TABLE public.grcharcategorysort OWNER TO prisma;
--
-- Name: groupcharacteristic; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.groupcharacteristic (
id integer NOT NULL,
xml_id text NOT NULL,
name text
);
ALTER TABLE public.groupcharacteristic OWNER TO prisma;
--
-- Name: groupcharacteristic_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.groupcharacteristic_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.groupcharacteristic_id_seq OWNER TO prisma;
--
-- Name: groupcharacteristic_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.groupcharacteristic_id_seq OWNED BY public.groupcharacteristic.id;
--
-- Name: item; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.item (
id integer NOT NULL,
xml_id text,
is_active boolean,
name text,
price_old integer,
price_retail integer,
price_purchase integer,
cpa integer,
sales_notes text,
delivery_cost text,
delivery_days text,
popularity integer,
quantity integer,
brand integer,
ser integer,
type_control integer,
category integer,
country integer,
always_to_order boolean,
leader boolean,
ne_pokazyvat_stranicy boolean,
new boolean,
otdelno_ne_prodaetsa boolean,
on_sale boolean,
hide_in_catalog boolean,
is_advance boolean,
is_nabor boolean
);
ALTER TABLE public.item OWNER TO prisma;
--
-- Name: item_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.item_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.item_id_seq OWNER TO prisma;
--
-- Name: item_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.item_id_seq OWNED BY public.item.id;
--
-- Name: itemhascharenum; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemhascharenum (
item integer NOT NULL,
"char" integer NOT NULL,
index smallint NOT NULL,
value integer NOT NULL
);
ALTER TABLE public.itemhascharenum OWNER TO prisma;
--
-- Name: itemhascharstr; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemhascharstr (
item integer NOT NULL,
"char" integer NOT NULL,
index smallint NOT NULL,
value text
);
ALTER TABLE public.itemhascharstr OWNER TO prisma;
--
-- Name: itemhasprop; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemhasprop (
item integer NOT NULL,
prop integer NOT NULL,
index smallint NOT NULL,
value text NOT NULL
);
ALTER TABLE public.itemhasprop OWNER TO prisma;
--
-- Name: itemhasvarchar; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemhasvarchar (
item integer NOT NULL,
"varchar" integer NOT NULL
);
ALTER TABLE public.itemhasvarchar OWNER TO prisma;
--
-- Name: itemset; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemset (
id integer NOT NULL,
xml_id text,
is_active boolean,
sort integer,
name text NOT NULL,
type text NOT NULL,
product integer
);
ALTER TABLE public.itemset OWNER TO prisma;
--
-- Name: itemset_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.itemset_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.itemset_id_seq OWNER TO prisma;
--
-- Name: itemset_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.itemset_id_seq OWNED BY public.itemset.id;
--
-- Name: itemsethasitem; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.itemsethasitem (
itemset integer NOT NULL,
item integer NOT NULL
);
ALTER TABLE public.itemsethasitem OWNER TO prisma;
--
-- Name: property; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.property (
id integer NOT NULL,
code text,
active boolean,
default_value text,
name text NOT NULL,
sort integer
);
ALTER TABLE public.property OWNER TO prisma;
--
-- Name: property_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.property_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.property_id_seq OWNER TO prisma;
--
-- Name: property_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.property_id_seq OWNED BY public.property.id;
--
-- Name: seria; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.seria (
id integer NOT NULL,
xml_id text,
active boolean,
name text NOT NULL,
sort integer,
detail_text text,
brand integer
);
ALTER TABLE public.seria OWNER TO prisma;
--
-- Name: seria_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.seria_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.seria_id_seq OWNER TO prisma;
--
-- Name: seria_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.seria_id_seq OWNED BY public.seria.id;
--
-- Name: supercategory; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.supercategory (
id integer NOT NULL,
name text NOT NULL,
sort integer NOT NULL
);
ALTER TABLE public.supercategory OWNER TO prisma;
--
-- Name: supercategory_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.supercategory_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.supercategory_id_seq OWNER TO prisma;
--
-- Name: supercategory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.supercategory_id_seq OWNED BY public.supercategory.id;
--
-- Name: typecontrol; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public.typecontrol (
id integer NOT NULL,
xml_id text,
active boolean,
name text NOT NULL,
sort integer,
category integer NOT NULL
);
ALTER TABLE public.typecontrol OWNER TO prisma;
--
-- Name: typecontrol_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.typecontrol_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.typecontrol_id_seq OWNER TO prisma;
--
-- Name: typecontrol_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.typecontrol_id_seq OWNED BY public.typecontrol.id;
--
-- Name: varchar; Type: TABLE; Schema: public; Owner: prisma
--
CREATE TABLE public."varchar" (
id integer NOT NULL,
xml_id text,
name text NOT NULL,
sort integer,
"group" text NOT NULL,
type text NOT NULL,
detail_picture text NOT NULL
);
ALTER TABLE public."varchar" OWNER TO prisma;
--
-- Name: varchar_id_seq; Type: SEQUENCE; Schema: public; Owner: prisma
--
CREATE SEQUENCE public.varchar_id_seq
AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE public.varchar_id_seq OWNER TO prisma;
--
-- Name: varchar_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: prisma
--
ALTER SEQUENCE public.varchar_id_seq OWNED BY public."varchar".id;
--
-- Name: brand id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.brand ALTER COLUMN id SET DEFAULT nextval('public.brand_id_seq'::regclass);
--
-- Name: category id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.category ALTER COLUMN id SET DEFAULT nextval('public.category_id_seq'::regclass);
--
-- Name: characteristic id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.characteristic ALTER COLUMN id SET DEFAULT nextval('public.characteristic_id_seq'::regclass);
--
-- Name: charenums id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charenums ALTER COLUMN id SET DEFAULT nextval('public.charenums_id_seq'::regclass);
--
-- Name: country id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.country ALTER COLUMN id SET DEFAULT nextval('public.country_id_seq'::regclass);
--
-- Name: groupcharacteristic id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.groupcharacteristic ALTER COLUMN id SET DEFAULT nextval('public.groupcharacteristic_id_seq'::regclass);
--
-- Name: item id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item ALTER COLUMN id SET DEFAULT nextval('public.item_id_seq'::regclass);
--
-- Name: itemset id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemset ALTER COLUMN id SET DEFAULT nextval('public.itemset_id_seq'::regclass);
--
-- Name: property id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.property ALTER COLUMN id SET DEFAULT nextval('public.property_id_seq'::regclass);
--
-- Name: seria id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.seria ALTER COLUMN id SET DEFAULT nextval('public.seria_id_seq'::regclass);
--
-- Name: supercategory id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.supercategory ALTER COLUMN id SET DEFAULT nextval('public.supercategory_id_seq'::regclass);
--
-- Name: typecontrol id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.typecontrol ALTER COLUMN id SET DEFAULT nextval('public.typecontrol_id_seq'::regclass);
--
-- Name: varchar id; Type: DEFAULT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public."varchar" ALTER COLUMN id SET DEFAULT nextval('public.varchar_id_seq'::regclass);
--
-- Data for Name: brand; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.brand (id, xml_id, active, name, picture) FROM stdin;
\.
--
-- Data for Name: category; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.category (id, xml_id, active, name, sort, supercategory) FROM stdin;
\.
--
-- Data for Name: categorybrandsort; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.categorybrandsort (category, brand, sort) FROM stdin;
\.
--
-- Data for Name: characteristic; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.characteristic (id, code, name, active, sort, type, multiple) FROM stdin;
\.
--
-- Data for Name: charcategories; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.charcategories (har, category) FROM stdin;
\.
--
-- Data for Name: charenums; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.charenums (id, xml_id, "char", "default", sort, value) FROM stdin;
\.
--
-- Data for Name: charfilters; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.charfilters ("char", category, "column", hidden, sort) FROM stdin;
\.
--
-- Data for Name: charsorts; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.charsorts (har, category, grchar, hidden, sort) FROM stdin;
\.
--
-- Data for Name: country; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.country (id, xml_id, code, active, name, sort) FROM stdin;
\.
--
-- Data for Name: grcharcategorysort; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.grcharcategorysort (grchar, category, sort) FROM stdin;
\.
--
-- Data for Name: groupcharacteristic; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.groupcharacteristic (id, xml_id, name) FROM stdin;
\.
--
-- Data for Name: item; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.item (id, xml_id, is_active, name, price_old, price_retail, price_purchase, cpa, sales_notes, delivery_cost, delivery_days, popularity, quantity, brand, ser, type_control, category, country, always_to_order, leader, ne_pokazyvat_stranicy, new, otdelno_ne_prodaetsa, on_sale, hide_in_catalog, is_advance, is_nabor) FROM stdin;
\.
--
-- Data for Name: itemhascharenum; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemhascharenum (item, "char", index, value) FROM stdin;
\.
--
-- Data for Name: itemhascharstr; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemhascharstr (item, "char", index, value) FROM stdin;
\.
--
-- Data for Name: itemhasprop; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemhasprop (item, prop, index, value) FROM stdin;
\.
--
-- Data for Name: itemhasvarchar; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemhasvarchar (item, "varchar") FROM stdin;
\.
--
-- Data for Name: itemset; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemset (id, xml_id, is_active, sort, name, type, product) FROM stdin;
\.
--
-- Data for Name: itemsethasitem; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.itemsethasitem (itemset, item) FROM stdin;
\.
--
-- Data for Name: property; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.property (id, code, active, default_value, name, sort) FROM stdin;
\.
--
-- Data for Name: seria; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.seria (id, xml_id, active, name, sort, detail_text, brand) FROM stdin;
\.
--
-- Data for Name: supercategory; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.supercategory (id, name, sort) FROM stdin;
\.
--
-- Data for Name: typecontrol; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public.typecontrol (id, xml_id, active, name, sort, category) FROM stdin;
\.
--
-- Data for Name: varchar; Type: TABLE DATA; Schema: public; Owner: prisma
--
COPY public."varchar" (id, xml_id, name, sort, "group", type, detail_picture) FROM stdin;
\.
--
-- Name: brand_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.brand_id_seq', 1, false);
--
-- Name: category_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.category_id_seq', 1, false);
--
-- Name: characteristic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.characteristic_id_seq', 1, false);
--
-- Name: charenums_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.charenums_id_seq', 1, false);
--
-- Name: country_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.country_id_seq', 1, false);
--
-- Name: groupcharacteristic_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.groupcharacteristic_id_seq', 1, false);
--
-- Name: item_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.item_id_seq', 1, false);
--
-- Name: itemset_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.itemset_id_seq', 1, false);
--
-- Name: property_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.property_id_seq', 1, false);
--
-- Name: seria_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.seria_id_seq', 1, false);
--
-- Name: supercategory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.supercategory_id_seq', 1, false);
--
-- Name: typecontrol_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.typecontrol_id_seq', 1, false);
--
-- Name: varchar_id_seq; Type: SEQUENCE SET; Schema: public; Owner: prisma
--
SELECT pg_catalog.setval('public.varchar_id_seq', 1, false);
--
-- Name: brand brand_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.brand
ADD CONSTRAINT brand_pkey PRIMARY KEY (id);
--
-- Name: brand brand_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.brand
ADD CONSTRAINT brand_xml_id_key UNIQUE (xml_id);
--
-- Name: category category_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.category
ADD CONSTRAINT category_pkey PRIMARY KEY (id);
--
-- Name: category category_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.category
ADD CONSTRAINT category_xml_id_key UNIQUE (xml_id);
--
-- Name: categorybrandsort categorybrandsort_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.categorybrandsort
ADD CONSTRAINT categorybrandsort_pkey PRIMARY KEY (category, brand);
--
-- Name: characteristic characteristic_code_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.characteristic
ADD CONSTRAINT characteristic_code_key UNIQUE (code);
--
-- Name: characteristic characteristic_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.characteristic
ADD CONSTRAINT characteristic_pkey PRIMARY KEY (id);
--
-- Name: charcategories charcategories_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charcategories
ADD CONSTRAINT charcategories_pkey PRIMARY KEY (har, category);
--
-- Name: charenums charenums_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charenums
ADD CONSTRAINT charenums_pkey PRIMARY KEY (id);
--
-- Name: charenums charenums_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charenums
ADD CONSTRAINT charenums_xml_id_key UNIQUE (xml_id);
--
-- Name: charfilters charfilters_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charfilters
ADD CONSTRAINT charfilters_pkey PRIMARY KEY ("char", category);
--
-- Name: charsorts charsorts_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charsorts
ADD CONSTRAINT charsorts_pkey PRIMARY KEY (har, category);
--
-- Name: country country_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.country
ADD CONSTRAINT country_pkey PRIMARY KEY (id);
--
-- Name: country country_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.country
ADD CONSTRAINT country_xml_id_key UNIQUE (xml_id);
--
-- Name: grcharcategorysort grcharcategorysort_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.grcharcategorysort
ADD CONSTRAINT grcharcategorysort_pkey PRIMARY KEY (grchar, category);
--
-- Name: groupcharacteristic groupcharacteristic_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.groupcharacteristic
ADD CONSTRAINT groupcharacteristic_pkey PRIMARY KEY (id);
--
-- Name: groupcharacteristic groupcharacteristic_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.groupcharacteristic
ADD CONSTRAINT groupcharacteristic_xml_id_key UNIQUE (xml_id);
--
-- Name: item item_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT item_pkey PRIMARY KEY (id);
--
-- Name: item item_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT item_xml_id_key UNIQUE (xml_id);
--
-- Name: itemhascharenum itemhascharenum_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharenum
ADD CONSTRAINT itemhascharenum_pkey PRIMARY KEY (item, "char", index);
--
-- Name: itemhascharstr itemhascharstr_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharstr
ADD CONSTRAINT itemhascharstr_pkey PRIMARY KEY (item, "char", index);
--
-- Name: itemhasprop itemhasprop_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasprop
ADD CONSTRAINT itemhasprop_pkey PRIMARY KEY (item, prop, index);
--
-- Name: itemhasvarchar itemhasvarchar_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasvarchar
ADD CONSTRAINT itemhasvarchar_pkey PRIMARY KEY (item, "varchar");
--
-- Name: itemset itemset_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemset
ADD CONSTRAINT itemset_pkey PRIMARY KEY (id);
--
-- Name: itemset itemset_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemset
ADD CONSTRAINT itemset_xml_id_key UNIQUE (xml_id);
--
-- Name: itemsethasitem itemsethasitem_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemsethasitem
ADD CONSTRAINT itemsethasitem_pkey PRIMARY KEY (itemset, item);
--
-- Name: property property_code_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.property
ADD CONSTRAINT property_code_key UNIQUE (code);
--
-- Name: property property_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.property
ADD CONSTRAINT property_pkey PRIMARY KEY (id);
--
-- Name: seria seria_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.seria
ADD CONSTRAINT seria_pkey PRIMARY KEY (id);
--
-- Name: seria seria_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.seria
ADD CONSTRAINT seria_xml_id_key UNIQUE (xml_id);
--
-- Name: supercategory supercategory_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.supercategory
ADD CONSTRAINT supercategory_pkey PRIMARY KEY (id);
--
-- Name: typecontrol typecontrol_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.typecontrol
ADD CONSTRAINT typecontrol_pkey PRIMARY KEY (id);
--
-- Name: typecontrol typecontrol_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.typecontrol
ADD CONSTRAINT typecontrol_xml_id_key UNIQUE (xml_id);
--
-- Name: varchar varchar_pkey; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public."varchar"
ADD CONSTRAINT varchar_pkey PRIMARY KEY (id);
--
-- Name: varchar varchar_xml_id_key; Type: CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public."varchar"
ADD CONSTRAINT varchar_xml_id_key UNIQUE (xml_id);
--
-- Name: idx_category__supercategory; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_category__supercategory ON public.category USING btree (supercategory);
--
-- Name: idx_categorybrandsort__brand; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_categorybrandsort__brand ON public.categorybrandsort USING btree (brand);
--
-- Name: idx_charcategories__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_charcategories__category ON public.charcategories USING btree (category);
--
-- Name: idx_charenums__char; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_charenums__char ON public.charenums USING btree ("char");
--
-- Name: idx_charfilters__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_charfilters__category ON public.charfilters USING btree (category);
--
-- Name: idx_charsorts__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_charsorts__category ON public.charsorts USING btree (category);
--
-- Name: idx_charsorts__grchar; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_charsorts__grchar ON public.charsorts USING btree (grchar);
--
-- Name: idx_grcharcategorysort__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_grcharcategorysort__category ON public.grcharcategorysort USING btree (category);
--
-- Name: idx_item__brand; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_item__brand ON public.item USING btree (brand);
--
-- Name: idx_item__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_item__category ON public.item USING btree (category);
--
-- Name: idx_item__country; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_item__country ON public.item USING btree (country);
--
-- Name: idx_item__ser; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_item__ser ON public.item USING btree (ser);
--
-- Name: idx_item__type_control; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_item__type_control ON public.item USING btree (type_control);
--
-- Name: idx_itemhascharenum__char; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemhascharenum__char ON public.itemhascharenum USING btree ("char");
--
-- Name: idx_itemhascharenum__value; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemhascharenum__value ON public.itemhascharenum USING btree (value);
--
-- Name: idx_itemhascharstr__char; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemhascharstr__char ON public.itemhascharstr USING btree ("char");
--
-- Name: idx_itemhasprop__prop; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemhasprop__prop ON public.itemhasprop USING btree (prop);
--
-- Name: idx_itemhasvarchar__varchar; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemhasvarchar__varchar ON public.itemhasvarchar USING btree ("varchar");
--
-- Name: idx_itemset__product; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemset__product ON public.itemset USING btree (product);
--
-- Name: idx_itemsethasitem__item; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_itemsethasitem__item ON public.itemsethasitem USING btree (item);
--
-- Name: idx_seria__brand; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_seria__brand ON public.seria USING btree (brand);
--
-- Name: idx_typecontrol__category; Type: INDEX; Schema: public; Owner: prisma
--
CREATE INDEX idx_typecontrol__category ON public.typecontrol USING btree (category);
--
-- Name: category fk_category__supercategory; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.category
ADD CONSTRAINT fk_category__supercategory FOREIGN KEY (supercategory) REFERENCES public.supercategory(id);
--
-- Name: categorybrandsort fk_categorybrandsort__brand; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.categorybrandsort
ADD CONSTRAINT fk_categorybrandsort__brand FOREIGN KEY (brand) REFERENCES public.brand(id);
--
-- Name: categorybrandsort fk_categorybrandsort__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.categorybrandsort
ADD CONSTRAINT fk_categorybrandsort__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: charcategories fk_charcategories__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charcategories
ADD CONSTRAINT fk_charcategories__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: charcategories fk_charcategories__har; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charcategories
ADD CONSTRAINT fk_charcategories__har FOREIGN KEY (har) REFERENCES public.characteristic(id);
--
-- Name: charenums fk_charenums__char; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charenums
ADD CONSTRAINT fk_charenums__char FOREIGN KEY ("char") REFERENCES public.characteristic(id);
--
-- Name: charfilters fk_charfilters__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charfilters
ADD CONSTRAINT fk_charfilters__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: charfilters fk_charfilters__char; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charfilters
ADD CONSTRAINT fk_charfilters__char FOREIGN KEY ("char") REFERENCES public.characteristic(id);
--
-- Name: charsorts fk_charsorts__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charsorts
ADD CONSTRAINT fk_charsorts__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: charsorts fk_charsorts__grchar; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charsorts
ADD CONSTRAINT fk_charsorts__grchar FOREIGN KEY (grchar) REFERENCES public.groupcharacteristic(id);
--
-- Name: charsorts fk_charsorts__har; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.charsorts
ADD CONSTRAINT fk_charsorts__har FOREIGN KEY (har) REFERENCES public.characteristic(id);
--
-- Name: grcharcategorysort fk_grcharcategorysort__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.grcharcategorysort
ADD CONSTRAINT fk_grcharcategorysort__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: grcharcategorysort fk_grcharcategorysort__grchar; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.grcharcategorysort
ADD CONSTRAINT fk_grcharcategorysort__grchar FOREIGN KEY (grchar) REFERENCES public.groupcharacteristic(id);
--
-- Name: item fk_item__brand; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT fk_item__brand FOREIGN KEY (brand) REFERENCES public.brand(id);
--
-- Name: item fk_item__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT fk_item__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- Name: item fk_item__country; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT fk_item__country FOREIGN KEY (country) REFERENCES public.country(id);
--
-- Name: item fk_item__ser; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT fk_item__ser FOREIGN KEY (ser) REFERENCES public.seria(id);
--
-- Name: item fk_item__type_control; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.item
ADD CONSTRAINT fk_item__type_control FOREIGN KEY (type_control) REFERENCES public.typecontrol(id);
--
-- Name: itemhascharenum fk_itemhascharenum__char; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharenum
ADD CONSTRAINT fk_itemhascharenum__char FOREIGN KEY ("char") REFERENCES public.characteristic(id);
--
-- Name: itemhascharenum fk_itemhascharenum__item; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharenum
ADD CONSTRAINT fk_itemhascharenum__item FOREIGN KEY (item) REFERENCES public.item(id);
--
-- Name: itemhascharenum fk_itemhascharenum__value; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharenum
ADD CONSTRAINT fk_itemhascharenum__value FOREIGN KEY (value) REFERENCES public.charenums(id);
--
-- Name: itemhascharstr fk_itemhascharstr__char; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharstr
ADD CONSTRAINT fk_itemhascharstr__char FOREIGN KEY ("char") REFERENCES public.characteristic(id);
--
-- Name: itemhascharstr fk_itemhascharstr__item; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhascharstr
ADD CONSTRAINT fk_itemhascharstr__item FOREIGN KEY (item) REFERENCES public.item(id);
--
-- Name: itemhasprop fk_itemhasprop__item; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasprop
ADD CONSTRAINT fk_itemhasprop__item FOREIGN KEY (item) REFERENCES public.item(id);
--
-- Name: itemhasprop fk_itemhasprop__prop; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasprop
ADD CONSTRAINT fk_itemhasprop__prop FOREIGN KEY (prop) REFERENCES public.property(id);
--
-- Name: itemhasvarchar fk_itemhasvarchar__item; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasvarchar
ADD CONSTRAINT fk_itemhasvarchar__item FOREIGN KEY (item) REFERENCES public.item(id);
--
-- Name: itemhasvarchar fk_itemhasvarchar__varchar; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemhasvarchar
ADD CONSTRAINT fk_itemhasvarchar__varchar FOREIGN KEY ("varchar") REFERENCES public."varchar"(id);
--
-- Name: itemset fk_itemset__product; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemset
ADD CONSTRAINT fk_itemset__product FOREIGN KEY (product) REFERENCES public.item(id);
--
-- Name: itemsethasitem fk_itemsethasitem__item; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemsethasitem
ADD CONSTRAINT fk_itemsethasitem__item FOREIGN KEY (item) REFERENCES public.item(id);
--
-- Name: itemsethasitem fk_itemsethasitem__itemset; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.itemsethasitem
ADD CONSTRAINT fk_itemsethasitem__itemset FOREIGN KEY (itemset) REFERENCES public.itemset(id);
--
-- Name: seria fk_seria__brand; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.seria
ADD CONSTRAINT fk_seria__brand FOREIGN KEY (brand) REFERENCES public.brand(id);
--
-- Name: typecontrol fk_typecontrol__category; Type: FK CONSTRAINT; Schema: public; Owner: prisma
--
ALTER TABLE ONLY public.typecontrol
ADD CONSTRAINT fk_typecontrol__category FOREIGN KEY (category) REFERENCES public.category(id);
--
-- PostgreSQL database dump complete
--
Expect to get schema from SQL, get this:
Details
$ prisma introspect
ERROR: Project not found: 'default$default'
{
"errors": [
{
"message": "Project not found: 'default$default'",
"code": 3016,
"requestId": "local:cjqm7z2ea000009555l41lvrl"
}
],
"status": 200
}
Get in touch if you need help: https://www.prisma.io/forum/
To get more detailed output, run $ export DEBUG="*"
╭──────────────────────────────────────────────╮
│ │
│ Update available 1.17.0-alpha.2 → 1.23.4 │
│ Run npm i -g prisma to update │
│ │
╰──────────────────────────────────────────────╯
$ prisma -v
prisma/1.23.4 (darwin-x64) node-v11.4.0
$ DEBUG="*" prisma introspect
config CWD /Users/bogdan/tools/satra-db/py/1 +0ms
config HOME /Users/bogdan +2ms
config definitionDir /Users/bogdan/tools/satra-db/py/1 +0ms
config definitionPath /Users/bogdan/tools/satra-db/py/1/prisma.yml +0ms
cli { isGlobal: true } +0ms
StatusChecker setting status checker +0ms
cli command id introspect +7ms
cli:plugincache Got plugin from cache +0ms
cli:plugincache /Users/bogdan/Library/Caches/prisma/plugins.json +0ms
cli:plugincache Got plugin from cache +1ms
cli:plugincache /Users/bogdan/Library/Caches/prisma/plugins.json +0ms
plugins findCommand prisma-cli-core +0ms
plugin requiring command +0ms
cli-engine:plugins:manager requiring /Users/bogdan/.npm-global/lib/node_modules/prisma/node_modules/prisma-cli-core +0ms
cli-engine:plugins:manager required +1s
plugin required command +1s
Environment saving global rc +0ms
StatusChecker setting status checker +2s
prisma definition making cluster here +0ms
client Initializing cluster client +0ms
client introspecting { serviceName: 'default',
stageName: 'default',
workspaceSlug: null } +5ms
Error: Project not found: 'default$default': {"response":{"errors":[{"message":"Project not found: 'default$default'","code":3016,"requestId":"local:cjqm8njnn000209557t3pt7vq"}],"status":200},"request":{"query":"\nquery IntrospectionQuery {\n __schema {\n queryType { name }\n mutationType { name }\n subscriptionType { name }\n types {\n ...FullType\n }\n directives {\n name\n description\n locations\n args {\n ...InputValue\n }\n }\n }\n}\n\nfragment FullType on __Type {\n kind\n name\n description\n fields(includeDeprecated: true) {\n name\n description\n args {\n ...InputValue\n }\n type {\n ...TypeRef\n }\n isDeprecated\n deprecationReason\n }\n inputFields {\n ...InputValue\n }\n interfaces {\n ...TypeRef\n }\n enumValues(includeDeprecated: true) {\n name\n description\n isDeprecated\n deprecationReason\n }\n possibleTypes {\n ...TypeRef\n }\n}\n\nfragment InputValue on __InputValue {\n name\n description\n type { ...TypeRef }\n defaultValue\n}\n\nfragment TypeRef on __Type {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n ofType {\n kind\n name\n }\n }\n }\n }\n }\n }\n }\n}\n"}}
at GraphQLClient.<anonymous> (/Users/bogdan/.npm-global/lib/node_modules/prisma/node_modules/graphql-request/src/index.ts:72:13)
at step (/Users/bogdan/.npm-global/lib/node_modules/prisma/node_modules/graphql-request/dist/src/index.js:40:23)
at Object.next (/Users/bogdan/.npm-global/lib/node_modules/prisma/node_modules/graphql-request/dist/src/index.js:21:53)
at fulfilled (/Users/bogdan/.npm-global/lib/node_modules/prisma/node_modules/graphql-request/dist/src/index.js:12:58)
at process.internalTickCallback (internal/process/next_tick.js:77:7)
Exiting with code: 1Pay attention that it shows me "update available", even though my prisma version is latest. I did update many times, but this error keep showing.
I don't know if it is important or not, but I installed prisma both with npm -g and brew. Maybe npm i -g prisma does version check by prisma -v and because of that version in npm does not change...
Somewhere I read that I need to deploy prisma first, so lets deploy it.
Pay attention, that only User type is generated.
Details
$ prisma deploy
Creating stage default for service default ✔
Deploying service `default` to stage `default` to server `local` 617ms
Changes:
User (Type)
+ Created type `User`
+ Created field `id` of type `GraphQLID!`
+ Created field `name` of type `String!`
+ Created field `updatedAt` of type `DateTime!`
+ Created field `createdAt` of type `DateTime!`
Applying changes 1.1s
Your Prisma GraphQL database endpoint is live:
HTTP: http://localhost:4466
WS: ws://localhost:4466Now it succeeds, but content is not something that I expect:
Details
$ prisma introspect
Introspecting schema default$default 992ms
Created datamodel definition based on 2 database tables.
Created 1 new file: GraphQL SDL-based datamodel (derived from existing database)
datamodel-1546860404148.prisma
$ cat datamodel-1546860404148.prisma
type _RelayId @pgTable(name: "_RelayId") {
id: ID! @id @unique
stableModelIdentifier: String!
}
type User @pgTable(name: "User") {
createdAt: DateTime!
id: ID! @id @unique
name: String!
updatedAt: DateTime!
}I expected to get types and relations for my database...