Changeset 199
- Timestamp:
- 09/10/06 22:24:56 (2 years ago)
- Files:
-
- trunk/lib/ruport/query.rb (modified) (1 diff)
- trunk/test/test_query.rb (modified) (2 diffs)
- trunk/test/test_report.rb (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/lib/ruport/query.rb
r101 r199 60 60 # 61 61 # # uses a SQL file stored on disk 62 # Ruport::Query.new("my_query.sql",:origin => :file) 62 # Ruport::Query.new("my_query.sql") 63 # 64 # # explicitly use a file, even if it doesn't end in .sql 65 # Ruport::Query.new("foo",:origin => :file) 63 66 def initialize(sql, options={}) 64 67 options = { :source => :default, :origin => :string }.merge(options) 65 @sql = sql68 options[:origin] = :file if sql =~ /.sql$/ 66 69 @statements = SqlSplit.new(get_query(options[:origin],sql)) 70 @sql = @statements.join 67 71 68 72 if options[:dsn] trunk/test/test_query.rb
r112 r199 20 20 assert_equal([[1,2,3],[4,5,6],[7,8,9]],@query1.result) 21 21 end 22 23 def test_auto_resolve_file 24 q = Ruport::Query.new "test/samples/query_test.sql" 25 assert_equal "select * from foo", q.sql 26 end 27 22 28 23 29 def test_each … … 62 68 end 63 69 64 def test_to_dataset65 # query needs to be re-worked for a test like this66 # to be written67 end68 69 70 def test_caching_triggers 70 71 assert_nothing_raised { @query1.enable_caching } trunk/test/test_report.rb
r197 r199 42 42 } 43 43 assert_equal "a,b,c\n1,2,3\n4,5,6\n7,8,9\n", 44 @report.query("blah",:query_obj => @query1, :as => :csv) 44 @report.query("blah",:query_obj => @query1, :as => :csv) 45 45 end 46 46
