CUAHSI / CUAHSI/HydroServerLite
add mySQL stored procedure to update seriescatalog table
- Dominant language
- PHP
- Stars
- 7
- Forks
- 6
- PR merge metrics
- No merged PRs in 30d
Description
jirikadlec2[CodePlex]
Currently the code (update_series_catalog_function.php) for updating the seriescatalog table in the ODM database is very complicated,
I recommend replacing it with a stored procedure in the ODM database
(the MS SQL server ODM database is also using a stored procedure)
The SQL query for updating the seriescatalog table is in the attached file.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with update_series_catalog_function.php and review the attached SQL query for the seriescatalog update. Compare the proposed approach with the existing MS SQL Server stored procedure, then confirm that the MySQL ODM database performs the same update after the PHP code is replaced; the task is done when the stored procedure is installed and the update works correctly.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php, sql
- Domain
- backend, database
- Issue type
- Refactor
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100