Please remember the cost this submission may have on my midterm grades. ECE 106 midterm looks less passable by the day. I made the mistake of trying to learn and use GraphQL in a day during midterm week. Bad idea.
I would also like to point out that a lot of the code here is shit. I'm busy. If you want to see something better, I have https://github.com/talentmaker/api.
Finally, this stuff is bare minimum, complying with the given spec of the challenge (expect for the tests). For example, users does not have full CRUD support, only reading and updating.
A few tests are in the __tests__ directory. They demonstrate usage.
- Prisma ORM
- MySQL
- Jest for tests
- Typescript for source, Javascript everywhere else
- GraphQL (first time, it's quite nice)
- Express
- Pothos (Prisma integration)
Pretty simple, bog-standard app that took forever to set up.
To run, use docker-compose up. App will be on port 3333.
Database schema at schema.prisma
Seeding script can be found at ./scripts/seed.js. Note that my implementation skips duplicate emails.
query {
allUsers {
name
company
email
phone
}
}query {
user(id: USER_ID) {
name
company
phone
email
skills {
skill
rating(userId: USER_ID) # I couldn't figure out a good way around this
frequency
}
}
}query {
skills(minFrequency: NUMBER, maxFrequency: NUMBER) {
skill
frequency
}
}mutation {
# Data fields optional, of course
updateUser(userId: 1, data: {phone: PHONE, company: COMPANY, email: EMAIL}) {
name
company
phone
email
}
}Theoretical, of course
- idk, like everything
- Full CRUD support
- Collect code coverage
- More tests
- Split some bigger files up