A background process to periodically poll trademe and store data in MySQL dtabase.
These are all repeatable at present and are for dev/test purposes only.
- Create user and database
cd inserter
mysql -p < create_trademe_db.sql
- Create lookup data tables
mysql -u trademe_app -p trademe < create_localities_table.sql
- Create fact table
mysql -u trademe_app -p trademe < create_residential_table.sql
- Run lookup inserter
npm install
node localities_setup.js
- Run fact inserter (Does not get all records yet)
node insert_data.js
For now that should be get enough data to run the web graphs app off.
A nodejs express http server to process to get data from database and display as web pages.