Last active
June 18, 2020 05:46
-
-
Save rodrigo-galba/0d512f561de88a58e18a3385ce2276b5 to your computer and use it in GitHub Desktop.
Dumb python script to enter data
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
""" | |
How to use it: | |
$ APP_NODE=1 python app.py | |
""" | |
import mysql.connector | |
import time, os | |
host="abc.us-east-1.rds.amazonaws.com" | |
user="cloudops" | |
password="lab" | |
database="lab" | |
def open_connection(): | |
mydb = mysql.connector.connect( | |
host=host, | |
user=user, | |
password=password, | |
database=database | |
) | |
return mydb | |
def create_database(): | |
mydb = open_connection() | |
mycursor = mydb.cursor() | |
result = mycursor.execute("CREATE DATABASE mydatabase") | |
return result | |
def create_customers_table(): | |
mydb = open_connection() | |
mycursor = mydb.cursor() | |
result = mycursor.execute("CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), address VARCHAR(255), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP)") | |
return result | |
def save_customer(conn, name, address): | |
mydb = conn | |
mycursor = mydb.cursor() | |
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)" | |
val = (name, address) | |
mycursor.execute(sql, val) | |
mydb.commit() | |
return mycursor.rowcount | |
def fetch_customers(conn): | |
mydb = conn | |
mycursor = mydb.cursor() | |
mycursor.execute("SELECT * FROM customers") | |
result = mycursor.fetchall() | |
return result | |
def save_batch_customers(nodename): | |
conn = open_connection() | |
for x in range(100000): | |
name = "User " + str(x) | |
result = save_customer(conn, name, nodename) | |
# print(name) | |
# time.sleep(1) | |
# create_customers_table() | |
nodename = os.getenv('APP_NODE', 1) | |
save_batch_customers(nodename) | |
result = fetch_customers() | |
for x in result: | |
print(x) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment