problem with command heroku run -a pipenv run upgrade

Question

I have made a code with python flask and I am following the next steps to deploy it:

Deploying to Heroku (takes 7 minutes)

1. Install heroku (if you don't have it yet)

   $ npm i heroku -g
   

2. Login to heroku on the command line (if you have not already)

   $ heroku login -i
   

3. Create an application (if you don't have it already)

   $ heroku create <your_application_name>
   

Enviroment Variables (takes 2 minutes)

Now navigate to your heroku dashboard and look for your application settings, we have to manually add our environment variables into heroku:

You cannot create a .env file on Heroku, instead you need to manually create all the variables under your project settings.

Open your .env file and copy and paste each variable (FLASK_APP, DB_CONNECTION_STRING, etc.) to Heroku.

Deploying your database to Heroku (takes 3 minutes)

You local MySQL Database now has to be uploaded to a cloud, there are plenty of services that provide MySQL database hosting but we recommend JawDB because it has a Free Tier, its simple and 100% integrated with Heroku.

1. Go to your heroku project dashboard and look to add a new heroku add-on.

2. Look for JawDB MySQL and add it to your project (it may ask for a Credit Card but you will not be charged as long as your remain within 5mb database size, enough for your demo.

3. Once JawDB is added to your project look for the Connection String inside your JawDB dashboard, something like:

   mysql://tqqa0ui0cga32nxd:eqi8nchjbpwth82v@c584md9egjnm02sk.5btxwkvyhwsf.us-east-1.rds.amazonaws.com:3306/45fds423rbtbr
   

4. Copy the connection string and create a new environment variable on your project settings.

5. Run migrations on heroku: After your database is connected, you have to create the tables and structure, you can do that by running the pipenv run upgrade command on the production server like this:

   $ heroku run -a=<your_app_name> pipenv run upgrade
   

   :warning: Note: Notice that you have to replace <your app name> with your application name, you also have to be logged into heroku in your terminal (you can do that by typing heroku login -i)

   Push to the Heroku codebase

   Commit and push to heroku, make sure you have added and committed your changes and push to heroku

   $ git push heroku main hh
   

   That is it!

Now the problem is when I run this command:

heroku run -a=<your_app_name> pipenv run upgrade 

And the respons is:

bash: pipenv: command not found 

This is my Pipfile.txt:

[[source]]
name = "pypi"
url = "https://pypi.org/simple"
verify_ssl = true

[dev-packages]

[packages]
flask = "*"
sqlalchemy = "*"
flask-sqlalchemy = "*"
flask-migrate = "*"
flask-swagger = "*"
psycopg2-binary = "*"
python-dotenv = "*"
mysql-connector-python = "*"
flask-cors = "*"
gunicorn = "*"
mysqlclient = "*"
flask-admin = "*"
cloudinary = "*"
flask-login = "*"
pipenv = "*"

[requires]
python_version = "3.8"

[scripts]
start="flask run -p 3000 -h 0.0.0.0"
init="flask db init"
migrate="flask db migrate"
upgrade="flask db upgrade"
deploy="echo 'Please follow this 3 steps to deploy: https://github.com/4GeeksAcademy/flask-rest-hello/blob/master/README.md#deploy-your-website-to-heroku' "

These are the commands I run before deploying:

pipenv install;
mysql -u root -e "CREATE DATABASE example";
pipenv run init;
pipenv run migrate;
pipenv run upgrade;

If I don't run the upgrade in heroku this is what Release Log in heroku:

sqlalchemy.exc.DatabaseError: (mysql.connector.errors.DatabaseError) 2003 (HY000): Can't connect to MySQL server on 'localhost' (111)
(Background on this error at: http://sqlalche.me/e/14/4xp6)

Answer 1

It seems you are missing the pipenv tool or missing in PATH. You may install it using:

$ pip install pipenv

If pipenv already is installed check the PATH variable and if you are able to locate pipenv using $ which pipenv. Have a look at the docs regarding PATH:

• https://pipenv-fork.readthedocs.io/en/latest/advanced.html