snippets_py
Integration
New integration from credential
mysql_connection = yepcode.integration.mysql('credential-slug')
New integration from plain authentication data
import mysql.connector
mysql_connection = mysql.connector.connect(
host="localhost",
port=3306,
user="user",
password="password",
database="database"",
)
SELECT Text Only
SELECT Text only
cursor = mysql_connection.cursor(dictionary=True)
query = "SELECT * FROM your_table where id = 1"
cursor.execute(query)
SELECT Parametrized
SELECT Parameterized
cursor = mysql_connection.cursor(dictionary=True)
query = "SELECT * FROM your_table WHERE id = %s"
cursor.execute(query, [2])
SELECT Query Object
SELECT Query object
cursor = mysql_connection.cursor(dictionary=True)
query = "SELECT * FROM your_table WHERE id = %(id)s"
cursor.execute(query, {"id": 2})
INSERT Text Only
INSERT Text only
cursor = mysql_connection.cursor()
query = "INSERT INTO your_table (id, name, price) VALUES (2, 'bar', 19.99)"
cursor.execute(query)
mysql_connection.commit()
INSERT Parameterized
INSERT Parameterized
cursor = mysql_connection.cursor()
query = "INSERT INTO your_table (id, name, price) VALUES (%s, %s, %s)"
cursor.execute(query, [3, "baz", 29.99])
mysql_connection.commit()
INSERT Query Object
INSERT Query object
cursor = mysql_connection.cursor()
query = "INSERT INTO your_table (id, name, price) VALUES (%(id)s, %(name)s, %(price)s)"
cursor.execute(query, {"id": 4, "name": "qux", "price": 39.99})
mysql_connection.commit()