Rails Active Record - 带引号的标识符 - MS Sql Server 保留的表名称

发布于 2024-11-03 05:23:16 字数 606 浏览 1 评论 0原文

我有一个 SQL Server 2005 旧数据库，其中有一个名为 user 的表和一个映射到“用户”表的模型用户。

“user”是Sql Server中的保留字，因此我需要ActiveRecord在查询中引用/括号表名，因为

Select u.* from [user] where [user].[Id] = 1

默认情况

Select u.* from user where user.[Id] = 1

下由于保留字冲突而失败。

如何通知 Rails 使用标准带引号的标识符或括号标识符来分隔表名称中的保留字和/或空格？

导轨模型

class User < UserBase
  set_primary_key "Id"
  set_table_name "user"

end

class UserBase < ActiveRecord::Base
  establish_connection "tums_#{[Rails.env]}"
  self.abstract_class = true
end

原文

I have a SQL Server 2005 legacy database which has a table named user and a model User which maps to the 'user' table.

'user' is a reserved word in Sql Server, so I need ActiveRecord to quote/bracket the table name in queries as

Select u.* from [user] where [user].[Id] = 1

the default is

Select u.* from user where user.[Id] = 1

which fails due to the reserve word conflict.

How do I inform rails to use use either the standard quoted identifiers or bracketed identifiers to delimit reserved words and/or spaces in table names?

Rails Models

class User < UserBase
  set_primary_key "Id"
  set_table_name "user"

end

class UserBase < ActiveRecord::Base
  establish_connection "tums_#{[Rails.env]}"
  self.abstract_class = true
end

分享到QQ

分享到微博