Difference between revisions of "VbzCart/coding"
< VbzCart
Jump to navigation
Jump to search
(moved data design stuff here) |
(integrity checks subpage) |
||
| Line 1: | Line 1: | ||
At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below). | At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below). | ||
==Data Design== | ==Data Design== | ||
| − | * | + | * {{l/vc|procs}} |
| − | * | + | * {{l/vc|queries}} |
| − | * | + | * {{l/vc|tables}} |
The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary. | The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary. | ||
At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress. | At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress. | ||
| + | |||
| + | Other data-related stuff: | ||
| + | * [[/integrity checks]] | ||
==Code== | ==Code== | ||
* [https://github.com/woozalia/VbzCart GitHub]: code repository | * [https://github.com/woozalia/VbzCart GitHub]: code repository | ||
Revision as of 23:51, 3 March 2016
At this point (2014-12-18), I'm just trying to get VbzCart back up and running after a massive rewrite that has so far taken over a year. Code has now been published in GitHub, and there's a Redmine repository for tracking bugs and (eventually) features (see links below).
Data Design
The MySQL user only needs INSERT, SELECT, and UPDATE privileges on most of the tables, but it does need DELETE privileges on the assignment tables (tables whose name is of the form *_X_*). Maybe I should add a WhenVoided field on these tables in order to make that unnecessary.
At this point, I'm trying to eliminate the need for PROCs and queries (VIEWs), but work is still in progress.
Other data-related stuff:
Code
- GitHub: code repository
- Redmine @ vbz: project tracker
Links
Trivia
- International Address Formats: reference for how addresses should be formatted for different countries