Skip to content
This repository was archived by the owner on Apr 1, 2022. It is now read-only.
This repository was archived by the owner on Apr 1, 2022. It is now read-only.

Change DB Configuration from sqlite to Postgres #27

Description

@Awinja-j

Describe the bug

Currently, the code has SQLite configuration, this should be changed to Postgres as it is supported by Heroku

What is the DB being used for?

The DB will store user information and the user's current stage in the bot.
The stages are in reference to gamification which will happen in the future.
The DB will also store all the messages that will be used in the bot.

Model structure

Messages
Index| Message| response_id| gif_id
Users
index| Full_name| game_stage|

Steps to take

  1. Install psycopg2
  2. Install flask-sqlalchemy
  3. freeze requirements.txt
  4. create models folder and add -> init.py, game_users.py, messages.py
  5. add tests

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or requesthelp wantedExtra attention is needed

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions