blob: 2dd6ec5fe624b88287ba70c848cf8940120e1508 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
require "cases/helper"
require "cases/view_test"
class UpdateableViewTest < ActiveRecord::PostgreSQLTestCase
fixtures :books
class PrintedBook < ActiveRecord::Base
self.primary_key = "id"
end
setup do
@connection = ActiveRecord::Base.connection
@connection.execute <<-SQL
CREATE VIEW printed_books
AS SELECT id, name, status, format FROM books WHERE format = 'paperback'
SQL
end
teardown do
@connection.execute "DROP VIEW printed_books" if @connection.table_exists? "printed_books"
end
def test_update_record
book = PrintedBook.first
book.name = "AWDwR"
book.save!
book.reload
assert_equal "AWDwR", book.name
end
def test_insert_record
PrintedBook.create! name: "Rails in Action", status: 0, format: "paperback"
new_book = PrintedBook.last
assert_equal "Rails in Action", new_book.name
end
def test_update_record_to_fail_view_conditions
book = PrintedBook.first
book.format = "ebook"
book.save!
assert_raises ActiveRecord::RecordNotFound do
book.reload
end
end
end
if ActiveRecord::Base.connection.respond_to?(:supports_materialized_views?) &&
ActiveRecord::Base.connection.supports_materialized_views?
class MaterializedViewTest < ActiveRecord::PostgreSQLTestCase
include ViewBehavior
private
def create_view(name, query)
@connection.execute "CREATE MATERIALIZED VIEW #{name} AS #{query}"
end
def drop_view(name)
@connection.execute "DROP MATERIALIZED VIEW #{name}" if @connection.table_exists? name
end
end
end
|
