{"_id":"@5no/pg-model","_rev":"9-4b39b5d3b8bc68948a24744dca3979b8","name":"@5no/pg-model","dist-tags":{"latest":"1.3.8"},"versions":{"1.3.0":{"name":"@5no/pg-model","version":"1.3.0","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"91a17340416a10fa74efaae4608cac285b660881","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.0","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-lVXhgPAjlgpBEWv5NGGe4kKHxLnJ+TMM/uLhzw8XKYwxxI00h9pLrHuhf2CBcKxaTszflcyzD5kdeJfLrfMrWA==","shasum":"7b2a5f26af216eb5e23aaa7407ecd3f505aeb9ba","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.0.tgz","fileCount":24,"unpackedSize":149101,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeDdAICRA9TVsSAnZWagAAfvoP/0FG005brEhPnX78oMBH\nxeGMHVNoTO2L5DSKZpce8e/Pa6ViJQBKit21vdHCJl3ueIVPyV1RUiG7ggvR\nLPyM0UM49mZwFm8O9jkWcCEuk1vgEy357qWdvLJhKejgaiVt6a60sjWCgeE5\nMbHK3QiW5FlSIyIpIyHWSyowhfuyGR6ahVppjXJyTGsPL69R1pk0LonbdzII\n2dFwiAT492FBHxTzgODaShtK9DB+hojhHq7rdnVUSvMqgH9+761uXwYh6n8W\neQLAcLohaZfBSSZkS8rxpQnjPnQ6ZQfEfdQqFM6QmAhbOb4bM+mknVpTxzso\n/7fi0kQo7RHXszAv4SyGCHvjHM7S7Wd1Wp4yzgU+vOtBj2rWZC00xpR78BUy\n8f1no92xnJoj5yvg+opohUIKwNGn9RDCStxRGx0uuw+I0wKTJSyLJPuEWTUF\n+eyXfVCGN2ZN1qBh6TOAG2aw+d/3VnGyh12YWs2qQC3bShDicMiwCH73jbXd\nuMASuUGLOKiBuiLTR5Nl61UR2UJpB7phzzNP8CvLYr+17hh1KMyekmTe/u65\nr9ziBaW948ZoRu61woPF7Y43CorFzwMvc3NgjbSS1gYolcl+83AA3pvoM88w\nU9gYYersY+Yz0RkBNrDA9tQ1rCfRz/xMN87ncdBRkIZv+cNXR1RROj7XjOE5\nBR++\r\n=Sqx1\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAkf8+I/UBYFgS7M+Dtl0LVBCaflz4B/t63Wgenf2nXgAiBaXW6PVJSFZkdvpT/vy9gZQWWxRx2sLlrDbcVGqcxlpA=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.0_1577963527543_0.10622273298109697"},"_hasShrinkwrap":false},"1.3.1":{"name":"@5no/pg-model","version":"1.3.1","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"71946b8541716a576b58aac88ee0ea0ce73298be","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.1","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-4anldZgjQHfYo/IEXKQhUYSHTeYwfSAzEACDBABTRqWs6llo1a/xI0FdZgOLZg3B7F8yjDafzHwhoBoTnf3IJg==","shasum":"d180ab7c5414dd62430711b5a2296ba5ccd776ad","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.1.tgz","fileCount":24,"unpackedSize":149163,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeDd2eCRA9TVsSAnZWagAAxIwP/0w/I2e7JScuAMXb1xU6\nxxIeCoyUdTo+efqGOiinejV4wWJE4hEcDRQjlDh7i9WdG3FpCCkMdIAw7ajQ\n4vWLyeU2yAG5L08BcksLnbUMnrD5raeEGnMMLmrpZayt443nLYeShKhX27yy\nJp1Bqsfzu/iaKvh8uAljuA6H3HKwcSvgJb11cU+XejJHj20ZS5iG7YEzRkhk\ngn7/BeRfGFHBPOvJVnH8mh1AGDoWavD74hnyPZcz7JCMQJVO8Pfk8sLofffI\nv35h1nsbndYGQpLFU02/AF0LJIHNA/THbAqzDvWNkjMn6wApUyw1DBN3cnDT\nW7gl6rOG7oyKNcfsVCp1j5LFv4aBNroqQvDwxFLNs4DKbRz2u9Gh0nIyilYi\nUW60Rk8pK+tQ4fMK3To7/UbGjbO2Kx3nOuWjo1wFTXZOy1JnoaKPKum3x50h\nESq7kJfN9dEAl8KGPkCW0b5w2tpD648OJvnpCigpGIxDMoSK6Q4gYZrEVHYU\nzCdIC9XnPcuG8uejEHXnPBQaJX9WOJ+tcPowvY8L53jRiibzd0/pnbVkEsqB\nZMtK8WmwethRbiv1XP+G+ZsT5VUB1d4dW3aU4D65xo1CSG9IuPODip0bPEON\nPzwFOjhdLL9HUsXyY/JqSSeUzaTeqdf43rgh8Jq2Y25K8zfriko9IY/jwkyw\nUY8L\r\n=nKMe\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIF3Iv3yWFMBe99Omf/QIBJIHRno1Qt+FdGIqp9gC0CrPAiBWJba4LuOSTZ2hj15nmcapI15Dom90eZfadMK0SaGheQ=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.1_1577967005795_0.7175389615324574"},"_hasShrinkwrap":false},"1.3.2":{"name":"@5no/pg-model","version":"1.3.2","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"20087cf1a043ab2fe20ea4756aadd33a4fe7e085","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.2","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-YJsCi6r/PJeGTwo53D+6hawt8vFigA1d54wg4CFY06xXMQu6ZbjJe/yUioaHQ4jAV49FnBMgq32KMeMs86gZKA==","shasum":"1bbf6dcd35ea4d2702217a474162222e06f17747","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.2.tgz","fileCount":24,"unpackedSize":149288,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJePEAgCRA9TVsSAnZWagAAOq4QAJvtAk6znyzops8cL7ES\nhzwNS1UDCZTbIhJNDvJ3l2equa7goQFfOKIXbNczEnHtOFRfWlmNZrVLS5cE\nvWSfTdXzZKMK9Mbo8+jXFM8C1GRYbHQmuSvqnNtNCR21gTbPGqa5HwC6/2D4\nWzNMXxsqc7PGNw9X6pX8BOlR+CUhy+2s4q/kVaijCnM4J7GsgN/fi4FFV17n\nDURGArxev0qLzbgmJoKx4xK9Cfmb3Rjxzk1OPM4mO1qUxyNebARD947A9c/J\nMlZhz8bX4FN/BWJNb3bzVgaHvaWet+XCVF4TLPk4JiylybhgWJTscLGgwDlS\nOyXA81mVKTS5tKpMMfXEb4+aSIGzIRTj8iO/c5G/CPyBW44nwPWX6vymv/Ui\niLDAX3Vo/bGoB6yIrP2xkV6FW2G2ZawCWtCUBlwx3dCHt1DIKuX4j7sQbZaM\nTGmyDbnpqO8fgIGKCZEoCSx6uXPjvZA3kyuwbc/lBIgpRo/K89XmL9gyb/kY\nh1IbFoWXeLECJSaCxuXDaR1evdxOK/xoQX5E+CTNqLxPgCrw4gGJ2DmYkQF3\nizgUIOzMAPQ8SoabOioB9qtSIczqZ+gVCU7W0BLaHqONqDLXVKzY0+jYsJQl\nDnU/b5sSRD0peM/T9ZgrqA6dA9MPUNXRTW6wEEY4MvoZNVoZUXIvdvoq/mLq\ni/XQ\r\n=bQSx\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCmt8nrQupssd8/i9stglHriKkoYZTZtWtCt1NYGy0vkwIhAMMJmk1YhpQmipMNssNepOc72m/fUuA1AyONrlYYt8zV"}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.2_1581006879573_0.6882261163468815"},"_hasShrinkwrap":false},"1.3.3":{"name":"@5no/pg-model","version":"1.3.3","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"71420b593bf21b6a3334e8d0b9ccf6a5fbde733c","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.3","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-60ctJHfPNovgYvPV9tuHDx5wxUfTxaOVa2yjcpzwr8ttNmRa2BzfkV2UVTbBkFpfJzH+14rqlkDRQV+rviWPZQ==","shasum":"0f0938a2cda6835c250155e2288c021820562d1d","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.3.tgz","fileCount":24,"unpackedSize":153394,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJef0v6CRA9TVsSAnZWagAAO94P/jzph33iyxA9B/lMFTIM\nIkOGjgNV8epLs0n7QcC22NBRfMaIEqNyjEz41XKFxBSLlXIIYwC6qb0810v2\nCgapfORNfmGH7ETyVBHfcNKhXUSIOWWbTpoQ6F/SPUveD18sjnOG8xznadYf\n4qYY1n34qsx+JOs1iU2OPq+uHAar+yToqf8+PdL6PgR3kaRQ/fEdNvox7gVn\nO6YK+UAqxMRTiEyMQRvV2E7BHMAfmvc0CLmmDGLskmhv87N8mSz/7IPGnl2J\nYnxebX5wVbofzM4dxj5dF/FbUQUIkevIW9YgddnvyWunpaCCKNHKkXwMmBUA\nSH/tKpDdtwPHyaHYFevdJ2cSRjwWc6gafjypre2Hm0rGITHltdo8GJF00NA4\nHM8+sM3zF4Bzz3OjWDIZdJ3ZPG0xblYwDvvhekKZwb5q584vJ3W9Ip42Hxyk\n1H9fYMdUIqYhhJi4Jp1/bvxnqZfwqCHhFz67tJZ4fl8Me6Og25W83+NN9Wuf\n6ns/KhpE8l+SL96XW0iB2iOAUM8/3Bsw+OaRsRG96Lq7vX3Zbo3O0qrLda7O\nF7q6f609Qqz3yKcQ2tHeVWmHreYkcXAxH632fFDBpHG2pSpHrxhbVuh+/CAd\nsNAe2uofkqm6oWF1RAIwvR+2L3pCH/2Wxs+esDqc4dbYEfXwC4Efzvzoc38a\nR7aX\r\n=8FyF\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIDuq+YNFLIe+UoYriNWw+8SRpOYZNzQwWrSfGiVkLOQCAiAH91oumco5ch+Ztr+N31OUBsJhBNlADVP5juuP/+r2nw=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.3_1585400826231_0.6936726962839408"},"_hasShrinkwrap":false},"1.3.4":{"name":"@5no/pg-model","version":"1.3.4","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"f66ae496a39827e83bd0809c627c6b21bbcb25d1","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.4","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-9SZlt1gUEXkZAWEBW13UxhyXX71Te+jNnhTfB8SdePlN5qMsNUZpYmWGWZWAbABWzMoPr1LGS7C+XUtPmZdPHg==","shasum":"ab5fb1009a76bba1be740c7781f0fafa8d38b7ae","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.4.tgz","fileCount":24,"unpackedSize":153378,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJef1RQCRA9TVsSAnZWagAAA7oP/R0LSnXbaKruSocl7WjA\nMHQfjH45EmeBUIi8xeX7agqb3GMTZyurQAxgsLA2hKQ2CdlpvWFVZEZb5qkz\nJp5+qiRgQgEWo/euYFTlimMGYgT/tTNuQ8D1f3OgZK47t+754glZiJS07XD9\nKmmVHv8fGqKtNJTrzM1WuOZG+TNDJiWI/QqyxmQP0MRrlyAJALmN2vheczL/\ng5vWfGQfonKBnVNl3qqvnTvc/5ijIoGNLRIBU8MUxzs1HTdkAR0GUgM3FsWY\nbWb5vjNhWYgtPxecSycjA6l3Rse62+UHyuQC5S3QlthAa8mlTOJRnxNAfyU4\nsDLUeikIdRm4epgfwxrZ2uXFxhf2Bb9VBBIhQTtQm1W91bRItgk5s3DRRll+\nZuuPwNQl9fUxa3JZtJZpPBFYVwwoF1ajks3No6abSnEEIKyf7Ly3I6Gi2VVq\n+UYwE48uwyHzWEUtw3kghu+ENgWuMzeNbJRLC2C2lfwD28NP4XYFli+bZZeK\nlSIdcVyOPukR6dVgGnMsP7kCW5XcHDd3O0Q+hIcZFQHl07IKeHGFn1auT4rm\nMHMo5XlqIPp8kiqxsF2WKrG4N7Cm1pSrHoPQE9uTEfOQhv1ISw8g1Qpyj4Hy\nMGOc9OSEzuyfPThEq3d5csIclOCxOWRSrj+6vfyVM+C+N//T0C66Y2SwuZ33\nYev5\r\n=Xpoe\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIA7W6AXsDV18MQ8LlTpQlIb/VM9WKwYE0nSs7cpsKXMuAiArTZhbL6nEZZ68YxLd1LxcpD4QVCIi7U1i+Qh+57a6aw=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.4_1585402959904_0.7186403183701107"},"_hasShrinkwrap":false},"1.3.5":{"name":"@5no/pg-model","version":"1.3.5","description":"JS ORM for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","clean:test":"rm -rf compiled/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d compiled/test","test:clean":"rm -rf compiled/test","test:run":"cp test/mocha.opts compiled/test && mocha compiled/test","test:db":"./test_db","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3","babel-cli":"^6.26.0"},"devDependencies":{"babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"gitHead":"372245778cdf240f8708a026a200d63f6718afce","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.5","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-FG7DbOfU2XyxTeT903/ByMw7l9dpTfKRKralnZaFAdaWhWunEzuK6zW3eWVud72PfK8hMa9ERv3WL+5HOOQhpg==","shasum":"02ac06e11c0f60ae2310aa28b060a397ac934a0a","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.5.tgz","fileCount":24,"unpackedSize":165665,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeh5G0CRA9TVsSAnZWagAAxJIP/0VJYmAK1CH8ncoecc5i\ncEdXcaUIHWFXmPJUyU3kkC6AUAGvKqxVjgRdiFIMtfn96Llek5GgNQEWZonD\nFIFcxe6R27FUn0PuQJ+CMPmmnMSJAq50opbuwsHw/KFZrGx7wn4/emveACd3\nXt3NUfhGorx9DR/KvU58wDot3mnY9AY/QEQQhAOrc7pnN4q7uFmt4iVdn/ut\nyybStwssBUkUTSFIkXV7Z+ZVa02IL5+qt0FJCiX1csoSy1HguhGdU4dH+2Er\ng4FPgNOPcAEtopUPJkgXxGVn9SqB7dPhghdZQNKyREg/gVlyi7Nv2Lrs/z5b\n2Q7WnSVymhkkA6n2WoNLO+eBEvJHUmIWbztFzBmgTPmrNbDUg0ImFN5po+g7\nJIwiPoH5iXqjFK/DkIWcMbOaiLDAx8G3fEXQmj1UcxS3YwFtmzF81Dz4WEoq\nAm1zRBdRBXd1IKgwYWm0iEt25vwZ0wlEht/vyP1a7+n72/m/Sz14roTE2AKW\nm30FV282zQXCm3yL3QOu7vcZhPFtw3x9TKtwLho1n9YmB7tbev3PmcNIclLO\nXaHo18evrO2vxvCCwX+4JYj2N54D9dubj0SCVe7/8cYc3fO/1c++O0vI9Ilz\nklcBIf1NwpST38EjLNSYv7GEwhmflh5TuKj01CZ2SbQ6O7McaXx2wPQBsLud\nYuSR\r\n=Cob5\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICigDCPVjpyoxDMGPm7Ygx7TZdl3O5K2yfazIqMNi7sRAiBKU7ySifwY2y0Wq0+YXapN3+dBsMaI9qquR0rGtRfwSw=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.5_1585942964135_0.4611000010722832"},"_hasShrinkwrap":false},"1.3.6":{"name":"@5no/pg-model","version":"1.3.6","description":"JS ORM for PostgreSQL","main":"lib/index.js","scripts":{},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.0","@5no/schema":"^1.2.3"},"devDependencies":{},"gitHead":"1a6ab8de55e311e05d98076c9733354668a98fb8","bugs":{"url":"https://github.com/reb2020/5no-pg-model/issues"},"_id":"@5no/pg-model@1.3.6","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-sRCu0wCH/huxNP2gOgmQukIeJF2JfBJrzDDsDN3oAdTdW5rOtEznrqGtzpW4l10LlBKBCMMLONIAg3fs0ubbKA==","shasum":"51b4c64f17b8e59a29b3145749ccec93dcabab89","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.6.tgz","fileCount":10,"unpackedSize":105252,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeh5NLCRA9TVsSAnZWagAAhgEQAJSGlkpPxuKBHo0cOj/B\na9KYFp/78M/FYwUS4UlHMPdEQf4Sw0BFN3S4S2s2x5LTq/3LjXSuUMLDcJCV\ngkzH64YdPgerST4W3LKcPs5HG7diAm14E57wVAVXDV+9HYZWVu8jcBGE6PS9\nmrKeUL7Id6uTI2Wxy97Jt8fmd2+BbuTnPb9mTfnpxTF/cf65rXTfdtoezpwJ\nbBCImUkujxRxhPDfLL/aAp467mPyLDhmgiO4eJT/vLwGzaZbmslfe4xDvdAP\n5AIuXK3HemC8BlXR4zQObkMMoD+DK2z9RjVUr+XTvWgoSsCWvzpNsycksqlz\nyBuNfP2JcFjMI8YkmugIiKDR54yp8HCyvIB80dV7dcnOtTj1DLuGbDK+JOwe\nYbA2QhqJZLlPyQJgP82bRkPcQ+HWqjRJ2m54T7KE4z+2IcRrzqBIMzyalhJ4\n9S3h7ozqCNT6gdKVeiNMoCxmC4qCzfdcq8mEjqDNvGBQfpa5t0VYFdzD6OZx\ndCwkUxIbRdAO9KEG+3hRpsp4h3stPUycgrXkNdgzyJKdwFpCZu6FoDGF7N3F\nPi+UJs1LdI+I8SEKJ7Cn/rFraQxEIE5tF0hrGAAXgwd0zef+eMwS99eRUj6Z\ntPPQSujUC2JX+Zt17uXt1T5yAv0qbTmaiUVWWn8vzLVhdVhApZkJoQC4EJLs\nMjtc\r\n=wctM\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCKvvMdwz55RNU3dg5Cx0xoDVy6nBQbSjb8cOMAldu+vgIhANDyTawDJBiB0il5T9TawCLNItLAVmG5Q5n+XtTayNS1"}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.6_1585943371280_0.7983183906021387"},"_hasShrinkwrap":false},"1.3.7":{"name":"@5no/pg-model","version":"1.3.7","description":"JS ORM for PostgreSQL","main":"lib/index.js","scripts":{"clean":"rm -rf lib","clean:test":"rm -rf lib/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d lib/test","test:clean":"rm -rf lib/test","test:run":"cp test/mocha.opts lib/test && mocha lib/test","test:db":"./test_db","build":"babel src -d lib","prepare":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io/","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.1","@5no/schema":"^1.2.5"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"_id":"@5no/pg-model@1.3.7","dist":{"shasum":"c0fb636690e544693860d4e3d282b78cca12035c","integrity":"sha512-VK6LvYcJ1wblVTP5d/arypWegRFu5Mzm8p/Jl+CZpdS0JpbiRwmtBHCNKOM2tkV0YQN+nFZC8gLfACf/csEJZA==","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.7.tgz","fileCount":12,"unpackedSize":106460,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeh6QwCRA9TVsSAnZWagAAF2sQAJ1TNCpZBgi5xpINYCtu\npiPQD1uIG2xlfi80bh1xlKpsFDhoTlfbPm5wiQLugPUWdOZrQuyeJ7SFRZpD\npZka+9GPj0cPCU5SPECkS4wnZTbyMSuOqS+zU9tf9ZBP6k9OgW8ZQwqbR+RO\nZWxqdeAddf2+EHTAyHKb/Xm1AJU+tt2RCj0o3hmJyhOcWzP9OagzUJyh+WrR\nh6dFC9W6oQ+j+VCXDFCCU1YIY1R8yE89DPI5ZJdo6oSpSJUd6cKDMaPTjEPm\nlahjK4CYbGnPHZoC9Y5nV9I5zRsZyL/frui/6IBdAWW3cG3hLKyaRDicKeJK\nYMfQwrwnyMZ1dn/WhyHfiR+ewrBqeXJsb2AmmXXw+Jfv+S65BQ86pAlDNoBp\nzgbTmyFuw7iVT9DvFPsHXsP2vAk1a5O61XScODZvCI9ftQ8F5BCrY6IzJL8i\nfLdRQSJyUlTZ6BB1w6xyHg1/RFItWtmG9RURQHDsn0ZcJEkLj6mXK+mXBEZG\nTMYRROVjpjtgOdY6q18hJH0Sq9xH+U6qcoeLizBRIPNCfOZ0qP4AJbwO1HWP\nt9THv7y0HFaVEq11X0iP8Mms3CzJp61VQ51tAEQY+16SsGH2wJ1d6JG9W96g\na9iqa/XdjLwzZozMvQeASCQDeH4A/S7Qrgs49pm+e5fD+B6OaociNgU4PthY\nT1xG\r\n=D6Dc\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIANrL6frVImpQG56LC73oiKb5nyqdxpiekak9I2jneubAiBHXv3jixkA8JM+DPN9+LybsLXf+KfFy+dK6GAnusOwog=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.7_1585947696270_0.19810312948404962"},"_hasShrinkwrap":false},"1.3.8":{"name":"@5no/pg-model","version":"1.3.8","description":"JS ORM for PostgreSQL","main":"lib/index.js","scripts":{"clean":"rm -rf lib","clean:test":"rm -rf lib/test","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"yarn test:db && yarn test:lint && yarn test:build && yarn test:run && yarn test:clean","test:lint":"eslint --fix --ext .js test","test:build":"babel test -d lib/test","test:clean":"rm -rf lib/test","test:run":"cp test/mocha.opts lib/test && mocha lib/test","test:db":"./test_db","build":"babel src -d lib","prepare":"yarn lint && yarn clean && yarn build && yarn test && yarn clean:test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","orm","model"],"homepage":"https://5no.io/","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"dependencies":{"@5no/pg-builder":"^1.2.1","@5no/schema":"^1.2.6"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-plugin-transform-runtime":"^6.23.0","babel-polyfill":"^6.26.0","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0","sinon":"^7.2.2","sinon-chai":"^3.3.0"},"_id":"@5no/pg-model@1.3.8","dist":{"shasum":"59ed9658c4a0e0ee515314c53e92e28f58809311","integrity":"sha512-jWBmbJtIjWzgI6rA69tSX/uHYU3jtKlOqSzN27V7g22tqaE8E/vCnBZHymLkNuqyJUE3kxH0TRKVkxed5EvjEQ==","tarball":"https://registry.npmjs.org/@5no/pg-model/-/pg-model-1.3.8.tgz","fileCount":12,"unpackedSize":106460,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeyFldCRA9TVsSAnZWagAAibMP+wVzGLlgs4uJU4zzvZ91\nI0FVU9uLNd4Ojbv+LTXDXiDbuG7rGx76aU2EAmVavJUXYb0gjVQdZq5pi8tZ\nTSqTDKw1esfbrkBWArVMhX911SLkOgLMadst0UeOHaXnKcDjNEDGINLfcA3g\nnuD1xe0VsFMQxc6OJmpOGeNyTysRPM03GZvY0HravwAlzOszorAqhQDEGKn2\nI2TZnYmCo2WlXr4t/9Q6Rt6bBq8xJVuqMX/Vjaru6Ok0FjcUpe7doNRdps/i\nXkYVzoUcsobu9F8AwvY3B8O7UUJqU+GHv4xaxdUoaSrjtUlAwS0txGtAvl3N\ngNROKCjc6KV5x5GcfjtFFYPCxER8nARAQYgluQlepfMWOaosMXpUq4O+GfNB\nHFUcnUPQfWQWngAqzahes2K3QxgaLUmsMsT4q2mwOxwdjedQRyI1etunQ0ow\nYmq7OxGfYkmf654ZEeeTia/nfpgEx1IFv9THo7Ysou12iCmODMkbFZ6utDZL\n3Ecn62BwcpS24nKLOz5KvE8ewAmcO7VxTNG8O0vqmeSeSEQIj7m+4X2V16g9\nlFeXMboxKKwXxSvpBFpfIyWGKPLQhvFP89wL/lCaXSKsZFr5pYmhCfVIPudF\nNuppOZjME5RtVzlj3At8aRp1gzWk+hI7tua1UF//RheZAPTIIZKBcbh6G6BA\nxoTw\r\n=xmyg\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCy1EfxYm4aMfRmVGBBjMNJKqJgqEaXWtAeRw6jrqaxSwIhAKdZdfef0+lu0+rR43pnBZIHCw/dlkllEC9Eo+7yVica"}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/pg-model_1.3.8_1590188380620_0.8662343475624377"},"_hasShrinkwrap":false}},"time":{"created":"2020-01-02T11:12:07.375Z","1.3.0":"2020-01-02T11:12:07.692Z","modified":"2022-04-04T10:48:37.350Z","1.3.1":"2020-01-02T12:10:05.950Z","1.3.2":"2020-02-06T16:34:39.727Z","1.3.3":"2020-03-28T13:07:06.356Z","1.3.4":"2020-03-28T13:42:40.114Z","1.3.5":"2020-04-03T19:42:44.321Z","1.3.6":"2020-04-03T19:49:31.432Z","1.3.7":"2020-04-03T21:01:36.456Z","1.3.8":"2020-05-22T22:59:40.716Z"},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"description":"JS ORM for PostgreSQL","homepage":"https://5no.io/","keywords":["postgresql","sql","query","builder","orm","model"],"repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-model.git"},"author":{"name":"reb2020"},"license":"MIT","readme":"# <a href='https://5no.io'><img src='https://5no.io/img/5no-small-logo.png' height='100' alt='5no Logo' aria-label='5no.io' /></a>Node.js ORM for Postgres\n\nNode.js ORM for Postgres\n\n## Install\n\n@5no/pg-model requires Node version 8 or above.\n\n```sh\nnpm install --save @5no/pg-model\n```\n\n## .env\n\n```js\nDATABASE_URL=postgres://test:123123@127.0.0.1:5432/testDB?ssl=false\nDATABASE_QUERY_LOG=true\n```\n\n## Schema\n\n[@5no/schema](https://www.npmjs.com/package/@5no/schema)\n\n```js\n    {\n      table: {\n        schema: 'public', //database schema name\n        name: 'users', //table name\n      },\n      columns: { // describe columns \n        [name]: { // column name\n          type: String, // String, Number, Boolean, Date, Object, Array, Function\n          primaryKey: true, // only for primaryKey\n          defaultValue: null, // default value\n          required: true, // validate values\n          prefilled: true, // filling field by default\n          schema: {}, // Can describe object schema\n          fn: () => null, // Describe a function for function type\n        },\n        [name]: { // Auto filling column name\n          type: Date,\n          created: true, // Fill in create moment\n          format: 'YYYY-MM-DD HH:mm:ss', // Format date\n        },\n        [name]: { // Auto filling column name\n          type: Date,\n          updated: true, // Fill in update moment\n          format: 'YYYY-MM-DD HH:mm:ss', // Format date\n        },\n      },\n      relations: {\n        Info: { // name \n          model: UsersInfo, // model \n          join: {\n            model: Roles, // Join model\n            local: 'role_id', // local column\n            foreign: 'id', // external table field\n            type: 'one', // one, many\n          }, // join model\n          local: 'id', // local column\n          foreign: 'user_id', // external table field\n          type: 'one', // one, many, join\n          cascade: [ // cascade methods \"save\", \"delete\"\n            'save',\n            'delete',\n          ],\n        }\n      }\n    }\n```\n\n## Model Methods\n\n```js\nasync set(name, value) // setter value\nasync get(name, value) // getter value\nasync save(transactionMode = true, allSave = false) // save changes\nasync join(data) // join another model\nasync setJSON(data) // set changes by JSON\nasync saveByJSON(data) // Save changes by JSON\nasync delete() // Delete entries\nasync toJSON() // Return to JSON format\n```\n\n\n## Manager.build(model, json = false) \n\nBuilder uses [@5no/pg-builder](https://www.npmjs.com/package/@5no/pg-builder)\n\n```js\nbuilder() // get a Builder for customing query\nfind(...values) // get one row by primary keys\nfindOne(field | [...fields], value | [...values]) // get one row by filter\nfindAll(field | [...fields], value | [...values], order = null, limit = null) // get all rows by filter\ncount(field | [...fields], value | [...values]) // get count rows\n```\n\n## Model Relations Type \"many\" Methods\n\n```js\nawait add(data = {}) // Model data JSON\nfetch(field | [...fields], value | [...values]) // get rows by filter\nfetchOne(field | [...fields], value | [...values]) // get row by filter\n```\n\n## Model Relations Type \"join\" Methods\n\n```js\nawait join(data) // Model data | Json | ID\nfetch(field | [...fields], value | [...values]) // get rows by filter if type many\nfetchOne(field | [...fields], value | [...values]) // get row by filter if type many\n```\n\n## Examples\n\n```js\nconst { Manager, Model } = require('@5no/pg-model')\n\n\nclass Roles extends Model {\n  static schema = {\n    table: {\n      schema: 'public',\n      name: 'roles',\n    },\n    columns: {\n      id: {\n        type: String,\n        primaryKey: true,\n        defaultValue: null,\n      },\n      role: {\n        type: String,\n        defaultValue: null,\n      },\n      created_at: {\n        type: Date,\n        created: true,\n        format: 'YYYY-MM-DD HH:mm:ss',\n      },\n      updated_at: {\n        type: Date,\n        updated: true,\n        format: 'YYYY-MM-DD HH:mm:ss',\n      },\n    },\n    relations: {},\n  }\n}\n\nclass Settings extends Model {\n  static schema = {\n    table: {\n      schema: 'public',\n      name: 'settings',\n    },\n    columns: {\n      id: {\n        type: String,\n        primaryKey: true,\n        defaultValue: null,\n      },\n      name: {\n        type: String,\n        defaultValue: null,\n      },\n      created_at: {\n        type: Date,\n        created: true,\n        format: 'YYYY-MM-DD HH:mm:ss',\n      },\n      updated_at: {\n        type: Date,\n        updated: true,\n        format: 'YYYY-MM-DD HH:mm:ss',\n      },\n    },\n    relations: {},\n  }\n}\n\nclass UserRoles extends Model {\n  static schema = {\n    table: {\n      schema: 'public',\n      name: 'user_roles',\n    },\n    columns: {\n      user_id: {\n        type: String,\n        defaultValue: null,\n        primaryKey: true,\n      },\n      role_id: {\n        type: String,\n        defaultValue: null,\n        primaryKey: true,\n      },\n    },\n    relations: {},\n  }\n}\n\nclass UserSetting extends Model {\n  static schema = {\n    table: {\n      schema: 'public',\n      name: 'user_setting',\n    },\n    columns: {\n      user_id: {\n        type: String,\n        defaultValue: null,\n        primaryKey: true,\n      },\n      setting_id: {\n        type: String,\n        defaultValue: null,\n        primaryKey: true,\n      },\n    },\n    relations: {},\n  }\n}\n\nclass UsersAddresses extends Model {\n    static schema = {\n      table: {\n        schema: 'public',\n        name: 'users_address',\n      },\n      columns: {\n        id: {\n          type: String,\n          primaryKey: true,\n          defaultValue: null,\n        },\n        user_id: {\n          type: String,\n          defaultValue: null,\n          required: true,\n        },\n        street_name: {\n          type: String,\n          defaultValue: null,\n        },\n        postcode: {\n          type: String,\n          defaultValue: null,\n        },\n        created_at: {\n          type: Date,\n          created: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n        updated_at: {\n          type: Date,\n          updated: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n      },\n      relations: {},\n    }\n}\n\nclass UsersInfo extends Model {\n    static schema = {\n      table: {\n        schema: 'public',\n        name: 'users_info',\n      },\n      columns: {\n        id: {\n          type: String,\n          primaryKey: true,\n          defaultValue: null,\n        },\n        user_id: {\n          type: String,\n          defaultValue: null,\n          required: true,\n        },\n        first_name: {\n          type: String,\n          defaultValue: null,\n        },\n        last_name: {\n          type: String,\n          defaultValue: null,\n        },\n        created_at: {\n          type: Date,\n          created: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n        updated_at: {\n          type: Date,\n          updated: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n      },\n      relations: {},\n    }\n}\n\nclass Users extends Model {\n    static schema = {\n      table: {\n        schema: 'public',\n        name: 'users',\n      },\n      columns: {\n        id: {\n          type: String,\n          primaryKey: true,\n          defaultValue: null,\n        },\n        email: {\n          type: String,\n          required: true,\n        },\n        public_key: {\n          type: String,\n          required: true,\n        },\n        secret_key: {\n          type: String,\n          defaultValue: '',\n          required: true,\n        },\n        personalised: {\n          type: Object,\n          prefilled: true,\n          defaultValue: {\n            test: 100,\n          },\n        },\n        properties: {\n          type: Array,\n          defaultValue: [],\n          schema: {\n            name: {\n              type: String,\n              required: true,\n              filters: [\n                'lowerCase',\n              ],\n            },\n            value: {\n              type: String,\n              required: true,\n            },\n          },\n        },\n        countRoles: {\n          type: Function,\n          fn: (model) => model.getCountRoles(),\n        },\n        created_at: {\n          type: Date,\n          created: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n        updated_at: {\n          type: Date,\n          updated: true,\n          format: 'YYYY-MM-DD HH:mm:ss',\n        },\n      },\n      relations: {\n        Info: {\n          model: UsersInfo,\n          local: 'id',\n          foreign: 'user_id',\n          type: 'one',\n          cascade: [\n            'save',\n            'delete',\n          ],\n        },\n        Addresses: {\n          model: UsersAddresses,\n          local: 'id',\n          foreign: 'user_id',\n          type: 'many',\n          cascade: [\n            'save',\n            'delete',\n          ],\n        },\n        Roles: {\n          model: UserRoles,\n          join: {\n            model: Roles,\n            local: 'role_id',\n            foreign: 'id',\n            type: 'many',\n          },\n          local: 'id',\n          foreign: 'user_id',\n          type: 'join', \n          cascade: [\n            'save',\n            'delete',\n          ],\n        },\n        Setting: {\n          model: UserSetting,\n          join: {\n            model: Settings,\n            local: 'setting_id',\n            foreign: 'id',\n            type: 'one',\n          },\n          local: 'id',\n          foreign: 'user_id',\n          type: 'join', \n          cascade: [\n            'save',\n            'delete',\n          ],\n        },\n      },\n    }\n\n    getCountRoles = () => Manager.build(UserRoles).count('user_id', this.id)\n}\n```\n\nCREATE NEW ENTRY\n\n```js\nconst roleModel = new Roles()\nroleModel.role = 'Admin'\nawait roleModel.save()\n\nconst settingModel = new Settings()\nsettingModel.name = 'AdminSetting'\nawait settingModel.save()\n\nconst testNewUser = new Users()\n\ntestNewUser.email = 'test@test.me'\ntestNewUser.public_key = 'test_123'\ntestNewUser.secret_key = 'test_333'\n   \ntestNewUser.properties = [\n        {\n          name: 'Test',\n          value: 'OK',\n        },\n      ]  \n\nawait testNewUser.Addresses.add({\n  street_name: 'Test',\n  postcode: '100500',\n})\nawait testNewUser.Addresses.add({\n  street_name: 'Test1',\n  postcode: '100502',\n})\n\ntestNewUser.Info.first_name = 'Aleks2'\ntestNewUser.Info.last_name = 'Sokol2'\n\nawait testNewUser.Roles.join(roleModel.id)\n\nawait testNewUser.Setting.join(settingModel)\n\nconst returnData = await testNewUser.save()\n\n/* \nIf all correct function return boolean \"true\" otherwise array errors\nError: [\n        'duplicate key value violates unique constraint \"users_email_index\"',\n      ]\n*/\n\n```\n\n\nBUILDER \n\n[@5no/pg-builder](https://www.npmjs.com/package/@5no/pg-builder)\n\n```js\nconst builder = await Manager.build(Users).builder()\n\nbuilder.select().where('id', '=', usersNewId)\n\nconst data = await builder.rows()\n```\n\n\nGET \n\n```js\nconst dataJson = await Manager.build(Users, true).find(usersId)\n```\n\nreturn\n\n```js\n{ \n  id: '7852468e-ac99-4f5e-9ee3-d506b0c4424e',\n  secret_key: 'test_333',\n  email: 'test@test.me',\n  public_key: 'test_123',\n  countRoles: 1,\n  created_at: '2018-12-20 17:10:31',\n  updated_at: '2018-12-20 17:10:31',\n  personalised: {\n    test: 100\n  },\n  properties: [\n    {\n      name: 'test',\n      value: 'OK',\n    },\n  ],\n  Info: \n   { id: '0320dc4f-4ca7-4b65-bd42-52f286a0b9db',\n     user_id: '7852468e-ac99-4f5e-9ee3-d506b0c4424e',\n     first_name: 'Aleks2',\n     last_name: 'Sokol2',\n     created_at: '2018-12-20 17:10:31',\n     updated_at: '2018-12-20 17:10:31' },\n  Addresses: \n   [ \n     { id: 'be40ccb3-3a33-4b6e-9467-6907b0c4396b',\n       user_id: '7852468e-ac99-4f5e-9ee3-d506b0c4424e',\n       street_name: 'Test',\n       postcode: '100500',\n       created_at: '2018-12-20 17:10:31',\n       updated_at: '2018-12-20 17:10:31' },\n     { id: 'f5bae3e9-290b-451e-a0e2-1ec2d9eaf543',\n       user_id: '7852468e-ac99-4f5e-9ee3-d506b0c4424e',\n       street_name: 'Test1',\n       postcode: '100502',\n       created_at: '2018-12-20 17:10:31',\n       updated_at: '2018-12-20 17:10:31' } \n    ], \n  Roles: [\n    {\n      created_at: '2018-12-20 17:10:31',\n      id: 'be40ccb3-3a33-4b6e-9467-6907b0c4396b',\n      role: 'Admin',\n      updated_at: '2018-12-20 17:10:31'\n    }\n  ],\n  Setting: {\n    created_at: '2018-12-20 17:10:31',\n    id: 'be40ccb3-3a33-4b6e-9467-6907b0c4396b',\n    name: 'AdminSetting',\n    updated_at: '2018-12-20 17:10:31'\n  }\n}\n```\n\nUPDATE\n\n```js\nlet data = await Manager.build(Users).find(usersId)\n\nlet oneAddresses = data.Addresses.fetchOne('street_name', 'Test1')\noneAddresses.postcode = '100508'\n\ndata.Info.last_name = 'Sokol200'\ndata.secret_key = 'test_33309'\n\nawait data.save()\n\n```\n\n\nSAVE BY JSON\n\n```js\nconst testNewUser = new Users()\n\nconst newData = {\n        email: 'test2010@test.me',\n        public_key: 'test_123',\n        secret_key: 'test_333',\n        personalised: {\n          test: 100,\n        },\n        Addresses: [{\n          street_name: 'Test 100',\n          postcode: '100501',\n        }],\n        Roles: [ await adminRole.toJSON() ],\n}\n\nconst returnData = await testNewUser.saveByJSON(newData)\n\n```\n\n\nDELETE\n\n```js\nlet data = await Manager.build(Users).find(usersId)\nawait data.delete()\n\n/* \nIf all correct function return boolean \"true\" otherwise array errors\n*/\n```\n\nDELETE ONE ITEM FROM RELATE\n\n```js\nlet data = await Manager.build(Users).find(usersId)\nlet dataDel = data.Roles.fetchOne('role', 'Admin')\nawait dataDel.delete()\n```\n\n## License\n\nMIT Licensed, Copyright (c) 2018 Aleksandr Sokol","readmeFilename":"README.md"}