def hello():
result = 'empty'
with connection.cursor() as cursor:
sql = "SELECT * FROM `makes` where `id`=%s"
cursor.execute(sql, ("6"))
result = cursor.fetchall()
return jsonify(result)
import sys
sys.path.insert(0,'..')
from database.database import connection
lines = []
with open("autobilis_makes.txt") as f:
lines = f.readlines()
lines = [x.strip() for x in lines]
for line in lines:
words = line.split(',')
make_id = words[0]
make = words[1]
with connection.cursor() as cursor:
cursor.execute('SELECT * FROM `makes` WHERE `make`=%s', (make) )
if len(cursor.fetchall()) == 0:
cursor.execute('INSERT INTO `makes`(`make`, `autobilis_make_id`) VALUES (%s,%s)', (make, make_id))
else:
cursor.execute('UPDATE `makes` SET `autobilis_make_id`=%s WHERE `make`=%s', (make_id, make))
connection.commit()
connection.close()