cursor.execute(query, {'data_file':'data.csv', 'db_table':'Bookings'})

LOAD DATA LOCAL INFILE %(data_file)s
 INTO TABLE %(db_table)s
 FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '\"'
 LINES TERMINATED BY '\n'

LOAD DATA LOCAL INFILE 'data.csv'
 INTO TABLE 'Bookings'
 FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '\"'
 LINES TERMINATED BY '\n'

LOAD DATA LOCAL INFILE {data_file}
INTO TABLE {table_name}
FIELDS TERMINATED BY '^' OPTIONALLY ENCLOSED BY '\"'
LINES TERMINATED BY '\n'

query = query.format(data_file="'" + self.data_file + "'", table_name=self.db_table)
cursor.execute(query)