loading YODA file into postgresql db

Question

loading YODA file into postgresql db

cdesyoun opened this issue 9 years ago · 3 comments

Jeff, when loading YODA file into postgresql db, there are lots of foreign key integration errors related to CV which is used for most of odm2 tables. unlike sqlite and mySQL, without disabling this constraint forcibly for each tables in postgresql, YODA data could not be loaded into it.
For this, probably, using odm2 CV services, I think related CV terms will be loaded into the database in advance. Or any other way to do this?

Answer 1 · 2016-01-20T20:52:45.000Z

@cdesyoun, yes, you do need to pre-load the CV's.

Use cvload.py. It's straightforward.

Answer 2 · 2016-01-20T21:34:40.000Z

Thanks! Emilio. I will test it.

Answer 3 · 2016-01-22T00:44:40.000Z

Yes, when testing and looking into this file, it was good.