Skip to content

Latest commit

 

History

History
18 lines (13 loc) · 1.25 KB

README.md

File metadata and controls

18 lines (13 loc) · 1.25 KB
Raw

DSCI-551-Final-Proj-Rel

This is the codebase for the relational portion of our DSCI 551 final project.

Flow of query parsing

cli.py --> queryparse.py --> make_tbl/edit_tbl/fetch_tbl/drop_tbl.py --> loaddata.py (from edit_tbl.py) / printoutput.py (from fetch_tbl.py)

File contents

  • cli.py contains the code for our command line interface, along with commands and docstrings for all commands.
  • loaddata.py contains code for loading and chunking a csv file into our DBMS.
  • queryparse.py contains a driver function for parsing queries coming from the command line, leading into the following...
    • make_tbl.py contains functions for creating a new table or a copy of an existing table.
    • edit_tbl.py contains functions for editing an existing table by inserting a row, inserting a whole csv file, updating a row, or deleting a row.
    • fetch_tbl.py contains functions for selecting, filtering, grouping, aggregating, joining, and sorting data from tables.
    • drop_tbl.py contains a function for dropping a table from the DBMS entirely, including any chunks that were created when loading data into it.
  • printoutput.py contains a function for crawling through the DBMS directories to locate the correct chunks for output.