20640: Fix test for table_name override / no searchable columns.
[arvados.git] / services / api / test / functional / sys_controller_test.rb
1 # Copyright (C) The Arvados Authors. All rights reserved.
2 #
3 # SPDX-License-Identifier: AGPL-3.0
4
5 require 'test_helper'
6
7 class SysControllerTest < ActionController::TestCase
8   include CurrentApiClient
9   include DbCurrentTime
10
11   test "trash_sweep - delete expired tokens" do
12     assert_not_empty ApiClientAuthorization.where(uuid: api_client_authorizations(:expired).uuid)
13     authorize_with :admin
14     post :trash_sweep
15     assert_response :success
16     assert_empty ApiClientAuthorization.where(uuid: api_client_authorizations(:expired).uuid)
17   end
18
19   test "trash_sweep - fail with non-admin token" do
20     authorize_with :active
21     post :trash_sweep
22     assert_response 403
23   end
24
25   test "trash_sweep - move collections to trash" do
26     c = collections(:trashed_on_next_sweep)
27     refute_empty Collection.where('uuid=? and is_trashed=false', c.uuid)
28     assert_raises(ActiveRecord::RecordNotUnique) do
29       act_as_user users(:active) do
30         Collection.create!(owner_uuid: c.owner_uuid,
31                            name: c.name)
32       end
33     end
34     authorize_with :admin
35     post :trash_sweep
36     assert_response :success
37     c = Collection.where('uuid=? and is_trashed=true', c.uuid).first
38     assert c
39     act_as_user users(:active) do
40       assert Collection.create!(owner_uuid: c.owner_uuid,
41                                 name: c.name)
42     end
43   end
44
45   test "trash_sweep - delete collections" do
46     uuid = 'zzzzz-4zz18-3u1p5umicfpqszp' # deleted_on_next_sweep
47     assert_not_empty Collection.where(uuid: uuid)
48     authorize_with :admin
49     post :trash_sweep
50     assert_response :success
51     assert_empty Collection.where(uuid: uuid)
52   end
53
54   test "trash_sweep - delete referring links" do
55     uuid = collections(:trashed_on_next_sweep).uuid
56     act_as_system_user do
57       assert_raises ActiveRecord::RecordInvalid do
58         # Cannot create because :trashed_on_next_sweep is already trashed
59         Link.create!(head_uuid: uuid,
60                      tail_uuid: system_user_uuid,
61                      link_class: 'whatever',
62                      name: 'something')
63       end
64
65       # Bump trash_at to now + 1 minute
66       Collection.where(uuid: uuid).
67         update(trash_at: db_current_time + (1).minute)
68
69       # Not considered trashed now
70       Link.create!(head_uuid: uuid,
71                    tail_uuid: system_user_uuid,
72                    link_class: 'whatever',
73                    name: 'something')
74     end
75     past = db_current_time
76     Collection.where(uuid: uuid).
77       update_all(is_trashed: true, trash_at: past, delete_at: past)
78     assert_not_empty Collection.where(uuid: uuid)
79     authorize_with :admin
80     post :trash_sweep
81     assert_response :success
82     assert_empty Collection.where(uuid: uuid)
83   end
84
85   test "trash_sweep - move projects to trash" do
86     p = groups(:trashed_on_next_sweep)
87     assert_empty Group.where('uuid=? and is_trashed=true', p.uuid)
88     authorize_with :admin
89     post :trash_sweep
90     assert_response :success
91     assert_not_empty Group.where('uuid=? and is_trashed=true', p.uuid)
92   end
93
94   test "trash_sweep - delete projects and their contents" do
95     g_foo = groups(:trashed_project)
96     g_bar = groups(:trashed_subproject)
97     g_baz = groups(:trashed_subproject3)
98     col = collections(:collection_in_trashed_subproject)
99     cr = container_requests(:cr_in_trashed_project)
100     # Save how many objects were before the sweep
101     user_nr_was = User.all.length
102     coll_nr_was = Collection.all.length
103     group_nr_was = Group.where('group_class<>?', 'project').length
104     project_nr_was = Group.where(group_class: 'project').length
105     cr_nr_was = ContainerRequest.all.length
106     assert_not_empty Group.where(uuid: g_foo.uuid)
107     assert_not_empty Group.where(uuid: g_bar.uuid)
108     assert_not_empty Group.where(uuid: g_baz.uuid)
109     assert_not_empty Collection.where(uuid: col.uuid)
110     assert_not_empty ContainerRequest.where(uuid: cr.uuid)
111
112     authorize_with :admin
113     post :trash_sweep
114     assert_response :success
115
116     assert_empty Group.where(uuid: g_foo.uuid)
117     assert_empty Group.where(uuid: g_bar.uuid)
118     assert_empty Group.where(uuid: g_baz.uuid)
119     assert_empty Collection.where(uuid: col.uuid)
120     assert_empty ContainerRequest.where(uuid: cr.uuid)
121     # No unwanted deletions should have happened
122     assert_equal user_nr_was, User.all.length
123     assert_equal coll_nr_was-2,        # collection_in_trashed_subproject
124                  Collection.all.length # & deleted_on_next_sweep collections
125     assert_equal group_nr_was, Group.where('group_class<>?', 'project').length
126     assert_equal project_nr_was-3, Group.where(group_class: 'project').length
127     assert_equal cr_nr_was-1, ContainerRequest.all.length
128   end
129
130 end