spec/tests/exporter_tests.rb in ferry-1.0.0 vs spec/tests/exporter_tests.rb in ferry-1.0.1
- old
+ new
@@ -11,31 +11,47 @@
end
after(:all) do
Contexts.teardown
FileUtils.rm_rf('db')
end
- it "to_csv should create a populated csv file" do
- exporter.to_csv('sqlite3', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/sqlite3/carts.csv"
- expect(File).to exist(file_path)
- lines = CSV.read(file_path)
- expect(lines.length).to eql(27)
- expect(lines[0]).to eql(["id", "email"])
- expect(lines[1]).to eql(["1", "abby@example.com"])
- expect(lines[26]).to eql(["26", "zach@example.com"])
- end
- it "to_yaml should create a populated yaml file" do
- exporter.to_yaml('sqlite3', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/sqlite3/carts.yml"
- expect(File).to exist(file_path)
- output = YAML.load_file(file_path)
- expect(output["carts"].length).to eql(2)
- expect(output["carts"].keys).to eql(["columns","records"])
- expect(output["carts"]["columns"]).to eql(["id","email"])
- expect(output["carts"]["records"][0]).to eql([1,"abby@example.com"])
- expect(output["carts"]["records"][25]).to eql([26,"zach@example.com"])
- end
+
+ describe "to_csv" do
+ it "call should create a populated csv file" do
+ exporter.to_csv('sqlite3', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/sqlite3/carts.csv"
+ expect(File).to exist(file_path)
+ lines = CSV.read(file_path)
+ expect(lines.length).to eql(27)
+ expect(lines[0]).to eql(["id", "email"])
+ expect(lines[1]).to eql(["1", "abby@example.com"])
+ expect(lines[26]).to eql(["26", "zach@example.com"])
+ end
+
+ it "should error if specified table does not exist" do
+ expect{exporter.to_csv('sqlite3', 'cart')}.to raise_error #correct table is "carts"
+ end
+
+ end
+
+ describe "to_yaml" do
+ it "call should create a populated yaml file" do
+ exporter.to_yaml('sqlite3', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/sqlite3/carts.yml"
+ expect(File).to exist(file_path)
+ output = YAML.load_file(file_path)
+ expect(output["carts"].length).to eql(2)
+ expect(output["carts"].keys).to eql(["columns","records"])
+ expect(output["carts"]["columns"]).to eql(["id","email"])
+ expect(output["carts"]["records"][0]).to eql([1,"abby@example.com"])
+ expect(output["carts"]["records"][25]).to eql([26,"zach@example.com"])
+ end
+
+ it "should error if specified table does not exist" do
+ expect{exporter.to_yaml('sqlite3', 'cart')}.to raise_error #correct table is "carts"
+ end
+ end
+
end
describe "postgresql db" do
before(:all) do
connect("postgresql")
@@ -44,31 +60,44 @@
end
after(:all) do
Contexts.teardown
FileUtils.rm_rf('db')
end
- it "to_csv should create a populated csv file" do
- exporter.to_csv('postgresql', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/postgresql/carts.csv"
- expect(File).to exist(file_path)
- lines = CSV.read(file_path)
- expect(lines.length).to eql(27)
- expect(lines[0]).to eql(["id", "email"])
- expect(lines[1]).to eql(["1", "abby@example.com"])
- expect(lines[26]).to eql(["26", "zach@example.com"])
- end
- it "to_yaml should create a populated yaml file" do
- exporter.to_yaml('postgresql', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/postgresql/carts.yml"
- expect(File).to exist(file_path)
- output = YAML.load_file(file_path)
- expect(output["carts"].length).to eql(2)
- expect(output["carts"].keys).to eql(["columns","records"])
- expect(output["carts"]["columns"]).to eql(["id","email"])
- expect(output["carts"]["records"][0]).to eql(["1","abby@example.com"])
- expect(output["carts"]["records"][25]).to eql(["26","zach@example.com"])
- end
+
+ describe "to_csv" do
+ it "call should create a populated csv file" do
+ exporter.to_csv('postgresql', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/postgresql/carts.csv"
+ expect(File).to exist(file_path)
+ lines = CSV.read(file_path)
+ expect(lines.length).to eql(27)
+ expect(lines[0]).to eql(["id", "email"])
+ expect(lines[1]).to eql(["1", "abby@example.com"])
+ expect(lines[26]).to eql(["26", "zach@example.com"])
+ end
+
+ it "should error if specified table does not exist" do
+ expect{exporter.to_csv('postgresql', 'cart')}.to raise_error #correct table is "carts"
+ end
+ end
+ describe "to_yaml" do
+ it "call should create a populated yaml file" do
+ exporter.to_yaml('postgresql', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/postgresql/carts.yml"
+ expect(File).to exist(file_path)
+ output = YAML.load_file(file_path)
+ expect(output["carts"].length).to eql(2)
+ expect(output["carts"].keys).to eql(["columns","records"])
+ expect(output["carts"]["columns"]).to eql(["id","email"])
+ expect(output["carts"]["records"][0]).to eql(["1","abby@example.com"])
+ expect(output["carts"]["records"][25]).to eql(["26","zach@example.com"])
+ end
+
+ it "should error if specified table does not exist" do
+ expect{exporter.to_yaml('postgresql', 'cart')}.to raise_error #correct table is "carts"
+ end
+ end
end
describe "mysql2 db" do
before(:all) do
connect("mysql2")
@@ -77,29 +106,41 @@
end
after(:all) do
Contexts.teardown
FileUtils.rm_rf('db')
end
- it "to_csv should create a populated csv file" do
- exporter.to_csv('mysql2', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/mysql2/carts.csv"
- expect(File).to exist(file_path)
- lines = CSV.read(file_path)
- expect(lines.length).to eql(27)
- expect(lines[0]).to eql(["id", "email"])
- expect(lines[1]).to eql(["1", "abby@example.com"])
- expect(lines[26]).to eql(["26", "zach@example.com"])
- end
- it "to_yaml should create a populated yaml file" do
- exporter.to_yaml('mysql2', 'carts')
- file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/mysql2/carts.yml"
- expect(File).to exist(file_path)
- output = YAML.load_file(file_path)
- expect(output["carts"].length).to eql(2)
- expect(output["carts"].keys).to eql(["columns","records"])
- expect(output["carts"]["columns"]).to eql(["id","email"])
- expect(output["carts"]["records"][0]).to eql([1,"abby@example.com"])
- expect(output["carts"]["records"][25]).to eql([26,"zach@example.com"])
- end
+
+ describe "to_csv" do
+ it "call should create a populated csv file" do
+ exporter.to_csv('mysql2', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/csv/mysql2/carts.csv"
+ expect(File).to exist(file_path)
+ lines = CSV.read(file_path)
+ expect(lines.length).to eql(27)
+ expect(lines[0]).to eql(["id", "email"])
+ expect(lines[1]).to eql(["1", "abby@example.com"])
+ expect(lines[26]).to eql(["26", "zach@example.com"])
+ end
+ it "should error if specified table does not exist" do
+ expect{exporter.to_csv('mysql2', 'cart')}.to raise_error #correct table is "carts"
+ end
+ end
+
+ describe "to_yaml" do
+ it "call should create a populated yaml file" do
+ exporter.to_yaml('mysql2', 'carts')
+ file_path = File.expand_path("..",Dir.pwd) + "/spec/db/yaml/mysql2/carts.yml"
+ expect(File).to exist(file_path)
+ output = YAML.load_file(file_path)
+ expect(output["carts"].length).to eql(2)
+ expect(output["carts"].keys).to eql(["columns","records"])
+ expect(output["carts"]["columns"]).to eql(["id","email"])
+ expect(output["carts"]["records"][0]).to eql([1,"abby@example.com"])
+ expect(output["carts"]["records"][25]).to eql([26,"zach@example.com"])
+ end
+ it "should error if specified table does not exist" do
+ expect{exporter.to_yaml('mysql2', 'cart')}.to raise_error #correct table is "carts"
+ end
+ end
end
end
end