Business intelligence made simple
require_relative "test_helper"
class QueriesTest < ActionDispatch::IntegrationTest
def setup
super
Blazer::Audit.delete_all
Blazer::Query.delete_all
end
def test_home
create_query
get blazer.root_path
assert_response :success
assert_match "Test", response.body
end
def test_index
get blazer.queries_path
assert_redirected_to blazer.root_path
end
def test_index_json
create_query
get blazer.queries_path, as: :json
assert_response :success
assert_match "Test", response.body
end
def test_new
get blazer.new_query_path
assert_response :success
assert_match "New Query", response.body
end
def test_new_fork_query_id
query = create_query(statement: "SELECT 1000")
get blazer.new_query_path(fork_query_id: query.id)
assert_response :success
assert_match "SELECT 1000", response.body
end
def test_new_upload_id
upload = Blazer::Upload.create!(table: "orders")
get blazer.new_query_path(upload_id: upload.id)
assert_response :success
assert_match "SELECT * FROM "uploads"."orders" LIMIT 10", response.body
end
def test_create
post blazer.queries_path, params: {query: {name: "Test", statement: "SELECT 1", data_source: "main"}}
query = Blazer::Query.last
assert_redirected_to blazer.query_path(query)
get blazer.query_path(query)
assert_response :success
post blazer.run_queries_path, params: {statement: query.statement, data_source: query.data_source, query_id: query.id}, xhr: true
assert_response :success
audit = Blazer::Audit.last
assert_equal query.id, audit.query_id
assert_equal query.statement, audit.statement
assert_equal query.data_source, audit.data_source
end
def test_create_error
post blazer.queries_path, params: {query: {name: "Test", statement: "", data_source: "main"}}
assert_response :unprocessable_entity
assert_match(/Statement can('|’)t be blank/, response.body)
end
def test_show
query = create_query
get blazer.query_path(query)
assert_response :success
assert_match "Test", response.body
end
def test_edit
query = create_query
get blazer.edit_query_path(query)
assert_response :success
assert_match "Test", response.body
end
def test_refresh
query = create_query
post blazer.refresh_query_path(query)
assert_redirected_to blazer.query_path(query)
end
def test_update
query = create_query
patch blazer.query_path(query, params: {query: {name: "Updated"}})
query.reload
assert_redirected_to blazer.query_path(query)
assert_equal "Updated", query.name
end
def test_destroy
query = create_query
delete blazer.query_path(query)
assert_redirected_to blazer.root_path
assert_raises(ActiveRecord::RecordNotFound) do
query.reload
end
end
def test_tables
get blazer.tables_queries_path(data_source: "main")
assert_response :success
tables = JSON.parse(response.body)
tables = tables.map { |v| v["table"] } if postgresql?
assert_includes tables, "blazer_queries"
end
def test_docs
get blazer.docs_queries_path(data_source: "main")
assert_response :success
assert_match "Docs: main", response.body
end
def test_schema
get blazer.schema_queries_path(data_source: "main")
assert_response :success
assert_match "Schema: main", response.body
end
def test_cancel
post blazer.cancel_queries_path("run-id", data_source: "main")
assert_response :success
end
def test_rollback
create_query
run_query "DELETE FROM blazer_queries"
assert_equal 1, Blazer::Query.count
end
def test_variables_time
query = create_query(statement: "SELECT {created_at}")
get blazer.query_path(query)
assert_response :success
assert_match "singleDatePicker", response.body
end
def test_variables_time_range
query = create_query(statement: "SELECT {start_time}, {end_time}")
get blazer.query_path(query)
assert_response :success
assert_match "daterangepicker", response.body
end
def test_variable_defaults
query = create_query(statement: "SELECT {default_var}")
get blazer.query_path(query)
assert_response :success
assert_match %{value="default_value"}, response.body
end
def test_variables_id
query = create_query(statement: "SELECT {id}")
get blazer.query_path(query), params: {id: 123}
assert_response :success
assert_match %!"variables":{"id":"123"}!, response.body
end
def test_variables_zero
query = create_query(statement: "SELECT {id}")
get blazer.query_path(query), params: {id: "0"}
assert_response :success
assert_match "SELECT 0", response.body
end
def test_variables_leading_zeros
query = create_query(statement: "SELECT {id}")
get blazer.query_path(query), params: {id: "0123"}
assert_response :success
assert_match "SELECT '0123'", response.body
end
def test_smart_variables
query = create_query(statement: "SELECT {period}")
get blazer.query_path(query)
assert_response :success
assert_match "day", response.body
assert_match "week", response.body
assert_match "month", response.body
end
def test_linked_columns
run_query "SELECT 123 AS user_id"
assert_match "/admin/users/123", response.body
end
def test_smart_columns
run_query "SELECT 0 AS status"
assert_match "Active", response.body
end
def test_csv
run_query("SELECT 1 AS id, 'Chicago' AS city", format: "csv")
assert_equal "id,city\n1,Chicago\n", response.body
assert_equal "attachment; filename=\"query.csv\"; filename*=UTF-8''query.csv", response.headers["Content-Disposition"]
assert_equal "text/csv; charset=utf-8", response.headers["Content-Type"]
end
def test_csv_query
query = create_query(name: "All Cities", statement: "SELECT 1 AS id, 'Chicago' AS city")
run_query(query.statement, format: "csv", query_id: query.id)
assert_equal "id,city\n1,Chicago\n", response.body
assert_equal "attachment; filename=\"all-cities.csv\"; filename*=UTF-8''all-cities.csv", response.headers["Content-Disposition"]
assert_equal "text/csv; charset=utf-8", response.headers["Content-Type"]
end
def test_csv_query_variables
query = create_query(name: "Cities", statement: "SELECT 1 AS id, {name} AS city")
run_query(query.statement, format: "csv", query_id: query.id, variables: {name: "Chicago"})
assert_equal "id,city\n1,Chicago\n", response.body
assert_equal "attachment; filename=\"cities.csv\"; filename*=UTF-8''cities.csv", response.headers["Content-Disposition"]
assert_equal "text/csv; charset=utf-8", response.headers["Content-Type"]
end
def test_url
run_query "SELECT 'http://localhost:3000/'"
assert_match %{<a target="_blank" href="http://localhost:3000/">http://localhost:3000/</a>}, response.body
end
def test_images_default
run_query("SELECT 'http://localhost:3000/image.png'")
refute_match %{<img referrerpolicy="no-referrer" src="http://localhost:3000/image.png" />}, response.body
end
def test_images
with_option(:images, true) do
run_query("SELECT 'http://localhost:3000/image.png'")
assert_match %{<img referrerpolicy="no-referrer" src="http://localhost:3000/image.png" }, response.body
end
end
def test_async
with_option(:async, true) do
perform_enqueued_jobs do
run_query "SELECT 123"
end
assert_match "123", response.body
end
end
end