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');
+ """