require 'smart_csv'
require 'pry'
describe "Check class CSV::Table" do

  let(:csv_data) {"id,firstname,lastname\n1,One,One\n2,Two,Two\n4,Four,Four\n5,Five,Five\n6,One,One"}

  let(:parse_data) { CSV.parse(csv_data, {:col_sep => ',', :headers => true}) }

  it "should correct create one record" do
    parse_data.size.should eql(5)
    parse_data.create("id"=> '13', "lastname" => '1992')
    parse_data.size.should eql(6)
    parse_data[-1]["id"].should eql('13')
  end

  it "should correct select records" do
    parse_data.where('firstname' => 'One').size.should eql(2)
    parse_data.where('firstname' => 'One').where_not('id' => '6').size.should eql(1)
  end

  it "should correct delete records" do
    parse_data.size.should eql(5)
    parse_data.delete_all
    parse_data.size.should eql(0)
  end

  it "should correct delete records" do
    parse_data.size.should eql(5)
    parse_data.delete_all
    parse_data.size.should eql(0)
  end

  it "should correct delete records" do
    parse_data.size.should eql(5)
    parse_data.where('firstname' => 'One').delete_all
    parse_data.size.should eql(3)
  end
end