Count and print the number of rows updated at the end of the updateQuery method in the format – “5 row(s) updated.”
computer science
Description
Part #1: Complete implementation of updateQuery method:
1. Count and print the number of rows updated at the end of the updateQuery method in the format – “5 row(s) updated.”.
2. Implement feature to handle where clause (i.e., the whereColIdx parameter is not -1) with 3 different conditions (‘=’, ‘<>’, and ‘like’) in a query, as in “update test.csv set raters=3 where title like ‘The’;”. See SQLAirBase::matches helper method. For this feature you only print rows with column-values (i.e., value in column indicated by whereColIdx) that match the given condition. See SQLAirBase::matches helper method. Note that given a row, you can get value via row.at(whereColIdx).
3. Of course, you can use the selectQuery method to help guide your implementation.
Instruction Files
Homework9.pdf
293.1 KB
sqlairstarterpart2.zip
1.3 MB
