{"_id":"@arthemy-ai/lil-orm-pg","_rev":"8-0e58df4923ebd6d4d6d7045f64ba0cf6","name":"@arthemy-ai/lil-orm-pg","dist-tags":{"latest":"1.3.1"},"versions":{"1.1.0":{"name":"@arthemy-ai/lil-orm-pg","version":"1.1.0","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"a32340fb0e1f9b4b233277bc53198e93d8eece0f","_id":"@arthemy-ai/lil-orm-pg@1.1.0","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-ZTszg4kKsUocB4ZGI1LE3yI0R7kCVxWajyQmCCZM4hE9UVUmQlPsRGGcjhFKaK+TFfiatTMGdd3eEQE3OcANyw==","shasum":"42d4180daaa2a8cde45f4e2ee89f6971ee718a5a","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.1.0.tgz","fileCount":91,"unpackedSize":162105,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCLBuUzwrL/QPWm1WRjz3DrIBQQJWPAfGvVTikgPdTxHAIgS78jPzAmeNeDDgjRoOcHRGJNjqUpqCifVyLTrPXjSWI="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.1.0_1695051149037_0.28304012075257945"},"_hasShrinkwrap":false},"1.1.1":{"name":"@arthemy-ai/lil-orm-pg","version":"1.1.1","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"7cabe078260b80d724a7afbab416a978413b1ff1","_id":"@arthemy-ai/lil-orm-pg@1.1.1","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-cj14KBvLsR1jllgYJhnK6BF2lQ7+xogfGw8UHOA7exZrFCJTfVY0jr/tTfzxeqZnDi+9C1CNwhAmJZX+LFKoqA==","shasum":"fd44a07a064092fce258e974354ff8141f332309","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.1.1.tgz","fileCount":91,"unpackedSize":162176,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIGHEeFw9OQJRpmqqGaQm1xcvdho8Gt3e749NRuw057hkAiEA56TIL0jrI88AHtj+dfE2hiYlBigWPCk5LCXoVugwNAA="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.1.1_1695059241253_0.4857849138826589"},"_hasShrinkwrap":false},"1.1.2":{"name":"@arthemy-ai/lil-orm-pg","version":"1.1.2","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"f103e90d3d62ceb3f96be3d4f9300b2ba928f30e","_id":"@arthemy-ai/lil-orm-pg@1.1.2","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-BKrVP+R19SyY39PfHNNepSGdZgS1BZ0hT8Mo0Oqk93ryrI8JT3MJcbsc7n+9ZJw2nCiIeuMelxjyvH/1kHQo9w==","shasum":"f29b90cc6fed69a2074c2978da6c772b6b01f173","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.1.2.tgz","fileCount":91,"unpackedSize":162351,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIFmOkyEwHvEArNEbt3uec3usRbHqYvt8Sh1j2iof9tetAiEAhnXy9MjRw8d25Z/3gyqsug1XB3eyw+xHlvEyfpr025s="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.1.2_1696939983633_0.36106582097991846"},"_hasShrinkwrap":false},"1.1.3":{"name":"@arthemy-ai/lil-orm-pg","version":"1.1.3","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"66a77617311947980db2a85f74f42a03eead57e7","_id":"@arthemy-ai/lil-orm-pg@1.1.3","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-d4rps6KXmxp8SGvaiAJxsljCPKiALs290FBnZ3sXhSDtXwBNKczWbgubq/jjjtWpA3h4NiZi2+f+XWloNhfY/g==","shasum":"0832d9d725eb560acef186c89cc8ef4ae76a5b76","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.1.3.tgz","fileCount":91,"unpackedSize":162925,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDMTZAlBoGB/5238LJnc/gwcFRRcmEoIt+qIfKDKLpkkgIgAygTiULmTXltLdxQwi65z0JN/ozJxtguqDTW4EAd1ig="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.1.3_1697033462525_0.7309553918988125"},"_hasShrinkwrap":false},"1.2.0":{"name":"@arthemy-ai/lil-orm-pg","version":"1.2.0","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"c91f53adfbd596542f7f15574638bd84201667b8","_id":"@arthemy-ai/lil-orm-pg@1.2.0","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-UEwOHk0yWNuUDJ0jPmK6mdSzYDTTlsr937ygC3tUU+J2U9UhfeCsT6i/bu/ffc95OMrxU/kQDEpSe7VFZ45WWA==","shasum":"1b9d5343219869a0177cfbdf353e0ca79a459022","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.2.0.tgz","fileCount":91,"unpackedSize":163747,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEXC3YKrFVW/kcv47lv3PrCFtJoHFIVjE2VkO1LzpEdSAiEA5w0sb9JKMJYXxkIwA2T0KD8j6TWtnJgQqWfs7lnNU1U="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.2.0_1697544061887_0.02601928436353207"},"_hasShrinkwrap":false},"1.2.1":{"name":"@arthemy-ai/lil-orm-pg","version":"1.2.1","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"95d0c35be259dc558b28028c8efc9f3af49975d2","_id":"@arthemy-ai/lil-orm-pg@1.2.1","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-eAyqTYt2/NQLu7gyhkg+GFC6EfGCfVpCmUYN92+8u391B2frfWnNMqdjumyiwtPbty/tH5KkisL6ixzhqglI3A==","shasum":"e06dde8c5c02456fef9a64e706250251ce913e84","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.2.1.tgz","fileCount":91,"unpackedSize":164561,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDKHkRwBLGenPAqfLp6rrk2FrTMnlxheAX6Xt5dNEPJeAiBHfOBYTbCHUSWXeXQtU3DN0pNaoX8NXU79QywV/1Yn8g=="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.2.1_1699737774657_0.20155376976841888"},"_hasShrinkwrap":false},"1.2.2":{"name":"@arthemy-ai/lil-orm-pg","version":"1.2.2","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"ecdd2faac1a00bc1fe74f0dc464705bb4b43640f","_id":"@arthemy-ai/lil-orm-pg@1.2.2","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-eohsc2TtGB9K0G3kLSVk+ci09xeoQncC7psry3U+H2sDM4HKNknPrKFvW9qapWIE8ayZrvyoWcuecLog3naTYQ==","shasum":"c8d249806d003f5f1f6f28b8a4e9c41dff93c363","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.2.2.tgz","fileCount":91,"unpackedSize":164946,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDL0m5N3iDIRFkX18d+rzOGKLkQgIW6LbYdyBnSy6t+4wIgbmH4iJjH8kDjhIpgUVZNXrk5nKyEC6zRe+qgMsHMqR0="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.2.2_1702459822000_0.1254628285201973"},"_hasShrinkwrap":false},"1.3.0":{"name":"@arthemy-ai/lil-orm-pg","version":"1.3.0","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"9faec1f715164403544ef07e451a12d6a69ea830","_id":"@arthemy-ai/lil-orm-pg@1.3.0","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-cDEE9wD/okxE+Ys0ueFk8mempW9mVfbVdUiA6TIsWFapk1mmSmQtrtapbdR7CdumSWR3b2IjZg4gAoyE0WxlDA==","shasum":"83e203208a84e10627bd983801193e2a08b8a5cb","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.3.0.tgz","fileCount":91,"unpackedSize":164681,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCL2+QKzM6dCnsmiJuBeE3Brtd4F5o1doWoP8bS26SHmQIgavyBkDoYYAxk6Lrr9tny6iWnnA2BKFJYivgy2/9uwMM="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.3.0_1702461517258_0.7304286593152169"},"_hasShrinkwrap":false},"1.3.1":{"name":"@arthemy-ai/lil-orm-pg","version":"1.3.1","description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","main":"dist/src/index.js","types":"dist/src/index.d.ts","scripts":{"test":"jest --config jestconfig.json","build":"tsc","format":"prettier --write \"src/**/*.ts\" \"src/**/*.js\"","lint":"tslint -p tsconfig.json","prepare":"npm run build","prepublishOnly":"npm run lint","preversion":"npm run lint","version":"npm run format && git add -A src","postversion":"git push && git push --tags"},"keywords":[],"author":{"name":"Arthemy"},"license":"ISC","devDependencies":{"@types/jest":"^29.5.2","@types/pg":"^8.10.2","jest":"^29.5.0","prettier":"^2.8.8","ts-jest":"^29.1.0","tslint":"^6.1.3","tslint-config-prettier":"^1.18.0","typescript":"^5.1.3"},"dependencies":{"date-fns":"^2.30.0","pg":"^8.11.3","reflect-metadata":"^0.1.13","sqlite3":"^5.1.6"},"gitHead":"bf3c5fbc4b7d4a330770727ade09f0f693f4bee1","_id":"@arthemy-ai/lil-orm-pg@1.3.1","_nodeVersion":"16.20.2","_npmVersion":"8.19.4","dist":{"integrity":"sha512-wvcLYI14mvdsNk0g6kcNSCgvCO+hcT5JuxB0eslMl4TNIdgTPr7LpawRvZdRbuRrzUJLKIQU6HOyaMoFpa+XNA==","shasum":"a1d09542d048523640b06b7a3caa45f98060fa6d","tarball":"https://registry.npmjs.org/@arthemy-ai/lil-orm-pg/-/lil-orm-pg-1.3.1.tgz","fileCount":91,"unpackedSize":164661,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBsgnqhgwy2l+4rJpX8odbkRhqooZqy23EHaYS/7qZY5AiBAE3vh/WjmuONdHfvrDu8M0jOzh80LQTiRXMx8YZTOmg=="}]},"_npmUser":{"name":"arthemy","email":"a.castella@arthemy.ai"},"directories":{},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/lil-orm-pg_1.3.1_1702464806967_0.9335849794172217"},"_hasShrinkwrap":false}},"time":{"created":"2023-09-18T15:32:28.949Z","1.1.0":"2023-09-18T15:32:29.264Z","modified":"2023-12-13T10:53:27.443Z","1.1.1":"2023-09-18T17:47:21.523Z","1.1.2":"2023-10-10T12:13:03.926Z","1.1.3":"2023-10-11T14:11:02.751Z","1.2.0":"2023-10-17T12:01:02.172Z","1.2.1":"2023-11-11T21:22:54.820Z","1.2.2":"2023-12-13T09:30:22.363Z","1.3.0":"2023-12-13T09:58:37.611Z","1.3.1":"2023-12-13T10:53:27.209Z"},"maintainers":[{"name":"scassius","email":"scassillofrancesco@gmail.com"},{"name":"arthemy","email":"a.castella@arthemy.ai"}],"description":"Lil ORM is a super lightweight PostgreSQL ORM for Node.js. With its clear API, you can easily interact with PostgreSQL databases.","keywords":[],"author":{"name":"Arthemy"},"license":"ISC","readme":"![ORM](https://github.com/scassius/lil-orm/assets/35706430/5fd46412-ea3d-40b8-a56a-20450e9e2986)\n\n# Lil ORM\nLil ORM is a lightweight SQLite ORM designed for Node.js. This compact project prioritizes clarity and simplicity in its API, making it effortless to interact with SQLite databases. Although it's a lightweight ORM, it boasts a robust set of capabilities, letting developers create intricate database queries with ease.\n\nWhile Lil ORM is primarily intended as a learning resource and experimental project, its lean design and user-friendly approach make it a noteworthy tool for those looking to understand the nuances of building APIs without the complexity that often accompanies larger ORMs.\n\nPlease note: Lil ORM is currently not recommended for use in production environments (yet), but rather as a learning tool and sandbox for testing and development purposes\n\n⚠️ **API are subjected to change** ⚠️ \n\n# Install \n```shell\nnpm i lil-orm\n```\n\n# Define Entity\n```typescript\n@Entity('user')\nclass UserEntity {\n  @PrimaryKey({\n    autoIncrement: true,\n  })\n  @Column({\n    type: 'INTEGER',\n    name: 'id',\n  })\n  id: number;\n\n  @Column({\n    type: 'TEXT',\n    name: 'name',\n  })\n  name: string;\n\n  @Column({\n    type: 'TEXT',\n    name: 'email',\n  })\n  email: string;\n\n  @Column({\n    type: 'JSON',\n    name: 'config',\n  })\n  config: any;\n\n  @Column({\n    type: 'BOOLEAN',\n    name: 'is_active',\n  })\n  isActive: boolean;\n\n  @Column({\n    type: 'DATE',\n    name: 'created_at',\n  })\n  createdAt: Date;\n}\n```\nsupported types:\n - TEXT\n - INTEGER\n - REAL\n - BOOLEAN\n - DATE (ISO Format)\n - JSON\n\n \n⚠️ **Warning: Important Configuration Required**\n\nTo ensure proper functioning of the library, please make sure to configure your TypeScript project correctly.\n\n```json\n\"experimentalDecorators\": true,\n\"emitDecoratorMetadata\": true,\n\"esModuleInterop\": true,\n```\n\n**Other configurations**\n\n**Option 1: Enable `useDefineForClassFields`**\n\nIn your project's `tsconfig.json`, add or modify the `compilerOptions` section to include the following:\n\n```json\n{\n  \"compilerOptions\": {\n    \"useDefineForClassFields\": true\n  }\n}\n```\n**Option 2: Initialize Every Property with Default Values**\n\nIf you cannot enable `useDefineForClassFields` or prefer not to modify your TypeScript configuration, make sure to explicitly initialize every property in your entity class with a default value.\n\nFor example:\n\n```typescript\n@Entity('tableName')\nclass MyEntity {\n  @PrimaryKey({\n    autoIncrement: true,\n  })\n  @Column({\n    type: 'INTEGER'\n  })\n  id: number = 0;\n  \n  @Column({\n    type: 'TEXT'\n  })\n  name: string = '';\n  // ...other properties\n}\n```\n\n# Module Setup\n```typescript\nimport { LilORM } from 'lil-orm';\n\nconst databaseConnectionString = ':memory:';\n\nconst module = new LilORM(databaseConnectionString);\n\n```\n\n# Create Table\n(experimental API name)\n```typescript\nmodule.createTable(UserEntity) //to create a table from an entity\n```\n\n# CRUD Operations\n```typescript\n//get repository\nconst repository = module.getRepository<UserEntity>(UserEntity);\n\n//Insert \nconst userEntity = new UserEntity();\nuserEntity.id = 1;\nuserEntity.name = 'test';\nuserEntity.email = 'test@example.com';\nuserEntity.isActive = false;\nuserEntity.age = 42;\nuserEntity.config = null;\nuserEntity.createdAt = new Date();\n\nawait repository.insert(userEntity);\n\n//Find by id\nconst users = await repository.retrieve(qb => qb.where('id').equals(1));\n\n//Update\nuserEntity.name = 'updated';\nawait repository.update(userEntity, qb => qb.where('id').equals(1));\n\n//Delete\nawait repository.delete({ id: 69 });\n```\n\n# Custom query with query builder\n```typescript\nlet user: any[] = lilOrm.retrieve<UserEntity>(\n            qb => qb.forEntity(UserEntity)\n            .where('isActive').equals(true)\n            .and('age').greaterThan(18)\n            .or('config').equals({ allowed: true })\n            .finalize(), \n            (data) => data)\n```\n\n# Transactions\n\nTO-DO\n","readmeFilename":"README.md"}