def aws_list_data3(request, id):
context = {}
#1 get aws details
aws_details = AwsUserAccessDetails.objects.filter(user_id=request.user)
aws_details = aws_details.last()
host = aws_details.host
database = aws_details.database
password = aws_details.aws_password
user_id = aws_details.aws_user_name
#2 set up instance
aws_database_object = PostgresDB(host, database, user_id, password)
aws_site_object = AwsUploadDetails.objects.get(id=id)
table_name = aws_site_object.table_name
context['table_name'] = table_name
data_html_edit = aws_database_object.data_to_html_table_edit(table_name)
data = aws_database_object.get_plain_data(table_name)['data']
di_data = {}
for i in data:
di_data[i[0]] = i[1]
context['data_html_edit'] = data_html_edit
if request.method =='POST':
for key in di_data.keys():
updated_value = request.POST.get(key)
updated_value = float(updated_value)
origional_value = di_data.get(key)
origional_value = float(origional_value)
if origional_value == updated_value:
pass
else:
print('to be updated')
aws_database_object.update_fx_table_sql(table_name, key, 'av_fx_rate', updated_value, 'currency')
data_html_edit = aws_database_object.data_to_html_table_edit(table_name)
context['data_html_edit'] = data_html_edit
return render(request,"fileprocess/aws_listing3.html", context)
return render(request,"fileprocess/aws_listing3.html", context)
def aws_list_data4(request, id):
context = {}
#1 get aws details
aws_details = AwsUserAccessDetails.objects.filter(user_id=request.user)
aws_details = aws_details.last()
host = aws_details.host
database = aws_details.database
password = aws_details.aws_password
user_id = aws_details.aws_user_name
#2 set up instance
aws_database_object = PostgresDB(host, database, user_id, password)
aws_site_object = AwsUploadDetails.objects.get(id=id)
table_name = aws_site_object.table_name
context['table_name'] = table_name
data_html_edit = aws_database_object.data_to_html_table_editFSOnly(table_name)
data = aws_database_object.get_plain_data(table_name)['data']
di_data = {}
for i in data:
di_data[i[0]] = i[1]
context['data_html_edit'] = data_html_edit
return render(request,"fileprocess/aws_listing4.html", context)