One Paragraph of project description goes here
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.
On the most basic level, the way we learned to query through a table in one of our databases is pretty simple.
The SQL SELECT
statement allows us to search through a table and return a custom results table with whatever columns/groupings/operations we specified in our query.
SELECT * FROM movies WHERE rottentomatoes > 85 AND lead_actor like 'Kevin Spacey';
Unfortunately, sometimes the queries need an added level of complexity and a simple statement like the one above wont do the trick. Here are two scenarios where we need to add some intricacy to our SQL statement in order to perform a sufficient query:
/** | |
* If argument is a string, try to parse as JSON. | |
* Otherwise return null. | |
*/ | |
export function parseOrNull(raw: unknown) { | |
if (!raw) return null | |
if (typeof raw === 'string') { | |
try { | |
return JSON.parse(raw) |