Demonstration of framework of item list with ratings and reviews. Using SQLite database table on Node server
Sample Node server must be running on http://localhost:8000. The sample Node server package is located at ./server/.
The sample data are loaded from http://localhost:8000/SQLSchools.js?func=get
and saved to url http://localhost:8000/SQLSchools.js?func=set.
PDF is generated on url http://localhost:8000/Pdf.js?func=getpdf.
The reviews are loaded from http://localhost:8000/SQLSchools.js?func=getratings. The review is added on http://localhost:8000/SQLSchools.js?func=setreview.
The sample data on server are stored in ./server/sqlite.db database file in tables Schools_Schools, Schools_Ratings, Schools_Reviews
and the script loading and saving data is located at ./server/SQLSchools.js
There are three modes to work with data:
a) View all data and rate and review the schools.
Default mode, without log in.
b) Edit data as user. Every user has his own data.
You can log in as Jan, Magda, David,
Adam, Linda, all without password.
Or you can add new user by entering new name and password.
c) Edit all data as administrator. You can edit all data or even assign it to another user.
You can log in as Admin, without password.