10 Commits

Author SHA1 Message Date
Teodor
18a20c77a7 Completed PostGreSQL support for staging and production 2026-05-08 17:46:14 +02:00
Yannik
a7381d5257 Use prepared statements for SQL Delete commands (#17) 2024-03-05 15:10:42 -08:00
Argha-Nilanjon-Nondi
b5b308380c Prettify sql statement (#5) 2020-10-18 19:15:47 +02:00
XD-DENG
793c1fa130 1. use .encode(); 2. use placeholder for SQL INSERT
1. this makes the code able to run on both Python 2 and 3 (previous version only support 2);

2. Use placeholder to prepare SQL INSERT statement. This is much more proper than using .format to prepare the statement. One obvious advantage is it can handle single/double quotations marks very perfectly. The previou version will fail if there is single quotation mark in the values that I'm going to insert.
2018-04-17 22:09:38 +08:00
XD-DENG
7385cb4add Minor change to support Chinese character in note feature 2017-07-30 12:19:01 +08:00
XD-DENG
961f17c2f5 Ensure image files & Record can be cleaned when a user is removed 2017-07-08 11:39:59 +08:00
XD-DENG
4b693ddb69 User can delete the image they uploaded 2017-07-08 11:22:21 +08:00
XD-DENG
0e73da4df9 Add 'Image Upload' Feature
Each user can upload image to the system. The images from different users where be separated.
2017-07-08 11:02:46 +08:00
XD-DENG
c072aa771d For Private page, add feature 'take note'
This makes this app much more meaningful. For this feature, a new database table is added. More complicated logics are also needed, for example, we use hash(user ID + timestamp + note contant) as the unique id of each note (it's necessary when we try to delete a note)
2017-07-03 22:34:58 +08:00
XD-DENG
b34ba55cd2 initial commit 2017-07-01 18:37:53 +08:00