File: select.template

package info (click to toggle)
flamerobin 0.9.13.ds.2-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 7,300 kB
  • sloc: cpp: 59,818; sh: 10,505; xml: 1,029; ansic: 302; makefile: 27
file content (4 lines) | stat: -rw-r--r-- 422 bytes parent folder | download | duplicates (3) 
1
2
3
4
 
{%edit_conf%}{%wrap:{%kw:select%} {%foreach:column:, :{%ifcontains:{%getconf:{%object_path%}/columnNames%}:{%object_name%}:a.{%object_quoted_name%}%}%}%}
{%kw:from%} {%object_quoted_name%} a {%ifeq:{%countall:{%getconf:{%object_path%}/whereColumnNames%}%}:0:;:
{%kw:where%}{%foreach:column: {%kw:and%} :{%ifcontains:{%getconf:{%object_path%}/whereColumnNames%}:{%object_name%}:
{%tab%}a.{%object_quoted_name%} = '?'%}%}%}