{"_id":"@agung_dhewe/pgsqlc","_rev":"7-e4b41e88a67ab5f150220ca5bf3b8216","name":"@agung_dhewe/pgsqlc","dist-tags":{"latest":"1.1.8"},"versions":{"1.0.0":{"name":"@agung_dhewe/pgsqlc","version":"1.0.0","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.0.0","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"f192f4765bc614e4eed30f11fb8819d5dde79c91","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.0.0.tgz","fileCount":13,"integrity":"sha512-EpD8Nc5CpC41DavrOhHAH4Olf9A589QhgkYRnuOqdNEEae6tdRs+w179zGeY1HmvNwf7d5eB0fjpKrefGuo5FA==","signatures":[{"sig":"MEQCIF0pkk6kdzcasH0s8VsfxWIx99OZpV8KfGGNqCypCOHDAiBdW9lWDhbyEPPs8EZa57lULKBd/GLw2XWG90PuXEIJpQ==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":53213},"main":"index.mjs","gitHead":"7cef98dc3da2c83f92e20625971a326abf06731e","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","actor":{"name":"agung_dhewe","type":"user","email":"agung_dhewe@yahoo.com"},"email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"10.9.2","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"22.13.1","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.0.0_1752031365624_0.9381446153026616","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@agung_dhewe/pgsqlc","version":"1.0.1","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.0.1","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"abfadd52da2b5722703bbab3f6c51b1c15fe5786","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.0.1.tgz","fileCount":13,"integrity":"sha512-/B147LeDgmAMCOJ6coHESxBjaVtPB59FkmLTq45bxWH7inNLkUMVSYMVH+X7w0baPHWT8guL+tIRjQPltOx53g==","signatures":[{"sig":"MEYCIQCDxtXxaQkH0jK2Weo/oh2/PbVFO15JKRnR1rmmXZ11vQIhAPH60KhIWdknTOjnkbrd13hk+nf1rWPGm3bszZKJJPVK","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":53223},"main":"./src/index.mjs","gitHead":"dd72c127f055a36ece52547748f95c7d2394ccb6","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","actor":{"name":"agung_dhewe","type":"user","email":"agung_dhewe@yahoo.com"},"email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"10.9.2","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"22.13.1","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.0.1_1752032453679_0.6314174674173485","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@agung_dhewe/pgsqlc","version":"1.0.2","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.0.2","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"e3c8223a7e3b5410d8e3ec9dcf67f43be55de7b1","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.0.2.tgz","fileCount":13,"integrity":"sha512-GaY3zG4HB4pb/AKIMYhEUpVsex0r01IBXQQS9rB/emKRmk81wbX1ia6F8TIo+/iixKiFky8R0AGO69+WQYQBNg==","signatures":[{"sig":"MEQCIEyCGXME4T8lQ0AwPJT+J/LBrT/wW+05z9wJtK9ewYUvAiBpmxwSfhBUwaX9BLuI4syB5tMEsR1BosH9Ap0ZGiiy5g==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":53255},"main":"./src/index.mjs","gitHead":"471523d52100c70ef25a55af3fc38041b2de53d4","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","actor":{"name":"agung_dhewe","type":"user","email":"agung_dhewe@yahoo.com"},"email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"10.9.2","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"22.13.1","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.0.2_1752032601188_0.2706401116063464","host":"s3://npm-registry-packages-npm-production"}},"1.1.5":{"name":"@agung_dhewe/pgsqlc","version":"1.1.5","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.1.5","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"00589ea5a8dc06c4af37092bc3905e4a09bbc081","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.1.5.tgz","fileCount":14,"integrity":"sha512-fr0apwPMs7i94Ka6Nk942tO4hSjtNVpvI2atgeA+cXS2LnnCq8q+0mYeI0pWc/qZcDoKlIx9HJ20i0jIzVz+vQ==","signatures":[{"sig":"MEUCIBffUvyzcS1PRTDy+5de0hPS75k0ljl/CkTFEoQ42s4SAiEA+Iwn/d21U2edu0Se/st/7KVVyWHq9XNeZFMyU6ViKvI=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59555},"main":"./src/index.mjs","types":"./src/index.d.ts","gitHead":"6ca9ec403a0715a4e4a78f41ede6332d3da4bb4b","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"11.5.1","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"24.7.0","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.1.5_1760088001878_0.6319762752789275","host":"s3://npm-registry-packages-npm-production"}},"1.1.6":{"name":"@agung_dhewe/pgsqlc","version":"1.1.6","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.1.6","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"9ea798bb23415b7d32cbfb496a551b52d6c5e69c","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.1.6.tgz","fileCount":14,"integrity":"sha512-fGyCd479UAUkzqHi6UCsk5/ft3l6VXFD+rCUV17S4drlnmYxAgaBgPeZTRwnbasUKLN73ugLS8FN7HJAgk/+sQ==","signatures":[{"sig":"MEUCIQDicEpxXpOmt6jiL1xtxUhi31XA3XO7qDve8PXNS8PbfwIgT2GvKTxOnG+lgK+PDUyGCiqzr415bKxhOzkQ6+rPF78=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59555},"main":"./src/index.mjs","types":"./src/index.d.ts","gitHead":"6130cd3341026ff9b13094c5d22da514b66cd4b9","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"11.5.1","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"24.7.0","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.1.6_1772418220899_0.11724552036270874","host":"s3://npm-registry-packages-npm-production"}},"1.1.7":{"name":"@agung_dhewe/pgsqlc","version":"1.1.7","keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","_id":"@agung_dhewe/pgsqlc@1.1.7","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"homepage":"https://github.com/agungdhewe/pgsqlc#readme","bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"dist":{"shasum":"114dd039acca6622ba08fe6694471aeae9369e03","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.1.7.tgz","fileCount":14,"integrity":"sha512-ZVhgKKCLUXf3F27osx7hFqnG+NZYh4FU3v4j2h84w0EBVsvSuEuGc5vcbgivcdmacb4EUWM7L3yCk2GrW32tlw==","signatures":[{"sig":"MEQCIClr0wdDxSnZFsn+mvIq9It4ywccZVv6PZRtkMu6XZQCAiBrvfmGN1amP+d/DBIpm31j3cpMKoLnjmQn+4U6D5kOwg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":59642},"main":"./src/index.mjs","types":"./src/index.d.ts","gitHead":"928134950790a70d8c71e654f768f32c883919dd","scripts":{"test-delete":"node ./test-delete.mjs","test-insert":"node ./test-insert.mjs","test-select":"node ./test-select.mjs","test-update":"node ./test-update.mjs"},"_npmUser":{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"},"repository":{"url":"git+https://github.com/agungdhewe/pgsqlc.git","type":"git"},"_npmVersion":"11.5.1","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","directories":{},"_nodeVersion":"24.7.0","dependencies":{"pg-promise":"^11.15.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.1.0"},"_npmOperationalInternal":{"tmp":"tmp/pgsqlc_1.1.7_1772436743497_0.4113369369486721","host":"s3://npm-registry-packages-npm-production"}},"1.1.8":{"name":"@agung_dhewe/pgsqlc","version":"1.1.8","description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","main":"./src/index.mjs","scripts":{"test-select":"node ./test-select.mjs","test-insert":"node ./test-insert.mjs","test-update":"node ./test-update.mjs","test-delete":"node ./test-delete.mjs"},"repository":{"type":"git","url":"git+https://github.com/agungdhewe/pgsqlc.git"},"keywords":["query-builder","declarative","postgresql"],"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","publishConfig":{"access":"public"},"bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"homepage":"https://github.com/agungdhewe/pgsqlc#readme","dependencies":{"pg-promise":"^11.15.0"},"devDependencies":{"dotenv":"^17.1.0"},"_id":"@agung_dhewe/pgsqlc@1.1.8","gitHead":"8551f44e2f6fe4d4631ae3aeeccf77b37ba794c9","types":"./src/index.d.ts","_nodeVersion":"24.7.0","_npmVersion":"11.5.1","dist":{"integrity":"sha512-SjuukKnMGSX6NxgHcCOH+/AkPWcLmqy7QtC28W8o4wwIqweofR12H2n0OM+3VIbzJaTVLTSGcPQ+2Oxaka6YJw==","shasum":"d3b7dceba2aa3234f9f247f57b0f8dc3c5b350a4","tarball":"https://registry.npmjs.org/@agung_dhewe/pgsqlc/-/pgsqlc-1.1.8.tgz","fileCount":14,"unpackedSize":60722,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCp9IbHNkeYO+IgdlE/SW07XmAxg1tCNJFJD43R8k4miwIhAO7gOwHUmeSzSGSaQUkauwMFA9Gpn/j7hgGQYvimngS5"}]},"_npmUser":{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"},"directories":{},"maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/pgsqlc_1.1.8_1772505272101_0.6821371543080559"},"_hasShrinkwrap":false}},"time":{"created":"2025-07-09T03:22:45.517Z","modified":"2026-03-03T02:34:32.392Z","1.0.0":"2025-07-09T03:22:45.825Z","1.0.1":"2025-07-09T03:40:53.846Z","1.0.2":"2025-07-09T03:43:21.355Z","1.1.5":"2025-10-10T09:20:02.066Z","1.1.6":"2026-03-02T02:23:41.033Z","1.1.7":"2026-03-02T07:32:23.644Z","1.1.8":"2026-03-03T02:34:32.250Z"},"bugs":{"url":"https://github.com/agungdhewe/pgsqlc/issues"},"author":{"name":"Agung Nugroho"},"license":"GPL-3.0-or-later","homepage":"https://github.com/agungdhewe/pgsqlc#readme","keywords":["query-builder","declarative","postgresql"],"repository":{"type":"git","url":"git+https://github.com/agungdhewe/pgsqlc.git"},"description":"Sql Utility untuk mempermudah membuat query insert, update, delete dialect postgres, menggunakan pg-promise","maintainers":[{"name":"agung_dhewe","email":"agung_dhewe@yahoo.com"}],"readme":"# @agung_dhewe/pgsqlc\n\nUtilitas SQL untuk PostgreSQL, mempermudah pembuatan perintah `INSERT`, `UPDATE`, dan `DELETE` dalam aplikasi berbasis Node.js. Sangat cocok digunakan dalam proyek TypeScript atau JavaScript modern.\n\n---\n\n## ✨ Fitur Utama\n\n- Generate perintah SQL `INSERT`, `UPDATE`, dan `DELETE` secara otomatis\n- Fokus pada *convention over configuration*\n- Mengurangi penulisan SQL manual\n- Dukungan parameterisasi yang aman\n\n---\n\n## 🚀 Instalasi\n\n```bash\nnpm install @agung_dhewe/pgsqlc\n```\n\n\n---\n\n\n## 🔧 Contoh Penggunaan\n\n```js\nimport sqlUtil from '@agung_dhewe/pgsqlc'\n\n// Data yang ingin dimasukkan ke dalam tabel\nconst user = {\n  user_nickname: 'agung',\n  user_fullname: 'Agung Nugroho',\n  user_email: 'myemai@mydomain.com',\n  _createby: 1\n}\n\n// Nama tabel dalam schema PostgreSQL\nconst tablename = 'user'\n\n// Buat perintah SQL INSERT\nconst cmdInsert = sqlUtil.createInsertCommand(tablename, user, ['user_id'])\n\n// Eksekusi perintah (dengan asumsi cmdInsert sudah memiliki method execute)\nconst result = await cmdInsert.execute()\n\nconsole.log(result)\n\n```\n\n\n---\n\n## Menggunakan Transaksi\n\n```js\nimport sqlUtil from '@agung_dhewe/pgsqlc'\n\n\nconst tablename = 'core.\"user\"'\nconst rows = [\n  { user_id: 1, user_nickname: 'citra', user_fullname: 'Citra Lestari', user_email: 'citra.lestari@outlook.com' },\n  { user_id: 2, user_nickname: 'dwi', user_fullname: 'Dwi Handoko', user_email: 'dwi_hdk@yahoo.com' },\n  { user_id: 3, user_nickname: 'eka', user_fullname: 'Eka Sari', user_email: 'eka_sari@gmail.com' },\n  { user_id: 4, user_nickname: 'faisal', user_fullname: 'Faisal Rahman', user_email: 'faisal.rahman@fgta.net' },\n  { user_id: 5, user_nickname: 'gita', user_fullname: 'Gita Indrawati', user_email: 'gita.indra@yahoo.com'},\n  { user_id: 6, user_nickname: 'hendra', user_fullname: 'Hendra Wijaya', user_email: 'hendra.wijaya@gmail.com' },\n  { user_id: 7, user_nickname: 'irma', user_fullname: 'Irma Nuraini', user_email: 'irma_nur@fgta.net' },\n  { user_id: 8, user_nickname: 'joni', user_fullname: 'Joni Saputra', user_email: 'joni.saputra@outlook.com' }\n];\n\n\nsqlUtil.connect(db)\n\n\n// dengan transaksi\ndb.tx(async t => {\n  var cmdUpdate\n  for (var row of rows) {\n\n    row._modifyby = 1\n    row._modifydate = 'now()'\n    if (cmdUpdate==null) {\n      cmdUpdate = sqlUtil.createUpdateCommand(tablename, row, ['user_id'])\n    }\n\n    cmdUpdate.setTransaction(t)\n    var result = await cmdUpdate.execute(row)\n    console.log(result)\n  }\n\n})\n```","readmeFilename":"README.md"}