How to run a node project using postgress db (populated by a seed file) in the bitbucket pipeline ?

Jouni Riimala

Hi, 

I have a node project using postgres db via sequelize. My purpose is to run integration tests within pipeline.   

Installation phase goes well, but then it complains that it doesn't find the table where to push seed file (predefined record, which can be pushed to the table). Issue is that tables have not yet been created as those are created when the project starts after npm start command. Tried to add npm start after npm install, but then it just runs continuously.

How to make this work, is there a way to make npm start to run on background ?

I would appreciate example

pipelines:
default:
- step:
image: node
script:
- npm install
- npm run seed
- npm test
services:
- postgres
definitions:
services:
postgres:
image: postgres
environment:
POSTGRES_DB: postgres
POSTGRES_USER: postgres
POSTGRES_PASSWORD: postgres

Riley Venable

You can try adding the command "npm start &" to your bitbucket-pipelines.yml file after the "npm install" command. This will run the "npm start" command in the background, allowing the "npm run seed" and "npm test" commands to run afterwards.