http://wiki.linuxmce.org/index.php?action=history&feed=atom&title=Sql2cpp_example 2026-07-21T20:21:10Z Revision history for this page on the wiki MediaWiki 1.44.0 http://wiki.linuxmce.org/index.php?title=Sql2cpp_example&diff=20003&oldid=prev 2009-07-23T08:47:07Z

<p><span class="autocomment">See Also: </span> whoops.</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:47, 23 July 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l134">Line 134:</td> <td colspan="2" class="diff-lineno">Line 134:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==See Also==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==See Also==</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>The Code is here [[<del style="font-weight: bold; text-decoration: none;">Lmce_game_update</del>]].</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>The Code is here [[<ins style="font-weight: bold; text-decoration: none;">Lmce_media_update</ins>]].</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This code is used in GAMEROM.cpp/.h in src/UpdateMedia. Take a look to see the other side of the equation. Wiki link here: [[Gamerom]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This code is used in GAMEROM.cpp/.h in src/UpdateMedia. Take a look to see the other side of the equation. Wiki link here: [[Gamerom]]</div></td></tr> </table>

Tschak909 http://wiki.linuxmce.org/index.php?title=Sql2cpp_example&diff=20002&oldid=prev 2009-07-23T08:46:26Z

<p><span class="autocomment">See Also: </span> Linkage.</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:46, 23 July 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l133">Line 133:</td> <td colspan="2" class="diff-lineno">Line 133:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==See Also==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==See Also==</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">The Code is here [[Lmce_game_update]].</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This code is used in GAMEROM.cpp/.h in src/UpdateMedia. Take a look to see the other side of the equation. Wiki link here: [[Gamerom]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>This code is used in GAMEROM.cpp/.h in src/UpdateMedia. Take a look to see the other side of the equation. Wiki link here: [[Gamerom]]</div></td></tr> </table>

Tschak909 http://wiki.linuxmce.org/index.php?title=Sql2cpp_example&diff=20001&oldid=prev 2009-07-23T08:45:34Z

<p>Category addition.</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">←Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 08:45, 23 July 2009</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l139">Line 139:</td> <td colspan="2" class="diff-lineno">Line 139:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-Thom</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>-Thom</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">[[Category:Programmer's Guide]]</ins></div></td></tr> </table>

Tschak909 http://wiki.linuxmce.org/index.php?title=Sql2cpp_example&diff=19994&oldid=prev 2009-07-23T08:32:08Z

<p>Initial Content.</p> <p><b>New page</b></p><div>==Rationale==<br /> I needed to create a small utility to update the lmce_game metadata database when new versions of MAME were released.<br /> <br /> ==Where To Get the code==<br /> I have placed the code in src/lmce_media_update in the LinuxMCE-0810 source tree, and have it cut and paste into the wiki here:<br /> [[Lmce_media_update]]<br /> <br /> The code to read this has been placed here:<br /> [[Gamerom]]<br /> <br /> ==Explanation of Table Schema==<br /> Currently the lmce_game database stores simple attribute metadata for a series of ROMs using a schema pattern similar to pluto_media where the central tables are Rom, RomAttribute, and Rom_RomAttribute, creating essentially a Has and Belongs to many Pattern (HABTM)<br /> <br /> &lt;pre&gt;<br /> mysql&gt; show tables;<br /> +---------------------+<br /> | Tables_in_lmce_game |<br /> +---------------------+<br /> | GameSystem | <br /> | Rom | <br /> | RomAttribute | <br /> | RomAttributeType | <br /> | Rom_RomAttribute | <br /> | psc_game_batdet | <br /> | psc_game_bathdr | <br /> | psc_game_batuser | <br /> | psc_game_repset | <br /> | psc_game_schema | <br /> | psc_game_tables | <br /> +---------------------+<br /> 11 rows in set (0.00 sec)<br /> &lt;/pre&gt;<br /> ===Note about the psc tables===<br /> The psc_ tables were created by sqlCVS when I told it to create a new repository in the database to hold history data. same for any psc_tables in the database, lmce_game_update is unaware of them, and does not touch them at all.<br /> <br /> ===The Rom Table===<br /> &lt;pre&gt;<br /> mysql&gt; explain Rom;<br /> +---------------+--------------+------+-----+-------------------+----------------+<br /> | Field | Type | Null | Key | Default | Extra |<br /> +---------------+--------------+------+-----+-------------------+----------------+<br /> | PK_Rom | int(11) | NO | PRI | NULL | auto_increment | <br /> | FK_GameSystem | int(11) | NO | MUL | NULL | | <br /> | Romname | varchar(255) | YES | | NULL | | <br /> | psc_id | int(11) | YES | | NULL | | <br /> | psc_batch | int(11) | YES | | NULL | | <br /> | psc_user | int(11) | YES | | NULL | | <br /> | psc_frozen | tinyint(1) | YES | | 0 | | <br /> | psc_mod | timestamp | NO | | CURRENT_TIMESTAMP | | <br /> | psc_restrict | int(11) | YES | | NULL | | <br /> +---------------+--------------+------+-----+-------------------+----------------+<br /> 9 rows in set (0.00 sec)<br /> <br /> mysql&gt; <br /> &lt;/pre&gt;<br /> <br /> The Rom table simply contains filenames, and maps them to PK_Rom entries.<br /> <br /> ===The RomAttribute Table===<br /> &lt;pre&gt;<br /> mysql&gt; explain RomAttribute;<br /> +---------------------+------------+------+-----+-------------------+----------------+<br /> | Field | Type | Null | Key | Default | Extra |<br /> +---------------------+------------+------+-----+-------------------+----------------+<br /> | PK_RomAttribute | int(11) | NO | PRI | NULL | auto_increment | <br /> | FK_RomAttributeType | int(11) | NO | MUL | NULL | | <br /> | FK_GameSystem | int(11) | NO | | NULL | | <br /> | Name | longtext | YES | | NULL | | <br /> | psc_id | int(11) | YES | | NULL | | <br /> | psc_batch | int(11) | YES | | NULL | | <br /> | psc_user | int(11) | YES | | NULL | | <br /> | psc_frozen | tinyint(1) | YES | | 0 | | <br /> | psc_mod | timestamp | NO | | CURRENT_TIMESTAMP | | <br /> | psc_restrict | int(11) | YES | | NULL | | <br /> +---------------------+------------+------+-----+-------------------+----------------+<br /> 10 rows in set (0.00 sec)<br /> &lt;/pre&gt;<br /> <br /> Similar for attributes, we simply store single attributes, and map them to PK_Attributes. <br /> ==== A Note about Foreign Keys and the related RomAttributeType table. ====<br /> Notice FK_AttributeType? That&#039;s a foreign key.<br /> There is an AttributeType table which simply contains:<br /> <br /> &lt;pre&gt;<br /> mysql&gt; select * from RomAttributeType;<br /> +---------------------+--------------+--------------+-------------+---- ----+-----------+----------+------------+---------------------+--------------+<br /> | PK_RomAttributeType | Define | Description | PicPriority | psc_id | psc_batch | psc_user | psc_frozen | psc_mod | psc_restrict |<br /> +---------------------+--------------+--------------+-------------+--------+-----------+----------+------------+---------------------+--------------+<br /> | 1 | title | Title | NULL | 1 | NULL | NULL | 0 | 0000-00-00 00:00:00 | NULL | <br /> | 2 | year | Year | NULL | 2 | NULL | NULL | 0 | 0000-00-00 00:00:00 | NULL | <br /> | 3 | manufacturer | Manufacturer | NULL | 3 | NULL | NULL | 0 | 0000-00-00 00:00:00 | NULL | <br /> | 4 | genre | Genre | NULL | 4 | NULL | NULL | 0 | 0000-00-00 00:00:00 | NULL | <br /> +---------------------+--------------+--------------+-------------+--------+-----------+----------+------------+---------------------+--------------+<br /> &lt;/pre&gt;<br /> <br /> This table isn&#039;t really used by lmce_update directly. Instead, when sql2cpp was run to generate the lmce_game class, there was a Define_RomAttributeType.h file, which contains among other things:<br /> <br /> &lt;pre&gt;<br /> #define ROMATTRIBUTETYPE_title_CONST 1<br /> #define ROMATTRIBUTETYPE_year_CONST 2<br /> #define ROMATTRIBUTETYPE_manufacturer_CONST 3<br /> #define ROMATTRIBUTETYPE_genre_CONST 4<br /> &lt;/pre&gt;<br /> <br /> this is referenced in the code to provide a consistent way to put human readable constant names to the different attribute type integers.<br /> <br /> And finally to join the Roms and RomAttributes together, there is the Rom_RomAttribute Table, which really only has two real columns:<br /> <br /> ===The Join Table: Rom_RomAttribute===<br /> <br /> &lt;pre&gt;<br /> mysql&gt; explain Rom_RomAttribute;<br /> +-----------------+------------+------+-----+-------------------+-------+<br /> | Field | Type | Null | Key | Default | Extra |<br /> +-----------------+------------+------+-----+-------------------+-------+<br /> | FK_Rom | int(11) | NO | PRI | NULL | | <br /> | FK_RomAttribute | int(11) | NO | PRI | NULL | | <br /> | psc_id | int(11) | YES | | NULL | | <br /> | psc_batch | int(11) | YES | | NULL | | <br /> | psc_user | int(11) | YES | | NULL | | <br /> | psc_frozen | tinyint(1) | YES | | 0 | | <br /> | psc_mod | timestamp | NO | | CURRENT_TIMESTAMP | | <br /> | psc_restrict | int(11) | YES | | NULL | | <br /> +-----------------+------------+------+-----+-------------------+-------+<br /> 8 rows in set (0.00 sec)<br /> &lt;/pre&gt;<br /> <br /> Joining a Rom key, and a RomAttribute key.<br /> <br /> ====sql2cpp Naming Conventions and their relationship to different keys====<br /> <br /> If you use these naming conventions, PK_ for primary key, FK_ for Foreign Key, and EK_ for External Key, sql2cpp will take these, and build C++ code to be able to link between them.<br /> <br /> ==See Also==<br /> <br /> This code is used in GAMEROM.cpp/.h in src/UpdateMedia. Take a look to see the other side of the equation. Wiki link here: [[Gamerom]]<br /> <br /> I hope this code shows some more of the tools used to build parts of this system.<br /> <br /> -Thom</div>

Tschak909