Guest User

Untitled

a guest
Nov 25th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. @app.route('/export_data', methods=['GET', 'POST'])
  2. def export_data():
  3. cnx = mariadb.connect(user='root', password='', database='test')
  4. cursor = cnx.cursor()
  5.  
  6. query = "SELECT ID, data, cred, deb, dsc, valor FROM base_teste"
  7.  
  8. cursor.execute(query)
  9. rows = cursor.fetchall()
  10. desc = cursor.description
  11. cnx.close()
  12.  
  13.  
  14. lista = [dict(itertools.izip([col[0] for col in desc], row))
  15. for row in rows]
  16.  
  17. return lista
  18.  
  19. @app.route('/get_data', methods=['GET', 'POST'])
  20. def get_data():
  21. results = export_data()
  22. return json.dumps(results)
  23.  
  24. $(document).ready(function() {
  25. $('#examplo').DataTable( {
  26. "ajax": {
  27. "url": "/get_data",
  28. "dataSrc": "",
  29. },
  30. } );
  31. } );
Add Comment
Please, Sign In to add comment