def insertrecords(request):
print('insert record')
data = JSONParser().parse(request)
print(data['date_stamp'])
con = sqlite3.connect('./tkph.sqlite')
cursorObj = con.cursor()
cursorObj.execute(
"create table if not exists items (date_stamp TEXT primary key not null, date TEXT,customer TEXT,project TEXT, state TEXT,district TEXT,siteAddress TEXT,otherDetails TEXT,tyre_size TEXT,max_amb_temp TEXT,cycle_length TEXT,cycle_duration TEXT,vehicle_make TEXT,vehicle_model TEXT,empty_vehicle_weight TEXT,pay_load TEXT,weight_correction TEXT,load_dist_front_unloaded TEXT,load_dist_rear_unloaded TEXT,load_dist_front_loaded TEXT,load_dist_rear_loaded TEXT,added_by TEXT,distance_km_per_hour TEXT,gross_vehicle_weight TEXT,k1_dist_coefficient TEXT,k2_temp_coefficient TEXT,avg_tyre_load_front TEXT,avg_tyre_load_rear TEXT,basic_site_tkph_front TEXT,basic_site_tkph_rear TEXT,real_site_tkph_front TEXT,real_site_tkph_rear TEXT, uploaded BOOL);"
)
values = list(data.values())
cursorObj.execute(
'insert into items ("date_stamp","date","customer","project", "state", "district", "siteAddress", "otherDetails","tyre_size","max_amb_temp","cycle_length","cycle_duration","vehicle_make","vehicle_model","empty_vehicle_weight","pay_load","weight_correction","load_dist_front_unloaded","load_dist_rear_unloaded","load_dist_front_loaded","load_dist_rear_loaded","added_by","distance_km_per_hour","gross_vehicle_weight","k1_dist_coefficient","k2_temp_coefficient","avg_tyre_load_front","avg_tyre_load_rear","basic_site_tkph_front","basic_site_tkph_rear","real_site_tkph_front","real_site_tkph_rear","uploaded") values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)',
values)
con.commit()
cursorObj.execute("select * from items;")
rows = cursorObj.fetchall()
rs = pd.DataFrame(
data=rows,
columns=[
"date_stamp", "date", "customer", "project", "state", "district",
"siteAddress", "otherDetails", "tyre_size", "max_amb_temp",
"cycle_length", "cycle_duration", "vehicle_make", "vehicle_model",
"empty_vehicle_weight", "pay_load", "weight_correction",
"load_dist_front_unloaded", "load_dist_rear_unloaded",
"load_dist_front_loaded", "load_dist_rear_loaded", "added_by",
"distance_km_per_hour", "gross_vehicle_weight",
"k1_dist_coefficient", "k2_temp_coefficient",
"avg_tyre_load_front", "avg_tyre_load_rear",
"basic_site_tkph_front", "basic_site_tkph_rear",
"real_site_tkph_front", "real_site_tkph_rear", "uploaded"
])
print(rs)
js = rs.to_json()
ps = json.loads(js)
data = {
'hello': ps,
}
print(data)
return JsonResponse(ps)
def post_to_googlesheet(request):
if request.method == 'POST':
data = JSONParser().parse(request) # Python dict
client = pygsheets.authorize(
) # Авторизация в Google API, файл client_secret.json должен лежать в корневой папке
sh = client.open(TABLE_NAME) # Объект таблицы
wks = sh.sheet1 # Объект вкладки, по умолчанию первая
wks.append_table(list(data.values()))
send_mail('Новая регистрация',
mail_body(data),
settings.EMAIL_HOST_USER, [RECIPIENT_EMAIL],
fail_silently=False)
all_records = wks.get_all_records() # list of dicts
if len(all_records) % PERIOD == 0:
send_mail('Список регистраций с правкой резюме',
mail_body(all_records[-PERIOD:]),
settings.EMAIL_HOST_USER, [RECIPIENT_EMAIL],
fail_silently=False)
return HttpResponse('OK')
