21 lines
439 B
Lua
21 lines
439 B
Lua
require 'pl'
|
|
|
|
utils.on_error 'quit'
|
|
|
|
stuff = [[
|
|
Department Name,Employee ID,Project,Hours Booked
|
|
sales, 1231,overhead,4
|
|
sales,1255,overhead,3
|
|
engineering,1501,development,5
|
|
engineering,1501,maintenance,3
|
|
engineering,1433,maintenance,10
|
|
]]
|
|
|
|
t = data.read(stringio.open(stuff))
|
|
|
|
q = t:select 'Employee_ID,Hours_Booked where Department_Name == "engineering"'
|
|
|
|
test.asserteq2(1501,5,q())
|
|
test.asserteq2(1501,3,q())
|
|
test.asserteq2(1433,10,q())
|