{"_id":"genql","_rev":"7-b52860e59440e47c3d6e70ca804bfdc3","name":"genql","dist-tags":{"latest":"2.0.1"},"versions":{"1.0.0":{"name":"genql","version":"1.0.0","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"is-obj":"^2.0.0","lodash":"^4.17.15"},"gitHead":"0dea0a32d3f9d92c81faf929e531ffed5f2fa422","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@1.0.0","_npmVersion":"6.5.0-next.0","_nodeVersion":"11.6.0","_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"dist":{"integrity":"sha512-dnGzwnFp/T3CTSavUFpg2bBTkUtu4ERMaWbGTxU/XWZmuJc6WPv6cTDfp82NcVETFrBnNlovZXmaGSwrb6Kw+A==","shasum":"43c437b8364bb57073907a74715753c247aeacec","tarball":"https://registry.npmjs.org/genql/-/genql-1.0.0.tgz","fileCount":4,"unpackedSize":4911,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdRpKMCRA9TVsSAnZWagAA8p0P/jt1HuIY1/VXkXY1IXyi\n/fXh8dXkVMSmImvsZ3vXz+/sDMvsxKSE768GoE5iu66AOSIvWuaXuIQ6Z71A\n6nZVzRd53xjSK7Ztzh/OhbKA6aaUnN3R7k7ZRxVUaIB8fzx+RUzXOzCmy+bw\niRE90XbDIGLUJiYSeF2f9qNfMqTNA8pu7MH2gcEL/2LyOAsHfBweSb+f9Lam\niTgIKmF9SeztEzUr2xAWcjvtqlDjHsgy1hS0YgvP3a4OzjGtksAPH+lamihI\nsFBfkkds434Tyu8l763vqp5TrYWqYgWUynoF+Wbuij/Trp64W/hxNreKctJV\nowZeDk25yhRuXVFTHW8b7sf2udXcVkykf8xIxVo793WGYLwWGN7cmTND3bis\ny8/cUxlEOfd6mQne2FjfMOXwJYBLnUFeY1SqiiLJMx2PvRcf/+TYwvfeWtpI\nAG37wLMAUj5G/QSHORnGL5xJZygchHT2o4itogCdcFgibmre3QTj8WpZRjZM\n+Bcocc7e3qtTqPhxRt5hy5TSDKs7HQN3XYfgcq+20WsZuP6Y93hCBMjEjHAL\neReR1mlkXBEYuor4WbR+5z28fGqEOJW1XVRsyWOrzYVKWD02x7DK08WXg2KU\nuLkdnFL53GC8OCrkvJf0zjY2cegAf4Yuwl0QhCBXhwQZK6ZVmkPVqWP7dzuu\ntWD5\r\n=guzo\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIE9xvPWSW4fMsilWlUVaVW6lIre7NKJyey2joq+ulKziAiEAhTZohu0g4/yuriSY1vy1AnyufzA0MBgPR55F+0jv/7c="}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_1.0.0_1564906123488_0.741867594260456"},"_hasShrinkwrap":false},"1.0.1":{"name":"genql","version":"1.0.1","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"is-obj":"^2.0.0","lodash":"^4.17.15"},"gitHead":"79334dd808f40f89411396beb0a7eba176bf9254","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@1.0.1","_npmVersion":"6.5.0-next.0","_nodeVersion":"11.6.0","_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"dist":{"integrity":"sha512-eYk0M6kpnt7EmuFHwjad6G493hQWnwaiRFsr1+MMLxPMMj4OlVEHuFmHKu+i7lZUC/91U5uo2Z+LHYc+A1ELYQ==","shasum":"7b222e04328e11978901d7e4a0b489ce6bff0e2c","tarball":"https://registry.npmjs.org/genql/-/genql-1.0.1.tgz","fileCount":4,"unpackedSize":4983,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdRtrSCRA9TVsSAnZWagAA26UP/3nx392Y3u8rjNpx18b3\n4aHhEh74XaZqdcta86RNlRQfm9oZLjcxTcQI4zVhuj5tghCIcT9V4GwSp2Pz\n8rxL5FG8fm4v0AWWh5J1WzOzmXSClNdqVqwqvVW2i/UbbreYz4RiK5eeecKJ\nRb/3dUNfnzitoErgYLssOtjFtcm+hfV2WUAvhrcFCrBT4hj0H07hNrzK79Ey\nE5qQ+aqRpIjtHP4yP5imkjFKLoNO3DlftYgM0oRkTZjF1EsImk8/P7mhI1Vj\nbihvpHpgBaV/ndOU5V2tdsWSAfGs97ViopjZ1T2mLIS7dBcDOVAYI23TbSq6\nhLHksUkqbNWdxyyblFzZUaBECUI0wcywQ5+48hCQ4znYiR+2QHxXlRJlfDbZ\nfY9BBC485phDgkJy5OuxE0mrz0L0wNuYklNauT0MgvdwO2ErCHl3cQN7qJkv\n+c+GETne6n1pc/PEVnjcMf4RrUJ0XCt8w37ZTMS+rvAMkj5DgcB38lwhE6r9\n8jLQI6m/8p55OVw2WUBfew/M509JcMTa7PU2dsl+G71MtWi5JfHW4nYf0S86\nRJTJm0vGKt80W8NcsVrfKTO+r3nSkCsRfshVkiASd3PemNWWe+hsovmQuSH5\nX9QUDLgteo79cCNcvTNYDbK5qob2HP07tzTU2R5Q8fdY0YWps9J1g1lZG4s9\nu02z\r\n=mKHy\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDhNJzdLgdc6KfVofd7iI1V5iRKUNwS2qn7a9NjoPZ2YwIhAP3lN1RTtl/H3x7SBApQFRTL6fP536lBU6+Q/gZEjs6y"}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_1.0.1_1564924626006_0.8885888559360791"},"_hasShrinkwrap":false},"1.0.2":{"name":"genql","version":"1.0.2","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"lodash":"^4.17.15"},"gitHead":"7be1c3dd756fad8dceeb32b5254f9b8aea19ad5f","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@1.0.2","_npmVersion":"6.5.0-next.0","_nodeVersion":"11.6.0","_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"dist":{"integrity":"sha512-MX5yPpO3sYTu6lHDuR94I0O6/ZK4z0fOaax4nAFCRFuAhCtTivtJbWx4m5iqcFOqrnLe43UYcSgZ/+VVF5IJVw==","shasum":"d36a4b1c5039888a0a27fea616646ae4e29f3bc1","tarball":"https://registry.npmjs.org/genql/-/genql-1.0.2.tgz","fileCount":13,"unpackedSize":10552,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdRwzpCRA9TVsSAnZWagAAbGEQAICRs6+X139kSQyd/Ev0\nfhTAz/TXruViLGlJ184H6VsHs/UV8tsAVpMY7gvhTawin1UFw6SUsZauBUtZ\ngy827MkcLUrOrLNXCnIOCgsed/dr0vj7QXgH9tfHRvCzMdZQEr/IIkM6ceyK\ncgW9y2FLvmVt6nRMS7Dl2j9NLa5z91bThbL608xfCTb6sZLTZHrDhW80EbLr\nMg83faYuh3IoeCQ59IRjRYi2D6chT4Rl5JwZiVY8u4ljnPqEczQiaLIHM08m\nIDiVtRIiqnQLwGAJXnxQIDLh3Il1XPY876Wdgev3yXa6dCcIFTlmCmBmJQxh\nMrkyv67swP6gCr+Z6xjBSQdgI9a3tySKGD+QBg+Xv0KnJ1IKiOgjCzL83Odr\nZOY0+NWLRySVFQ5AwEQ9RqooEwfkuw55S976/uCVtrwIcr/sLjIoxFE9KVhZ\n8jDqV03cIS4a30+6p1BxiYF9GtLNPL1ZHoVUrq2Y3YX0K7Py5uHFeq77wTsx\nwd4NM6g5ykBmAYGEsEQsofNAuLfIWW4PJx5vHIgPyegGnQEgu4k7Yfnb0XNz\nodcaGnmeLy7lThAE0XB97gzsmITHh5NhuasYlpSmQMKCuXh/DbYTEU8ux7d+\nSfJ6AkS3oJUVnPKDRVl4mab/nimzCXnIQp+fJ7JRiZ+yD2I0qeP8mXGl1xdj\ndMFL\r\n=vjXb\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICgaeHWiMR9g25MtGBU8eXbjhWc1VK61GDtgKIwxmBxiAiASisb22sYPPwgNH+yIRai0As+0UhrCudYIi2NLdnyF5Q=="}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_1.0.2_1564937447795_0.21614769409950219"},"_hasShrinkwrap":false},"1.0.3":{"name":"genql","version":"1.0.3","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"lodash":"^4.17.15"},"gitHead":"42a15a60690c944de1dc4b5f8974fca8dd62994c","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@1.0.3","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-rKfs9SVaYXX7vO5TVNf6cs9zSmXV+2wi3T3mRc+r3omgU8PNbYM6WuafrCnH6ACGa2U09jbfCiCoI3yeEl2o2g==","shasum":"ce396726498b51f844cb64fdefbfc55b58e7ab52","tarball":"https://registry.npmjs.org/genql/-/genql-1.0.3.tgz","fileCount":14,"unpackedSize":10997,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdUCLzCRA9TVsSAnZWagAAd2wP+wRFit8rk+FhA9QC5+Wo\nlvEdzeyJSQMaH5tjnOTv6/O/EyCfAomcCJC3eObOBd6KzufD9CxaPqs/JLBT\nlK4YAZjF1i5YVepAEpPGcOqLSsPj5Z0xa6256XrchxiMP8IsRHc68SSzGL0c\nnJ9w8OCoQiZdWvKMpAJMgqjbBTxVJHqTDV4YHxpgwxrJ45+PbldQ3IY235TT\n+/novELPX24ljf3JLBRWaFN4NaKuA3pLnUg+jbdQp+tfa12pweUpRj4e90h3\nqmzcCZL4mNv8eS1bDv0F/tfX7uDp+HU4OF7TxIRqXGnuVSJSztDg3pEj6KV9\n54+BZbLKYhCrameB3cEcq+Hi4lBstPxGT/sDBsXjSqHB/GKoyZwp+Bz4tlpN\naDorK2pzMbaxgIS8AjYq0AHERdwR+s71ipaaxJuUYGWlw8xY2CiHtm6RSKN2\nZoCOVeHkorWPxPLsGgzJfZQNrrm1hbBBlHsNilbUTXaYoLxNdsbEHJY683yv\nQ72ccQ2eKz0v+mg7ML0G+DtPXeTpLFXgD2n9lKzIBQGFU0CxhOiP3qyxUkqD\nIThRrYvAzrfe0rVxn+UwKpheURuzV5HA0G60RufrhS2outyQ2Otc+p5fQODF\n/hocjVlwhUJntmJNFjj2mkthJQZpFBK8Dv0893XhuSuRYP4LIZARjfA3HZWi\nFUCd\r\n=daFq\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQChYbH/7FAawCg4nRaaw9LIDGK7WgOyL/gZc8v76ZEM9gIhAKO/u9ad/FcZ1JEZkdCsiczDLLUgt5BHcl4mPAF0A6YV"}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_1.0.3_1565532914606_0.7819151038602317"},"_hasShrinkwrap":false},"1.0.4":{"name":"genql","version":"1.0.4","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"lodash":"^4.17.15"},"gitHead":"25b873903f8f41ad29ef29259cef3fd6332e13f5","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@1.0.4","_npmVersion":"6.5.0-next.0","_nodeVersion":"11.6.0","_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"dist":{"integrity":"sha512-kX38KjnY7H8EuWtwa9Vz4XXv7NYP0A1Ke3zecr7F5SavmfqYs9tZPBeg5edffZgSLDDoMVXNzzgI8kAfFmob2A==","shasum":"e0ff3bc97a3b2116faa4759e983c3dad7d51158e","tarball":"https://registry.npmjs.org/genql/-/genql-1.0.4.tgz","fileCount":14,"unpackedSize":11094,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdUFPHCRA9TVsSAnZWagAAO7oP+wce8GVTR37fQ3uIDaWI\nme4q4UF2XFsxRZgPBYOBf+0rjFKpnVUAzxZ2QVHAZBTqPWYGwSwsXMM87YB9\nfv3kbXCEo3EClUzAf3cI/3hQGX8xa4zGk0kP2Cfe465shbKOfnXbEwhnJ55m\niI2fzmU0ZMEK4yPE7tMoofCPYxdkdgA4C+MXy6fcgJDtcWgD+tgYuQLgb/lq\n/syotIUiibLCf3DBGQnl+LjQ9J28LCoC5fXoJAVdJFjCeDwL1/TX67VpSsnR\nB5TQHV3kTzbqR3MDbgFZ21iOufhddSlYdtxPkc0267n4cKUDIpY8INFJwdQl\n1aF77vXNBpUBZqN0Qtl2y7GWKzVm7TXQdawZxdL913tnezLjm0POtIeSLY2Q\nBW6/cVzcy/STAWLFrJ5ALmx7zot2DrIEvJJrZBQJYUbKytPTFeGDtPTIbap6\n8OArhHF5lW2MQgORdshfCCGjharioKk22lx3OVz8sePC7DhSZKQAIvLG47fE\nlOSWn6VKFjv7PhcntAFwIjlXDPuM6ofWVV01tAlLchNqiDKUX1ap2rIK4neU\nRDzHGDrMv7TNb3RimydfNTMhvM2J/u7Pic/nL2tDeEezMLzjv9kRAB1OAsSa\nzBg99bStdn82HQLDTdJxUvVUgWe5Vw/YkzSwrFN82Ggp2gphQ0h2L5TkID8H\nAHTO\r\n=/B2A\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIG2QRf2OL5qMNJYzlVYL2Ryg41nBsj5bUpuf9W/5d52xAiBekIe0P93f/s4ICaedyzLg/hwMcZp0z9Mx20lyS09/jg=="}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_1.0.4_1565545414796_0.4749021918150922"},"_hasShrinkwrap":false},"2.0.0":{"name":"genql","version":"2.0.0","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","mocha":"^5.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"lodash":"^4.17.15"},"gitHead":"3c7070b8f0eb9b49eb4aea2e7069b6e98013257d","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@2.0.0","_npmVersion":"6.5.0-next.0","_nodeVersion":"11.6.0","_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"dist":{"integrity":"sha512-2pYEVlTedUqfPddobI6UNlTwFBmuZSGwnEFB0iuv5gHAhxG/kabv/dpD60DHXmkV5xcvAp/sT+12HQzMe9kcgQ==","shasum":"7ab794fe086d2fbb3b1efcf4e4dbe53e6e4ff743","tarball":"https://registry.npmjs.org/genql/-/genql-2.0.0.tgz","fileCount":4,"unpackedSize":7139,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdcTeeCRA9TVsSAnZWagAAa54P/0XxHYpsss7jEtCQ+J7/\nJXLvZc2lRS81BjWeOE6F7RwnRWP1Luj+C6GV3Kx5eTaqM4pF9SfRHTFVi7Hy\nrCnMBOsX2crlhPlcYnsjCG227x9Uke5YmIc8IDWCJ6yhKA1wNhdHn3aW29mK\nyv0CCTORlelJX/NZDqqqTkxL/HGiCvjo/YT22MH+1jms25K9OwuY9/c2kwwp\nsZaF1ALueK86uxXuYN684U0JwbMvL/AAzNHY7XcIVLf3vdvHemNOzVEN+41Q\nPTM2gOhohmNlVDysTs2rSvBSsB1S7CCOA42jlJZ57ilEcbKXRXbJD8DMxihP\n+tj6LXHu821WEjfFBzOi157wUMxMbFhRDF7JtOlGRDPBA+9HOYPl99EyfYlU\nx+qVadntCUGOehhb1tuKlu3/LKwbIu6pTD2D9/OOdpWgZTxxQQgkF0WwEaJW\nIyvHqhG4dRSmU+rT6WrTc0+EXG6dYw4cO0yGENzoeg1kSqvlAOjhgJmrAini\nntu3m9MUFwqfVOg3gS8oR9azibV3Nf6Vf87QYabc5+jaXKJFFu5n3W8zg2RD\nKaNXV5/Eh5mj0UAcTVUDm7TcN+jWnKN4EYLGvVakPkTh0Q8jiuZz7DJj0EqD\nCksMm9n63kuOjw+1lrBpODR22V62Q+yar5F4Fx3XY5jH/0DT7hNytjvI+Tgu\nx0In\r\n=0z/Z\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIC2KATPkurDgHdTbVcBdC7jdD9swI32y9t8szxVeRmTEAiEAto6lt56GOe1OevKUK1T6drRBK5l74IdWq9IYJIFZxrI="}]},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_2.0.0_1567700893965_0.6918930040703972"},"_hasShrinkwrap":false},"2.0.1":{"name":"genql","version":"2.0.1","description":"Helper for generating and formatting SQL queries","main":"index.js","scripts":{"lint":"eslint --ignore-path .gitignore .","pretest":"eslint --ignore-path .gitignore .","test":"node_modules/mocha/bin/mocha tests/*"},"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"devDependencies":{"chai":"^4.2.0","eslint":"^5.11.1","eslint-config-strongloop":"^2.1.0","mocha":"^5.2.0"},"author":{"name":"Arshad Kazmi"},"license":"MIT","dependencies":{"lodash":"^4.17.15"},"gitHead":"cbe083b83a6a525e510b8ad1b0214b6f5f5b59b1","bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"homepage":"https://github.com/arshadkazmi42/genql#readme","_id":"genql@2.0.1","_nodeVersion":"14.15.5","_npmVersion":"6.14.11","dist":{"integrity":"sha512-mZvBg23mU9HikS0FJ50KWna+tOlN8geBA9d62NyklQexbL0JhqO8oZ0qS0SM6TSIGj1VG7AV3wS20zn1off6Lg==","shasum":"fba2daebcb7138538692b4fbef737ede716fc547","tarball":"https://registry.npmjs.org/genql/-/genql-2.0.1.tgz","fileCount":4,"unpackedSize":7139,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhGMqRCRA9TVsSAnZWagAAJucP/3HyJoSAW7zyQ4244wPZ\nh6ftErRTW9swuJHe1xA3GzXIu2w+vW1jMM/NJ2d8OxAVKsk7JltC1YmbEXYN\nhGQXDtS4GaOgOoKhxsA7aj5vJCvFlG8m5gEUxH79zivHK3zqpXlwvBC/C5a/\ngQEaSp3EG/FAuPtFX4h9c0x1fbiwZi8DEH7SRtZbcCOlSgZFIH9MkDBS9x04\nMwlfHPME4EbSRP7FcspbP+AuD5mpr6l58/HL/BkDlNd3p7SMNGz7UDroXdCS\nnmmxZil9DtTZoluSr5FjO4wJplzt4OGqHnZ221CJY6xXlsucYc0CxDAL1URY\nnpnw8Qg5fUsCdZ3jUGMrVM7xXaqgG9U7Tg7g/es/23TaRkB0fV4SimfOZ4Wg\n5uvo9WdW05qIMfL2FNxX5ol2D7RDabjhJ5FIjGemSCT7L57QzTzCS47VaWIs\nG1XXUcERjqQWdOouwHBOz2+ctwhfQknDJGoo2fxbIiqh7rxCwJCVDrAMmMHm\n4hYwQfZiKUJXDAzI1Y0f9dPsf8zNwh2v6l9YPbiOwi/gfVo6ThTSiVEO+V/o\nAvSzr8DT4Za2UZ6sYJ1Zc8gup8vz8ElWEO+ksf8KRJU4NYic+7V0AkkiGIbz\n+qv9hh2FcYhKcWm0AtPLjDzEvMbBX65OX4DdZ/3oBh29KjIxodQ9+FxykoWP\n37ZX\r\n=9tmb\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDFTA2/MIylG0O+WYw4avytWVHeROZe2YhebfGFLbGSewIgSdZs2ea2qsPDWo+Ogyu6lkm4iMyR0n+cMnIZaq5NVxo="}]},"_npmUser":{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"},"directories":{},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/genql_2.0.1_1629014672909_0.4332521231185271"},"_hasShrinkwrap":false}},"time":{"created":"2019-08-04T08:08:43.487Z","1.0.0":"2019-08-04T08:08:43.602Z","modified":"2022-05-03T13:30:02.288Z","1.0.1":"2019-08-04T13:17:06.184Z","1.0.2":"2019-08-04T16:50:48.002Z","1.0.3":"2019-08-11T14:15:14.792Z","1.0.4":"2019-08-11T17:43:34.963Z","2.0.0":"2019-09-05T16:28:14.109Z","2.0.1":"2021-08-15T08:04:33.166Z"},"maintainers":[{"name":"arshadkazmi42","email":"arshadkazmi42@gmail.com"}],"description":"Helper for generating and formatting SQL queries","homepage":"https://github.com/arshadkazmi42/genql#readme","keywords":["sql","query","sql query","query format","query generate","mysql","sqlite","query helper"],"repository":{"type":"git","url":"git+https://github.com/arshadkazmi42/genql.git"},"author":{"name":"Arshad Kazmi"},"bugs":{"url":"https://github.com/arshadkazmi42/genql/issues"},"license":"MIT","readme":"# genql\n\n[![Build Status](https://api.travis-ci.com/arshadkazmi42/genql.svg?branch=master)](https://api.travis-ci.com/arshadkazmi42/genql)\n\nHelper for SQL query generating and formatting\n\n## Install\n\n```\nnpm i genql\n```\n\n## Usage\n\n```javascript\n\nconst GenQL = require('genql');\nconst model = require('./data/model.json');\n\nconst $ = new GenQL(model);\nconst fields = $._select();\nconst fieldPrefix = $._select('$');\nconsole.log(fields);\nconsole.log(fieldPrefix);\n\n// OUTPUT -> {{fields}}\n// [\n//  'id',\n//  'name',\n//  'email',\n//  'COALESCE(NULLIF(class, ''), cls)',\n//  'status'\n// ]\n\n// OUTPUT -> {{fieldPrefix}}\n// [\n//  '$.id',\n//  '$.name',\n//  '$.email',\n//  'COALESCE(NULLIF($.class, ''), cls)',\n//  '$.status'\n// ]\n\n```\n\n## API\n\n- **`_default(field)`**\n  - Returns default value for the field from model\n  - ***`Params`***\n    - field (string)\n\n- **`_insert(prefix)`**\n  - Returns all the fields from model, except the `auto` fields. Uses optional `prefix` and appends it to column name\n  - ***`Params`***\n    - prefix (String) {Optional}\n\n- **`_join(prefix)`**\n  - Returns all the fields from model, appended with `join_key` as prefix which is defined in model. Uses optional `prefix`  and appends it to column name\n  - ***`Params`***\n    - prefix (String) {Optional}\n\n- **`_findPrivate(prefix)`**\n  - Returns all the column which have `private` flag defined with it in the model. Uses optinal `prefix` and appends it to column names\n  - ***`Params`***\n    - prefix (String) {Optional}\n\n- **`_removePrivate(data)`**\n  - Removes all the values from `data` object which are marked as private column in model\n  - ***`Params`***\n    - data {JSON}\n\n- **`_values(data)`**\n  - Returns list of values from data object for all the columns from model which are not marked as private\n  - ***`Params`***\n    - data (JSON)\n\n- **`_select(prefix)`**\n  - Returns all the fields from model and uses alternate column if defined in model. Uses optional `prefix` and appends it to column name\n  - ***`Params`***\n    - prefix (String) {Optional}\n\n- **`_update(fields, data)`**\n  - Returns list of values from data for the input fields\n  - ***`Params`***\n    - fields (Array)\n    - data (JSON)\n\n> Note: Sample model definition is available in [data/model.json](data/model.json)\n\n\n## Contributing\n\nInterested in contributing to this project?\nYou can log any issues or suggestion related to this library [here](https://github.com/arshadkazmi42/genql/issues/new)\n\nRead our contributing [guide](CONTRIBUTING.md) on getting started with contributing to the codebase\n\n## Contributors\n\nThank you to all the contributors who have helped us in making this project better :raised_hands:\n\n<a href=\"https://github.com/arshadkazmi42\"><img src=\"https://github.com/arshadkazmi42.png\" width=\"30\" /></a>\n\n\n","readmeFilename":"README.md"}