def insert_row(row):
dest_table=GuruTable(table_name='ura_private_units_sold')
#print(row)
dest_table.insert().values(
year=row["year"],
month=row["month"],
developer=row["Developer"],
property_type=row["Property Type"],
locality=row["Locality"],
street_name=row["Street Name"],
project_name=row["Project Name"],
total_units_projects=row["Total Number of Units in Project"],
cumulative_units_launched=row["Cumulative Units Launched to-date"],
cumulative_units_sold=row["Cumulative Units Sold to-date"],
total_unsold_units=row["Total Number of Unsold Units"],
cumulative_units_launched_unsold=row["Cumulative Units Launched but Unsold"],
units_launched_month=row["Units Launched in the Month"],
units_sold_month=row["Units Sold in the Month"],
median_price_psf_month=row["Median Price ($psf) # in the Month"],
lowest_price_psf_month=row["Lowest Price ($psf) # in the Month"],
highest_price_psf_month=row["Highest Price ($psf) # in the Month"],
modified_date=dt.datetime.now()
).execute()
