Odoo中文网|Odoo实施培训

标题: 数据库区分大小写的问题 [打印本页]

作者: 磨叽什么 时间: 2018-4-26 17:23
标题: 数据库区分大小写的问题
源码如下：
def _select(self):
      select_str = """
         select min(id) as id, date, code, ID, CH1, CH2, CH3, dvalue, result, checker
      """
      return select_str

def _from(self):
      from_str = """
         test_ngc
      """
      return from_str

def _group_by(self):
      group_by_str = """
         GROUP BY date, code, ID, CH1, CH2, CH3, dvalue, result, checker
      """
      return group_by_str

@api.model_cr
def init(self):
      tools.drop_view_if_exists(self.env.cr, self._table)
      self.env.cr.execute("""CREATE or REPLACE VIEW %s as (
         %s
         FROM %s
         %s
         )""" % (self._table, self._select(), self._from(), self._group_by()))

修改之后如下：
def _select(self):
      select_str = """
         select min(id) as id, date, code, "ID", "CH1", "CH2", "CH3", dvalue, result, checker
      """
      return select_str

def _from(self):
      from_str = """
         test_ngc
      """
      return from_str

def _group_by(self):
      group_by_str = """
         GROUP BY date, code, "ID", "CH1", "CH2", "CH3", dvalue, result, checker
      """
      return group_by_str

@api.model_cr
def init(self):
      tools.drop_view_if_exists(self.env.cr, self._table)
      self.env.cr.execute("""CREATE or REPLACE VIEW %s as (
         %s
         FROM %s
         %s
         )""" % (self._table, self._select(), self._from(), self._group_by()))

将大写的字段用双引号引起来，注意必须一致

欢迎光临 Odoo中文网|Odoo实施培训 (http://www.chinaodoo.net/)