search

ODM2 / YODA-File

The YAML Observation Data Archive & exchange (YODA) File Format
BSD 3-Clause "New" or "Revised" License
4 stars 0 forks source link

loading YODA file into postgresql db #40

Closed cdesyoun closed 8 years ago

cdesyoun commented 8 years ago

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?

emiliom commented 8 years ago

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

Use cvload.py. It's straightforward.

cdesyoun commented 8 years ago

Thanks! Emilio. I will test it.

cdesyoun commented 8 years ago

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