aergonus/eeit

Electrical Engineering Inventory Tracker

eeit's Issues

Promises?

Should we use promises or callbacks?

Graceful Handling of SQL/Jade Errors

Write case statements for returned err instead of quitting.
Perhaps use try catch blocks to handle.

        if (err) {
            res.status(400).send(err);
        }
        res.status(200).send(rows);

https://www.npmjs.com/package/mysql#timeouts
https://www.npmjs.com/package/mysql#error-handling
https://github.com/mysqljs/mysql#error-handling

Pooling solves connection blowup?

Run Tests

Test high concurrency access with Siege. See here This might be cool for the demo?
Something something unit tests?

Raw Data Formatting

In order to load data into our database efficiently, we have to reformat everything to CSVs. Ideally the eeit_schema_gen script should only need to be run once to create the schema and load all the data from local files.

Possible issues:

• Columns must be aligned to tables within the database to load perhaps use library but prefer native SQL
• Foreign keys must match up which can be done programmatically