pycharm 中写裸 sql 时,不能识别 fstring 的变量? - V2EX
推荐学习书目
Learn Python the Hard Way
Python Sites
PyPI - Python Package Index
http://diveintopython.org/toc/index.html
Pocoo
值得关注的项目
PyPy
Celery
Jinja2
Read the Docs
gevent
pyenv
virtualenv
Stackless Python
Beautiful Soup
结巴中文分词
Green Unicorn
Sentry
Shovel
Pyflakes
pytest
Python 编程
pep8 Checker
Styles
< href="http://www.python.org/dev/peps/pep-0008/" target="_blank">PEP 8
Google Python Style Guide
Code Style from The Hitchhiker's Guide
solxnp

pycharm 中写裸 sql 时,不能识别 fstring 的变量?

  •  
  •   solxnp May 27, 2019 2990 views
    This topic created in 2542 days ago, the information mentioned may be changed or developed.

    有没有用的熟练的大佬知道在哪里可以设置,亦或是这就是个 Bug ?

    如图,说不影响是假的,专门起的给 sql 用的变量,看起来都是灰色未使用,总是忍不住想要删掉。。。

    VZQmDS.png

    VZQnHg.png

    7 replies    2019-05-27 17:57:00 +08:00
    neoblackcap
        1
    neoblackcap  
       May 27, 2019
    看看这个情况肯定就是两种语法冲突啦,你要 Pycharm 按哪种语法进行高亮?按目前来看,你这个语言不属于 SQL,因此高亮不起来。如果按 f-string 高亮,select 这些 SQL 的关键字也就不可能高亮。
    这东西要能做,完全就是 hack,去 youtrack 提 issue 吧
    daiqiangbudainiu
        2
    daiqiangbudainiu  
       May 27, 2019
    你这个逗号有问题吧,写代码用英文输入法,不要用中文输入法的英文
    edsion996
        3
    edsion996  
       May 27, 2019
    ![]( )
    为什么我可以?
    solxnp
        4
    solxnp  
    OP
       May 27, 2019
    @zjb861107 应该是如 1 楼所说的两种语法冲突了。

    你的可以是因为你没使用 sql 语法,看下我的 sql 截图:

    ![VZNWa6.png]( https://s2.ax1x.com/2019/05/27/VZNWa6.png)
    solxnp
        5
    solxnp  
    OP
       May 27, 2019
    @neoblackcap 确实是这个问题!我尝试在 select 后面加个 1,使之不被认为是个 sql 后,就正常了
    solxnp
        6
    solxnp  
    OP
       May 27, 2019
    权衡利弊之后,选择了关闭 sql 的语法提示,不然右侧提示全是红杠。

    关闭位置位于 File--Settings--Editor--Language Injections--取消勾选 "SQL select/delete/insert/updatge/create"
    gejun123456
        7
    gejun123456  
       May 27, 2019 via iPhone
    写个 idea 插件就能支持了
    About     Help     Advertise     Blog     API     FAQ     Solana     3075 Online   Highest 6679       Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 47ms UTC 15:04 PVG 23:04 LAX 08:04 JFK 11:04
    Do have faith in what you're doing.
    ubao msn snddm index pchome yahoo rakuten mypaper meadowduck bidyahoo youbao zxmzxm asda bnvcg cvbfg dfscv mmhjk xxddc yybgb zznbn ccubao uaitu acv GXCV ET GDG YH FG BCVB FJFH CBRE CBC GDG ET54 WRWR RWER WREW WRWER RWER SDG EW SF DSFSF fbbs ubao fhd dfg ewr dg df ewwr ewwr et ruyut utut dfg fgd gdfgt etg dfgt dfgd ert4 gd fgg wr 235 wer3 we vsdf sdf gdf ert xcv sdf rwer hfd dfg cvb rwf afb dfh jgh bmn lgh rty gfds cxv xcv xcs vdas fdf fgd cv sdf tert sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf sdf shasha9178 shasha9178 shasha9178 shasha9178 shasha9178 liflif2 liflif2 liflif2 liflif2 liflif2 liblib3 liblib3 liblib3 liblib3 liblib3 zhazha444 zhazha444 zhazha444 zhazha444 zhazha444 dende5 dende denden denden2 denden21 fenfen9 fenf619 fen619 fenfe9 fe619 sdf sdf sdf sdf sdf zhazh90 zhazh0 zhaa50 zha90 zh590 zho zhoz zhozh zhozho zhozho2 lislis lls95 lili95 lils5 liss9 sdf0ty987 sdft876 sdft9876 sdf09876 sd0t9876 sdf0ty98 sdf0976 sdf0ty986 sdf0ty96 sdf0t76 sdf0876 df0ty98 sf0t876 sd0ty76 sdy76 sdf76 sdf0t76 sdf0ty9 sdf0ty98 sdf0ty987 sdf0ty98 sdf6676 sdf876 sd876 sd876 sdf6 sdf6 sdf9876 sdf0t sdf06 sdf0ty9776 sdf0ty9776 sdf0ty76 sdf8876 sdf0t sd6 sdf06 s688876 sd688 sdf86