A capstone project aim to create a consultation chat platform for MCC.
The key words "MUST", "MUST NOT", "REQUIRED", "SHALL", "SHALL NOT", "SHOULD", "SHOULD NOT", "RECOMMENDED", "NOT RECOMMENDED", "MAY", and "OPTIONAL" in this document are to be interpreted as described in BCP 14 [RFC2119] [RFC8174] when, and only when, they appear in all capitals, as shown here.
- Node.js and NPM. LTS version is recommended
- Docker
- DB Browser for SQLite if
filed_sqlite
is preferred. - PostgreSQL. v14.3 is recommended.
- Python v3 or higher.
- Visual Studio Build Tools (v2017 or higher) with desktop development with C++
- Run
npm install
- Copy .env.example file as .env to root. Values may change according to your chosen database.
- Choose the database to be used:
- SQLite (using memory) [fastest to set]
- Change the
DATABASE_TYPE
variable in your .env tomemoried_sqlite
- Change the
- SQLite (using SQL file)
- Change the
DATABASE_TYPE
variable in your .env tofiled_sqlite
- Create an empty file named sqlite.sql in database
- Change the
DATABASE_PATH
variable in your .env todatabase/sqlite.sql
- Change the
- MySQL (container)
- Change the
DATABASE_TYPE
variable in your .env tomysql
- Run
docker-compose up -d --build
- It will run too long for the first build only. Subsequent builds will be fast. This will create the database server.
- Note: Re-run
docker-compose up -d --build
every time you change one of the following variables in your .env:DATABASE_PASSWORD
DATABASE_PORT
DATABASE_NAME
- Change the
- PostgreSQL (local)
- Change the
DATABASE_TYPE
variable in your .env topgsql
- Download the installer for the latest version.
- Install and just click next. You may customize the installation and data directory. Stack Builder is not required. Default port should be 5432. Remember your password. If you want to use the password the same as to the example, use root password.
- Wait for the installation to complete.
- Search using keyword pgAdmin 4 and run the matched application. Its purpose is similar to MySQL workbench and MongoDB Compass. This may be needed for troubleshooting.
- Change the
- PostgreSQL (deployment) [slowest to set]
- Change the
DATABASE_TYPE
variable in your .env topgsql
- Change the
DATABASE_URL
variable in your .env to URL provided by your host
- Change the
- SQLite (using memory) [fastest to set]
- Run
./execute -database -initialize
if it is the database server is newly installed; and chosen database ismysql
orpgsql
or./execute -database -upgrade
(if there are no breaking changes in database migrations) or./execute -database -reset
(if there are breaking changes in database migrations). - Run
npm run seed:up:all
(if there are no breaking changes in database migrations) ornpm run seed:redo:all
(if there are breaking changes in database migrations). - Set the empty email variables. They may vary depending on per team.
EMAIL_USER
. This e-mail address will be used to log in to the SMTP server and will be the sender of e-mail messages in the app (i.e. e-mail verification).EMAIL_PASS
. This is the password of e-mail address above and will be used to log in to the SMTP server. It is recommended to use an app password.
- Run
npm run dev
- Visit http://localhost:16000
Visit this detailed instructions for more details
Visit this detailed instructions for more details
- Angelo Magtoto
- Ardrin Gregorio
- Jarlem Red De Peralta
- John Jerome Pertez
- Kenneth Trecy Tobias