This is a generator of SQL commands to create a database about Arcade games.
It uses pugixml.
There is nothing special about the compilation. Compile everything with g++ -std=c+11 and include pugixml files.
./listing mamelist.xml fbalist.xml catlist.ini nplayers.ini
- mamelist.xml: Obtained from MAME by running the command:
./mame -listxml > mamelist.xml - fbalist.xml: Obtained from FBA GUI.
- Catlist.ini: Download from here.
- nplayers.ini: Download from here.
It will output the results to stdout.
Using sqlite3:
cat sql/table.sql | sqlite3 database.db
./listing mamelist.xml fbalist.xml catlist.ini nplayers.ini | sqlite3 database.db
You can use sqlitebrowser. It is a GUI for sqlite.
See the file sql/table.sql to see some queries.