# File lib/jdbc_adapter/jdbc_mssql.rb, line 26 def self.adapter_matcher(name, *) name =~ /sqlserver|tds/ ? self : false end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 30 def self.column_selector [/sqlserver|tds/, lambda {|cfg,col| col.extend(::JdbcSpec::MsSQL::Column)}] end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 7 def self.extended(mod) unless @lob_callback_added ActiveRecord::Base.class_eval do def after_save_with_mssql_lob self.class.columns.select { |c| c.sql_type =~ /image/ }.each do |c| value = self[c.name] value = value.to_yaml if unserializable_attribute?(c.name, c) next if value.nil? || (value == '') connection.write_large_object(c.type == :binary, c.name, self.class.table_name, self.class.primary_key, quote_value(id), value) end end end ActiveRecord::Base.after_save :after_save_with_mssql_lob @lob_callback_added = true end end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 246 def _execute(sql, name = nil) if sql.lstrip =~ /^insert/ if query_requires_identity_insert?(sql) table_name = get_table_name(sql) with_identity_insert_enabled(table_name) do id = @connection.execute_insert(sql) end else @connection.execute_insert(sql) end elsif sql.lstrip =~ /^\(?\s*(select|show)/ repair_special_columns(sql) @connection.execute_query(sql) else @connection.execute_update(sql) end end
Adds a new column to the named table. See TableDefinition#column for details of the options you can use.
# File lib/jdbc_adapter/jdbc_mssql.rb, line 184 def add_column(table_name, column_name, type, options = {}) add_column_sql = "ALTER TABLE #{table_name} ADD #{quote_column_name(column_name)} #{type_to_sql(type, options[:limit], options[:precision], options[:scale])}" add_column_options!(add_column_sql, options) # TODO: Add support to mimic date columns, using constraints to mark them as such in the database # add_column_sql << " CONSTRAINT ck__#{table_name}__#{column_name}__date_only CHECK ( CONVERT(CHAR(12), #{quote_column_name(column_name)}, 14)='00:00:00:000' )" if type == :date execute(add_column_sql) end
SELECT .. FOR UPDATE is not supported on Microsoft SQL Server
# File lib/jdbc_adapter/jdbc_mssql.rb, line 265 def add_lock!(sql, options) sql end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 10 def after_save_with_mssql_lob self.class.columns.select { |c| c.sql_type =~ /image/ }.each do |c| value = self[c.name] value = value.to_yaml if unserializable_attribute?(c.name, c) next if value.nil? || (value == '') connection.write_large_object(c.type == :binary, c.name, self.class.table_name, self.class.primary_key, quote_value(id), value) end end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 153 def change_order_direction(order) order.split(",").collect {|fragment| case fragment when /\bDESC\b/ then fragment.gsub(/\bDESC\b/, "ASC") when /\bASC\b/ then fragment.gsub(/\bASC\b/, "DESC") else String.new(fragment).split(',').join(' DESC,') + ' DESC' end }.join(",") end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 236 def columns(table_name, name = nil) return [] if table_name =~ /^information_schema\./ cc = super cc.each do |col| col.identity = true if col.sql_type =~ /identity/ col.is_special = true if col.sql_type =~ /text|ntext|image/ end cc end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 173 def create_database(name) execute "CREATE DATABASE #{name}" execute "USE #{name}" end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 168 def drop_database(name) execute "USE master" execute "DROP DATABASE #{name}" end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 111 def quote(value, column = nil) return value.quoted_id if value.respond_to?(:quoted_id) case value when String, ActiveSupport::Multibyte::Chars value = value.to_s if column && column.type == :binary "'#{quote_string(JdbcSpec::MsSQL::Column.string_to_binary(value))}'" # ' (for ruby-mode) elsif column && [:integer, :float].include?(column.type) value = column.type == :integer ? value.to_i : value.to_f value.to_s else "N'#{quote_string(value)}'" # ' (for ruby-mode) end when TrueClass then '1' when FalseClass then '0' when Time, DateTime then "'#{value.strftime("%Y%m%d %H:%M:%S")}'" when Date then "'#{value.strftime("%Y%m%d")}'" else super end end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 141 def quote_column_name(name) "[#{name}]" end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 133 def quote_string(string) string.gsub(/\'/, "''") end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 137 def quote_table_name(name) name end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 149 def quoted_false quote false end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 145 def quoted_true quote true end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 163 def recreate_database(name) drop_database(name) create_database(name) end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 223 def remove_check_constraints(table_name, column_name) # TODO remove all constraints in single method constraints = select "SELECT CONSTRAINT_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE where TABLE_NAME = '#{table_name}' and COLUMN_NAME = '#{column_name}'" constraints.each do |constraint| execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint["CONSTRAINT_NAME"]}" end end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 210 def remove_column(table_name, column_name) remove_check_constraints(table_name, column_name) remove_default_constraint(table_name, column_name) execute "ALTER TABLE #{table_name} DROP COLUMN [#{column_name}]" end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 216 def remove_default_constraint(table_name, column_name) defaults = select "select def.name from sysobjects def, syscolumns col, sysobjects tab where col.cdefault = def.id and col.name = '#{column_name}' and tab.name = '#{table_name}' and col.id = tab.id" defaults.each {|constraint| execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint["name"]}" } end
# File lib/jdbc_adapter/jdbc_mssql.rb, line 231 def remove_index(table_name, options = {}) execute "DROP INDEX #{table_name}.#{index_name(table_name, options)}" end
Generated with the Darkfish Rdoc Generator 2.