def insert(self, sql_values):
sql = 'INSERT INTO MOVIES (' + ', '.join(
[str(k) for k in self.__dict__.keys()]
) + ') VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
url = urlparse(os.environ['CLEARDB_DATABASE_URL'])
conn = MySQLConnection(
host=url.hostname,
port=url.port,
user=url.username,
password=url.password,
database=url.path[1:],
)
conn.ping(reconnect=True)
cur = conn.cursor()
try:
cur.executemany(sql, sql_values)
conn.commit()
except Exception as e:
conn.rollback()
raise
finally:
cur.close()
conn.close()
def delete(cls):
sql = 'DELETE FROM MOVIES'
url = urlparse(os.environ['CLEARDB_DATABASE_URL'])
conn = MySQLConnection(
host=url.hostname,
port=url.port,
user=url.username,
password=url.password,
database=url.path[1:],
)
conn.ping(reconnect=True)
cur = conn.cursor()
try:
cur.execute(sql)
conn.commit()
except Exception as e:
conn.rollback()
raise
finally:
cur.close()
conn.close()
