Difference between revisions of "VbzCart/coding"
< VbzCart
Jump to navigation
Jump to search
(moved data design stuff here) |
(/checkout) |
||
| (4 intermediate revisions by the same user not shown) | |||
| 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:// | + | * {{l/same|v1/class}}: class catalog |
| + | * [https://gitlab.com/woozalia/VbzCart GitLab]: code repository | ||
* [http://rm.vbz.net/projects/vbzcart Redmine @ vbz]: project tracker | * [http://rm.vbz.net/projects/vbzcart Redmine @ vbz]: project tracker | ||
| + | * [[/vocabulary]]: I'm trying to be consistent. | ||
| + | ===Pieces=== | ||
| + | * [[/checkout]] | ||
==Links== | ==Links== | ||
===Trivia=== | ===Trivia=== | ||
* [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries | * [http://www.bitboost.com/ref/international-address-formats.html International Address Formats]: reference for how addresses should be formatted for different countries | ||
Latest revision as of 14:35, 4 June 2019
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
- v1/class: class catalog
- GitLab: code repository
- Redmine @ vbz: project tracker
- /vocabulary: I'm trying to be consistent.
Pieces
Links
Trivia
- International Address Formats: reference for how addresses should be formatted for different countries