| /** | |
| * Register your own functionality | |
| */ | |
| (function(){ | |
| var mosql = require('mongo-sql'); | |
| mosql.registerQueryType( | |
| 'select1' | |
| , 'select {columns} from {table} {id} limit 1' | |
| ); | |
| mosql.registerQueryHelper( | |
| 'id' | |
| , function(id, values, query){ | |
| return ( 'where "' | |
| + query.table + '"."id" = $' | |
| + values.push( id ) | |
| ) | |
| } | |
| ); | |
| return { | |
| type: 'select1', | |
| table: 'users', | |
| id: 7 | |
| }; | |
| })() |