CUAHSI / CUAHSI/HydroServerLite

add mySQL stored procedure to update seriescatalog table

Open
#34 2 comments 0 reactions 0 assignees View on GitHub
CodePlex
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.