python

import csv
import os
from utilities import sqlutils


counter = 0
input_data = "data\\rating_final.csv"

#  insert data into ratings_final
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1] + ": " + row[2])
            sql = "INSERT INTO ratings_final(userID, placeID, rating, food_rating, service_rating) "
            sql = sql + " VALUES (%s, %s, %s, %s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1], row[2], row[3], row[4]))
            # print(sql)

        counter = counter + 1

# insert data in chefmozaccepts

counter = 0
input_data = "data\\chefmozaccepts.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1])
            sql = "INSERT INTO chefmozaccepts(placeID, Rpayment) "
            sql = sql + " VALUES (%s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1]))
            print(sql)

        counter = counter + 1

#insert data into userpayment

counter = 0
input_data = "data\\userpayment.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1])
            sql = "INSERT INTO userpayment(userID,Upayment) "
            sql = sql + " VALUES (%s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1]))
            print(sql)

        counter = counter + 1

#insert data into userprofile

counter = 0
input_data = "data\\userprofile.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1] + ': ' + row[2] + ': ' + row[3] + ': ' + row[4] + ': ' + row[5] + ': ' + row[6] + ': ' + row[7] + ': ' + row[8] + ': ' + row[9] + ': ' + row[10] + ': ' + row[11] + ': ' + row[12] + ': ' + row[13] + ': ' + row[14] + ': ' + row[15] + ': ' + row[16] + ': ' + row[17]+ ': ' + row[18])
            sql = "INSERT INTO userprofile(userID,latitude,longitude,smoker,drink_level,dress_preference,ambience,transport,marital_status,hijos,birth_year,interest,personality,religion,activity,color,weight,budget,height) "
            sql = sql + " VALUES (%s, %s, %s, %s, %s, %s,%s, %s, %s,%s, %s, %s,%s, %s, %s, %s, %s, %s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12],row[13], row[14], row[15], row[16], row[17], row[18]))
            print(sql)

        counter = counter + 1

#insert data into usercuisine

counter = 0
input_data = "data\\usercuisine.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1])
            sql = "INSERT INTO usercuisine(userID, Rcuisine) "
            sql = sql + " VALUES (%s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1]))
            print(sql)

        counter = counter + 1

#insert data in chefmozparking

        counter = 0
        input_data = "data\\chefmozparking.csv"
        with open(input_data, 'rU') as f:
            for row in csv.reader(f):
                if any(row) and counter > 1:
                    print(row[0] + ': ' + row[1])
                    sql = "INSERT INTO chefmozparking(placeID, parking_lot) "
                    sql = sql + " VALUES (%s, %s);"
                    sqlutils.execMysqlQuery(sql, (row[0], row[1]))
                    print(sql)

                counter = counter + 1

#insert data into geoplaces2

                counter = 0
                input_data = "data\\geoplaces2.csv"
                with open(input_data, 'rU') as f:
                    for row in csv.reader(f):
                        if any(row) and counter > 1:
                            print(row[0] + ': ' + row[1] + ': ' + row[2] + ': ' + row[3] + ': ' + row[4] + ': ' + row[
                                5] + ': ' + row[6] + ': ' + row[7] + ': ' + row[8] + ': ' + row[9] + ': ' + row[
                                      10] + ': ' + row[11] + ': ' + row[12] + ': ' + row[13] + ': ' + row[14] + ': ' +
                                  row[15] + ': ' + row[16] + ': ' + row[17] + ': ' + row[18] + ': ' + row[19] + ': ' +
                                  row[20])
                            sql = "INSERT INTO geoplaces2(placeID,latitude,longitude,the_geom_meter,name,address,city,state,country,fax,zip,alcohol,smoking_area,dress_code,accessibility,price,url,Rambience,franchise,area,other_services) "
                            sql = sql + " VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);"
                            sqlutils.execMysqlQuery(sql, (
                            row[0], row[1], row[2], row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10],
                            row[11], row[12], row[13], row[14], row[15], row[16], row[17], row[18], row[19], row[20]))
                            print(sql)

                        counter = counter + 1

#insert data into chefmozcuisine

counter = 0
input_data = "data\\chefmozcuisine.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1])
            sql = "INSERT INTO chefmozcuisine(placeID, Rcuisine) "
            sql = sql + " VALUES (%s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1]))
            print(sql)

        counter = counter + 1

#isnert data into chefmozaccepts

counter = 0
input_data = "data\\chefmozaccepts.csv"
with open(input_data, 'rU') as f:
    for row in csv.reader(f):
        if any(row) and counter > 1:
            print(row[0] + ': ' + row[1])
            sql = "INSERT INTO chefmozaccepts(placeID, Rpayment) "
            sql = sql + " VALUES (%s, %s);"
            sqlutils.execMysqlQuery(sql, (row[0], row[1]))
            print(sql)

        counter = counter + 1