Pretty print SQL broken? Or am I doing something wrong?

Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

[-- Attachment #1: Type: text/plain, Size: 730 bytes --]

verb-sql.tex seems not to work correctly. Is it broken or am I doing  
something wrong?

I call it as this:

\definetyping[SQL][option=color,numbering=line,bodyfont=9pt]
\defineoverlay[ifsqoverlay][\overlayfigure{IfSQ-overlay.pdf}]
\setupcolors[state=start]
\setuplayout[leftmargin=10mm,rightmargin=0mm,footer=0mm,header=5mm]
\setuppapersize[A4,landscape][a4,landscape]
\setupbackgrounds[page][background=ifsqoverlay]
\setuptyping[SQL][palet=colorpretty]
\starttext
\typefile[SQL][]{test2.txt}
\stoptext

I get rather strange coloration. I would expect comments to be colored  
differently, but only start and end character are. When I run PL/SQL  
through the formatter, variable names as bar_foo get only the _  
colored, etc.


[-- Attachment #2: testsql2.pdf --]
[-- Type: application/pdf, Size: 56173 bytes --]

[-- Attachment #3: Type: text/plain, Size: 1 bytes --]



[-- Attachment #4: Type: text/plain, Size: 487 bytes --]

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Berend de Boer]

>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:

    Gerben> verb-sql.tex seems not to work correctly. Is it broken or
    Gerben> am I doing something wrong?

What if you use lowercase?

-- 
Cheers,

Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

On 8 Jun 2009, at 09:59, Berend de Boer wrote:

>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
>    Gerben> verb-sql.tex seems not to work correctly. Is it broken or
>    Gerben> am I doing something wrong?
>
> What if you use lowercase?

For 'SQL' I assume I should use 'sql'. When I do that, exactly the  
same happens.

Yours,

Gerben

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

Nobody has a solution for my problem with non-working colouration of  
code?

G

On 9 Jun 2009, at 00:12, Gerben Wierda wrote:

>
> On 8 Jun 2009, at 09:59, Berend de Boer wrote:
>
>>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>>
>>   Gerben> verb-sql.tex seems not to work correctly. Is it broken or
>>   Gerben> am I doing something wrong?
>>
>> What if you use lowercase?
>
> For 'SQL' I assume I should use 'sql'. When I do that, exactly the  
> same happens.
>
> Yours,
>
> Gerben
>
> ___________________________________________________________________________________
> If your question is of interest to others as well, please add an  
> entry to the Wiki!
>
> maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
> webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
> archive  : https://foundry.supelec.fr/projects/contextrev/
> wiki     : http://contextgarden.net
> ___________________________________________________________________________________
>

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Hans Hagen]

Gerben Wierda wrote:
> Nobody has a solution for my problem with non-working colouration of code?

the sql filter in mkii was not written by me ...

(in mkiv we hav eno sql filter yet)

Hans


-----------------------------------------------------------------
                                           Hans Hagen | PRAGMA ADE
               Ridderstraat 27 | 8061 GH Hasselt | The Netherlands
      tel: 038 477 53 69 | fax: 038 477 53 74 | www.pragma-ade.com
                                              | www.pragma-pod.nl
-----------------------------------------------------------------
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

On 11 Jun 2009, at 15:05, Hans Hagen wrote:

> Gerben Wierda wrote:
>> Nobody has a solution for my problem with non-working colouration  
>> of code?
>
> the sql filter in mkii was not written by me ...

So, who did? Or is there documentation on how this works so I can look  
at it myself?

G

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Berend de Boer]

>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:

    Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
    Gerben> exactly the same happens.

I mean "select" instead of "SELECT".

-- 
Groetjes,

Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

On 11 Jun 2009, at 14:22, Berend de Boer wrote:

>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
>    Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
>    Gerben> exactly the same happens.
>
> I mean "select" instead of "SELECT".

Maakt geen verschil.

Gerben

___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Gerben Wierda]

On 11 Jun 2009, at 14:22, Berend de Boer wrote:

>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
>
>    Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
>    Gerben> exactly the same happens.
>
> I mean "select" instead of "SELECT".

Sorry, English: makes no difference.

G
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________

Re: Pretty print SQL broken? Or am I doing something wrong?

[Berend de Boer]

>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:

>>>>>> "Gerben" == Gerben Wierda <Gerben.Wierda@rna.nl> writes:
    >> 
    Gerben> For 'SQL' I assume I should use 'sql'. When I do that,
    Gerben> exactly the same happens.
    >> 
    >> I mean "select" instead of "SELECT".

Hi Gerben,

Just following up publicly on the files you sent me, this works for me:

  \setuptyping[SQL][palet=colorpretty]
  \def\typeSQLfile{\typefile[SQL]}
  \starttext
  \typeSQLfile{test2.txt}
  \stoptext

So changes:

1. Don't define the typing, it's already.

2. use SQL, not sql.

3. Your SQL keywords must be lowercase not UPPERcase, else they won't
   get highlighted.

4. comments inside your SQL file trip up the parser, don't know why,
   but just leave them out.


-- 
Groetjes,

Berend.
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : https://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________