How to create test database with Flask-Testing

Question

I want to set up test database for Flask-Testing class, so tests do not affect my main database. I need test database being created each time I run my unittests testcase How can I do this?

I use Flask-Testing, Flask-SQLAlchemy, psycopg2

Privilegies to create database properly granted. So now I just have to figure out how perform this.

Please advice how can I do this?

Community · Accepted Answer · 2020-06-20 09:12:55Z

3

Use different setting for production and testing purpose.

How to create flask app this way - http://flask.pocoo.org/docs/0.10/patterns/appfactories/#app-factories

UPD

Create base_setting.py for base settings, production_setting.py and testing_setting.py with diffrerent db settings and create app from one of them. - http://flask.pocoo.org/docs/0.10/config/#configuring-from-files

for example:

app = Flask(__name__)
app.config.from_pyfile('base')
app.config.from_envvar('YOURAPPLICATION_SETTINGS')

Don't forget to set YOURAPPLICATION_SETTINGS env

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 17, 2015 at 10:15

Alexander Sysoev

8356 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

micgeronimo Over a year ago

Can you please post more detailed answer so I could accept it.

Collectives™ on Stack Overflow

How to create test database with Flask-Testing

1 Answer 1

UPD

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

UPD

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related