GToidZ/guitarkeep-daq

GuitarKeep

A project in Data Acquisition class all about keeping your guitar safe.

Instructions for Group Members

1. Install depedencies using pip

   pip install -r requirements.txt

2. Configure database URL in a .env file (we use asyncmy so please use the following format,)

   DB_URL=mysql+asyncmy://user:pass@host:3306/dbname?charset=utf8mb4
   

3. Run the server using uvicorn

   uvicorn guitarkeep.server:app

Example Queries

• List all data entries

  {
     dataEntries {
        ts
        roomType
        dataType
        value
        source
        tip
     }
  }

• List all data entries in Living Room

  {
     dataEntriesByRoomType(roomType: livingRoom) {
        ts
        roomType
        dataType
        value
        source
        tip
     }
  }

• List all humidity data during 26 October to 28 October

  {
     dataEntriesByDataType(
        dataType: humidity,
        startTime: "2023-10-26",
        endTime: "2023-10-28"
     ) {
        ts
        roomType
        dataType
        value
        source
        tip
     }
  }