1-DAV-202 Data Management 2023/24
Previously 2-INF-185 Data Source Integration

Materials · Introduction · Rules · Contact
· Grades from marked homeworks are on the server in file /grades/userid.txt
· Dates of project submission and oral exams:
Early: submit project May 24 9:00am, oral exams May 27 1:00pm (limit 5 students).
Otherwise submit project June 11, 9:00am, oral exams June 18 and 21 (estimated 9:00am-1:00pm, schedule will be published before exam).
Sign up for one the exam days in AIS before June 11.
Remedial exams will take place in the last week of the exam period. Beware, there will not be much time to prepare a better project. Projects should be submitted as homeworks to /submit/project.
· Cloud homework is due on May 20 9:00am.


Ljavascript

From MAD
Revision as of 08:46, 11 April 2024 by Teacher (talk | contribs)
Jump to navigation Jump to search

HWjavascript

In this lecture we will extend the website from the previous lecture with interactive visualizations written in JavaScript. We will not cover details of the JavaScript programming language, only use visualization contained in the Google Charts library.

Your goal is to take examples from the documentation and tweak them for your purposes.

Overview of the approach

  • Your Python server (in Flask) produces a HTML page with some content.
  • You can embed some JavaScript code inside the HTML. This code will be run in browser.

In this case we want JavaScript to visualize data which resides in an SQLite3 database.

  • Examples in the documentation contain data written directly in the JavaScript code (such as var data in the histogram example).
  • We will also use this simple way, but see the warning below.

So data flow can be as follows:

Warning:

  • Writing data into JavaScript code is a (very) bad practice, but sufficient for this lecture. (A better way is to load data in JSON format through API).

Tips

  • Documentation for each chart contains also HTML+JS code example. That is a good starting point. You can just put it inside the flask template and see what it does.
  • Debugging tip: When looking for errors, limit the amount of data you send through the template, so you can easily read the resulting JS code.
  • Debugging tip 2: Viewing page source code (via Ctrl+U), can show you what you sent to browser.
  • Debugging tip 3: If you open devtools (Ctrl+Shift+J in Chrome, F12 in Firefox) and go to the Console tab, you can see individual Javacript errors.
  • Consult the previous lecture on running and accessing Flask applications.

Using multiple charts in the same page (merging examples)

  • You need to include <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> just once. This is similar to import in Python.
  • You can either load individual packages separately by commands of the form: google.charts.load("current", {packages:["calendar"]}); or you can list all packages in one array of the load method.
  • After loading of library is done, you can call function named drawChart as follows: google.charts.setOnLoadCallback(drawChart);. You can either draw multiples charts in one function, or call multiple functions (you need to set multiple callbacks). Be careful to not name multiple functions with same name.
  • Each chart needs its own HTML element with different ID. It looks something like this: <div id="chart_div" style="width: 900px; height: 500px;">. The id chart_div is then referenced here: new google.visualization.Histogram(document.getElementById('chart_div'));
  • Follow the instructions here: [1]