This is a backend and frontend application for the management of the online database of science clubs affiliated with the Philippine Society of Youth Science Clubs (PSYSC).
This is a course requirement for CS191/192 Software Engineering Courses of the Department of Computer Science, College of Engineering, University of the Philippines, Diliman under the guidance of Ma. Rowena C. Solamo for the 1st and 2nd Semester of the academic year 2018-2019.
main.py
running in a Heroku dyno with ClearDB MySQL
- Clone this repo
- Run
heroku create
in theorgdb/
folder - Run
heroku addons:create cleardb:ignite
(changeignite
to something else if on a different plan)
- Run
- Deploy this Git repo into a Heroku app using
git push heroku master
- Run
heroku run python importdb.py
in a terminal, ignore the[Command skipped]
messages - Run
heroku run python initcredentials.py
in a terminal - Input new passwords for the
admin
&dev
accounts (can be skipped by pressing Enter) - Run
heroku ps:scale web=1
- Run
heroku open
- Install requirements:
pip install -r requirements.txt
- Copy
dbconf.sample
and rename it asdb.conf
- Edit
db.conf
according to the MySQL/MariaDB settings - Run the MySQL/MariaDB server
- Run
source db.sql;
in an SQL command prompt - Run
python initcredentials.py
in a terminal - Input new passwords for the
admin
&dev
accounts (can be skipped) - Run
python main.py
in a terminal - Open https://localhost:8080 in a browser
More information about the application and its development process are available in orgdb.wordpress.com.
This project (Org Affiliations Database) is licensed under the MIT License - see the LICENSE.md file for details.
The CherryPy library, used here for the web-serving code, is licensed under the BSD 3-Clause "New" or "Revised" License.
The Mako library, used here for templating HTML pages, is licensed under the MIT License.
The Semantic-UI framework, used here for its UI elements, is licensed under the MIT License.
The jQuery library, used to implement various dynamic UI features, is licensed under the MIT License.