Backend

The backend of StuyActivities is written in JavaScript. The main technologies/libraries it uses are Node.JS, GraphQL (Apollo), and Sequelize. The actual database uses MySQL, but you can also use SQLite in development. To work on the API, pull the repository and install the dependencies (usually with npm i). You might have trouble installing the SQLite dependency, sqlite3, in which case you may need to install some dependencies as outlined in the Installation section of this page. You can also skip SQLite3 and run a local MySQL server (!). Run the program with npm run dev to work on it, but make sure you run npm authenticate first. You can log in with any account, but make sure you don't put other people's emails in your database or you might end up sending them emails from your account.

File Structure Overview

• package.json - outlines the dependencies.
• captain-definition - The backend runs on CapRover (captain.stuysu.org), so each application is a docker container, including the backend and the MySQL server it connects to. This file contains the Dockerfile lines (as a JSON array) required to create the docker container from the code that CapRover pulls from GitHub. The Dockerfile file contains the same info. Read more about Dockerfiles here.
• src/ - the code for the API
  • app.db - the SQLite database that gets created if you use SQLite in your development
  • index.js - this is the entryway into the app. In production mode, it spawns several workers, one for each CPU core, so that the program can be multi-threaded.
  • app.js - this is the main app file. It creates an Express.JS app and adds the GraphQL middleware. It also initializes the tasks that are run on intervals (src/googleApis/gmailWatcher and src/utils/createRecurringMeetings).
  • constants.js - this contains the constants that the app uses.
  • graphql/ - this folder contains all of the information and code behind the GraphQL API---this is the meat of the code
    • index.js - this is the main GraphQL file. It creates an Apollo server and defines the functions that get passed to resolvers, as well as error handling code and JWT code.
    • schema/ - this folder contains all of the GraphQL code that defines how the API works
      • index.js - this file imports every other file in the folder and exports it in one neat package for src/graphql/index.js
      • Query.js - this file contains all of the query operations you can make.
      • Mutation.js - this file contains all of the mutation operations you can make.
      • The rest of the files in this folder are GraphQL type definitions.
    • resolvers/ - this folder contains all of the JavaScript code that implements the schema in the src/graphql/schema folder.
      • index.js - this file imports every other file in the folder and exports it in one neat package for src/graphql/index.js
      • Query/ - this folder contains all of the functions for query operations
        • index.js - this file imports every other file in the folder and exports it for src/graphql/resolvers/index.js
      • Mutation/ - this folder contains all of the functions for mutations
        • index.js - this file imports every other file in the folder and exports it for src/graphql/resolvers/index.js
        • login/ and linkOAuthPlatform/ are sub-folders for functions that are split into multiple files (although usually we'd put these files into the src/utils folder now)
      • Every other folder in this directory has files that describe how to get certain properties of the type their folder is named after. For example, the Meeting/ folder has a file called organization.js which fetches the organization related to the meeting when someone queries for it.
  • database/ - this folder contains information on how to work with the database.
    • models/ - this folder contains the database models. Each model corresponds to a database table, and describes how the table works. Most of these models are partially or completely automatically generated.
      • index.js - this file automatically imports every model in the directory and initializes the Sequelize object.
    • migrations/ - this folder contains migrations, which are changes made to the database (such as new tables or changes in table structure). Most of these are also automatically generated, although some are created by hand. These files are only run when you run npm run migrate.
    • seeders/ - this folder contains files to "seed" the database by adding info to it. These files have not been updated and should not be used. If you need to seed the database, you can download the existing one and create a fake club for yourself to play around with.
    • dataloaders/ - this folder contains basic methods for loading specific objects from the databse. They are used in the models.
  • middleware/ - this folder contains various middlewares that the app.js file uses.
  • utils/ - this folder contains utilities that are either too long to be put into a file with the other code or that are used in multiple places.
  • googleApis/ - this folder contains the files used for interacting with Google APIs.
  • emailTemplates/ - this folder contains the email templates used in certain resolvers.

Common tasks

Editing the Database

If you want to edit the live database directly, go to adminer.stuysu.org and use the credentials located in the stuyactivities-credentials repository or in the environment variables of the mysql app on CapRover. If you don't see the stuyactivities-credentials repo, you might not have access to it. For adminer, use the url captain.stuysu.org or srv-captain--mysql-db, the database stuyactivities, and the user stuyactivities.

If you want to edit your local database, and you're using SQLite, run the command sqlite3 app.db (the app.db folder is located in src/). Then, run any SQL commands you'd like. To make it easier to see, you can change the display format by using .mode (e.g. .mode table). You can also run commands like .schema to get the schema of a table.

Creating and Editing Tables (Migrations)

Use the CLI to create a model, then edit the model to add dataloaders and stuff (!).

Creating Resolvers

Talk about which functions are provided and stuff (!).