{"_id":"smart-mysql","_rev":"30-52be00ccceb1e4e853654eefb0a95574","name":"smart-mysql","time":{"modified":"2022-06-26T21:19:20.611Z","created":"2017-02-24T20:12:30.541Z","0.9.0":"2017-02-24T20:12:30.541Z","0.9.1":"2017-02-24T20:16:49.930Z","0.2.0":"2017-02-24T20:27:23.822Z","0.3.0":"2017-02-24T20:31:11.091Z","0.3.1":"2017-02-25T12:52:40.262Z","0.3.2":"2017-02-25T15:15:01.784Z","0.9.2":"2017-02-25T15:25:51.806Z","0.9.3":"2017-04-05T06:22:37.382Z","0.9.4":"2017-04-05T06:25:44.455Z","0.9.5":"2017-04-05T06:29:49.802Z","0.9.6":"2017-04-05T06:41:20.465Z","0.9.7":"2017-04-05T07:07:19.976Z","0.9.8":"2017-04-05T07:09:38.065Z","0.9.9":"2017-04-05T07:18:27.277Z","0.9.10":"2017-04-05T07:19:24.207Z","0.9.11":"2017-04-05T07:23:22.116Z","0.9.12":"2017-04-05T09:35:45.047Z","0.9.13":"2017-04-05T10:02:42.351Z","0.9.14":"2017-04-05T10:05:31.151Z","0.9.15":"2017-04-05T10:19:12.050Z","0.9.16":"2017-04-05T10:20:57.357Z","0.9.17":"2017-04-08T07:47:52.509Z","0.9.18":"2017-04-08T07:52:40.404Z","0.9.19":"2017-04-19T05:35:27.978Z"},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"},{"name":"amirrezasoft","email":"amirrezasoft@yahoo.com"}],"dist-tags":{"latest":"0.9.19"},"description":"Interact with MySQL Using NoSQL Commands","readme":"**Smart MySQL**\r\n*smart-mysql made to build queries by hand waste your time.*\r\n\r\nSo let's build it with JavaScript.\r\n\r\n**How to Install**\r\n\r\n    $ npm install smart-mysql\r\n\r\n**How to connect**\r\n\r\n Let’s connect with smart_mysql class with calling class name.\r\nYou can make a new object of smart_mysql class as we have done here .\r\n\r\nhost, user , password , charset , database is required .\r\n\r\n\r\n    var smart_mysql = require('smart-mysql');\r\n    \r\n    var db = new smart_mysql({\r\n        host: 'localhost',\r\n        user: 'root',\r\n        password: '',\r\n        charset: 'utf8_unicode_ci',\r\n        database: 'avl'\r\n    }, false);\r\n\r\n\r\n **Specify your table**\r\n\r\nIt’s easy to define which table you wants to work with.\r\nYou can specify your table name as we have done below.\r\n\r\n    db.collection('table_name');\r\n\r\n\r\n**Inserting Rows**\r\n\r\nWe'll show you, That's simple to insert some records.\r\n\r\n    db.collection('user').insert({a: 1});\r\n    db.collection('user').insert({a:1, b:2});\r\n\r\nOr you can insert many rows in a command.\r\n\r\n    db.collection('user').Insert({[{a:1}, {a:2}, {a:3}], b:1});\r\n\r\n\r\nYou can use callback () function.\r\n\r\n    db.collection('user').Insert({a:1}, function(count){\r\n        console.log('Number of inserted rows : ' + count);\r\n    });\r\n\r\nWhat does callback () function do ?\r\nYou can retrieve results of your action with this class. We show you how to.\r\n\r\n    db.collection('user').insert({a:1}, function(done) {\r\n        if (done) {\r\n            console.log (\"done!\");\r\n        };\r\n    });\r\n\r\n\r\n**Updating Rows**\r\n\r\nUpdate your table simply.\r\nThis line update all of your rows without any condition.\r\nUse put new data in first parameter.\r\nNext line will update all of your culomns named `a`.\r\n\r\n    db.collection('user').Update({a: \"your data\"}, function(done){\r\n        if (done) {\r\n            console.log (\"done!\");\r\n        };\r\n    });\r\n\r\nThis sql query happen for last command:\r\n\r\n> Update `tbl` set `a`:  \"your data\"\r\n\r\nAnd you can chose condition if you want to, Put it in second parameter.\r\n\r\n    db.collection('user').Update({a:\"your data\"}, {a:\"my data\"} , function(done){\r\n        if (done) {\r\n            console.log (\"done!\");\r\n        };\r\n    });\r\n\r\nIn last line this query string will happen.\r\n\r\n> Update `tbl` set `a` :  \"your data\" where `a` : \"my data\"\r\n\r\n**Delete a Row**\r\n\r\nIt’s simple to delete a row from table with that condition you want or Without any condition as we have done below.\r\n\r\n    db.collection('user').delete({id:5}, function(done){\r\n        if (done) {\r\n            console.log (\"done!\");\r\n        };\r\n    });\r\n\r\nLast command return this query string:\r\n\r\n> Delete * from ` tablename ` where ` id ` = 5\r\n\r\nOr in other way we can use an array in condition.\r\n\r\n    db.collection('user').delete({id:[5, 7, 10, 14, 17]}, function(done){\r\n        if (done) {\r\n            console.log (\"done!\");\r\n        };\r\n    });\r\n\r\n\r\n\r\n\r\n**Selecting Rows**\r\n\r\nThere is three way to use select function\r\n\r\n>  1. table\r\n>  2. record \r\n>  3. field\r\n\r\n\r\n1. In table function you will take all of rows that you want to be.\r\nYou can use this parameters for table function.\r\n\r\ndb. Table ( field, filter, order, group, limit, page, callback )\r\nField can be a string or an array.\r\n`db.table(\"id\")`   OR   `db.table([\"id\", \"name\"])`\r\nOR `db.table(false)` FALSE will return * or all rows in select\r\nYou can set condition in second parameter for select\r\n\r\n    db.collection('user').table([\"id\",\"username\"], {id:1}, function(data){\r\n        // Process the result data\r\n    });\r\n\r\nOR use array condition\r\n\r\n    db.collection('user').table([{id:1}, {age:25}], function(data){\r\n        // Process the result data\r\n     });\r\n\r\nIn next parameter you can use ORDER in next parameter to condition; order can be an array or a string\r\n\r\n    db.collection('user').table(false, [{id : 1}, {age: 25}], \"id desc\", function(data){\r\n        // Process the result data\r\n    });\r\n\r\nOr use an array for order\r\n\r\n    db.collection('user').table([\"id\", \"name\"], [{id: 1}, {age: 25], [\"id desc\", \"name asc\"], function(data){\r\n        // Process the result data\r\n    });\r\n\r\n**Record**\r\n\r\n2. in record function you take only one row of table as we have done below.\r\nYou can use this function like table function. But different is this function fetch first row.\r\n\r\n>record(field, filter, order, callback);\r\n\r\n>db.collection('user').record([\"id\", \"name\"], {id: 5}, (rec)=>{console.log(rec);});\r\n\r\n3. field function only return first field of that row we fetch\r\n**db.field ( [ \"name\" ]  , { id : 5 } );**\r\n\r\nLast command return this query, string.\r\nSelect `name` from tablename where `id`=5, First parameter is that field we want get and second parameter\r\nIs our condition.\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n","versions":{"0.3.0":{"name":"smart-mysql","version":"0.3.0","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.3.0","_shasum":"5514f26e3a66096bf153d1139f82bf5718ac9dcd","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"5514f26e3a66096bf153d1139f82bf5718ac9dcd","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.3.0.tgz","integrity":"sha512-1dHjYNDXNWTykMQl3/tYZjhetMYiMzz6pfi4y/k6A8w7N93ycU4nVoloGb0CyMOPwqBJemC4CEv0d326244i+Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC+9fTRCVj7O94i1/IQA8qVh2+llOGu2hK/qXgBOe6NkQIhANxqSMqu/sxQNLDL3KTo+9xFF9MC6dJ2d++U96NqfzPp"}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.3.0.tgz_1487968269211_0.28078493056818843"}},"0.3.1":{"name":"smart-mysql","version":"0.3.1","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.3.1","_shasum":"c049394c4ac468ab723f55e9009b7482d057ea6a","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"c049394c4ac468ab723f55e9009b7482d057ea6a","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.3.1.tgz","integrity":"sha512-6Bc+WOx5MVG5XqmguecpYQloaL7kQ5Wt9sNR54n488slOmElzeK3qGLsUZhZ3z1neucBaHWKYB1wP1h1EJmUrQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC1/TJZ2oVBdiiZupEz1FuYfD0p/0CTJaORI6V8Gv2zYAIgFI9oPkGX+8eQuYEr9b744pX40Q0uDR34/bXIvdPDBnw="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.3.1.tgz_1488027158398_0.19616731349378824"}},"0.3.2":{"name":"smart-mysql","version":"0.3.2","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.3.2","_shasum":"c846e3ce2104be034679f39fafe6ff74465a559a","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"c846e3ce2104be034679f39fafe6ff74465a559a","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.3.2.tgz","integrity":"sha512-qTNFBuJhf22SvhBjBlHQNFLVDTLwYu70vkB2yNo4E3RvHYU3saDngSWgmSClIx2bq1vzibB5POBZaNRjmeReJg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDIq7uhREfHTv/p3faf9r+iKNz9a2dxiUKMT8sIPLM2OQIgXMMxAGJv5JTrJjVu4Tvot9RMxZWUf4gt9TNy6WrzJu8="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.3.2.tgz_1488035701078_0.5338727924972773"}},"0.9.2":{"name":"smart-mysql","version":"0.9.2","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.2","_shasum":"e74aa1f08a460e3a8deda508de6ea82466d12169","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"e74aa1f08a460e3a8deda508de6ea82466d12169","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.2.tgz","integrity":"sha512-ItXTZgK6geIQgboFrG9QxTlKkf7fQ0dfJRIeAzwOTuJ/lJjjZ7O8mlevl68++GRkt14HbbvKzDCwAA/nGoxKkA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDvYYAYbV1zPwsavb9Ut76rDmHgIni4exVDFErKGIQUMgIgC0SZ4iZA4detK6B80Z86Ft7jCDqEJ8SJ1iz+1K6ol/w="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.2.tgz_1488036350089_0.13117596739903092"}},"0.9.3":{"name":"smart-mysql","version":"0.9.3","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.3","_shasum":"264969b67041887dfc5c707059698de8c337199f","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"264969b67041887dfc5c707059698de8c337199f","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.3.tgz","integrity":"sha512-ma1gcbMXtdLf+QZbVhupccmWm9ygK2HSGASf2mjbHIA+fI2n1+DJS7iNUu4XmMahBLzLm5eJX7n32zePUSVfVQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCmdK2eKDXwTrceQ6HUi4h3gamU6S91oSIqfGCQRWiRAQIgUvF0y1Hww04JLA+uP46PJGEzm79OQIk3KQKI2bSrnD0="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.3.tgz_1491373356828_0.36914905929006636"}},"0.9.4":{"name":"smart-mysql","version":"0.9.4","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.4","_shasum":"446dfe6a14c1158c411c76ecd629cceb317b36a4","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"446dfe6a14c1158c411c76ecd629cceb317b36a4","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.4.tgz","integrity":"sha512-aa6TWy068yQSPEiInSRjoalccv7/pltnd8K3Sa4wF9nlC0cQA+82E3n7AYnVaJpHfCb2Pnrh12B2Vu5c1Mu3jw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC1uNW2DtIvdlVX8pu0q8EWrPoFdBatZcpHFQGLwQ3YQwIgfnLjkGIOvONdtk+aZSq+o+5AecCaTNAOgnhVpo8WNKE="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.4.tgz_1491373527227_0.6947041198145598"}},"0.9.5":{"name":"smart-mysql","version":"0.9.5","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.5","_shasum":"7dd61f9e383fcf52347d05e821476e057ac67657","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"7dd61f9e383fcf52347d05e821476e057ac67657","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.5.tgz","integrity":"sha512-dZ9uHLUw4Z4u58Hiro5sG+aYMMG7jMjeta9KM+HKmlZ77pX5ERBYa0mknjoAxClyM56qrvc7z5eflMQU58jeWA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIA+Ye7pP9on6ghg+F6ltsJFY7OkcmVitiP7ZLN93QyHmAiEAlf2mjYPIsMLrRdpi0I7IVEYWVDnOIJx2FZubRy57XCo="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.5.tgz_1491373789242_0.2601519194431603"}},"0.9.6":{"name":"smart-mysql","version":"0.9.6","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.6","_shasum":"387f4830217ffe780fed41e17be2754d2f2bba46","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"387f4830217ffe780fed41e17be2754d2f2bba46","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.6.tgz","integrity":"sha512-y6M5eQ/MC4ijcNLW2AAW40n99bGfJgkNxl2KMi86w8wD9dhTRnWlIO+ZwW2vQSUUhboogEoczS3dc87tFeJgsg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDmdV5v9114uddgu22SsRSp9hf+4fjMUxWM2Dd4+a/fSgIhAMEY3H/YX2E37ob/nbaDpM6jtQn80hwVumqXSzp9UZL4"}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.6.tgz_1491374479874_0.4707561933901161"}},"0.9.7":{"name":"smart-mysql","version":"0.9.7","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.7","_shasum":"d064a2f50e216c18b9feaa74b8ab616565a6aaaa","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"d064a2f50e216c18b9feaa74b8ab616565a6aaaa","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.7.tgz","integrity":"sha512-p23ruxg4IiP41RQuOJ3u8lApo/HZxMn3QY+IVET7SSq0JPrmqFFeHmMH4JM9G78QuVq9lWitgAiGHhGhR0g3xA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCM4ftii4GedylTSHkWq5cg54gDHA4PWG5jurrn+qGXqQIgHb3Z3/km6+waeB8rnlmD0SIaFEsRkf6vdqK1q7Zldj8="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.7.tgz_1491376039240_0.8162395220715553"}},"0.9.8":{"name":"smart-mysql","version":"0.9.8","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.8","_shasum":"47b2d2327bc632808f320fa2a33cca65f95f8d8e","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"47b2d2327bc632808f320fa2a33cca65f95f8d8e","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.8.tgz","integrity":"sha512-CusEzpegtCOjetBWn0Tcw6Hw7GKIYJycwWf4oNnMUH2sWxcLx8q1wexUeRlTCRWm+FQqiX/C+uILtlwJg4Bo+A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCID2E7UkxQQDrmuVEvHaSUGfZbbgJTIURVv5HNinumASoAiEAmHMx/VjyCw+HgUV4haUm27SVfPCtZO+2KIrVs51Y+pg="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.8.tgz_1491376177361_0.6507838955149055"}},"0.9.9":{"name":"smart-mysql","version":"0.9.9","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.9","_shasum":"4de2299d7308304f6f8ade3ea678974a94cd9801","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"4de2299d7308304f6f8ade3ea678974a94cd9801","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.9.tgz","integrity":"sha512-kS8o37/xZ607w8q3Mq6JummYxKNJ1hQtADty8WdN1X9vIh2WBZzWQRdLVz2nhEqDCxqR6gYOahWePF9yf+mpuQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAnU/5NuMXhg6Pc0Xv0IR+ZVo11GcrMg0zX6c4I6F8Q9AiBQgnL7wOOb0VO8z8kmcGKPCascy00m7aarKsp5P9H5Bg=="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.9.tgz_1491376705441_0.5542764430865645"}},"0.9.10":{"name":"smart-mysql","version":"0.9.10","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.10","_shasum":"294ce4f7f5576ee4bd110b604d4f4cc30f3c5ecf","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"294ce4f7f5576ee4bd110b604d4f4cc30f3c5ecf","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.10.tgz","integrity":"sha512-Htf9ytxwjFJ1kmh7KSwr9NA/Lz7DBXmxPLJnNUDuKUT7wz6/X2mFhHKhxzm/i3ILMbOZV8mlfaElJzI0C8arZg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCCji9vChNIo/N4KDrgv336WaL092jRIEF1Pk9SW7IyLAIgeG1jeexf8JAbNMQR+VWQo/HvV2jp7gydcVxaI7aNwa4="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.10.tgz_1491376763528_0.6767304602544755"}},"0.9.11":{"name":"smart-mysql","version":"0.9.11","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.11","_shasum":"efedcf939a07041c0a86bbb9ac475cb1134f3b68","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"efedcf939a07041c0a86bbb9ac475cb1134f3b68","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.11.tgz","integrity":"sha512-wWwgatl2rZ/HEIBj4uMnPkLex91RdsTohNAK0um9FQAuehhHj0yebI3T3Zc0WmjyhweToPmmnyZ6sUkLlF48CQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCAMM6zXC6l7NN6ayGI5gNSqIpg3cDdLuW5AOskKM1n5QIhAIqrUP3YeycLYACRN4aDalWrdTxhPKKycpCCvhkYYSum"}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.11.tgz_1491377001461_0.7919020389672369"}},"0.9.12":{"name":"smart-mysql","version":"0.9.12","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.12","_shasum":"206fb91d0b4413111a37147add646b43c1bc423b","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"206fb91d0b4413111a37147add646b43c1bc423b","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.12.tgz","integrity":"sha512-jldDIxYKpHKQ28x31KAdX3UTArGlyEz6OHptgPV403CB5uejUzkqwaHTiuMrndjv72kHhkVP2O+3G/XPnbBkyQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBdrvgPlfNghajkegn+zX7T08rN+/izHDki2qvwuZHdRAiEA4OusAU5UQ3Sm48aPtyprIHjoNWmA3m2ecUFRdTORl4E="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.12.tgz_1491384944485_0.21349164354614913"}},"0.9.13":{"name":"smart-mysql","version":"0.9.13","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.13","_shasum":"88355ae40f6bba9d6ea40922e6536c8d52de3aca","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"88355ae40f6bba9d6ea40922e6536c8d52de3aca","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.13.tgz","integrity":"sha512-CBjn0BeKrr9etisU7rFiOrMAMZCR3GuG7+E301Cw3E2wWW7hP9S/4WORs+ZzwqqKRoVCeoU+0hgILG0gX/3dJA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFnIs6wUR2lLvIoz5wBWULJomone4P9q76v36K92XVXFAiBRNQFuvRdjxgZ8l7IL2p8JIhhHIloBrD3wnSOVauMCLA=="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.13.tgz_1491386560513_0.1970296350773424"}},"0.9.14":{"name":"smart-mysql","version":"0.9.14","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.14","_shasum":"3a112d34f8fe6531e7b3d7641b3c3d85cc52738c","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"3a112d34f8fe6531e7b3d7641b3c3d85cc52738c","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.14.tgz","integrity":"sha512-dh/PSE55vjDW35fU/IVWSL65Mv/XFR8CD5afsA0ywOmaMeYYhFaw4Ah2e0PJcBA4ArLeVNtqukldZRd+FtrtDw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE1C6fGxWtZafgSgvCGOhX/2v3I1wo3QbaK1U7kv9hPrAiAgf2h0uFCYyXFayBfx/C1lP1Z6HeJitzhYFQ2JDkIaQQ=="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.14.tgz_1491386728967_0.4361471284646541"}},"0.9.15":{"name":"smart-mysql","version":"0.9.15","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.15","_shasum":"b159e4091fadd54f6b97cffe8434054b55e0bde2","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"b159e4091fadd54f6b97cffe8434054b55e0bde2","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.15.tgz","integrity":"sha512-RlDVBPvYFcpo1DEiLxNPpHSPvK3P/cABg7WKCHoKkY082OVUlaKDbNaEOU32If34O+r4Pfhp+aFbff9EQYekHw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHC9c9+mp+MAbols9Zo6yMeT/EcLbas2JMaI2WXCXvstAiEAnVGlJgvbfDJH3H9CLl3UQK7fqx1Yci+Q7Nuxcgw4xWA="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.15.tgz_1491387551370_0.4786828891374171"}},"0.9.16":{"name":"smart-mysql","version":"0.9.16","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.16","_shasum":"454f409eea5b17ae6b2cf648e7fe0e4e67657923","_from":".","_npmVersion":"4.0.5","_nodeVersion":"7.4.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"454f409eea5b17ae6b2cf648e7fe0e4e67657923","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.16.tgz","integrity":"sha512-dpelMbEE2dtz/5GZTLHcOou+RpBCqYPA/NbKVGZ8p0MgTvkv0OLPaIAl0KykCfsJhHOI/Eduxr5WIv/EBvevrA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD9NFtYGPQnYCoqYJ8BewA+hCF5P8Jgfbj3bqGsOvtqgQIgZb5ErEf7uRtVwYRWpOLJON8OBaxRAmbsbxnFSWCNiDU="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.16.tgz_1491387656674_0.18958532414399087"}},"0.9.17":{"name":"smart-mysql","version":"0.9.17","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.17","_shasum":"6366c1d28bb702012f2dc1a4e2c8a487d3140547","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.10.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"6366c1d28bb702012f2dc1a4e2c8a487d3140547","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.17.tgz","integrity":"sha512-bPjzYClZBDll+T6stwlTFmCZH7tbW19PaQ6v+D5Cq9+nkJalHXfmjVPJ43rl1LGLAc00dxDcaO7da51Te3HbdQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDM82LzStCtR+la0K+A0+m4ZSUTQlFUpDqia8oROAVnCgIgYDJax/vT3+BXYiwTV/b99jKCZzdlwrMfzQJL43NQ2tk="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.17.tgz_1491637671959_0.03349589719437063"}},"0.9.18":{"name":"smart-mysql","version":"0.9.18","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.18","_shasum":"652168bccaf17b6352d2df5a27e6c510e1ffc342","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.10.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"652168bccaf17b6352d2df5a27e6c510e1ffc342","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.18.tgz","integrity":"sha512-ZJ+ZcgxQXaVk7PW+D+JzTYgcSv4XyoxfO5/lX30TuiLb1/B7NVzk5XtTi/PQY4hCe+iOLT0rN+R577u2+bm2lQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCICa6CtwtjkmR1TZMa7h3rEoZAxXb/8UoVvWZxlbbPfvaAiAnVXjjwgqg2x+P/JJlBjZYwvww6hwLn+WMiXxZWiJWuQ=="}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.18.tgz_1491637958182_0.5652264126110822"}},"0.9.19":{"name":"smart-mysql","version":"0.9.19","description":"Interact with MySQL Using NoSQL Commands","main":"index.js","scripts":{"test":"echo \"Error: no test specified\" && exit 1"},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","dependencies":{"mysql":"latest"},"_id":"smart-mysql@0.9.19","_shasum":"4dde569b2279389ac901e118f729e6eae81785d8","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.10.0","_npmUser":{"name":"afsorde","email":"hamid@yekta.io"},"dist":{"shasum":"4dde569b2279389ac901e118f729e6eae81785d8","tarball":"https://registry.npmjs.org/smart-mysql/-/smart-mysql-0.9.19.tgz","integrity":"sha512-0T+k2JjEez2ab9v6m3gfiSEUH3tIWPv4OrSpbbDp90gTxjBP/U0sOPZ0FrFNWufs78mMcpF5e/dXq/2tDxUEoQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCp/+DgJsrD+84VsgTJLwoGS/i3S2WUQx7Cpd4xamheQQIhAMDQ677UFCv9p8xb77oubmb6CRPLUzZOjIy19qVHC1GP"}]},"maintainers":[{"name":"afsorde","email":"hamid@yekta.io"},{"name":"amirrezasoft","email":"amirrezasoft@yahoo.com"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/smart-mysql-0.9.19.tgz_1492580127007_0.5449290028773248"}}},"keywords":["mysql","smart","nosql"],"author":{"name":"Hamidreza Afsorde","email":"hamid@yekta.io","url":"http://yekta.io"},"license":"ISC","readmeFilename":"readme.md","users":{"afsorde":true}}