Module: UmbrellioUtils::ClickHouse::Backends::Base::ClickHouseStringEscaping

Defined in:
lib/umbrellio_utils/click_house/backends/base.rb

Overview

ClickHouse uses C-style escape sequences in string literals, so backslashes must be doubled. Sequel’s default (Postgres) escaping only escapes single-quotes.

Instance Method Summary collapse

Instance Method Details

#literal_string_append(sql, str) ⇒ Object



20
21
22
# File 'lib/umbrellio_utils/click_house/backends/base.rb', line 20

def literal_string_append(sql, str)
  sql << "'" << str.gsub("\\") { "\\\\" }.gsub("'", "''") << "'"
end