2

I have a pdflatex project where I need both Python and SQL listings. The listings package works great, I was able to add and reformat the extra keywords for Python with the following code:

\lstset{
    language=python,
    basicstyle=\small,
    identifierstyle=\ttfamily,
    keywordstyle=\bfseries\ttfamily\color[rgb]{0,0,1},
    stringstyle=\ttfamily\color[rgb]{0.627,0.126,0.941},
    morekeywords={cls,self,abstractmethod,classmethod,
                  __call__,__import__,__init__, __nonzero__,None}
}

However, I need to add extra SQL keywords as well, that are not valid in Python, like REFERENCES. How do I add keywords for different languages?

Thank you.

0

1 Answer 1

5

You can define two separate styles, or even two separate environments.

\documentclass[]{article}

\usepackage{xcolor}
\usepackage{listings}


\lstdefinestyle{Python}
{
    language=python,
    basicstyle=\small,
    identifierstyle=\ttfamily,
    keywordstyle=\bfseries\ttfamily\color[rgb]{0,0,1},
    stringstyle=\ttfamily\color[rgb]{0.627,0.126,0.941},
    morekeywords={cls,self,abstractmethod,classmethod,
                  __call__,__import__,__init__, __nonzero__,None}
}

\lstdefinestyle{Sql}
{
    language=SQL,
    basicstyle=\small,
    identifierstyle=\ttfamily,
    keywordstyle=\bfseries\ttfamily\color[rgb]{0,0,1},
    stringstyle=\ttfamily\color[rgb]{0.627,0.126,0.941},
    morekeywords={REFERENCES}
}


\lstnewenvironment{sql}
{\lstset{style=Sql}}
{}

\lstnewenvironment{python}
{\lstset{style=Python}}
{}

\begin{document}


\begin{python}
    parents, babies = (1, 1)
     while babies < 100:
    print 'This generation has {0} babies'.format(babies)
    parents, babies = (babies, parents + babies)
\end{python}

\begin{sql}
  CREATE TABLE STATION
(ID INTEGER PRIMARY KEY,
CITY CHAR(20),
STATE CHAR(2),
LAT_N REAL,
LONG_W REAL);
REFERENCES
\end{sql}
\end{document}

enter image description here

2
  • Would i be able to move those into a separate source file and include it whenever I need these? Thank you
    – gt6989b
    Commented Mar 24, 2015 at 15:41
  • 1
    @gt6989b You can always save the styles as separate files and \input them, if you mean that.
    – user11232
    Commented Mar 24, 2015 at 15:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .