Advertisement
abrar1

Untitled

Dec 11th, 2020
208
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.52 KB | None | 0 0
  1. sql = "SELECT WEEKlY_DAY, START_TIME, END_TIME FROM ROSTER WHERE EMPLOYEE_ID = %s;"
  2.         cursor = connection.cursor()
  3.         cursor.execute(sql, [employee_id])
  4.         result = cursor.fetchall()
  5.         cursor.close()
  6.         table = []
  7.        
  8.         for data in result :
  9.             row = {'day': data[0], 'start_time': data[1], 'end_time': data[2]}
  10.             table.append(row)
  11.        
  12.         return render(request, 'sales_representative_status.html', {'emp_info': emp_info, 'flag': flag, 'table': table})
  13.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement