{"_id":"@acastellon/postgresql","_rev":"13-9533d513eb4bbecc94f8958c101cecb8","name":"@acastellon/postgresql","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.1":{"name":"@acastellon/postgresql","version":"1.0.1","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.1","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"f9a28dc448a8f6934cee6f11c7c927de4a1e910b","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.1.tgz","fileCount":7,"integrity":"sha512-oPw/AnfjeiJ84zZEQrpKqpbrJAAN5NQiVoygzKvDb390JwBDE7iFMPdSo56/I9hQtzSFXJ7uE7UF9247MLTQtQ==","signatures":[{"sig":"MEUCIQC+ggmmWN5Ja8Znf+1RPn6bsnoas0dgozu16IO6JHGjEgIgAlEEShRSRMg2N7iWfsolotsbU1Cgaj8LSYwEsRASWh0=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":16967,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQD1ICRA9TVsSAnZWagAA3/gP/0jCJ1JH0l5FcqpnnOQc\nYctMEbumMVrnypdNBA6VC2IIEZ3lRJ89ENG7fVgXawNTZmJ8uCmKU289iVyx\njxJrHUgv9wNaOO/3NnEqhbL1+UEUBKRC/i/LhMxwGfn++Mg65aMq11Bvk+6B\ncapyT8VNXUbBLMzxIQZt5s8N4RES936hB8hbmZanClwTlm3c9MUpy4atLsr+\nFcfSfqcTaZ9b+on42tEOjx5rFtDkS1ExkI4XHBdnDVxlnRAGUu3vZhIQYtDu\nluY0h26xblIMbjFLYipHzSJoGSK0tauwnAxxlxhNcGycPLaiYYmk56gEbqEl\nhWMA0VHhKcDzz/oZAK4vdpymDtV4Jq8E9GSEfyO2Rai0fW1Ck+VJKFAMsW+8\nVZc+bCmiMl/7auBVvAjkfLZE70al9wsoWn7UEl9H96ifL+/L9qigxWgVXtRz\nRt2b+XP8JXTTKLZ6MldezLOtTKbEA7S+HAeYRCknASJOmx1JKDBQvlXz8DQP\nYTE/0AaFNXBgohQjb0B52/G20gaLd8NlTSs+Zjs5whDH5vQqViHAHNIPv8ng\nB2fahYxgwZJrqvUL/+Y0rqX/vklJgyEPF23wLc5Ye9MyVQulM9e61BaQLYHU\np1O6sxXIUl3l5OQIJsFaYdI+FdwnN8kLLP78pNQgkgt9ZfrMM8cH9Q2pkfUd\nZVgo\r\n=NKv3\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"a79dd100c2f20256d5d88eecd5f93ef6a2766d81","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.1_1631599944366_0.3933231067922669","host":"s3://npm-registry-packages"}},"1.0.2":{"name":"@acastellon/postgresql","version":"1.0.2","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.2","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"147ac6bd5ffe1b7579afac7ba03960d3824ff53b","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.2.tgz","fileCount":7,"integrity":"sha512-nWkMwFE1gshZJ99+bLZYKNvrnQus6iK0l7LbukQnsNXXZmBVp1r1nZRyG8WIROguwH5iThnVMAfdb0ZW8+6lPw==","signatures":[{"sig":"MEQCIH8kNMurEzB7PKRFcWh6xwSZWKiZupIv22sBhtFZUnNMAiA2VogEBZNgdvaG7ZV6VvnGCx9OXTmiU7eWJHeCE7CsNg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":17108,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQD95CRA9TVsSAnZWagAANLEP/i96NB1IAXzGt1M3TK+M\nix920FKpr5raxySK2I+krblE80pQNH3xuVjs0zEsk0Dul1KSqZ6ma993+Dmm\nQN7tc5GheZAB8eIDMDkQkS7bGtwxSV0FilqChR3zpe7xNS6POyvUvi6DB/f/\n95plWCq90otjhHpe/aPktX0fueGCrMEucbcfQHTwjWS7fBKtGGfO0XhNVHL4\nBbxb9ug8AbjB0jtodp+HkXUCjNKVFxggpNWdXE+qCJyl1iXawn+tHWbHlwux\nF22+oR0+5eXOi2bxr//MnMbxWtR5AsQi0AiXvWrIxa83sbYX1HwbNIv7EExv\nIIuDBOqH4oZBNYdIJwzc4AtVUmVzHgZbqCRRfcmy0mFm5gG2NcCtwkBHCLCN\niUkGzM0/dOlSjpGpgRNJFOI0n8sj3Iy8oVJJ8Fu1JDv+NL3wj44Z5fnOWNGC\n8Bqdly+W9B8qeUAK1uAdXnEH89epu5544S+hN1dvXMN4SMVThviPFVkIzUT3\ntPjnbVDPIPrUQX9FKNfdqRIHa7onDY/sQIyc6ARd/NzL0Y7yj4JjyaUfSsqD\nm28XBBBZs8t9yMimodYGfunULzFW4FuLZ/K93nmU2Zq5+D0MMzoZA4wguX5e\nKFMay6ccRcXeCMrl9fyEjehXMhSkp6DKIvaJYoUZ96QkCqJanUm+02hDShSL\nazOB\r\n=5DLo\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"1a8eda52df8c85c34f8258aaa24922923beed053","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.2_1631600505692_0.7342366355691852","host":"s3://npm-registry-packages"}},"1.0.3":{"name":"@acastellon/postgresql","version":"1.0.3","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.3","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"65ee47addfa4960886d9be16dd0b8a31a4e72788","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.3.tgz","fileCount":7,"integrity":"sha512-iraj80ItWRpZUDSKOuGls0ySpiV16PvvvBsDA5ziO6dnDSxmOTnAx6y4nOv6nnCxjzbzCSPN5Vj/yN7hi6NkGA==","signatures":[{"sig":"MEYCIQCnBKKwHz9i0wGKnx7Z52s4WjF6j++jOYhrAgLy1ePyqgIhAPnFclogP3XamMBfXj/5XMcHAzi3yvAkGPFpeT+MVKKD","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":17595,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQEuBCRA9TVsSAnZWagAAWHwP/i4z96fgOkY4/J2Mys4P\nmIJJ1M2Rml+IV4c4DKzpFBRovNZKg3wQ6+4EYUlM40bFH56sJyVduGSLRYIE\nr2esvgMmwkw6cooBQcGTKaAxBgzLnPe5sLMQjr8WVTwE0eHY8hKFc3jbUIeR\nVmsJRNSvgVFDWCV7JrKzKTFKdsXuPIdpthdU4kMGxEBXqwoZcp+bvR9SlzVm\naXnyDUfdEEAgtYDmaUlZJSfsGOvSK6A9I+zpmUSZtHAndO3M42kvaaTs2cTv\nW4954U2LMlWSYzgChcp8Y3Xq2gEh6PbfiDajwpcyr8+DGMsA+UHUhPj1JgRI\nNmwJfW/Rv/9mf8DkQ6ZCGjGHkab2q36MAAP0rMfmm1rdvrTF+b3dRht+wsHF\n6IJ7V5zE7htskRUKCgROjddpzEvXV+Qu+ZDQAVkXRHkLmD2RpQiJQDOLA5sg\nPl7sRVTOtrQ4ENGJdKB3MEPcpN+8fTCOYCw++WQIk7B9woS/lKPCJRguuLHG\n40mEh5Tk6M/+rzTj/1aRu5Afzj5IfaDZO6IcwLk6eY0TRvWqQEB0qP7igx0K\nbUqJtzAAkYVYicyqdE+RQzgkmKqao5kq0ppqGB5Jtvy6qnngEF0qJzU3m/kh\nNZfNUpEnDl7dTm/JxTNLD/bZiUfNdXR8v/npFRXXvEwaMpLrRKtHy4KvwT4B\n7jyy\r\n=qVbO\r\n-----END PGP SIGNATURE-----\r\n"},"main":"index.js","gitHead":"fac8e3992d8de43b889b417745de0aa1ddf482c6","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.3_1631603585682_0.11194811824291762","host":"s3://npm-registry-packages"}},"1.0.4":{"name":"@acastellon/postgresql","version":"1.0.4","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.4","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"b4c8f90684ea195bc3ce1429243f40acc0390717","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.4.tgz","fileCount":7,"integrity":"sha512-DEq2N0UegoIukOpicbbwjIgfeC9qjtApSXl2KQepO+T7Bjhs3rpPUtVZ44TMRJYvSxvRJMHh75mPbEdyiGU4zQ==","signatures":[{"sig":"MEQCIBjLoVGmlDsACGD1wbfwOjYjzWjb3FZF/owwm0Ypk8/SAiBvjiaJ3L57jMk+9XJx48ifSo6aYeOElvxFh/5WTtlOVg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":17600,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQFUpCRA9TVsSAnZWagAAcS4QAIQJk2It0zckeZF0Fph+\n9b7THQwn/VrG6dKQ5rqzBbJ1AvePijlXrbNkx4ZzhdBpePXb+MnH2gKV5s6Y\nnEt2E1WufX9AwMpE+ZajvHJZPxKAJr846rKa5f11O0rx5YlYQYIJ7C1VdO//\ndp/f121RVKnDgnVK2vXv5EX1jXJntraDw8OL39ICBN7Q9bJY/9lBaacIlJMS\nA71Vb6Ew4jmnK4bkQPjQklNDxFZAp5ECL0ruxIl+tbcJDlQa3a0yS3XFxSRR\nSVa/TenRnpDPensN8YAJj5+gyM9yk1v0vc3jc8Uq6dg1Ot+GW30WPU2HAilU\ns4QWGfKWlDYtew+V/YAjGQ+2X8ourc5JLpMDj2smBQo0mqqbEnUZGq+ti8MI\nib8IsEz4UgMh+KdnRB4Zy61f93Y19dqqsa+KJCajoaO0oucFcPV8TsD69+no\nQVE1oLW3jMGcJDEInX5UdVZJIowDEOVitWO0nYX1IzNWWs1DZE5w9kNYliCB\n8TpypAanX94o4fV2Z6k4DYQNzNtSFMVQRbLJ4+eXSuMMeNkCLy3Yqh9O3bI2\nX20w7JIzaSvE0A6XMD+944LfVMkqTJyb/b04kRuR2BK4yJPQVHukaCg87S6Z\nmPjhHxqc0/D2uC6iMBff2C3LHo1vTZ1Qm/4/iKiMIAwarkb5EpZCPAm+dLyt\n8k/k\r\n=1yon\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"a45a387825b86958192ffb4d15d9bffe093771ce","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.4_1631606057735_0.8948618796338925","host":"s3://npm-registry-packages"}},"1.0.5":{"name":"@acastellon/postgresql","version":"1.0.5","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.5","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"0f7be202c7636e9d02a3b2af13dfe8b9e0a34c2f","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.5.tgz","fileCount":7,"integrity":"sha512-5yb2/Zij/vn69A0IJD9IG67ChvHMCxz++9N9MwOFgvK5QQU6dCjE6tROPqD+BtKAdjnXTUgUF3QeGX6VQ3iO2w==","signatures":[{"sig":"MEUCIQDvZCfV6oLLoAfUlNo02MuNskKH1egNxy+t0SUrO3vYAwIgc47TQJoycDvkrHdyowN6LF1ZtzQ6zDdG4H+XFUx8RO4=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":18791,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQGXdCRA9TVsSAnZWagAAN1gP/37cStAnOhntgB/mBKC4\n46bg+aIq3v21CrMTsQjY5CQqTYDNgxlfV44gCc4Wde+/UxHgVXnS45KlwMYk\nlIf82PlAfSVOq7PI74Z7z62tG377LrPsVotkA5d0BnDbUHvzAIqwDyz8QY+g\nkv3YiDUvd/+YVUGn/HUvtbNu/xWfY9jcXOEj/A+0dIHN/1V+V9sP+uo0Bs3u\npbEiJhbWt0Q+/C3iOe+YvVAjRBywkCMWqo6/luw1H5MVYOq0h5BUoqYtzrf2\n7LvbFG+0aHzf0Q4GyPoYTOKcog08pL1jrXDQGEk3i4jH2ggUiTbKr58Na4wN\nvOi4Dpxuanfuoj8cUXAvRCc3HPykzdrIfNzZi7OvZ/ST+g3B6Wx/yY/m189B\nHx8kdm7Ypxm4VeFyzO3sR1TrwGNa7eQShdazYSx08/l/biZ2fuS6l4pB4FA+\nsw5bxXfCg+phNssRlRWoQsiFBXb5p2rrEwFWZXs7tKOs2NQ+NXjRpiKrSzMr\nPxIeiguHiYqBtlIaqrjnf/GsxWPULEb/nRWV/hWOf7cHRm5Bbq8Bd8TPMkPd\nbs4LfVi8JY3YClZWsEPOcmNz1aSQkPh6zAD8vYOrfUMAfebys3RGy/z468JJ\netbXBVK6OePtbLofejTQLq5xff4sbYLcVBEwhebyTgvo7fvsovt+hIC+Pzwt\nlPiA\r\n=is6W\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"880aa6cf4857e8ec59601c2b81ac684a7d3f5136","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.5_1631610332977_0.30193226443435894","host":"s3://npm-registry-packages"}},"1.0.6":{"name":"@acastellon/postgresql","version":"1.0.6","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.6","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"b15f3ab4364e5e67a32a0a6d2702448136a8620a","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.6.tgz","fileCount":7,"integrity":"sha512-0s7z3BSH8MVMIl6UVkBZPnNFWYwj18H3sPnqcuibPKTwlMFKgztaYcpYogtD/HS5zKEbme2pm8vVm6QPlumu+w==","signatures":[{"sig":"MEUCIE8yvbp503K84CTN4U3nyL/nIGacwtwIeiExyHxSiLSoAiEA6uihZuiCuOQW0+uu3rVoZJYWD0K8dZmo8CM8cff7xrk=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":19347,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQI+1CRA9TVsSAnZWagAAj5kP/1VbSzNNFuZN+IAs/drM\naCeHZ5VZm5r8vgHJ3354LzmXsORsylKqZCeAXEOJYenmyEIgqzXW8ACf9PF4\n6xowYHVU5szB2Ii0iYofWJ1MABPQ5UnjqH5ntJEcjEY0ykuzYP+gQFQKj0K5\nRM8PIsC8Fa5vVHT8YhPWlCq2rfc3+a8DEVJOksg5MZdctxU549AeAy48kY5N\nJINhKCa0U5CrEmbvwJmKsk0Nby3X4NRoqNJO5V5ZhwScS2Cfrn4mH35P2enF\nTSy84IWa/L1zfLN6l5Xu3ab50RrEJ6/awCt8RUI+iI2EnNi0KgSUt/2ymOnU\n+1kILndHCCtv0pRQ1qwIhbQ0SykxBLsCD1zYWxn6oj4Pffp2xova69otLCpw\nx2gcUwzXRYe61Pjx0IJ7Q/H47KePTj5RattPpYLtm9+fknqY7xu+BendTnaw\n/lBH/J5LnFg/WoB7qWWhQfICIX02cNl5UR1CSyA0Q8hn2v0Mz5J0y4gCSGKJ\ndqqtrZWBJgdISWv+akk3WoZRoO5NKSjGUna2bxOVhS9gBWih4o02rhh+Fnai\nCOQv+ta9y2iwps/QwN5hvBtIpYYQB36WGfcGklPKFDLDDXOyOBlWkzaw1ftr\nABA3E3eToEjqjBGhUr3LNQuV4bl0hH6UQCYZ+NXtbnh6BAVm7HPFsSAvQjxX\nmwi5\r\n=auIW\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"ad4795e7aea8221614462a2a3430c0b3c97f2d87","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.6_1631621045538_0.3311114272847826","host":"s3://npm-registry-packages"}},"1.0.7":{"name":"@acastellon/postgresql","version":"1.0.7","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.7","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"8de97ca94e3a5d224a4d0f1a225d1685b7885a9f","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.7.tgz","fileCount":7,"integrity":"sha512-o5RgWkD+qJ/7oBAoO0t9ApQVC7Jvp3Aq0e9k3QZzDhIKbw/RBLEsTKZnpEzKqRhMpjnK0E8xjJQqlNPCB6f+GQ==","signatures":[{"sig":"MEYCIQDOirYEAU77rcgQ9ldZgHaeju2hbZaN+eIafMhSsEgLvAIhAIV2L9H3OrU/MzC2bA//P2qIj/66M97lDUVH4Y4oG4yc","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":21744,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQYjTCRA9TVsSAnZWagAAGUUP+gI6bkwvq5ODn/84EdFe\n25v+4IdY/yJBZefZrSx11BH24hJGFbWktr88QRY7VnKC0p1sHaZt8oVit5RI\nxVKEHNEC9OJUUuz33ZPs6VLvHSOAzD5U0hHhzPLaPOrSfN9IAIRn5QerS5he\ndDJsUj2daolOn0hYgfSuvfsoPm/vJBkzSyRs2aNO1QR/K3sTQ5Jh9j0+q8pR\nvqbGgVBQSUHY2vSjLZqIDSJk8DckeL86+z/0EA2kEpd9FH1rrnDs5LpziJBW\npTHNn2kdKm+2o2WkkhUhTd3e/bEz4dYsmMYhpz5XgrVvhlHiKIj7aMDvBZL/\nNosDB0k391yG5dvXkEpDRNg9AP7GL1Tycco9DONvoSbbnutekqhEtMJop5/y\nGW8f6vXYkrxxnXK4SnsCrv8bSKDHE1kR5geVEKpb24OvIsCJYJLPakJJkH6I\n0JpFBNc3qU829qkkZWyb+dH2LxGXdv76HZERGGgQ+Xq40pkqAQ9bow7SUHPK\nWAvNriAS7tjBPzQpgbhz3jpNwKodXb//DNgPm1AJR444OA+p2GG+/BJgk9QA\nWSz9qPB4ZXZGN1dV9uI0epA7k+Lxvt7C2HJcSPjN3AynwE8P5uQpBfkbrQZo\n6gnhTR77JeaupLKtOkZxuGL43O3hTolsIw5YJN10uUqMcGOZECr6ymJyc1cr\nb0Rh\r\n=OIbM\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"ce9a68909f537e6be6f8f3c4a6b1100fa058bb16","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.7_1631684819398_0.4267331284870792","host":"s3://npm-registry-packages"}},"1.0.8":{"name":"@acastellon/postgresql","version":"1.0.8","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.8","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"e0587718a2e29942fafec7e04ae57401c98eb5d1","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.8.tgz","fileCount":7,"integrity":"sha512-dI0inqsaNns7XQyE7JgClqNWsXwG84VjTZl38QeGXiAb+giUg3VgOfcS0mpm3TYJQxSq2fjUf70/OZA7um4QJw==","signatures":[{"sig":"MEUCIQD77wHMNIleaTV1TB3wGJTXIb0x/ru8rDannuxbIl8wvAIgFpSEAo4gYvkVklYBBz9AfUp8EQO63pikAse1aszHg/M=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":21821,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhQuwOCRA9TVsSAnZWagAAvhcP+wePQMogJcBbayUkGiJg\nNb2X2e7eesyGXJ5ojiwKmMCgs66Z67NpRmEmrG/oQfGBbWwwrZHagTKINJME\nHzmEMXHolyYHPmCL/xcgBKunUySL+1UXnsLEtx9u3M8gwaaX89gXnkWtZnOi\ndjo6/ZDDKQPHR2Y8Bmcydyo0BQICmQ+ROCyDKetqrGojpexYLkwzqhdGKYzJ\nwx0F01jJlQBxjmI1Q5ZOlBkI891wO3VTrU0cFf823ZewhbZQDRSL9akLjjBi\nscDwCdjqN3iui2GQHYvq1DU51aVa7fxsvbLmJyyK1JIrr0wSyTbmnrceo3Cc\nX2wwubllMsqVLFHNnpZH5VKBiX/QfQ/u1J23vCvQrlsl0BEZ6ZYFMO+lSj7d\nlBXMpHOJycoM5+LKuR46w4WqM9GFy4TBCrAYnrcGevdQxu+VniIE5Jaf3OWo\nIzarHH64EHDTpEmvX81O6O4PNjlRLTi6GBuL+yCadKlMnY7WjFNml8C1A7S/\n01vztnniMt93ISK9aZf/ZKZvy1v6NME3zrTrIEHDhLA1asWqf6fg0Pxu1fAy\nEAPda8iD96V/UwlkEZ+BpQ5g6EuWjZv+RnQqyokPIEDYGF2jTTx7uAOU/UY4\n3XBkf+l/KCXkfv/olYw7qlTSCmzbEW3SEP/lNYquHG/WEN3+fFAJbrspM2Jh\n67Wq\r\n=6xFD\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"70bd7c88bed0190737fa23891983c0b8e1b2bf0d","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.986.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.8_1631775757879_0.619496351495932","host":"s3://npm-registry-packages"}},"1.0.10":{"name":"@acastellon/postgresql","version":"1.0.10","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.10","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"7b05bcb8796d6d9c7219e2ef95bc9b13510e0bef","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.10.tgz","fileCount":7,"integrity":"sha512-mKd0lotky9IjDzcOo/acK1X+vrgnuxXxHoCB8z8nf3qIE4Yt5q8a85oQwkcRaHa/Na3J5GRYssEzcezftyjqaQ==","signatures":[{"sig":"MEYCIQDspTk47tf4DPzBkb0tkbRbxL5PFYnN9fsf9MTwAO/b4AIhAK5YViJxMJDOCjW+m6Br+qlMoWYtIGDrSVG/nnr8XWty","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22401},"main":"postgresql.js","gitHead":"67a96dff15b350fa884e76aaa6298a7226f1d1d4","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.1007.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.10_1636547099727_0.4734162808028557","host":"s3://npm-registry-packages"}},"1.0.11":{"name":"@acastellon/postgresql","version":"1.0.11","keywords":["potsgresql","utils","database"],"author":{"name":"Antonio Castellon"},"license":"MIT","_id":"@acastellon/postgresql@1.0.11","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"dist":{"shasum":"c1478ab5eaf5a6d19792c55f9659575f04171ce6","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.0.11.tgz","fileCount":7,"integrity":"sha512-u53lN3y4QV7TVk92fHM1gv22FK0oHLKaGQsyiqUiK0yYaVZ6mrafRn0FsFDwSOyJUHplS5igHpjTmger8QoiWA==","signatures":[{"sig":"MEQCICSzkCL6USWKKc07/1gy/OSEVkhxD1jPc7Uaph4O1SRuAiByrx0zK49NsZBllcFxQJjt+mbeLspRyEgHIFMb7HYlpg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":22826,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhuyY8CRA9TVsSAnZWagAATTwQAJOg9SPswAvD1WOA15Cz\nSmogHvQuzqLns+hjXGt2caSoVro7Gy4KuPKFta2ozu1z4H496b/o4x+lryiu\n92E8cu48BhLQIGXjcGOI7ywp7qklFBDPZWDMUBZOsMGTk/e7MSthC9lRt2yI\nyFdlVx/POjSREvm0xbpmfnltAq7jWFOaCvRm/fT+IQ+/cC1l6EWR574HGPI0\n4TALGQ2fmBz9G3o9x7Bvzl2G1VWw+k+IbYFs4ZUthFIP5/cAU4hcHjb1OPzO\nt0N1Kt7oPUHXf/lxxZ3399V1vRz5MgOtUpU6dqQA6HHVM15pXuGEXuoVO7B6\n9s3mAt52SjOkMkD3DqSqzikv8csjGQNDb+ktrOmeR6cOv+vIoVqagmOdAL14\nR+GI+UTB7rTSl5Wa5+xoq1I4u6K3VsnzPp5Yp7yybokcuto7wNQK+5oOU0CQ\n3hyHLz4N2gy+ht3KQOYklj4mDlAt1w8KkdyJ0Ym5imVlgZSsX06t//2dehuo\nfvub6ja8UX+uIJeD8OuW/4+sR3Za5kJYWia8GlrYfjtGwLJ5itwR7GBljUh7\nuWuh9b/Wc5oc3+IfDVmTyEGXLgdXhR9Z2SK9oqIZeKQ6UITmtRait44Pmw8y\nCHvVrdXXzQF3+JhNkBFff/+w1BEyMMRxIAP9j2JPAH3V7kUUk00vRoAVjUMB\nS6fd\r\n=dZ7V\r\n-----END PGP SIGNATURE-----\r\n"},"main":"postgresql.js","gitHead":"8b77c845ada30765eca6f44eab3b5712b5eeeb70","scripts":{"test":"node test.js"},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"repository":{"url":"git+https://github.com/antonio-castellon/module-postgresql.git","type":"git"},"_npmVersion":"6.14.13","description":"Postgresql database connector focus on simplify the access to Document Storages as JSON fields","directories":{},"_nodeVersion":"14.17.1","dependencies":{"pg":"^8.7.1","aws-sdk":"^2.1007.0","@acastellon/utils":"^1.0.2"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/postgresql_1.0.11_1636557753064_0.8619538859198299","host":"s3://npm-registry-packages"}},"1.2.0":{"name":"@acastellon/postgresql","version":"1.2.0","description":"PostgreSQL database connector focused on simplifying the access to Document Storages as JSON fields","main":"postgresql.js","scripts":{"test":"node test.js"},"repository":{"type":"git","url":"git+https://github.com/antonio-castellon/module-postgresql.git"},"keywords":["postgresql","utils","database","json"],"dependencies":{"@acastellon/utils":"^1.2.0","aws-sdk":"^2.1118.0","pg":"^8.7.1"},"author":{"name":"Antonio Castellon"},"license":"MIT","bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"homepage":"https://github.com/antonio-castellon/module-postgresql#readme","engines":{"node":">=18.0.0"},"_id":"@acastellon/postgresql@1.2.0","gitHead":"afd8a0f3f5db38e9c9cfc39753a37dbd5eef75b9","_nodeVersion":"22.14.0","_npmVersion":"10.9.2","dist":{"integrity":"sha512-IEGB0xZ9xeYMQ9PM6iTCLeXWewhyzUaw6vkrJOyE+YJPNTu7mp1mv4hoK5VsdUXWEGsP3HRq2zN2SuM0Tq1VvQ==","shasum":"daadb1a77362bf90f8a783b715efe85ab231ffe8","tarball":"https://registry.npmjs.org/@acastellon/postgresql/-/postgresql-1.2.0.tgz","fileCount":6,"unpackedSize":22979,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEQCIG8v1T4pviLJjuMhIORW1Y2wv6v2kR8X/K0lKR4fOxEGAiAyvnGpft0xa/FECewxWwc50rSiPcSwIK/+0jiqVrqSJg=="}]},"_npmUser":{"name":"acastellon","email":"antonio@castellon.ch"},"directories":{},"maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/postgresql_1.2.0_1780483672669_0.8812252341051483"},"_hasShrinkwrap":false}},"time":{"created":"2021-09-14T06:12:24.298Z","modified":"2026-06-03T10:47:52.935Z","1.0.1":"2021-09-14T06:12:24.514Z","1.0.2":"2021-09-14T06:21:45.828Z","1.0.3":"2021-09-14T07:13:05.826Z","1.0.4":"2021-09-14T07:54:17.889Z","1.0.5":"2021-09-14T09:05:33.117Z","1.0.6":"2021-09-14T12:04:05.694Z","1.0.7":"2021-09-15T05:46:59.521Z","1.0.8":"2021-09-16T07:02:38.019Z","1.0.10":"2021-11-10T12:24:59.907Z","1.0.11":"2021-11-10T15:22:33.233Z","1.2.0":"2026-06-03T10:47:52.815Z"},"bugs":{"url":"https://github.com/antonio-castellon/module-postgresql/issues"},"author":{"name":"Antonio Castellon"},"license":"MIT","homepage":"https://github.com/antonio-castellon/module-postgresql#readme","keywords":["postgresql","utils","database","json"],"repository":{"type":"git","url":"git+https://github.com/antonio-castellon/module-postgresql.git"},"description":"PostgreSQL database connector focused on simplifying the access to Document Storages as JSON fields","maintainers":[{"name":"acastellon","email":"antonio@castellon.ch"}],"readme":"# module-postgresql\r\n\r\nPostgreSQL database connector focused on simplifying the access to Document Storages as JSON fields.\r\n\r\n#### configuration\r\n\r\nsaved for example as 'config.postgresql.js' \r\n\r\n```js\r\nmodule.exports = {\r\n  // CERTIFICATION_PATH : '/opt/<project>/Certificate',\r\n\r\n  // RDS_CLOUD_CONNECTION : {\r\n  //   ACCESS_KEY_ID : '<YOUR-ACCESS-KEY>',\r\n  //   SECRET_ACCESS_KEY : '<YOUR-SECRET-ACCESS-KEY>',\r\n  //   REGION : 'eu-west-1'\r\n  // },\r\n\r\n  POSTGRE_URL: '127.0.0.1',\r\n  POSTGRE_PORT: 5432,\r\n  POSTGRE_USER: 'root',\r\n  POSTGRE_PASSWORD: 'root', // Only needed if it's not RDS based\r\n  POSTGRE_DATABASE: 'test',\r\n  TRACES: true\r\n};\r\n```\r\n\r\n#### usage\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n```\r\n\r\n#### methods\r\n\r\n##### findByDocKeys(tableName, where [, docName, conditions ])\r\n\r\nReturns documents from the JSON column matching the where inside the doc.\r\n\r\n- **Params**: tableName (str), where (obj), docName (default 'document'), conditions (default ' || ' or use db._AND / db._OR)\r\n- **Returns**: Promise<array of docs>\r\n- **Injection protection**: Yes (on table/doc/conditions)\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst where = { pmi_code: 'A10.345' };\r\n\r\ndb.findByDocKeys('JSON_TABLE', where)\r\n  .then(results => {\r\n    console.log(results);\r\n  })\r\n  .catch(err => console.error('Error:', err));\r\n```\r\n\r\n##### findAllFieldsByDocKeys(tableName, where [, docName, conditions ])\r\n\r\nLike above but returns full row (not just the document column).\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst where = { pmi_code: 'A10.345' };\r\n\r\ndb.findAllFieldsByDocKeys('JSON_TABLE', where)\r\n  .then(results => console.log(results))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### findByColumns(tableName, where [, conditions ])\r\n\r\nSearch by top-level columns (not inside JSON doc).\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst filter = { ROLESASSTRING: 'Operator' };\r\n\r\ndb.findByColumns('table_test', filter)\r\n  .then(results => console.log(results))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### saveDocument(document, tableName, where[, docName])\r\n\r\nInsert or update a full document JSON (uses PL/pgSQL DO block for upsert).\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst newdoc = { name: 'Manolo el gafotas', urgent: false, number: 555 };\r\nconst where = { name: 'Manolo el gafotas' };\r\n\r\ndb.saveDocument(newdoc, 'JSON_TABLE', where)\r\n  .then(success => console.log('Saved:', success))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### save(values, tableName [, where])\r\n\r\nColumn-based insert/upsert.\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst values = { DISABLED: true };\r\nconst where = { ROLESASSTRING: 'Operator' };\r\n\r\ndb.save(values, 'table_test', where)\r\n  .then(success => console.log('Saved:', success))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### remove(tableName, where, docName)\r\n\r\nDelete. Careful: partial where can delete many rows.\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst where = { name: 'Manolo el gafotas' };\r\n\r\ndb.remove('JSON_TABLE', where, 'document')\r\n  .then(success => console.log('Removed:', success))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### query(sql, params)\r\n\r\nRaw query with basic injection guard on the sql text.\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst sql = 'SELECT * FROM \"JSON_TABLE\" WHERE \"document\"->>\\'pmi_code\\' = $1';\r\nconst params = ['A10.345'];\r\n\r\ndb.query(sql, params)\r\n  .then(results => console.log(results))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n##### update(sql, params)\r\n\r\nRaw update (no guard).\r\n\r\n**Example (with minimal setup):**\r\n\r\n```js\r\nconst config = require('./config.postgresql.js');\r\nconst db = require('@acastellon/postgresql')(config);\r\n\r\nconst sql = 'UPDATE \"table_test\" SET \"status\" = $1 WHERE id = $2';\r\nconst params = ['active', 42];\r\n\r\ndb.update(sql, params)\r\n  .then(results => console.log(results))\r\n  .catch(err => console.error(err));\r\n```\r\n\r\n**Constants**: db._AND, db._OR (use when building conditions manually).\r\n\r\nSee source for full escaping / where building logic.\r\n\r\n## License\r\n\r\nMIT\r\n","readmeFilename":"README.md"}