Add options to the Skills and Interest Table

[Caleb-Cohen]

Related Issues Project: Filtering Depends on:

• 115

Description

• Create a script that will insert these values into the skills and interest table

• List below does not need to be exhaustive. Following @timmyichen's advice I recommend looking to see if there's a more exhaustive list. I would recommend sticking to skills relevant to web-development as 100Devs is web development, but I'm open to a more broad list.

• Add skills to the skills table

  • Skills include: HTML, CSS, Javascript, React, Angular, Vue.js, Node,js, Python, Ruby, PHP, MongoDB, MySQL, PosgreSQL, Git, Cypress, Jest, Docker, Kubernetes

• Add interest to the interest table

  • Interest include: Looking to Mentor, Coffee Chat, Resume Reviewer, Mock Interviewer, Pair Programming, Join a Project

Acceptance Criteria Values are properly added to the DB

[jmoldyvan]

LGTM

[timmyichen]

If you're doing it via script that uses sequelize, you won't need to set the ID, just creating the skills will autopopulate the ID.

Also, any particular reason why we use Vue.js but not React.js?

Is there a more exhaustive list we can use for the skills, maybe supplied as a text file that the script reads and uses to upsert (important, that way if we run the script again we won't have two of the same value). This doesn't have to be something you do BTW, can totally be put on the person picking up this ticket, but worth calling out as an alternative to the list supplied above.

Also, does casing matter? Should we enforce lowercase?

[Caleb-Cohen]

If you're doing it via script that uses sequelize, you won't need to set the ID, just creating the skills will autopopulate the ID.

Cool, updated.

Also, any particular reason why we use Vue.js but not React.js?

I used Google as a proxy for how technology is generally referenced.

Is there a more exhaustive list we can use for the skills, maybe supplied as a text file that the script reads and uses to upsert (important, that way if we run the script again we won't have two of the same value). This doesn't have to be something you do BTW, can totally be put on the person picking up this ticket, but worth calling out as an alternative to the list supplied above.

I could not find one. For the MVP I wanted a list of relevant web dev languages and frameworks, but I'll open it up to other ideas as someone works on it.

Also, does casing matter? Should we enforce lowercase?

Since we're controlling the input, I liked the concept of selective casing. I prefer the look of MySQL over mysql. What are the benefits to enforcing lowercase?