elireiner

const path = require('path');
const express = require('express');
const fs = require('fs');
const fetch = require('node-fetch');

const formatRouter = express.Router()

formatRouter
    .route('/')
    .get((req, res, next) => {

elireiner

{
    "message": "select \"subjects_id\" from \"tutors_subjects\" where \"user_id\" = $1 - invalid input syntax for type integer: \"{\"id\":155}\"",
    "error": {
        "length": 111,
        "name": "error",
        "severity": "ERROR",
        "code": "22P02",
        "file": "numutils.c",
        "line": "259",
        "routine": "pg_strtoint32"

elireiner

const connectEachUserWithSubjects = (users, subjects) => {
    let i = 0
    users.forEach(user => {
        //subjects is a little messy, with a lot of nested arrays
        //Let's clean it up!
        let subjectsArray = []
        subjects[i].map(subject => {
            subjectsArray.push(subject[0].subject_name)
        })

elireiner

As an experienced member of our Software Engineering Group, we look first and foremost for people who are passionate around solving business problems through innovation and engineering practices. You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner continuously with your many stakeholders on a daily basis to stay focused on common goals. We embrace a culture of experimentation and constantly strive for improvement and learning. You'll work in a collaborative, trusting, thought-provoking environment-one that encourages diversity of thought and creative solutions that are in the best interests of our customers globally.
This role requires a wide variety of strengths and capabilities, including:
* BS/BA degree or equivalent experience
* Expertise in application, data, and infrastructure architecture disciplines
* Advanced knowledge of architecture and design across all systems
* Proficiency in multiple modern programming langua

elireiner

Name of your app: Tutors-app

Link to live static version: https://tutors-app.vercel.app/

Link to repo on GitHub: https://github.com/elireiner/tutors-app

The user feedback you collected:

  Indicate who you spoke to: a friend and my mother
  

elireiner

Wireframe: https://github.com/elireiner/tutor-app
Flow: https://ibb.co/1nHYtwQ

elireiner

As a fisttime student user	I should be able to create a student account
As a fisttime student user	i should be able to search tutors by location or medium
As a fisttime student user	i should be able to search tutors by price
As a fisttime tutor user	i shold be able to create a tutor account
As a returning student user	i should be able to log in to my student account 
As a returning student user	I should be able to send an email to a tutor
As a returning student user	i should be able to delete my student account
As a returning tutor user	i should be able to log into my tutor account
As a returning tutor user	i should be able to update my profile
As a returning tutor user	i should be able to delete my tutor account

elireiner

I propose to build a full stack web app for students and tutors. The app will help students and tutors find each other.

elireiner

eliriner@Elis-Air noteful-api % npm run migrate

> noteful-api@1.0.0 migrate /Users/eliriner/projects/backend/noteful-api
> postgrator --config postgrator-config.js

sh: postgrator: command not found
npm ERR! code ELIFECYCLE
npm ERR! syscall spawn
npm ERR! file sh
npm ERR! errno ENOENT

elireiner

//when i use this:

projects=# SELECT
projects-#   e.emp_name employee,
projects-#   p.project_name project
projects-# FROM
projects-#   employee e
projects-#   JOIN  
projects-#   employee_project ep
projects-#   ON e.id = ep.emp_id