当我右键单击选定的 SQL 查询并选择“格式化 SQL”时,它会将 SQL 更改为小写。
另一个命令“To upper case”不是 SQL 智能的,这意味着它将选择中的所有内容都更改为大写,因此名称中也不会使用“SQL”来调用它。
查询本身不区分大小写,并在 SQL 中运行,全局更改为大写或小写,但是使用 SQL 查询结果的外部 Python 函数在将其设为大写时无法再找到所需的列,因为它搜索小写的 column_name。
这导致我的前端出现以下错误:
AttributeError
AttributeError: 'Source' object has no attribute 'schedule_day'
Traceback (most recent call last)
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1836, in __call__
return self.wsgi_app(environ, start_response)
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1820, in wsgi_app
response = self.make_response(self.handle_exception(e))
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1403, in handle_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1817, in wsgi_app
response = self.full_dispatch_request()
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1477, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1381, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1475, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/lib/python2.7/dist-packages/flask/app.py", line 1461, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/monitoring/app.py", line 149, in show_broken_sources
if source.schedule_day is None:
AttributeError: 'Source' object has no attribute 'item_day'
The debugger caught an exception in your WSGI application. You can now look at the traceback which led to the error.
To switch between the interactive traceback and the plaintext one, you can click on the "Traceback" headline. From the text traceback you can also create a paste of it. For code execution mouse-over the frame you want to debug and click on the console icon on the right side.
You can execute arbitrary Python code in the stack frames and there are some extra helpers available for introspection:
dump() shows all variables in the frame
dump(obj) dumps all that's known about the object
Brought to you by DON'T PANIC, your friendly Werkzeug powered traceback interpreter.
有没有办法只为 SQL command words更改为大写,最好是默认情况下?
转到文件--> 属性--> 编辑器--> SQL 编辑器--> 格式。您甚至可以选择数据源的设置、全局设置或外部设置。
就我而言,在“默认格式化程序”中,选择“上”,您可以使用
Ctrl
+Shift
+使用此格式化程序F