Spaced Repition Q A

BACKEND:
- Which database tables are created in the migrations?
    language, user, word
    
- What are the endpoints for user registration, login and refresh?
    /api/user - registration
    
- What endpoints have been implemented in the language router?
    '/' - get words
    
    
- What is the async and await syntax for? (Hint)
    async describes out of order code, the event loop keeps going
    await is blocking
    
- Which endpoints need implementing in the language router?
    '/head', '/guess'
    
- How does the GET /api/language endpoint decide which language to respond with? 
    (Hint: Does it relate to the user that made the request?)
    Relates to user that made the request, the user chooses language
    
- In the UserService.populateUserWords method, what is db.transaction?
        Hints:
            https://knexjs.org/#Transactions
            https://knexjs.org/#Builder-transacting
            https://www.postgresql.org/docs/8.3/tutorial-transactions.html
            https://www.tutorialspoint.com/postgresql/postgresql_transactions.htm
Preserves running sql across system failure, if desired sql fails - db rolls back.
    
- What is SERIAL in the create migration files? (Hint)
SERIAL data type allows you to automatically generate unique integer numbers (IDs, identity, auto-increment, sequence) for a column. 
    
- What is setval in the seed file? (Hint)

FRONTEND:

Which routes are already set up and what are their paths?
'/' - Dashboard, '/learn' -, 'register', 'login'

What is the concern of the AuthApiService object?
To either register a new token for login, or retrieve existing user for login

What is the concern of the UserContext?

Does the PrivateRoute make use of the UserContext?

What does the /cypress/integration/day-0.1-purpose.spec.js file test?

Which elements on the page are being checked in and what for?