\r\n\t\t\t\t\"options\": {} // optional\r\n\t\t\t}\r\n\t\t}{...}\r\n\t}\r\n}\r\n```\r\n\r\n## Optional Configurations:\r\n\r\n`gracenode-mysql` supports connection options. To add options, add `options` in your configurations.\r\n\r\n#####API: *create*\r\n\r\nMySql create(String configName)\r\n
\r\n> Returns an instance of MySqlGroup class\r\n\r\n##### MySqlGroup class\r\n\r\n> **getOne**\r\n\r\nvoid getOne(String sql, Array params, Function callback)\r\n
\r\n> Executes a \"select\" SQL query and passes a result to callback.\r\n>> If no result is found, the funtion will throw an error.\r\n```javascript\r\nvar mysql = gracenode.mysql.create('peopleDb');\r\nmysql.getOne('SELECT age, gender FROM people WHERE name = ?', ['bob'], function (error, result) {\r\n\tif (error) {\r\n\t\tthrow new Error('nothing found');\r\n\t}\t\r\n\t// do something here\r\n});\r\n```\r\n\r\n> **getOneFromMaster**\r\n\r\nReads from \"write-only\" database.\r\n\r\n> **getMany**\r\n\r\nvoid getMany(String sql, Array params, Function callback)\r\n
\r\n> Executes a \"select\" SQL query and passes results to callback\r\n>> If no result is found, the function will throw an error.\r\n\r\n> **getManyFromMaster**\r\n\r\nReads from \"write-only\" database.\r\n\r\n> **searchOne**\r\n\r\nvoid searchOne(String sql, Array params, Function callback)\r\n
\r\n> Executes a \"select\" SQL query and passes a result to callback\r\n>> No result will **NOT** throw an error.\r\n\r\n> **searchOneFromMaster**\r\n\r\nReads from \"write-only\" database.\r\n\r\n\r\n> **searchMany**\r\n\r\nvoid searchMany(String sql, Array params, Function callback)\r\n
\r\n> Executes a \"select\" SQL query and passes results to callback\r\n>> No result will **NOT** throw an error.\r\n\r\n> **searchManyFromMaster**\r\n\r\nReads from \"write-only\" database.\r\n\r\n> **write**\r\n\r\nvoid write(String sql, Array params, Function callback)\r\n
\r\n> Executes \"insert/update/delete/truncate/alter/create/drop/\" SQL query\r\n>> Can **NOT** be executed if the *type* is \"ro\"\r\n\r\n> **transaction**\r\n\r\nvoid transaction(Function taskCallback, Function callback)\r\n
\r\n> Creates Mysql transaction and allows you to execute transactional SQL queries in taskCallback.\r\n>> Commit will be executed automatically on successful execution of taskCallback\r\n>>> An error in taskCallback will cause auto-rollback and ends the transaction.\r\n>>>> Can **NOT** be executed if the *type* is \"ro\"\r\n```javascript\r\nvar mysql = gracenode.mysql.create('animalDb');\r\nmysql.transaction(function (transactionMysql, finishCallback) {\r\n\ttransactionMysql.write('INSERT INTO animal (name, species) VALUES(?, ?)', ['dog', 'knine'], function (error, res) {\r\n\t\tif (error) {\r\n\t\t\treturn finishCallback(error);\r\n\t\t}\r\n\t\ttransactionMysql.write('INSERT INTO food (animalName, amount) VALUES(?, ?)', ['dog', 10], function (error, res) {\r\n\t\t\tif (error) {\r\n\t\t\t\treturn finishCallback(error);\r\n\t\t\t}\r\n\t\t\t// taskCallback is done. now move forward\r\n\t\t\tfinishCallback();\r\n\t\t});\r\n\t});\r\n}, \r\nfunction (error) {\r\n\tif (error) {\r\n\t\tthrow new Error(error);\r\n\t}\r\n\t// All done and committed\r\n});\r\n```\r\n\r\n> **placeHolder**\r\n\r\nArray placeHolder(Array params)\r\n
\r\n> Creates and returns an array of *?* based on params given.\r\n```javascript\r\nvar mysql = gracenode.create('people');\r\nvar params = ['jenny', 'ben', 'krista', 'ken'];\r\nmysql.searchMany('SELECT * FROM people WHERE name IN (' + mylsq.placeHolder(params) + ')', params, function (error, res) {\r\n\tif (error) {\r\n\t\tthrow new Error(error);\r\n\t}\t\r\n\t// do something here\r\n});\r\n```\r\n","maintainers":[{"name":"voltrue2","email":"voltrue2@yahoo.com"}],"time":{"modified":"2022-06-18T13:46:04.810Z","created":"2014-05-22T05:35:14.662Z","0.1.0":"2014-05-22T05:35:16.236Z","0.1.1":"2014-05-26T04:56:50.984Z","0.1.2":"2014-06-06T05:04:22.822Z","0.1.3":"2014-06-30T03:44:55.803Z","0.1.4":"2014-07-02T00:36:30.902Z","0.1.5":"2014-11-05T10:44:00.210Z"},"readmeFilename":"README.md","keywords":["gracenode","framework","mysql"],"repository":{"type":"git","url":"https://github.com/voltrue2/gracenode-mysql.git"},"contributors":[{"name":"Brian de Heus","email":"me@brian.jp"}],"author":{"name":"Nobuyori Takahashi","email":"voltrue2@yahoo.com"},"bugs":{"url":"https://github.com/voltrue2/gracenode-mysql/issues"},"license":"MIT"}