blob: b970d3daf84dcb7742f80d72cba9ab2af7afc308 (
plain)
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
|
# frozen_string_literal: true
# rubocop: disable Gitlab/NamespacedClass
class ClickHouseTestRunner
def truncate_tables
ClickHouse::Client.configuration.databases.each_key do |db|
# Select tables with at least one row
query = tables_for(db).map do |table|
"(SELECT '#{table}' AS table FROM #{table} LIMIT 1)"
end.join(' UNION ALL ')
tables_with_data = ClickHouse::Client.select(query, db).pluck('table')
tables_with_data.each do |table|
ClickHouse::Client.execute("TRUNCATE TABLE #{table}", db)
end
end
end
def ensure_schema
return if @ensure_schema
ClickHouse::Client.configuration.databases.each_key do |db|
# drop all tables
lookup_tables(db).each do |table|
ClickHouse::Client.execute("DROP TABLE IF EXISTS #{table}", db)
end
# run the schema SQL files
Dir[Rails.root.join("db/click_house/#{db}/*.sql")].each do |file|
ClickHouse::Client.execute(File.read(file), db)
end
end
@ensure_schema = true
end
private
def tables_for(db)
@tables ||= {}
@tables[db] ||= lookup_tables(db)
end
def lookup_tables(db)
ClickHouse::Client.select('SHOW TABLES', db).pluck('name')
end
end
# rubocop: enable Gitlab/NamespacedClass
RSpec.configure do |config|
click_house_test_runner = ClickHouseTestRunner.new
config.around(:each, :click_house) do |example|
with_net_connect_allowed do
click_house_test_runner.ensure_schema
click_house_test_runner.truncate_tables
example.run
end
end
end
|