hasura / hasura/graphql-engine
Erron on tracking table for odoo database table
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
Current, I am trying to integrate odoo with hasura.
I used the track all function to track the existing odoo database and I encountered an error when tracking the ir_model_constraint and ir_model.
```
Adding existing table/view failed
Found conflicting definitions for "ir_model_constraint". The definition at "mutation_root.insert_ir_model.on_conflict.constraint" differs from the the definition at "subscription_root.ir_model_constraint_by_pk, subscription_root.ir_model_constraint, query_root.ir_model_constraint_aggregate.nodes, query_root.ir_model_constraint_by_pk, query_root.ir_model_constraint".
```
ir_model_constraint
```
CREATE TABLE public.ir_model_constraint
(
id integer NOT NULL DEFAULT nextval('ir_model_constraint_id_seq'::regclass),
name character varying COLLATE pg_catalog."default" NOT NULL,
definition character varying COLLATE pg_catalog."default",
message character varying COLLATE pg_catalog."default",
model integer NOT NULL,
module integer NOT NULL,
type character varying(1) COLLATE pg_catalog."default" NOT NULL,
write_date timestamp without time zone,
create_date timestamp without time zone,
create_uid integer,
write_uid integer,
CONSTRAINT ir_model_constraint_pkey PRIMARY KEY (id),
CONSTRAINT ir_model_constraint_module_name_uniq UNIQUE (name, module),
CONSTRAINT ir_model_constraint_create_uid_fkey FOREIGN KEY (create_uid)
REFERENCES public.res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE SET NULL,
CONSTRAINT ir_model_constraint_model_fkey FOREIGN KEY (model)
REFERENCES public.ir_model (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE CASCADE,
CONSTRAINT ir_model_constraint_module_fkey FOREIGN KEY (module)
REFERENCES public.ir_module_module (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE CASCADE,
CONSTRAINT ir_model_constraint_write_uid_fkey FOREIGN KEY (write_uid)
REFERENCES public.res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE SET NULL
)
```
ir_model
```
CREATE TABLE public.ir_model
(
id integer NOT NULL DEFAULT nextval('ir_model_id_seq'::regclass),
name character varying COLLATE pg_catalog."default" NOT NULL,
model character varying COLLATE pg_catalog."default" NOT NULL,
"order" character varying COLLATE pg_catalog."default" NOT NULL,
info text COLLATE pg_catalog."default",
state character varying COLLATE pg_catalog."default",
transient boolean,
create_uid integer,
create_date timestamp without time zone,
write_uid integer,
write_date timestamp without time zone,
is_mail_thread boolean,
is_mail_activity boolean,
is_mail_blacklist boolean,
CONSTRAINT ir_model_pkey PRIMARY KEY (id),
CONSTRAINT ir_model_obj_name_uniq UNIQUE (model),
CONSTRAINT ir_model_create_uid_fkey FOREIGN KEY (create_uid)
REFERENCES public.res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE SET NULL,
CONSTRAINT ir_model_write_uid_fkey FOREIGN KEY (write_uid)
REFERENCES public.res_users (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE SET NULL
)
```
Odoo v14 and the hasura version is v2.0.1
Any tips for solving this issue?
Let me know if any information is needed.
Thanks a lot
Contributor guide
Assessment
This issue has not been assessed yet.