search

Fnyasimi / MARS-Update-Pipeline

0 stars 2 forks source link

Database update #2

Open Fnyasimi opened 4 years ago

Fnyasimi commented 4 years ago

Hi @kipkurui, I have managed to write an sql script of the database here.

Kindly review it and give feedback. I hope you should be able to run it well from your side.

Description

The script starts with the sql commands for building the database and the required tables then this is followed by inserting the data into the tables which takes in majority of the script.

Challenge

I have found a challenge in updating the foreign key and and constrains which have run me into multiple errors.

I ended up commenting them out of the code. Kindly help me address this problem and updating all the required and necessary keys & constrains into the script.

A quick question on PBM_Data table I didnt understand what PBM_DEBRU meant...

Looking forward to hearing from you.

Fnyasimi/Msc_Project#22

kipkurui commented 4 years ago

@Fnyasimi, did you fix the database error on your side? Still getting:

"ERROR 1452 (23000) at line 739601: Cannot add or update a child row: a foreign key constraint fails (mat_db.#sql-aa5_59, CONSTRAINT Motif_ibfk_1 FOREIGN KEY (TF_ID) REFERENCES transcription_factor (TF_ID))"

kipkurui commented 4 years ago

Just noticed you did not include the Matrix table in your new schema.In the current design, how is the PWM data fetched?

kipkurui commented 4 years ago

Noticed that you changed that to motifs

Fnyasimi commented 4 years ago

@kipkurui the sql dump version was working from my end. Did you manage to solve the error?