import mysql.connector, datetime
from mysql.connector import errorcode

try:
    cnx = mysql.connector.connect(user='retail_dba', password='itversity',
                                  host='nn01.itversity.com',
                                  database='retail_db')

    cursor = cnx.cursor()
    query = ("select * from orders limit 10")
    cursor.execute(query)

    for i in cursor:
        print(i)

    query = ("select * from orders where order_date = %s")
    order_date = datetime.date(2014, 1, 1)

    cursor.execute(query, (order_date,))

    for i in cursor:
        print(i)

    cursor.close()

except mysql.connector.Error as err:
  if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
    print("Something is wrong with your user name or password")
  elif err.errno == errorcode.ER_BAD_DB_ERROR:
    print("Database does not exist")
  else:
    print(err)
else:
  cnx.close()