features/dump_as_insert.feature in sqldump-0.0.3 vs features/dump_as_insert.feature in sqldump-0.0.4

- old
+ new

@@ -36,5 +36,25 @@ VALUES ( 42, 'thingy' ); """ + + Scenario: suppress nulls + Given a database "foo.sqlite" with a table "numbers_and_strings" with the following data + | number[int] | string | + | 42 | <null> | + When I run `sqldump -d foo.sqlite -il numbers_and_strings` + Then it should pass with: + """ + INSERT INTO numbers_and_strings (number) VALUES (42); + """ + + Scenario: select specific columns + Given a database "foo.sqlite" with a table "numbers_strings_and_things" with the following data + | number[int] | string | thing | + | 42 | foo | bar | + When I run `sqldump -d foo.sqlite -is "number,thing" numbers_strings_and_things` + Then it should pass with: + """ + INSERT INTO numbers_strings_and_things (number, thing) VALUES (42, 'bar'); + """