From 0fe97972d86ad66b014ef64820c7c2458d54b393 Mon Sep 17 00:00:00 2001 From: Mike Naberezny Date: Tue, 4 Feb 2014 14:40:37 -0800 Subject: sqlite: add test Closes #26412. Signed-off-by: Mike McQuaid --- Library/Formula/sqlite.rb | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'Library/Formula/sqlite.rb') diff --git a/Library/Formula/sqlite.rb b/Library/Formula/sqlite.rb index 5817666e1..ca5143444 100644 --- a/Library/Formula/sqlite.rb +++ b/Library/Formula/sqlite.rb @@ -81,4 +81,19 @@ class Sqlite < Formula EOS end end + + test do + path = testpath/"school.sql" + path.write <<-EOS.undent + create table students (name text, age integer); + insert into students (name, age) values ('Bob', 14); + insert into students (name, age) values ('Sue', 12); + insert into students (name, age) values ('Tim', 13); + select name from students order by age asc; + EOS + + names = `#{bin}/sqlite3 < #{path}`.strip.split("\n") + assert_equal %w[Sue Tim Bob], names + assert_equal 0, $?.exitstatus + end end -- cgit v1.2.3