Issue Details (XML | Word | Printable)

Key: WPS-358
Type: Improvement Improvement
Status: Open Open
Priority: Critical Critical
Assignee: Unassigned
Reporter: Turadg Aleahmad
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
WISE Platform 2

Make `running` table compatible with `run`

Created: 12/Jun/06 05:41 PM   Updated: 22/Jan/07 07:40 AM
Component/s: None
Affects Version/s: None
Fix Version/s: Server switch

Issue Links:
Dependency
 


 Description  « Hide
There is so much code that depends on the `running` table. I want to write new code that uses `run` instead.

So what I'm gonna do is make a synchronizer that keys these two ways of recording in sync. New code will use `run` and old code will slowly be converted over to use `run` also. Once all the code is converted, `running` can be dropped.

I'll accomplish this by adding a `runID` column to `running` that specifies what `run` record the `running` row is duplicating.

ALTER TABLE `wise`.`running`
 ADD COLUMN `runID` INTEGER UNSIGNED FIRST;


 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
Turadg Aleahmad added a comment - 12/Jun/06 06:05 PM
Okay, I've got the syncer done:
  http://turadg.wisetest.org/Maintenance/makeRunForRunningAction

That can be run repeatedly. It makes a new-style record for each old-style record and then points the old to the new.

Now I need to go and change my branch of the code to use the new style. I'll see how far I get.

Once this goes into production, that Maintenance task needs to be run and then the site should work again.

To fix:
grep -ri --include=*.php " FROM running " .
grep -ri --include=*.php " running AS " .
grep -r --include=*.php " running " .