Skip to content

GitLab

Last edited by amot
Page history
This is an old version of this page. You can view the most recent version or browse the history.

Executable Test Cases

Executable Test Cases

Scenario 1

case1.csv:

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,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --drop:3:SomeTown --no-headers case1.csv

Output (in terminal):

John,Doe,120 Jefferson St.,Riverside, NJ,8075
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
John,Repici,120 Jefferson St.,Riverside,NJ,8075
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --drop:City:SomeTown --no-headers case1.csv

Output (in terminal):

Error: Header specified with --no-headers option!

Scenario 3

case3.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,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --drop:City:SomeTown case3.csv --output="case3out.csv"

Output (in terminal):

(empty)

case3out.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
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Scenario 4

case4.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;NJ;298
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
John;Doe;120 Jefferson St.;Riverside; NJ;8075
Jack;McGinnis;220 Hobo Ave.;Phila;PA;9119
John;Repici;120 Jefferson St.;Riverside;NJ;8075
Joan;Anne;Jet;9 Terrace Place;Desert City;CO;123

Scenario 5

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,NJ,298
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
John,Doe,120 Jefferson St.,Riverside, NJ,8075
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
John,Repici,120 Jefferson St.,Riverside,NJ,8075
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --keep:City:Riverside case5.csv

Output (in terminal):

First,Last,Address,City,State,Postal
John,Doe,120 Jefferson St.,Riverside, NJ,8075
John,Repici,120 Jefferson St.,Riverside,NJ,8075

Command: ./csvfilter --keep:First:* case5.csv

Output (in terminal):

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
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --cut:Postal case5.csv

Output (in terminal):

First,Last,Address,City,State
John,Doe,120 Jefferson St.,Riverside, NJ
Jack,McGinnis,220 Hobo Ave.,Phila,PA
John,Repici,120 Jefferson St.,Riverside,NJ
Stephen,Tyler,7452 Terrace Road,SomeTown,SD
,Blankman,,SomeTown,NJ
Joan,Anne,Jet,9 Terrace Place,Desert City,CO

Scenario 6

case6.csv:

hello

case6.txt:

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,NJ,298
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!

Scenario 8

Command: ./csvfilter --help OR ./csvfilter --drop:City:SomeTown case6.txt --help

Output (in terminal):

print help menu here (we will design this later)

Scenario 9

case9.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,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --drop:3:SomeTown case9.csv

Output (in terminal):

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
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Scenario 10

case10.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,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --replace:First:John:Jon case10.csv

First,Last,Address,City,State,Postal
Jon,Doe,120 Jefferson St.,Riverside, NJ,8075
Jack,McGinnis,220 Hobo Ave.,Phila,PA,9119
Jon,Repici,120 Jefferson St.,Riverside,NJ,8075
Stephen,Tyler,7452 Terrace Road,SomeTown,SD,91234
,Blankman,,SomeTown,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --locate:Last:Doe --replace:First:John:Jon case10.csv

First,Last,Address,City,State,Postal
Jon,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,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Command: ./csvfilter --replace:City:SomeTown:Chamberlain case10.csv

Output (in terminal):

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,Chamberlain,SD,91234
,Blankman,,Chamberlain,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123

Commands:

./csvfilter --locate:State:SD --replace:City:SomeTown:Chamberlain case10.csv --output="case10out.csv"

./csvfilter --locate:State:NJ --replace:City:SomeTown:Riverside case10out.csv --output="case10out.csv"

Output (in terminal):

(empty)

case10out.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,Chamberlain,SD,91234
,Blankman,,SomeTown,NJ,298
Joan,Anne,Jet,9 Terrace Place,Desert City,CO,123