{"_id":"loopback-connector-sqlite3","_rev":"301-33296a7a9e189984a1e10f90a6935f56","name":"loopback-connector-sqlite3","dist-tags":{"latest":"3.0.0"},"versions":{"1.0.0":{"name":"loopback-connector-sqlite3","version":"1.0.0","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/blob/master/LICENSE","name":"Dual Artistic-2.0/StrongLoop"},"_id":"loopback-connector-sqlite3@1.0.0","maintainers":[{"name":"kraman","email":"kraman@strongloop.com"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"d6967a9fef77cf46bc415491924955dd130acf12","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-1.0.0.tgz","integrity":"sha512-st9XIfho6BeutKE0MM0YXZpc7oMrVeA0PePJnorXyp8mnObQ2q1ovArNYEDXtwQb5Sl++OZO3jCd5HeOtjM+pg==","signatures":[{"sig":"MEYCIQCW9jfdmI0GkJOQ6W5Wv86Fohj2AS9biVCSsD8JWCSMGgIhAOBFOCBUTmOt8iWPopAS5PMNPGnc2s1z76uEYckU6cXl","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"d6967a9fef77cf46bc415491924955dd130acf12","gitHead":"911ae28850bf73a367dff0865d95575aee753952","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"kraman","email":"kraman@strongloop.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"2.10.1","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"0.12.4","dependencies":{"async":"^0.9.0","debug":"^2.1.1","moment":"^2.10.3","sl-blip":"http://blip.strongloop.com/loopback-connector-sqlite3@1.0.0","sqlite3":"^3.0.6","loopback-connector":"2.x"},"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^2.1.0","eslint":"^0.23.0","should":"^5.0.0","bluebird":"^2.9.12","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^2.17.0"},"optionalDependencies":{"sl-blip":"http://blip.strongloop.com/loopback-connector-sqlite3@1.0.0"}},"1.0.2":{"name":"loopback-connector-sqlite3","version":"1.0.2","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/blob/master/LICENSE","name":"Dual Artistic-2.0/StrongLoop"},"_id":"loopback-connector-sqlite3@1.0.2","maintainers":[{"name":"kraman","email":"kraman@strongloop.com"},{"name":"strongloop","email":"callback@strongloop.com"},{"name":"octet","email":"sam@strongloop.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"bajtos","email":"miro.bajtos@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"452866770339683e8e6defae2f71003d59f946a8","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-1.0.2.tgz","integrity":"sha512-M8j/K+I32Ui7eP5xSwpEMNqrTClcSbVf0+KnuN6dTAKpAcVnlQ+lPxD+VXQKS5ARbO3NMcYFSoOZ7H11Ua/nlA==","signatures":[{"sig":"MEUCIQC1XTUeqIbcv5105JQewAAt9PqLIE4tUFqtlO8i9dnKhQIgLT/hCQfoeFL4U9audP7r07ME8+88AQFCV6qjLWG2Bts=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"452866770339683e8e6defae2f71003d59f946a8","gitHead":"e3ce30b4d67c211db11b82e3eb524eed3a7154ee","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"kraman","email":"kraman@strongloop.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"2.11.3","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"0.12.7","dependencies":{"async":"^0.9.0","debug":"^2.1.1","moment":"^2.10.3","sl-blip":"http://blip.strongloop.com/loopback-connector-sqlite3@1.0.2","sqlite3":"^3.0.6","loopback-connector":"2.x"},"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^2.1.0","eslint":"^0.23.0","should":"^5.0.0","bluebird":"^2.9.12","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^2.17.0"},"optionalDependencies":{"sl-blip":"http://blip.strongloop.com/loopback-connector-sqlite3@1.0.2"}},"1.1.1":{"name":"loopback-connector-sqlite3","version":"1.1.1","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":"Artistic-2.0","_id":"loopback-connector-sqlite3@1.1.1","maintainers":[{"name":"kraman","email":"kraman@strongloop.com"},{"name":"strongloop","email":"callback@strongloop.com"},{"name":"octet","email":"sam@strongloop.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"bajtos","email":"miro.bajtos@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"dfdc15a238067a77c9ca9383ff195965f72e9c66","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-1.1.1.tgz","integrity":"sha512-8APUbISB2ZfOR1KTlbH3DiVKBC1M4UpT7rMsCFQSbspPHRirbz0G/IITHImR+fGYrt9MRSHAX65FAwinIAyt0Q==","signatures":[{"sig":"MEUCIARgGPbVeOgA1vNfmtrIUigRtXKvACng6Bm41irnspz0AiEAxWTkI4J/QQdBw/exOx1ZrwDGxv4GXInd2O85rXViJX0=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"dfdc15a238067a77c9ca9383ff195965f72e9c66","gitHead":"cc5b9cd7ce815465d3ab664d2c972b657d176464","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"bajtos","email":"mbajtoss@gmail.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"2.14.12","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"4.3.0","dependencies":{"async":"^0.9.0","debug":"^2.1.1","moment":"^2.10.3","sqlite3":"^3.1.0","loopback-connector":"2.x"},"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^2.1.0","eslint":"^0.23.0","should":"^8.0.2","bluebird":"^2.9.12","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^2.17.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-sqlite3-1.1.1.tgz_1455881221886_0.34294119058176875","host":"packages-6-west.internal.npmjs.com"}},"1.1.2":{"name":"loopback-connector-sqlite3","version":"1.1.2","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":"Artistic-2.0","_id":"loopback-connector-sqlite3@1.1.2","maintainers":[{"name":"bajtos","email":"mbajtoss@gmail.com"},{"name":"chandadharap","email":"chanda_dharap@yahoo.com"},{"name":"ibmcloud-admin","email":"rmg@ca.ibm.com"},{"name":"kraman","email":"kraman@gmail.com"},{"name":"octet","email":"vieuxtech@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"strongloop","email":"strngops@us.ibm.com"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"a874183d0a5491ae3599ba070cf7b3e52972b527","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-1.1.2.tgz","integrity":"sha512-VUwZ0g8Y9BoI+vh7vDggkZIxqlkP8WA0L8AwjtR5kynX6n4MrJCE2MNQhtozju5r1oOLl1I95eiWkX7hoDOILg==","signatures":[{"sig":"MEQCIGMyKFaCBS3bTuk0seWoGzUlvHhNTRXoIQXGIJRFYoqdAiAz3w90efN7eCKcknRgzSxlVFsQbGyza6Npk2jw0F6ukQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"a874183d0a5491ae3599ba070cf7b3e52972b527","gitHead":"201636298b7028ab823679900e73ab7b46367d44","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"rmg","email":"r.m.graham@gmail.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"3.8.8","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"4.4.3","dependencies":{"async":"^0.9.0","debug":"^2.1.1","moment":"^2.10.3","sqlite3":"^3.1.0","loopback-connector":"2.x"},"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^2.1.0","eslint":"^0.23.0","should":"^8.0.2","bluebird":"^2.9.12","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^2.17.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-sqlite3-1.1.2.tgz_1462576650157_0.20065334788523614","host":"packages-16-east.internal.npmjs.com"}},"1.2.0":{"name":"loopback-connector-sqlite3","version":"1.2.0","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":"Artistic-2.0","_id":"loopback-connector-sqlite3@1.2.0","maintainers":[{"name":"bajtos","email":"mbajtoss@gmail.com"},{"name":"chandadharap","email":"chanda_dharap@yahoo.com"},{"name":"ibmcloud-admin","email":"rmg@ca.ibm.com"},{"name":"kraman","email":"kraman@gmail.com"},{"name":"octet","email":"vieuxtech@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"setogit","email":"setogit@gmail.com"},{"name":"strongloop","email":"strngops@us.ibm.com"},{"name":"superkhau","email":"superkhau@gmail.com"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"3cbe45779fc663626b9b141e3374c6866d15bf1c","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-1.2.0.tgz","integrity":"sha512-NdnE7V8KSqLWClx9NoMZEmBy4VdgJ33sNPcYadvEyivtHN0US8Q6lEon9K1IsHdQs4JnQkrmDzreqgwOoxUlXQ==","signatures":[{"sig":"MEUCIAXQW+LPMIF7g3CG21tQxxEmirYzikBeEqsBLrlYh/fPAiEAji1J84vxYEdO1Amy4LNZKdwbb0teRCeiNdSOiGblatQ=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"index.js","_from":".","_shasum":"3cbe45779fc663626b9b141e3374c6866d15bf1c","gitHead":"8d945fdfee419aad574075489030fa4c0158a5cc","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"bajtos","email":"mbajtoss@gmail.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"3.10.3","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"6.6.0","dependencies":{"async":"^0.9.0","debug":"^2.1.1","moment":"^2.10.3","sqlite3":"^3.1.0","strong-globalize":"^2.6.2","loopback-connector":"2.x"},"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^2.1.0","eslint":"^0.23.0","should":"^8.0.2","bluebird":"^2.9.12","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^3.0.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-sqlite3-1.2.0.tgz_1476202083960_0.7127279464621097","host":"packages-16-east.internal.npmjs.com"}},"3.0.0":{"name":"loopback-connector-sqlite3","version":"3.0.0","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"license":"Artistic-2.0","_id":"loopback-connector-sqlite3@3.0.0","maintainers":[{"name":"0candy","email":"ngcandy@ca.ibm.com"},{"name":"amir-61","email":"amirali.jfr61@gmail.com"},{"name":"b-admike","email":"binadmt@hotmail.com"},{"name":"bajtos","email":"mbajtoss@gmail.com"},{"name":"davidcheung","email":"davidcheung@live.ca"},{"name":"dhmlau","email":"dianahmlau@gmail.com"},{"name":"hacksparrow","email":"captain@hacksparrow.com"},{"name":"jannyhou2016","email":"juehou@ca.ibm.com"},{"name":"kjdelisle","email":"kjdelisle@gmail.com"},{"name":"kraman","email":"kraman@gmail.com"},{"name":"mahesh.patsute","email":"mahesh.patsute@ibm.com"},{"name":"qpresley","email":"qpresley@ca.ibm.com"},{"name":"rashmihunt","email":"rashmihunt@gmail.com"},{"name":"rfeng","email":"enjoyjava@gmail.com"},{"name":"ritch","email":"skawful@gmail.com"},{"name":"rmg","email":"r.m.graham@gmail.com"},{"name":"superkhau","email":"superkhau@gmail.com"},{"name":"thegman","email":"gpandya@live.com"},{"name":"tonyf-ibm","email":"tffrench@us.ibm.com"},{"name":"virkt25","email":"taranveer@virk.cc"}],"homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"dist":{"shasum":"f7881e6f4b135675acf4199d8b69c01d37bf6a95","tarball":"https://registry.npmjs.org/loopback-connector-sqlite3/-/loopback-connector-sqlite3-3.0.0.tgz","fileCount":29,"integrity":"sha512-rDQVy952mnIlhFM1NCqfZ8YyF/NWujKkjG60YZAdP82qszVcqOdQ/4a1rZP2RC5Bgh36CwrYdapf6IP8oAi8RA==","signatures":[{"sig":"MEQCIFTND29LHV3ScPegdv0qToIPStxiZNj6eHc7nUrMSbWLAiAxxB6EfUu8l/det4Dj7mpVH3u9QdAHW4TYarzzgfVWyg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":56655,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbhC5KCRA9TVsSAnZWagAAbW0QAIeulT/Xx2Xp6RN4AWjC\nDowO3BXTXdtGI1yCcSp+bVTXC7/Q+fEzJkyeytnvJAnPp3izSS2sAPMrFUrt\n+H1ZPzbmx03/OdMkz0r7ffhJ4FetW0fhywIebMJZzdV+J4LLr5XWUEP5rCQ1\njr+ZCJNH93oMlYBZz1JcIH5QJKDklRU7e5gOopguvQKrUNbO0tVkZbOz/n+L\nhUXXG+yR1AA1T/kVlNg3VVdlCWYqctZKTh2h/kB7d1zd2WBPM3aZj3iIQXhq\nfc8+rNMdGXBowM/pWA1BmqejDmh4+xNhVlz+2bR4nB8zecpz/Ge8CFsvdy0Z\n98ysMzm0zP7MwKlq3ef9JftgtXU4cNCfBrgtLp5V4mEI/shPiOeCDrSpj+qP\n4HU3D3s6trbXlMRUQVdOIq7OiWqH8c2lwWcKWuI7uH8M3wsURnn8Y8nIpyF0\nLUXQ6v2n5CSzrL4L+sYyjXIUzXmewEibukHcU+g+NDqxY5qNHRm3nsbws89b\nhgYIbm6FO+UTiJIYD5Smb0utJ9ilL8Ny+FTcdfvwBcyuvKMoW+lK/q/aNoZB\nTYEk07eerV0uGXB1z8LPLo0V5M7923xjHo8A5n9AsaEz8J++nClGYyoNS22j\nEFWtC0+N6eItqh3XVDBRLTRjUo85LC7mOb3DdqhIZErS3Dj0u1hSCgq/R4FW\noI1F\r\n=BiEB\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","engines":{"node":">=4"},"gitHead":"51a165d306a9e2ef8e052ffe9e8286cbdde87f42","scripts":{"lint":"eslint ./ && jscs ./","test":"mocha -R spec -b --timeout 10000 --require test/init.js test/*.test.js","pretest":"eslint ./ && jscs ./"},"_npmUser":{"name":"rfeng","email":"enjoyjava@gmail.com"},"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"_npmVersion":"6.4.0","description":"Loopback SQLite3 Connector","directories":{},"_nodeVersion":"8.10.0","dependencies":{"async":"^2.6.1","debug":"^3.1.0","moment":"^2.10.3","sqlite3":"^4.0.2","strong-globalize":"^4.1.1","loopback-connector":"^4.5.1"},"_hasShrinkwrap":false,"devDependencies":{"rc":"^1.0.0","jscs":"^1.13.1","mocha":"^5.2.0","eslint":"^0.23.0","should":"^8.0.2","bluebird":"^3.5.1","mktmpdir":"^0.1.1","loopback-datasource-juggler":"^3.0.0"},"_npmOperationalInternal":{"tmp":"tmp/loopback-connector-sqlite3_3.0.0_1535389257808_0.010942031063821522","host":"s3://npm-registry-packages"}}},"time":{"created":"2015-07-21T22:59:41.464Z","modified":"2024-07-09T12:43:28.114Z","1.0.0":"2015-07-21T22:59:41.464Z","1.0.2":"2015-08-21T18:37:58.687Z","1.1.0":"2016-02-19T11:22:50.416Z","1.1.1":"2016-02-19T11:27:06.250Z","1.1.2":"2016-05-06T23:17:33.271Z","1.2.0":"2016-10-11T16:08:04.493Z","3.0.0":"2018-08-27T17:00:57.931Z"},"bugs":{"url":"https://github.com/strongloop/loopback-connector-sqlite3/issues"},"license":"Artistic-2.0","homepage":"https://github.com/strongloop/loopback-connector-sqlite3#readme","keywords":["StrongLoop","LoopBack","SQLite","SQLite3","DataSource","Connector"],"repository":{"url":"git+https://github.com/strongloop/loopback-connector-sqlite3.git","type":"git"},"description":"Loopback SQLite3 Connector","maintainers":[{"email":"enjoyjava@gmail.com","name":"rfeng"},{"email":"r.m.graham@gmail.com","name":"rmg"},{"email":"dianahmlau@gmail.com","name":"dhmlau"},{"email":"jgorzinski@gmail.com","name":"theprez"},{"email":"frbuceta@gmail.com","name":"frbuceta"},{"email":"marioestradarosa@yahoo.com","name":"marioestradarosa"},{"email":"Vn7WbcdkHEmkHHpPCoKf@achrinza.com","name":"achrinza"},{"email":"skawful@gmail.com","name":"ritch"},{"email":"captain@hacksparrow.com","name":"hacksparrow"},{"email":"superkhau@gmail.com","name":"superkhau"},{"email":"kraman@gmail.com","name":"kraman"},{"email":"gpandya@live.com","name":"thegman"},{"email":"davidcheung@live.ca","name":"davidcheung"},{"email":"tffrench@us.ibm.com","name":"tonyf-ibm"},{"email":"ngcandy@ca.ibm.com","name":"0candy"},{"email":"qpresley@ca.ibm.com","name":"qpresley"},{"email":"amirali.jfr61@gmail.com","name":"amir-61"},{"email":"juehou@ca.ibm.com","name":"jannyhou2016"},{"email":"rashmihunt@gmail.com","name":"rashmihunt"},{"email":"mahesh.patsute@ibm.com","name":"mahesh.patsute"},{"email":"taranveer@virk.cc","name":"virkt25"}],"readme":"# loopback-connector-sqlite3\n\n[SQLite](https://sqlite.org/) is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. This is the official SQLite3 connector module for the LoopBack framework.\n\n## Installation\n\nEnter the following in the top-level directory of your LoopBack application:\n\n```\n$ npm install loopback-connector-sqlite3 --save\n```\n\nThe `--save` option adds the dependency to the application's `package.json` file.\n\n## Connector settings\n\nConfigure the connector with the following data source properties:\n\n* `file`: The path to the database file or `:memory:`\n* `debug`: Display debug information. Default is false.\n\nThe SQLite3 connector uses [node-sqlite3](https://github.com/mapbox/node-sqlite3) as the driver.\n\n## Model definition for SQLite3\n\nThe model definition consists of the following properties:\n\n* name: Name of the model, by default, it's the camel case of the table\n* properties: Property definitions, including default value mapping\n\n```json\n\n    {\"name\": \"Inventory\", \"options\": {\n      \"idInjection\": false,\n    }, \"properties\": {\n      \"id\": {\n        \"type\": \"String\",\n        \"required\": false,\n        \"length\": 64,\n        \"precision\": null,\n        \"scale\": null\n      },\n      \"productId\": {\n        \"type\": \"String\",\n        \"required\": false,\n        \"length\": 20,\n        \"precision\": null,\n        \"scale\": null,\n        \"id\": 1\n      },\n      \"locationId\": {\n        \"type\": \"String\",\n        \"required\": false,\n        \"length\": 20,\n        \"precision\": null,\n        \"scale\": null,\n        \"id\": 1\n      },\n      \"available\": {\n        \"type\": \"Number\",\n        \"required\": false,\n        \"length\": null,\n        \"precision\": 32,\n        \"scale\": 0\n      },\n      \"total\": {\n        \"type\": \"Number\",\n        \"required\": false,\n        \"length\": null,\n        \"precision\": 32,\n        \"scale\": 0\n      },\n      \"createdOn\": {\n       \"type\": \"Date\",\n        \"required\": false,\n        \"sqlite3\": {\n          \"dbDefault\": \"now\"\n        }\n      }\n    }}\n\n```\n\n## Type Mapping\n\n| LoopBack type | Mapped to SQLite3 type |\n|-----|-----|\n| Number| Primary key stored as INTEGER, others as REAL |\n| Boolean | INTEGER 1 or 0 |\n| Date | INTEGER (ms since Jan 01 1970 00:00:00 0000) |\n| String | ? |\n| Complex types: GeoPoint, Point, List, Array, Object, and sub-models | TEXT in JSON format |\n| JSON | TEXT |\n\nSQLite3 does not enforce types. Any data can be stored in any column regardless of definiton.\nThis connector attempts to check for invalid Date, Number and JSON types.\n\n## Unsupported features\n\n### Discovering Models\n\nThe SQLite3 connector does not currently support model discovery.\n\n### Auto Migrate / Auto Update\n\nThe SQLite3 connector does not currently support auto-migrate or auto-upgrade.\n\n## Running tests\n\nThe tests in this repository are mainly integration tests, meaning you will need\nto run them using our preconfigured test server.\n\n1. Ask a core developer for instructions on how to set up test server\n   credentials on your machine\n2. `npm test`\n","readmeFilename":"README.md","users":{"bpatel":true,"harry-sm":true}}