如何在 jupyter notebook 中为 SQL 行魔术、单元魔术和自定义命令添加语法高亮? [英] How to add syntax highlight to SQL line magic, cell magic and custom command in jupyter notebook?

问题描述

我一直在寻找在 jupyter notebook 中突出显示 SQL 代码的方法.我只能突出显示 SQL 单元格魔术，但不能突出显示线条魔术和自定义设置.

案例 1(作品)

高亮单元格魔法(单元格以%%sql开头)

参考:

相关链接

• I was searching for ways to highlight SQL codes in jupyter notebook. I was able to highlight SQL cell magic only, but not line magic and custom settings.

  Case 1 (works)

  Highlight cell magic (cell startswith %%sql)

  Ref: adding syntax highlighting to Jupyter notebook cell magic

  require(['notebook/js/codecell'], function(codecell) {
    codecell.CodeCell.options_default.highlight_modes['magic_text/x-mssql'] = {'reg':[/^%%sql/]} ;
    Jupyter.notebook.events.one('kernel_ready.Kernel', function(){
    Jupyter.notebook.get_cells().map(function(cell){
        if (cell.cell_type == 'code'){ cell.auto_highlight(); } }) ;
    });
  });
  

  Case 2(does not work)

  Line Magic: line starts with %sql
  My attempt: Change the regex to ^%sql but it did not work.

  %sql select * from Products limit 5;
  

  Case 3 (does not work)

  How to syntax highlight custom cells (cell startswith ##%%)
  My attempt: Tried to changing regex to ^##%%sql

  ##%%sql
  q = " select * from customer limit 2;"
  execute_query(q,dbname)
  

  Example image

  In the image we can see that cell magic %sql commands are not highlighted. I want them to be highlighted.

  Related links

  • adding syntax highlighting to Jupyter notebook cell magic
  • IPython change input cell syntax highlighting logic for entire session

  解决方案

  This will work even for assignments, as in the third cell. Currently multiple languages highlighting unavailable. So it will be either Python or SQL syntax, whatever comes first.

  require(['notebook/js/codecell'], function (codecell) {
      codecell.CodeCell.options_default.highlight_modes['magic_text/x-mssql'] = { 'reg': [/%?%sql/] };
      Jupyter.notebook.events.one('kernel_ready.Kernel', function () {
          Jupyter.notebook.get_cells().map(function (cell) {
              if (cell.cell_type == 'code') { cell.auto_highlight(); }
          });
      });
  });
  

  这篇关于如何在 jupyter notebook 中为 SQL 行魔术、单元魔术和自定义命令添加语法高亮?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！