{"_id":"@caitken-com/node-red-contrib-json2mysql","_rev":"7-130feb24092f38ac2bcaefaac4e89677","name":"@caitken-com/node-red-contrib-json2mysql","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.0":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.0","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json"],"dependencies":{"mysql":"2.18.1"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"2aa394bcab4cd6dadd91268d9bf2581bba2a318c","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.0","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-eVJlKLceeWsXMjrSZ4m45J/3WWk5A8rD9cfGaXxvw7f2RyeHuHXLLZD/tS810UfFazyH5ejJqbNRBQvTulGwuQ==","shasum":"f17ff6bbccd5a9d8ff004accf923133d1f09a385","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.0.tgz","fileCount":8,"unpackedSize":40450,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEOc5xpyp95jKm5RNves68Nl4lNQFXv3y02zVkcscW/AAiEAmnipTj07/N48Rdg7R29pJewgNfR5nbYXBTuIPXKnZSI="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkIW4fACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmodPQ//a5MKjNnfiWoHfpgyd7jJqJCgMwY9dSzAe+rsDFIsGnpnHQUo\r\nPUcC439/jESIkTYnv9MSxy/UmI9x6L20zRZV3wSUbgsoGgRHsdOQw8pbGKbA\r\nla5lrDvnbBSIphSCuk7exgVTkrA97CSd4IUi8/PM+Wq4PXMbIH2pDMiu0m/o\r\nETNMhSEUCCL64kkYM0lVFMTHij+sedC8ISIhCiWMownhQGdyMtDixnsV5+oc\r\nIa2+WK9HJhnGrFstZBtM6KdOQ57yeLplDqmBYqckHSGv7KgvQc1C11h+d2zj\r\njsd5WcvlXpS/otfk5A5zKwAcRkbabCwg6nFBQ5ookoWl+KJIwaGkQZGuGsDG\r\noIItzLSgvxLJOdhgtk2sgYzKyXg//Y6Qw4sV8EsCZCwUhM8c3NFlveFcnS5z\r\ndbWFyera5vvHucUg5TLQlOe9f1+D1djuEmXKIO93koyRioEoHWLSaOJf7JFc\r\n2xDYjrHWRpH/qJ+/k3Smy+h5hOB9sk4Z1QXLguPINFwgDky9tsUR5oKSiCr7\r\ngkIPK/09StqtxBpz56dIClIgtefbPvtbobz1C4Zaf7M92DaBFGVCoDYSwruW\r\nzha4MPEhQQLMGyBdN4TsPyBW5Vf8VaL3BVfxTgCmrxCStwqPfW+ekvYlEd7q\r\npJf10ulZBB3io/V0GnwPH2Ps2AT2Y+L0wNE=\r\n=4g+e\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.0_1679912479461_0.49374606068100624"},"_hasShrinkwrap":false},"1.0.1":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.1","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"mysql":"2.18.1"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"6335e814f4009dc53abe1e60ab05dcc84e39c276","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.1","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-VkVyPFTniW9fzOb9IzDhjvvKGA/683cQPCMZJ0vO7D3agfagk7w6eyeUpZV39t9TKsfm7y+Y+LqtnwU7pvoFfg==","shasum":"fc4cadfdc7ac51b87a7ea3352b2e118fd36ba654","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.1.tgz","fileCount":8,"unpackedSize":40461,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHIDc8+/Q0m3k3i4QYHetg6f82zehKq0SCqOPr5qPSYDAiEA6YQrBehPtuOeMxDpbw4+ynlj7jZ1oV0YlvMkp5KZ9dg="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkIW9bACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmpPjw/+KtUD00oufC6IWhYPmkgFyEm+7Ol5AkwT5bKgApnYI0ljAc0J\r\nSfGY5IF5fW0ZQ+4DPoficYcpuNmdm2emRGxs7wCGqLGyse2Ir6/3M0xJeR1M\r\nfoc2MJeFF5+UVulrvdTvZMQ+oh7OCdX5+kYDEopfmS59DYDFG2HRjLuHHj63\r\neL84xr9jqj5ZslINUgr/TsVFXIYcNoVFZTbpM9CsAPyXfCnHH224PSirhXaK\r\njPVhdfpkCpYKYEvMtIL7CQWtKrD8JPtA6vp5ByWc/A3EHA6IZIefeqyV6E7c\r\nxK91JQ022b2zwRl9HroEA+dNmXfjTwWMYNTowjSjhJeE/PuoMXfT0QyOgowf\r\nfeG3cVLAUnnPhnDu9mFInB0TVpq9MPV1bBI+Hy6vy9Ibjmu3ccFtui5+5kA/\r\n7OZquI6Ymz9RolOOABpIDblS96G2I+96EzG0QzLl5t7bnMcGxiFOOJWqG3yH\r\nTHj3Ohf7UUhUCDYSpH30KyLEerIJDEF/jeU474A/9kfjn0ocX0ukF9rQ1R/p\r\ncGOLs7uso4GkaaynEZPDKllA+HYVwvSbckFWzW/jayP7siwLbwN/67cOrZwg\r\n4phBhSyLhnmDHUUMU4qhY497bbZoTz/q4KeSxFOT4QxCVfw2P5f+0tFIvjCq\r\nmeLU0Uc4jfZ4ABheQOjgEH0qcM1b3TbQSjQ=\r\n=SUkz\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.1_1679912795322_0.8455835526782471"},"_hasShrinkwrap":false},"1.0.2":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.2","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"300250198c5e8aae56dd0bb6c424bb6fb95f3fe6","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.2","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-6ZEhi0/2xWbG+ANFIy7iuaR3g8fJlluqU8cqG1csPkkgOWDSeHrilxmLYfR9F9hY0lmmefy62w0qduavJGdRcQ==","shasum":"86e42be77c8324c0bb8b9fcbce018d98c4c43b8f","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.2.tgz","fileCount":9,"unpackedSize":42275,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIGTDFMS7C7mLaALdLTxAlw1hQmZc4W6uujGtDxSIq8fMAiAwEwYAijR2wWk/jOJfkXLukZWlJG+cyD8iKrFs4tDN1w=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkIXOLACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmqj2xAAmQOOZJEZGiHRSXAFIuoSSOnZD06e52GGypT7MrTXEKwhfBkU\r\nX4IVVljtKXDp/nMBFr6AoN10SLRfq+P5ExmGow3yXwHK39QYDQdMjrLQm3gT\r\n0xgGfOllHmT98IxSvYpmGqcylmzPsGkjVAnJEyut7m7gkYNy2yVleV/mRdKI\r\nNCF7FHkJtiJ9hzocVdfIbFpNLpRT74Z2RO03LZYEbQQO7Yu6kKyiSRxOvxNZ\r\nA8dSVWZnT6Rr73HyzOQrl9cuKNLivmdSXy9BzVj05KFp/B4VSfK0e69tXHA7\r\nvcJSqdaFo6Y6Pk4QEBgRdiNDfbPIqmuyLW/sVyy116T+AL3tKr3H0P7EuEBW\r\ndhP/lpRjKalR9n4jrF7tCKlGXOvgl4Gq56s2XQiTXMENjrwMAckjfQJD7yHa\r\n6kSNdnxR2gav7nlPaBwVrKgFpXV6IlX9NVFlDtjbaJDJbgbj3Uyne+ly0PQc\r\nzlWa88x4Sfdb7ww7G8edGI1tEUnQctSSBoPlwZ4t8diicbAanNdBOE+yv9mu\r\nMYovtgrx1oITnx67ZPQ1+R/lHYnb/+un0Mj3KMjpnf8FYkgD/TkrxEBDj2Q/\r\njj+z7T9mv0SJ+y5/8X6j1521EoWHaIFSTf/2fYH0QSKwgpoVmaOnQtITxnws\r\naWaMWq4QQDZlC5Aq6f+GNg+0SIx8vts0W7w=\r\n=woKA\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.2_1679913867082_0.7584121604008387"},"_hasShrinkwrap":false},"1.0.3":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.3","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"3a8ce71447aac37f70aea42e646527769ca147b8","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.3","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-JVcosjsq2sJoyBJXBfEEoHHQGeygxabI3MfevPeTxvOnhlAV1pftl4AsRT7ZulxbnRjkwasEUAqYoTZfitRMkw==","shasum":"31c49c41d1fbc48469e2635a1a76d5fbb978f214","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.3.tgz","fileCount":9,"unpackedSize":42414,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCID2bn/zWZvHaIRJJE3zHSKuqZYmWcHk6KQIZ2fliSDvcAiEAzMqsY875KNacOXEAkmlyhE1FXFR2a/foqXYTqbf0Cs0="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkIXoDACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoczQ//ZlhM4hAYiheNisHZ4BXM7Ch4JwS/TjPds6hXRtI3eOOsx5AR\r\nfGnugYry8/tgoSSZiCgzVKMC4srXQmYnCELhh9KHK0FcpLGdON7a9tfLCz5F\r\nCVfLkUvul73jSnozpRVphxFQM0VkL4dktLteHZfqDg+3ac1HTf6lVp34Hox1\r\n2Ebt2Cig3JtiJnqmDc8qrywhrjMNj7t5V54+2Zf/J/ZqjmEGuhM7SITUg/fq\r\nUZi/YCk1fu1p/gDoKeeVE8HDcCT0Zy5MaCxYUslry99vzq10bn9l1kyeXu6W\r\nlDXyVH6kCkHR2rbZPdXgcbFQ7OUUMXOslKZa0QyM0xB+oK7gMcVJU8gsK/vy\r\nALW97k335uGAmlFm7XyBq2F+TAdp55GAefJ389oOEUq4hhXP6cG/MfOeT45E\r\nEsX1Wa2+PUzReen4pX3Y3D8mVg7l3PlQKK8fyjLWdTT/fBhs4cYlmQFExhKN\r\ntftFyk3R5JDlJB1tinn3ml2R+mvermchJ8XmDBVmYYHYOCHAO88u8dNY2Oj2\r\nVb0QkYQs7z+mNI1x8/bfQAzDOlHkXAv67Wu1o1stUf/AY/hUK17BU5pIIHa6\r\n8m22BNfFHIkxPjRLnJ4H1TMISldNY6kdlwiTJmjId5MtlukL5qtRmfjWJGmN\r\njJOwWObzo+hVL7cXA0XpTm6SgNVB9OF925o=\r\n=xnUT\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.3_1679915523585_0.6676612544652751"},"_hasShrinkwrap":false},"1.0.4":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.4","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"23f3a346af063c67d865b54a5c7416d78a8fc9ef","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.4","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-enFgyNgO5AehBOa5BZpXaZ8mP4LAMEcoMHNhrgKY+rhobugmuLY1BDYKbwzRXi83MTSTHUuidG1HmPI8NTjvOA==","shasum":"056e1904b93e7999a64b3810e9724e973d3d4796","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.4.tgz","fileCount":9,"unpackedSize":41706,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCrjKP6Zm5uf8ikJKs18QcofuF21GFQcwMDXHYKJmVSlQIhAM2l+nMosvzcVT6uxXECUNgEiQs3g4+Wd+aqk/mbMWGt"}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkJZWwACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoP6g/+LztklJQLX0azznOZX+YoSlnQDQ36j8djp03ANxxuqg/eT60S\r\narnzWiaKOvoqrx1DjCC1xoM0Zb7HdFMs9nKDBbbdjKRWmhqOP8B+/+sraTkB\r\noLBESf2tcogqUVuc8Q1++SDVXmc4mSdWGODFDSi0jdh516/0teKQxLbB1t51\r\n4EOJYLdd4+BwLT9lwvVpn6RkMngSYfyG+TqOj2YEs+GU9ZRIzuHnvoiHeRW/\r\ns+rTtb5dXg1tq6euKcDNZxwUZZepEoe+DzV8Fr1grq9EuAOHa5jyBeXWEKGj\r\ny6/jD/xQaWeKaXVGs09hleo2RV0F0BWVgE9yYAGnVmL3jg4ZJQLCKjSPjXJJ\r\nQ9N+eSXwDzgRNVSiKglPgmTUznzsG2kVIVQFrg67uIImYCXgobO3XuqBhDIg\r\nYEZLAwufGZUocJO8p7syZGt423zhHDyIgtvCVHx8ilUuFKrLZEPmEsESg1Nn\r\nkyrIIWca+f6zoOUCvs9b1/MxKfDMu8OUATXiXMDhxN0ygL0zxKDCw6hRMrms\r\ndLuflmIhbipSV8g1cim/evL7WhgyFYP882rNNv9SGhHQ0Ws1fA/V2bXz9GkO\r\najdkV0k+79isvmvoRP5B3Il+1p/4U1vuqaP8I74QjfEeMAbXo0aNZJWNET2G\r\nU8sXrl0crqrv+3+XYdFEYLDAxyXUvfgDK+s=\r\n=mmeo\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.4_1680184752244_0.721310707111217"},"_hasShrinkwrap":false},"1.0.5":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.0.5","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"4b163876e56fa5cea4413888497d4408eca0f5ba","_id":"@caitken-com/node-red-contrib-json2mysql@1.0.5","_nodeVersion":"14.18.1","_npmVersion":"6.14.15","dist":{"integrity":"sha512-2iBnwO4YKuJ3rEVdCb7pKZ479OV53LNgBIQ656yvpJeMd/xkjJCqh4SpOhZylafNmROgs1y8DwoB0fz08PuHmw==","shasum":"f9485aaeaca49d8ac88b7b7d9f423acb718d2708","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.0.5.tgz","fileCount":9,"unpackedSize":42195,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDHgpzubrlQNtntjmom5yuBmr1vu2ScZiOpdZThBoR/kAIhALk5Hm7PR7O2zPqWWJ9vs1WTXSE6ba4tLr7wwCBQZtZg"}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkMlkgACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmoE5A//ZTJqmTZ3GAZ79qcDRWAclZTavcUtIjuuHdlaOqqFhTlAbOtJ\r\nxAEVYjF3q86UjdfHbjidiUI2jlhcKNY//6V7XY6I9/+ojwyP8Bth/BAIFx0a\r\nai0lMIirF43i/5OQ25le9OUZUjXP5GSDTlQKJSDllRH6tFFLE3/tYrWHs4xT\r\nKNnwFDbuwv6bldM1tcBv0kq0jLC6GWSHx/TzFe/xEj8uV525GmszikHVR1BG\r\n9x6uddGmUZ5LLZQ/DhXpaJWp7iZjZ5c4HYTeKXav07TaiIciXv00BR2D/kKP\r\nOzYZDlT4USfbKAOM55M5upssGEMWRJl+HQkWDlMqdqgUqHo33P+sGv9kpqeJ\r\njU0+X6oqPp3V6G+Ljwk8OLBV6mamSMlkrfHnCfsy6rI5tVY96Pu9z33MrNLH\r\nH+GrZcncCL4gQ07BdAPi+vh7uT5u4xQFGIRsmVYDLzGMAtOcO+TkdhzFKCK/\r\n4Ucf7hKTn+DA36lClxAq127aJeCLZS5Kd/22zk4+n41itkqIJw1Ok/fsfA/U\r\n3UA+rJbiKV7FLhzCxvZBfc/mVFdfkWML8QpLwSb74XbaVGv82Lg5T4cGckmp\r\n7e5AnUsTEk7Bp7/982iIwg5Gldp7Z/JyeoF0MFbNgseX7q7M3PVqKqaa7J3r\r\ng69KdAW/gJs8yY/w0xLpIcN5XCLWAVf2610=\r\n=c5+4\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.0.5_1681021215951_0.36282539067060315"},"_hasShrinkwrap":false},"1.1.0":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.1.0","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"@caitken-com/simple-sql-builder":"^1.0.0","mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","repository":{"type":"git","url":"git+https://github.com/caitken-com/node-red-contrib-json2mysql.git"},"license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"c4cd81276d43c4814d2ec65dfca4686d7838a376","_id":"@caitken-com/node-red-contrib-json2mysql@1.1.0","_nodeVersion":"14.18.1","_npmVersion":"9.6.5","dist":{"integrity":"sha512-Kg9xkr2c+q8c61IYgMxJyc7OzD6o7r0XorilTw8vRccrolYSy36pVxhiNAsqcL4fpaOnsRVVfm5rv6Gye9x9JQ==","shasum":"5f989204747abfcf583b44f5da4ba223c6f9ed2b","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.1.0.tgz","fileCount":8,"unpackedSize":18544,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCGdhBt0SjhPKUVu/8FqJP+kAL2ohurLi4QidiC5+UxiwIhAOYB92LYG0r9WOvjseQi09n/QRBb5Ql2q4Fh1dMirJ4Z"}]},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.1.0_1696753925801_0.8067718616531072"},"_hasShrinkwrap":false},"1.2.0":{"name":"@caitken-com/node-red-contrib-json2mysql","version":"1.2.0","description":"JSON to MYSQL","main":"json2mysql.js","keywords":["mysql","json","node-red"],"dependencies":{"@caitken-com/simple-sql-builder":"^1.1.0","mysql":"2.18.1"},"engines":{"node":">=14.18.1"},"bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"author":{"name":"Christopher Aitken"},"homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","repository":{"type":"git","url":"git+https://github.com/caitken-com/node-red-contrib-json2mysql.git"},"license":"MIT","node-red":{"version":">=2.0.0","nodes":{"json2mysql-server":"json2mysql-server.js","json2mysql":"json2mysql.js"}},"gitHead":"d7aa6d853903c922cead63b89f949e210d41ccf9","_id":"@caitken-com/node-red-contrib-json2mysql@1.2.0","_nodeVersion":"14.18.1","_npmVersion":"9.6.5","dist":{"integrity":"sha512-gxB7H5+cxv5v3Ekp3diLKFMPw8E0Fb4NcUmnoD46lP07ZFmInDWDlHOpioaCx6eO19JXjRjqaxfVjrJxri27nA==","shasum":"fc5f584aa0e30814455c8aff5eae788f83af2ac2","tarball":"https://registry.npmjs.org/@caitken-com/node-red-contrib-json2mysql/-/node-red-contrib-json2mysql-1.2.0.tgz","fileCount":8,"unpackedSize":18544,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCjxxhpeVzHKm82bTADnBOntLHYq0eMR0lsHxhjRm457gIhAJSl+rtxXeGvobRegAoKThLzV5FS+ssWNVjE17Xetvux"}]},"_npmUser":{"name":"caitken","email":"aitken85@gmail.com"},"directories":{},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/node-red-contrib-json2mysql_1.2.0_1697096332888_0.6563253688654807"},"_hasShrinkwrap":false}},"time":{"created":"2023-03-27T10:21:19.357Z","1.0.0":"2023-03-27T10:21:19.635Z","modified":"2023-10-12T07:38:53.324Z","1.0.1":"2023-03-27T10:26:35.469Z","1.0.2":"2023-03-27T10:44:27.258Z","1.0.3":"2023-03-27T11:12:03.822Z","1.0.4":"2023-03-30T13:59:12.429Z","1.0.5":"2023-04-09T06:20:16.160Z","1.1.0":"2023-10-08T08:32:05.972Z","1.2.0":"2023-10-12T07:38:53.131Z"},"maintainers":[{"name":"caitken","email":"aitken85@gmail.com"}],"description":"JSON to MYSQL","homepage":"https://github.com/caitken-com/node-red-contrib-json2mysql","keywords":["mysql","json","node-red"],"author":{"name":"Christopher Aitken"},"license":"MIT","readme":"# JSON 2 MySQL for NodeRed\n\nTakes *{JSON}* payloads which then creates and executes MySQL queries, that are sql injection safe, with automatic quoting for input params, and  automatic **\\`table\\`.\\`column\\`** back-ticking.\n\n## Dependencies\n\n- **MySQL server:** Here's a tutorial on installing for [Raspberry Pi](https://linuxhint.com/setup-mysql-raspberry-pi/).\n- **Some prior knowledge:** Although I've changed certain keywords to simplify the json, some prior knowledge of MySQL is beneficial.\n\n\n## Config node\n\nCreate a config node to connect to your database server\n\n| Field | Comment |\n|---|---|\n| host | `your-domain/IP/localhost`. |\n| database |  Name of database to connect. |\n| user | Username to database. |\n| password | Password to database. |\n\n\n## Query node\n\nThis is the node you'll use in your flows to pass in *{JSON}* and receive *{string|array|object}* from the output.\n\n| Field | Comment |\n|---|---|\n| name | (optional) Node label |\n| server | Config node used for database connection. |\n| template | (optional) JSON string to create static payloads. Input payload can override/appended via input payload. |\n\nExample template:\n\n```\n{\n\t\"select\": {\n\t\t\"table\": {\"users\": \"user\"},\n\t\t\"columns\": [\n\t\t\t\"user.*\"\n\t\t]\n\t}\n\t\"where\": [\n\t\t[\"user.first_name\", \"=\", \"?:first_name\"]\n\t]\n}\n```\n\nExample payload to append to the template:\n```\n{\n\t\"params\": {\n\t\t\"first_name\": \"John\"\n\t}\n}\n```\n\nExample payload to override (where clause) of the template, the rest of the template will remain unchanged:\n```\n{\n\t\"where\": [\n\t\t[\"user.first_name\", \"is not\", null]\n\t]\n}\n```\n\n\n# Payload:\n\nSee documentation for available methods as [keywords within your payload](https://www.npmjs.com/package/@caitken-com/simple-sql-builder). (Note: `fromJson`)\n\n## The `return` keyword:\n\nTakes _{string}_ with value as any of the following to specify desired output of this node:\n\n| Value | Comment |\n|---|---|\n| `string` |  Returns a _{string}_ of the generated query. Useful for debugging. |\n| `array` | Returns _{object[]}_ of rows, where each row is `{column: value, ...}` |\n| `array-num` | Returns _{array}_ of rows, where each row is a numeric _{array}_ |\n| `row` | Returns _{object}_ of a single row `{column: value, ...}`. |\n| `row-num` | Returns a single row, as a numeric _{array}_ `[0: value, 1: value, ...]` |\n| `map` | Returns _{object[]}_ of `{column: value}` where the identifier is the first column in the result set, and the value is the second. |\n| `map-array` | Returns _{object}_ of `{identifier: {column: value, ...}}`, where the identifier is the first column in the result set, and the value an _{object}_  of `{column: value}` pairs. |\n| `val` | Returns a single value, of the first column of the first row. |\n| `col` | Returns an _{array}_ from the first column of each row `[0: value, 1: value, ...]`. |\n| `count` | Number of rows returned/affected. |\n\nIf omitted from payload the default return type is `string`.\n\n\n## Complete payload example\n\nExample of a typical payload.\n\n```\n{\n\t\"select\": {\n\t\t\"table\": {\"users\": \"user\"},\n\t\t\"columns\": [\n\t\t\t\"user.id\",\n\t\t\t\"user.name\",\n\t\t\t\"YEAR(user.date_added) AS alumni\"\n\t\t]\n\t},\n\t\"joins\": [\n\t\t{\n\t\t\t\"type\": \"inner\",\n\t\t\t\"table\": {\"salaries\": \"salary\"},\n\t\t\t\"conditions\": [\n\t\t\t\t[\"salary.user_id\", \"=\", \"user.id\"]\n\t\t\t]\n\t\t}\n\t],\n\t\"where\": [\n\t\t[\"salary.amount\", \">\", 100],\n\t\t[\"user.first_name\", \"!=\", \"?\"]\n\t],\n\t\"group\": [\n\t\t\"user.id\"\n\t],\n\t\"order\": [\n\t\t{\"salary.amount\": \"DESC\"},\n\t\t\"user.name\"\n\t],\n\t\"limit\": 10,\n\t\"params\": [\n\t\t\"Sam\"\n\t],\n\t\"return\": \"string\"\n}\n```\n\nWhich will return the following:\n\n```\nSELECT `user`.`id`, `user`.`name`, YEAR(`user`.`date_added`) AS `alumni`\nFROM `users` AS `user`\nINNER JOIN `salaries` AS `salary` ON `salary`.`user_id` = `user`.`id`\nWHERE `salary`.`amount` > 100\nAND `user`.`first_name` != 'Sam'\nGROUP BY `user`.`id`\nORDER BY `salary`.`amount` DESC, `user`.`name`\nLIMIT 10\n```\n","readmeFilename":"README.md","bugs":{"url":"https://github.com/caitken-com/node-red-contrib-json2mysql/issues"},"repository":{"type":"git","url":"git+https://github.com/caitken-com/node-red-contrib-json2mysql.git"}}