A demo project created to learn PyQt (Python wrapping of the famous Qt Library). The project communicates to a MySQL database using mysql.connector python module.
- python (v2.x)
- mysql
- pyqt4
- mysql.connector
sudo apt-get install python mysql-server python-qt4 python-mysql.connector
Edit the configuration.py file according to your mysql setup.
| Name | Role |
|---|---|
| user | MySQL Username |
| password | MySQL Password |
| host | MySQL Host |
| database | MySQL Database Name |
| logintable | Login Table Name |
| entriestable | Entries Table Name |
| Field | Type |
|---|---|
| name | varchar(20) |
| password | varchar(20) |
| role | int(11) |
NB: 'role' field: 1 for admin, 2 for user, 3 for tester
| Field | Type |
|---|---|
| creator | varchar(20) |
| format | varchar(400) |
To execute the project:
python main.py