Overall, I spent around 5-6 hours on this assignment. I spent around 2-ish hour setting up the actual API. I had to spent a large amount of time troubleshooting issues with sqlite3, and other bug fixings. And I spent around 30-45 minutes on writing tests. I definitely struggled a lot with getting sqlite3 to work specifically on my windows machine, like figuring out that I had to add sqlite to my environment path, and making sure I can run the setup script on my window machine.
I did not really had many issues with typescript itself.
I personally do not find writing tests particuarlly interesting but I do recognize how it might be necessary. It did help me find issues with my code, such as how I had my date validation like the 1a activity format but it was conflicting with the formating in the database schema.
I did use LLM to help, specifically with repeitive tasks such as coming up with dummy data for testings. I did also use to help debug code when I was stuck although they aren't particularly effective at it. Overall, I do believe LLM help save me time.
Back to Home