search

PatentsView / PatentsView-DB

35 stars 15 forks source link

rearranging all of the sql queries and dependencies for the reporting… #159

Closed bethanne-card closed 1 year ago

bethanne-card commented 1 year ago

… database

bethanne-card commented 1 year ago

@sarvothaman I tried to modularize the reporting database scripts a bit more but putting all of the indexes statements in the same file as the table creation. I also broke up the 04_support and 06_reporting_db into more scripts so that if I need to go back and fix all of the cpc or all of the location, they will be easier to find. Let me know if you see any issues with this logic.

bethanne-card commented 1 year ago

Thank you for your feedback @sarvothaman. I'll build a test reporting DB using this branch and report back.

bethanne-card commented 1 year ago

@sarvothaman the reporting DB code successfully ran. I had to make a few tweaks to the codebase due to the changes made here and some changes that would have need to be made either way. Am I okay to merge this code?