import mysql.connector

def main():
    connection = mysql.connector.connect(user='[your username]',
                                         password='[your password]',
                                         host='warren.sewanee.edu',
                                         database='[your database]')

    count = 0
    f = open("data/museums.tsv", "r")
    for line in f:
        count += 1
        if (count % 1000 == 0):    # sanity check
            print(c)
        line = line.strip()
        fields = line.split('\t')

                             #
        query = " ...."      #  <---- for you to fill in.
                             #    it may take mulitple lines
                             #    to do it.

        cursor = connection.cursor()  #
        cursor.execute(query)         #  these four lines should execute
        connection.commit()           #  the query you built above
        cursor.close()                #

    f.close()


main()