CI.yaml

name: Node.js CI

on:
  pull_request:
    branches:
      - main

jobs:
  build:
    name: CI
    runs-on: ubuntu-latest

    steps:
    - name: Checkout code
      uses: actions/checkout@v2
      
    - name: Setup Node.js
      uses: actions/setup-node@v2
      with:
        node-version: 14 

    - name: Install dependencies
      run: npm install
        
    - name: Display .env file
      run: |
        echo "DB_USER=${{ secrets.DB_USER }}" >> .env
        echo "DB_PASSWORD=${{ secrets.DB_PASSWORD }}" >> .env
        echo "DB_NAME=${{ secrets.DB_NAME }}" >> .env
        echo "PORT=${{ secrets.PORT }}" >> .env
        echo "CSVPATH='/home/admin/webapp/users.csv'" >> .env
        cat .env

       
    - name: configuremysql
      run: |
        sudo apt-get update
        sudo apt-get install -y curl
        sudo systemctl start mysql
        sudo systemctl status mysql
        mysql -u root -p"${{ secrets.MY_SQL_PASSWORD }}" -e "CREATE DATABASE  Assignment3;"

  #  asd

    - name: Run Tests
      run : npm test
    
# checking CI command on PR - 1.2.3