Notes

// #define function NOM_LOG_MSG(dev, msg) { if(dev === 'dev') { result = "console.log('dev: %s', msg)"; return result; } }
// #put NOM_LOG_MSG('dev', "hello, boobies~!")+';'

// #define DEBUG_NODE_APP=1
// #define function HELLO_MSG(msg) { return msg; }
// #if DEBUG_NODE_APP==1
// #put HELLO_MSG('var note = { msg: "hello, boobies~!" }')+';'
// #put HELLO_MSG('console.log(note);')+';'
// #endif

// #define PI=Math.PI
// #define function RADTODEG(x){return x*180/PI}
var angle = // #put RADTODEG(3)+";"

// #include "lib/stub.js"
// #include "lib/db.js"

# Install site build dependencies
npm install -g grunt-cli
gem install sass

# Install app dependencies
npm install

mysqlimport --fields-optionally-enclosed-by="\"" --fields-terminated-by=',' \
--lines-terminated-by="\n" --user=blew -p IR jobs.csv

# TODO: Test passing of NULL params on everything

# List all jobs
curl -i -X GET -d rpc='{"method":"list_pr","params":{}}' http://localhost:3000/api/jobs

# List specific job
curl -i -X GET -d rpc='{"method":"list_pr","params":{"pid":"1"}}' http://localhost:3000/api/jobs

# List jobs by their status
curl -i -X GET -d rpc='{"method":"list_pr","params":{"status":2}}' http://localhost:3000/api/jobs/

# Create a job
curl -i -X POST -d rpc='{"method":"create_job","params":{"jobnum": "15-555", "client": "jeff", "status":"2"}}' http://localhost:3000/api/jobs

# Update job
curl -i -X PUT -d rpc='{"method":"update_pr","params":{"pid":"5","jobnum":"15-601","status":"1"}}' http://localhost:3000/api/jobs

# Delete a job
curl -i -X DELETE -d rpc='{"method":"delete_job","params":{"pid": 6}}' http://localhost:3000/api/jobs

# Search jobs
curl -i -X GET -d rpc='{"method":"search","params":{ "query": "devilman"}}' http://localhost:3000/api/search

# Search jobs; test FULLTEXT AND, NOT operator
curl -i -X GET -d rpc='{"method":"search","params":{ "query": "-devilman +square"}}' http://localhost:3000/api/search

# Search jobs; test wildcard operator
curl -i -X GET -d rpc='{"method":"search","params":{ "query": "dev*"}}' http://localhost:3000/api/search

# TODO: test FULLTEXT AND operator
# TODO: test FULLTEXT OR operator

# List all users
curl -i -X GET -d '{"params":{}}' http://scorpio.local:3000/api/v1/jobs

# List user by ID
curl -i -X GET -d rpc='{"method":"list_users","params":{ "uid": "admin"}}' http://localhost:3000/api/users/

curl -i -X GET -d rpc='{"method":"list_users","params":{ "uid": "testme_ipv6", "ip": "192.168.151.200"}}' http://scorpio.local:3000/api/users/

# Create user
curl -i -X POST -d rpc='{"method":"create_user","params":{ "uid": "testme", "password": "boobies", "ip": "192.168.151.126" }}' http://scorpio.local:3000/api/users/create/

curl -i -X POST -d rpc='{"method":"create_user","params":{ "uid": "testme_ipv6", "password": "boobies" }}' http://scorpio.local:3000/api/users/create/

# Update user
curl -i -X PUT -d rpc='{"params":{ "user_id": "testme", "password": "boobies"}}' http://scorpio.local:3000/api/users/

# Delete user
curl -i -X DELETE -d rpc='{"method":"delete_user","params":{"uid": "testme"}}' http://scorpio.local:3000/api/users/

curl -i -X DELETE -d rpc='{"method":"delete_user","params":{"uid": "testme_ipv6"}}' http://scorpio.local:3000/api/users/

# TODO: test duplicate user_id

TODO

Optimizations

See DBISam: Optimizations

Unsupported ANSI SQL elements

ALLOCATE CURSOR (Command) ALLOCATE DESCRIPTOR (Command) ALTER DOMAIN (Command) CHECK (Constraint) CLOSE (Command) CONNECT (Command) CONVERT (Function) CORRESPONDING BY (Expression) CREATE ASSERTION (Command) CREATE CHARACTER SET (Command) CREATE COLLATION (Command) CREATE DOMAIN (Command) CREATE SCHEMA (Command) CREATE TRANSLATION (Command) CREATE VIEW (Command) CROSS JOIN (Relational operator) DEALLOCATE DESCRIPTOR (Command) DEALLOCATE PREPARE (Command) DECLARE CURSOR (Command) DECLARE LOCAL TEMPORARY TABLE (Command) DESCRIBE (Command) DISCONNECT (Command) DROP ASSERTION (Command) DROP CHARACTER SET (Command) DROP COLLATION (Command) DROP DOMAIN (Command) DROP SCHEMA (Command) DROP TRANSLATION (Command) DROP VIEW (Command) EXECUTE (Command) EXECUTE IMMEDIATE (Command) FETCH (Command) FOREIGN KEY (Constraint) GET DESCRIPTOR (Command) GET DIAGNOSTICS (Command) GRANT (Command) MATCH (Predicate) NATURAL (Relational operator) NULLIF (Expression) OPEN (Command) OVERLAPS (Predicate) PREPARE (Command) REFERENCES (Constraint) REVOKE (Command) SET CATALOG (Command) SET CONNECTION (Command) SET CONSTRAINTS MODE (Command) SET DESCRIPTOR (Command) SET NAMES (Command) SET SCHEMA (Command) SET SESSION AUTHORIZATION (Command) SET TIME ZONE (Command) SET TRANSACTION (Command) TRANSLATE (Function) USING (Relational operator)

References

DBISam: SQL Reference

DBISam: Unsupported SQL

Architecture

api/contacts cid (client_id) cname (Company;LName;FName)

api/properties pid (property_id) cid (client_id) jobnum

api/users uid (user_id) uname (user_name)

POST http://localhost:3001/api/status GET http://localhost:3001/api/status GET http://localhost:3001/api/status/:property_id PUT http://localhost:3001/api/status/:property_id DELETE http://localhost:3001/api/status/:property_id

POST http://localhost:3001/api/contacts GET http://localhost:3001/api/contacts GET http://localhost:3001/api/contacts/:contact_id PUT http://localhost:3001/api/contacts/:contact_id DELETE http://localhost:3001/api/contacts/:contact_id

POST http://localhost:3001/api/properties GET http://localhost:3001/api/properties GET http://localhost:3001/api/properties/:property_id PUT http://localhost:3001/api/properties/:property_id DELETE http://localhost:3001/api/properties/:property_id

POST http://localhost:3001/api/users GET http://localhost:3001/api/users GET http://localhost:3001/api/users/:user_id PUT http://localhost:3001/api/users/:user_id DELETE http://localhost:3001/api/users/:user_id