TO-DO.md

TO-DO list

Basic Code

CommandInterpreter.java

• loadStatement-XYY

• storeStatement-XYY

• printStatement-SCH

• selectStatement-SCH

• tableDefinition

  • if part-HTC
  • else part-AZH (AS)

• selectClause-SCH

• conditionClause-XYY

• condition -XYY

Condition.java

• boolean test(Row... rows) -XYY

Database.java

• Database()-HTC

• put-HTC

• get-HTC

Row.java

• size-AZH

• get-AZH

• equals-HTC

Table.java

• Table()-HTC

• columns-HTC

• getTitle-HTC

• findColumn-AZH

• size-AZH

• add-HTC

• readTable-XYY

• writeTable-XYY

• print-XYY HTC

• Table select(List<String> columnNames, List<Condition> conditions) -XYY AZH

• Table select(Table table2, List<String> columnNames, List<Condition> conditions) -XYY AZH

• equijoin -XYY

Additional Test

• Automatically build and test project with GitHub Actions -HTC

Duplicate

• table name-HTC

• table column title-HTC

• insert values-HTC

Syntax Error

• Parenthesis (create table)-HTC

• Data type error in relation -XXY

• Column not found -XXY

• Standard Error Messages -AZH

Advance

Operation

• insert rows with multiple columns-HTC

• data types(int,double,string)-HTC -XYY

• trie-HTC

• SHA-1-HTC

• file operation-HTC

• like-HTC

• * -XYY

• as-AZH

• primary key-HTC

• between -ZYQ

• min -ZYQ

• max -ZYQ

• avg -ZYQ

• round -ZYQ

• count -ZYQ

• order by -SCH

• group by -SCH

• (not) in -HTC

Beautify

• print (MySQL style)-HTC

Application

• re-implement in Assignment 2-ZYQ

• testing -HTC

• version control-TYZ

  • statement
  • snapshot
  • log

Presentation and Report

Presentation

• PPT-ZYQ
• Present
  • Introduction-AZH
  • Database structure-AZH
  • Basic SQL Syntax -SCH
  • Advanced SQL Syntax-SCH
  • Version Control-TYZ
  • Real-implement-AZH
• editor-TYZ

Report

• Set Up Instruction-HTC
• Readme and TO-DO List-ZYQ
• Error message format and comment edit-AZH
• Gif examples-SCH