3 //rely on the convention that any reference column is named [parent_table]_id
4 //or the other way around, the column is labled [child_table]_id
6 // so either we will be looking for the id of the parent table, or we will
7 // be given the id for the child table
11 'class' => 'Domain\Entities\StepMania\Simfile',
12 'table' => 'simfiles',
15 'title' => DataAccess\
Varchar('title'),
16 'artist' => DataAccess\
VO('Artist'),
17 'uploader' => DataAccess\
Entity('User', 'getUploader'),
18 'bpm' => DataAccess\
VO('BPM'),
19 'bpmChanges' => DataAccess\
Int('bpm_changes', 'hasBPMChanges'),
20 'stops' => DataAccess\
Int('stops', 'hasStops'),
21 'fgChanges' => DataAccess\
Int('fg_changes', 'hasFgChanges'),
22 'bgChanges' => DataAccess\
Int('bg_changes', 'hasBgChanges'),
23 'banner' => DataAccess\
Entity('File', 'getBanner', 'banner_file'),
24 'simfile' => DataAccess\
Entity('File', 'getSimfile', 'simfile_file'),
25 'packId' => DataAccess\
Int('pack_id', 'getPackId'),
26 'steps' => DataAccess\
VOArray('StepChart', 'getSteps')
31 'class' => 'Domain\Entities\StepMania\Pack',
34 'title' => DataAccess\
Varchar('title'),
35 'uploader' => DataAccess\
Entity('User', 'getUploader'),
36 'simfiles' => DataAccess\
EntityArray('Simfile', 'getSimfiles'),
37 'banner' => DataAccess\
Entity('File', 'getBanner', 'banner_file'),
38 'file' => DataAccess\
Entity('File', 'getFile')
43 'class' => 'Domain\VOs\StepMania\BPM',
44 'table' => 'simfiles',
46 'high' => DataAccess\
Int('bpm_high', 'getHigh'),
47 'low' => DataAccess\
Int('bpm_low', 'getLow')
52 'class' => 'Domain\Entities\User',
55 'country' => DataAccess\
VO('Country'),
56 'displayName' => DataAccess\
Varchar('display_name'),
57 'name' => DataAccess\
VO('Name'),
58 'tags' => DataAccess\
VOArray('Tag', 'getTags'), // TODO: Make VarcharArray class
59 'facebookId' => DataAccess\
Varchar('facebook_id')
64 'class' => 'Domain\VOs\Name',
65 'table' => 'users_meta',
67 'firstname' => DataAccess\
Varchar('firstname'),
68 'lastname' => DataAccess\
Varchar('lastname')
73 'class' => 'Domain\VOs\Country',
74 'table' => 'users_meta',
76 'country' => DataAccess\
Varchar('country', 'getCountryName')
81 'class' => 'Domain\VOs\StepMania\Tag',
82 'table' => 'step_artists',
84 'tag' => DataAccess\
Varchar('tag')
89 'class' => 'Domain\VOs\StepMania\Artist',
92 'name' => DataAccess\
Varchar('name')
97 'class' => 'Domain\VOs\StepMania\StepChart',
100 'mode' => DataAccess\
VO('DanceMode', 'getMode'),
101 'difficulty' => DataAccess\
VO('Difficulty'),
102 'artist' => DataAccess\
VO('StepArtist', 'getArtist', 'step_artist'),
103 'rating' => DataAccess\
Int('rating')
108 'class' => 'Domain\VOs\StepMania\DanceMode',
111 'stepManiaName' => DataAccess\
Varchar('mode', 'getStepManiaName')
116 'class' => 'Domain\VOs\StepMania\StepArtist',
117 'table' => 'step_artists',
119 'tag' => DataAccess\
Varchar('tag')
124 'class' => 'Domain\VOs\StepMania\Difficulty',
127 'stepManiaName' => DataAccess\
Varchar('difficulty', 'getStepManiaName')
132 'class' => 'Domain\Entities\File',
135 'hash' => DataAccess\
Varchar('hash'),
136 'path' => DataAccess\
Varchar('path'),
137 'filename' => DataAccess\
Varchar('filename'),
138 'mimetype' => DataAccess\
Varchar('mimetype'),
139 'size' => DataAccess\
Int('size'),
140 'uploadDate' => DataAccess\
Int('uploaded', 'getUploadDate')