search

chicken-sloths / bangazon-api-sprint1

API for a mock Amazon + Etsy platform providing developers access to the company's employee & product data
0 stars 0 forks source link

Fixes #53: makeEmployeeTrainingTable finished #83

Closed DavidLarsKetch closed 6 years ago

DavidLarsKetch commented 6 years ago

Description

This provides the function to create the Employee_Training_Programs join table in the db/employees/makeEmployeeTrainingTable

Number of Fixes

1

Related Ticket(s)

Fixes #53

Problem to Solve

Employee_Training_Programs join table did not exist

Proposed Changes

makeEmployeeTrainingTable pulls in generateSqlTable() from db/sqlRunTemplate & data from data/json/employeeTrainingProgram, templates the data, and exports the resulting function

Expected Behavior

npm run db:generate should create a Employee_Training_Programs table with fake data

Steps to Test Solution

  1. npm run db:generate
  2. Open db/api-spring.sqlite
  3. SELECT * FROM Employee_Training_Programs