CS257 Software Design
Monday, 7 November 2022

+ API & DB design feedback
- May I have a volunteer group?

+ Look at each other's API/DB designs
- Sit with your partner
- Grab a nearby group
- Share your api-design.txt and database-schema.sql
    - however is easiest
        - Slack github file links
        - Look at each other's laptops
        - whatever
    - talk about it

+ The "end to end" assignment

    Javascript in a web page --> API --> DBMS 
                             <-- API <--

    Once the JS gets the JSON from the API,
    the JS modifies the web page accordingly.

    For end-to-end assignment, do this on any data in your dataset
    and any UI element.

+ Accessibility


-------
query = '''SELECT blah FROM communities, ... 
           WHERE 1 = 1 '''

where_clause_args = []
language_contains = flask.request.args.get('language_contains')
if language_contains is not None:
    query += ' AND language_contains = %s'
    where_clause_args.append(language_contains)

...

cursor.execute(query, where_clause_args)