node-red-node-mysql

{ "id": "b1c2d3e4.f5g6h7", "type": "function", "name": "Prepare MySQL Query", "func": "// This code is designed to be placed inside a Node-RED Function node.\n// It prepares the 'msg.topic' and 'msg.payload' objects\n// which are then passed to a `MySQL` database node (from this package).\n\n// First, ensure you have a `MySQL` node configured in your Node-RED flow\n// with appropriate database credentials and connection details.\n// Connect the output of this Function node to the input of your MySQL node.\n\n// Example: Inserting a new user with a unique username\n// Make sure your 'users' table exists, e.g.:\n// CREATE TABLE users (id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(255) UNIQUE NOT NULL);\n\nconst uniqueUsername = `user_${Date.now()}_${Math.floor(Math.random() * 1000)}`;\nmsg.payload = { username: uniqueUsername };\nmsg.topic = \"INSERT INTO users (username) VALUES (:username);\";\n\n// --- Alternative: Updating an existing user ---\n// Uncomment the following lines to demonstrate an update operation.\n// This requires a user with a specific ID to exist.\n/*\nmsg.payload = { userId: 1, newUsername: \"updated_user_name\" };\nmsg.topic = \"UPDATE users SET username = :newUsername WHERE id = :userId;\";\n*/\n\n// --- Alternative: Selecting data ---\n// Uncomment the following lines to demonstrate a select operation.\n/*\nmsg.payload = { searchTerm: \"%user%\" };\nmsg.topic = \"SELECT id, username FROM users WHERE username LIKE :searchTerm;\";\n*/\n\nreturn msg;", "outputs": 1, "noerr": 0, "initialize": "", "finalize": "", "libs": [], "x": 100, "y": 100, "wires": [ [ "a8b9c0d1.e2f3g4" // Connect this to your Node-RED MySQL node's ID ] ] }