dockers/scraper/schedular.py
def make_insert(mycursor, loc, start_date, due_date, size, url, price, lat, lon, maanden):
    """
    Insert data into database table of mysql
    """
    call = "INSERT INTO kamernet (loc, start_date, due_date, size, url, price, lat, lon, tijd)"
    call += " VALUES ('{}','{}','{}',{},'{}','{}', {}, {}, {});".format(loc,
                                                               start_date,
                                                               due_date,
                                                               size,
                                                               url,
                                                               price,
                                                               lat,
                                                               lon,
                                                               maanden
                                                               )
    mycursor.execute(call)
    return call

    Insert data into database table of mysql
    
Insert data into database table of mysql
Insert data into database table of mysql
def make_insert(mycursor, loc, start_date, due_date, size, url, price, lat, lon, maanden):
    call = "INSERT INTO kamernet (loc, start_date, due_date, size, url, price, lat, lon, tijd)"
    call += " VALUES ('{}','{}','{}',{},'{}','{}', {}, {}, {});".format(loc,
                                                               start_date,
                                                               due_date,
                                                               size,
                                                               url,
                                                               price,
                                                               lat,
                                                               lon,
                                                               maanden
                                                               )
    mycursor.execute(call)
    return call
def make_insert ( mycursor , loc , start_date , due_date , size , url , price , lat , lon , maanden ) : call = "INSERT INTO kamernet (loc, start_date, due_date, size, url, price, lat, lon, tijd)" call += " VALUES ('{}','{}','{}',{},'{}','{}', {}, {}, {});" . format ( loc , start_date , due_date , size , url , price , lat , lon , maanden ) mycursor . execute ( call ) return call
Insert data into database table of mysql
Insert data into database table of mysql
"""
    Insert data into database table of mysql
    """
mycursor
loc
start_date
due_date
size
url
price
lat
lon
maanden