|
|
# Executable Test Cases
|
|
|
### Scenario 1
|
|
|
Command:
|
|
|
`./csvfilter --drop:3:SomeTown case1.csv`
|
|
|
|
|
|
case1.csv:
|
|
|
```
|
... | ... | @@ -13,6 +11,9 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:3:SomeTown case1.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
... | ... | @@ -23,9 +24,6 @@ Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123 |
|
|
|
|
|
### Scenario 3
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case3.csv --output case3out.csv`
|
|
|
|
|
|
case3.csv:
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
... | ... | @@ -37,6 +35,9 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case3.csv --output case3out.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
(empty)
|
... | ... | @@ -53,9 +54,6 @@ Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123 |
|
|
|
|
|
### Scenario 4
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown --delim=';' case4.csv`
|
|
|
|
|
|
case4.csv:
|
|
|
```
|
|
|
First;Last;Address;City;State;Postal
|
... | ... | @@ -67,6 +65,9 @@ Stephen;Tyler;7452 Terrace Road;SomeTown;SD;91234 |
|
|
Joan;Anne;Jet;9 Terrace Place;Desert City;CO;123
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown --delim=';' case4.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
First;Last;Address;City;State;Postal
|
... | ... | @@ -76,10 +77,7 @@ John;Repici;120 Jefferson St.;Riverside;NJ;8075 |
|
|
Joan;Anne;Jet;9 Terrace Place;Desert City;CO;123
|
|
|
```
|
|
|
|
|
|
### Scenario 5a
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case5.csv`
|
|
|
### Scenario 5
|
|
|
|
|
|
case5.csv:
|
|
|
```
|
... | ... | @@ -92,6 +90,9 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case5.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
... | ... | @@ -101,22 +102,9 @@ John,Repici,120 Jefferson St.,Riverside,NJ,8075 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
### Scenario 5b
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --keep:City:Riverside case5.csv`
|
|
|
|
|
|
case5.csv:
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
,Blankman,,SomeTown,SD,298
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
... | ... | @@ -124,22 +112,9 @@ John,Doe,120 Jefferson St.,Riverside, NJ,8075 |
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
```
|
|
|
|
|
|
### Scenario 5c
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --keep:First:* case5.csv`
|
|
|
|
|
|
case5.csv:
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
,Blankman,,SomeTown,SD,298
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
... | ... | @@ -150,22 +125,9 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
### Scenario 5d
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --cut:Postal case5.csv`
|
|
|
|
|
|
case5.csv:
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
|
|
John,Doe,120 Jefferson St.,Riverside, NJ,8075
|
|
|
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
|
|
|
John,Repici,120 Jefferson St.,Riverside,NJ,8075
|
|
|
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
|
|
|
,Blankman,,SomeTown,SD,298
|
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
First,Last,Address,City,State
|
... | ... | @@ -177,26 +139,13 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO
|
|
|
```
|
|
|
|
|
|
### Scenario 6a
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case6.csv`
|
|
|
### Scenario 6
|
|
|
|
|
|
case6.csv:
|
|
|
```
|
|
|
hello
|
|
|
```
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
Error: Input csv is not properly formatted!
|
|
|
```
|
|
|
|
|
|
### Scenario 6b
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case6.txt`
|
|
|
|
|
|
case6.txt:
|
|
|
```
|
|
|
First,Last,Address,City,State,Postal
|
... | ... | @@ -208,6 +157,17 @@ Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234 |
|
|
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case6.csv`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
Error: Input csv is not properly formatted!
|
|
|
```
|
|
|
|
|
|
Command:
|
|
|
`./csvfilter --drop:City:SomeTown case6.txt`
|
|
|
|
|
|
Output (in terminal):
|
|
|
```
|
|
|
Error: Input is not a csv file!
|
... | ... | |