"Fossies" - the Fresh Open Source Software Archive

Member "wscite/sql.properties" (11 Sep 2020, 12696 Bytes) of package /windows/misc/wscite445.zip:


As a special service "Fossies" has tried to format the requested text file into HTML format (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 # Define SciTE settings for SQL, PL/SQL, Apache Hive and Apache Pig files.
    2 
    3 file.patterns.sql=*.sql
    4 file.patterns.plsql=*.spec;*.body;*.sps;*.spb;*.sf;*.sp
    5 file.patterns.hql=*.hql
    6 file.patterns.pig=*.pig
    7 
    8 lexer.$(file.patterns.sql)=sql
    9 lexer.$(file.patterns.plsql)=sql
   10 lexer.$(file.patterns.hql)=sql
   11 lexer.$(file.patterns.pig)=sql
   12 
   13 file.patterns.sql.like=$(file.patterns.sql);$(file.patterns.plsql);$(file.patterns.hql);$(file.patterns.pig)
   14 
   15 *source.patterns.sql=$(file.patterns.sql.like);
   16 
   17 filter.sql=SQL (sql)|$(file.patterns.sql.like)|
   18 
   19 *filter.sql=$(filter.sql)
   20 
   21 *language.sql=S&QL|sql||
   22 
   23 #*language.plsql=P&LSQL|spec||
   24 #*language.hql=Hive SQL|hql||
   25 #*language.pig=Pig Query|pig||
   26 
   27 # SQL comments
   28 comment.block.sql=--
   29 #comment.block.at.line.start.sql=1
   30 comment.stream.start.sql=/*
   31 comment.stream.end.sql=*/
   32 comment.box.start.sql=/*
   33 comment.box.middle.sql= *
   34 comment.box.end.sql= */
   35 
   36 # SQL styles
   37 # White space
   38 style.sql.0=fore:#808080
   39 # Comment
   40 style.sql.1=fore:#007F00,$(font.comment)
   41 # Line Comment
   42 style.sql.2=fore:#007F00,$(font.comment)
   43 # Doc comment
   44 style.sql.3=fore:#7F7F7F
   45 # Number
   46 style.sql.4=fore:#007F7F
   47 # Keyword
   48 style.sql.5=fore:#00007F,bold
   49 # Double quoted string
   50 style.sql.6=fore:#7F007F,$(font.monospace)
   51 # Single quoted string
   52 style.sql.7=fore:#7F007F,$(font.monospace)
   53 # SQL*Plus
   54 style.sql.8=$(colour.preproc)
   55 # SQL*Plus PROMPT
   56 style.sql.9=fore:#007F00,$(font.monospace),back:#E0FFE0,eolfilled
   57 # Operators
   58 style.sql.10=bold
   59 # Identifiers
   60 style.sql.11=
   61 # Not used
   62 #style.sql.12=fore:#000000,$(font.monospace),back:#E0C0E0,eolfilled
   63 # SQL*Plus Comment
   64 style.sql.13=fore:#007F00,$(font.comment)
   65 # not used
   66 # style.sql.14=
   67 # Hash Line Comment
   68 style.sql.15=fore:#007F00,$(font.comment)
   69 # Keywords2: Database objects
   70 style.sql.16=fore:#B00040
   71 # Comment Doc Keyword
   72 style.sql.17=fore:#3060A0,$(font.code.comment.doc)
   73 # Comment Doc Keyword Error
   74 style.sql.18=fore:#804020,$(font.code.comment.doc)
   75 # Keywords5: User Keywords 1
   76 style.sql.19=fore:#4B0082
   77 # Keywords6: User Keywords 2
   78 style.sql.20=fore:#B00040
   79 # Keywords7: User Keywords 3
   80 style.sql.21=fore:#8B0000
   81 # Keywords8: User Keywords 4
   82 style.sql.22=fore:#800080
   83 # Quoted identifier
   84 style.sql.23=fore:#DD9900
   85 # Q operator
   86 style.sql.24=fore:#EE00AA
   87 
   88 # Braces are only matched in operator style
   89 braces.sql.style=10
   90 # Enables backslash as an escape character
   91 #sql.backslash.escapes=1
   92 
   93 # Activate '#' based comments for MySQL with 1 or disable for Oracle with 0:
   94 #lexer.sql.numbersign.comment=0
   95 
   96 # Set to 1 to colourise recognized words with dots
   97 # (recommended for Oracle PL/SQL objects)
   98 #lexer.sql.allow.dotted.word=1
   99 
  100 #lexer.sql.backticks.identifier=1
  101 
  102 keywords.$(file.patterns.sql)=\
  103 absolute action add admin after aggregate \
  104 alias all allocate alter and any are array as asc \
  105 assertion at authorization \
  106 before begin binary bit blob body boolean both breadth by \
  107 call cascade cascaded case cast catalog char character \
  108 check class clob close collate collation column commit \
  109 completion connect connection constraint constraints \
  110 constructor continue corresponding create cross cube current \
  111 current_date current_path current_role current_time current_timestamp \
  112 current_user cursor cycle \
  113 data date datetime day deallocate dec decimal declare default \
  114 deferrable deferred delete depth deref desc describe descriptor \
  115 destroy destructor deterministic dictionary diagnostics disconnect \
  116 distinct domain double drop dynamic \
  117 each else end end-exec equals escape every except \
  118 exception exec execute exists exit external \
  119 false fetch first float for foreign found from free full \
  120 function \
  121 general get global go goto grant group grouping \
  122 having host hour \
  123 identity if ignore immediate in indicator initialize initially \
  124 inner inout input insert int integer intersect interval \
  125 into is isolation iterate \
  126 join \
  127 key \
  128 language large last lateral leading left less level like \
  129 limit local localtime localtimestamp locator \
  130 map match merge minute modifies modify module month \
  131 names national natural nchar nclob new next no none \
  132 not null numeric \
  133 object of off old on only open operation option \
  134 or order ordinality out outer output \
  135 package pad parameter parameters partial path postfix precision prefix \
  136 preorder prepare preserve primary \
  137 prior privileges procedure public \
  138 read reads real recursive ref references referencing relative \
  139 restrict result return returns revoke right \
  140 role rollback rollup routine row rows \
  141 savepoint schema scroll scope search second section select \
  142 sequence session session_user set sets size smallint some| space \
  143 specific specifictype sql sqlexception sqlstate sqlwarning start \
  144 state statement static structure system_user \
  145 table temporary terminate than then time timestamp \
  146 timezone_hour timezone_minute to trailing transaction translation \
  147 treat trigger true \
  148 under union unique unknown \
  149 unnest update usage user using \
  150 value values varchar variable varying view \
  151 when whenever where with without work write \
  152 year \
  153 zone
  154 
  155 keywords.$(file.patterns.plsql)=\
  156 all alter and any array as asc at authid avg begin between \
  157 binary_integer \
  158 body boolean bulk by char char_base check close cluster collect \
  159 comment commit compress connect constant create current currval \
  160 cursor date day declare decimal default delete desc distinct \
  161 do drop else elsif end exception exclusive execute exists exit \
  162 extends false fetch float for forall from function goto group \
  163 having heap hour if immediate in index indicator insert integer \
  164 interface intersect interval into is isolation java level like \
  165 limited lock long loop max min minus minute mlslabel mod mode \
  166 month natural naturaln new nextval nocopy not nowait null number \
  167 number_base ocirowid of on opaque open operator option or order \
  168 organization others out package partition pctfree pls_integer \
  169 positive positiven pragma prior private procedure public raise \
  170 range raw real record ref release return reverse rollback row \
  171 rowid rownum rowtype savepoint second select separate set share \
  172 smallint space sql sqlcode sqlerrm start stddev subtype successful \
  173 sum synonym sysdate table then time timestamp to trigger true \
  174 type uid union unique update use user validate values varchar \
  175 varchar2 variance view when whenever where while with work write \
  176 year zone
  177 
  178 # Keywords for PlDoc comments
  179 keywords3.$(file.patterns.sql)=\
  180 param author since return see deprecated todo
  181 
  182 # Keywords for SQL*Plus
  183 keywords4.$(file.patterns.sql)=\
  184 acc~ept a~ppend archive log attribute \
  185 bre~ak bti~tle \
  186 c~hange cl~ear col~umn comp~ute conn~ect copy \
  187 def~ine del desc~ribe disc~onnect \
  188 e~dit exec~ute exit \
  189 get \
  190 help ho~st \
  191 i~nput \
  192 l~ist \
  193 passw~ord pau~se pri~nt pro~mpt \
  194 quit \
  195 recover rem~ark repf~ooter reph~eader r~un \
  196 sav~e set sho~w shutdown spo~ol sta~rt startup store \
  197 timi~ng tti~tle \
  198 undef~ine \
  199 var~iable \
  200 whenever oserror whenever sqlerror \
  201 
  202 # User keywords 1
  203 # Keywords for Standard packages
  204 keywords5.$(file.patterns.sql)=\
  205 dbms_output.disable dbms_output.enable dbms_output.get_line \
  206 dbms_output.get_lines dbms_output.new_line dbms_output.put \
  207 dbms_output.put_line \
  208 
  209 
  210 # Reserved Keywords for Apache Hive SQL
  211 keywords.$(file.patterns.hql)=\
  212 all alter and as authorization between both by \
  213 case cast column conf create cross cube current \
  214 cursor database delete describe distinct \
  215 drop else end exchange exists extended external fetch following \
  216 for from full function grant group grouping having if import in inner insert \
  217 intersect interval into is join lateral left less like local macro map \
  218 more not of on or order out outer over partialscan partition percent \
  219 preceding preserve procedure range reads reduce revoke right rollup row rows \
  220 select set table tablesample then to transform trigger \
  221 truncate unbounded union uniquejoin update user using values \
  222 when where window with commit only regexp rlike rollback start \
  223 cache constraint foreign primary references \
  224 extract floor precision views \
  225 sync
  226 
  227 # User keywords 2
  228 # Reserved Keywords for Apache Hive SQL
  229 keywords6.$(file.patterns.hql)=\
  230 add admin after analyze archive asc before bucket buckets cascade change \
  231 cluster clustered clusterstatus collection columns comment compact compactions \
  232 compute concatenate continue data databases dbproperties deferred \
  233 defined delimited dependency desc directories directory disable distribute \
  234 elem_type enable escaped exclusive explain export fields file fileformat first \
  235 format formatted functions hold_ddltime idxproperties ignore index \
  236 indexes inpath inputdriver inputformat items jar keys key_type limit lines \
  237 load location lock locks logical mapjoin materialized metadata minus \
  238 msck noscan no_drop offline option outputdriver outputformat \
  239 overwrite owner partitioned partitions plus pretty principals protection purge \
  240 read readonly rebuild recordreader recordwriter regexp reload rename repair \
  241 replace replication restrict rewrite rlike role roles schema schemas \
  242 semi serde serdeproperties server sets shared show show_database skewed sort \
  243 sorted ssl statistics stored streamtable tables tblproperties \
  244 temporary terminated touch transactions unarchive undo uniontype \
  245 unlock unset uri use utc value_type view while \
  246 autocommit isolation level offset snapshot transaction work write \
  247 abort key last norely novalidate nulls rely validate \
  248 detail expression operator quarter summary vectorization \
  249 zone
  250 
  251 # User keywords 3
  252 # Column/Field Types for Apache Hive SQL
  253 keywords7.$(file.patterns.hql)=\
  254 array bigint boolean char date decimal double float int smallint timestamp \
  255 utc_tmestamp varchar integer time numeric \
  256 datetime long string struct tinyint timestamptz unsigned utctimestamp
  257 
  258 # Functions for Apache Hive SQL
  259 keywords4.$(file.patterns.hql)=\
  260 round floor ceil rand exp ln log10 log2 log pow sqrt bin hex unhex conv abs \
  261 pmod sin asin cos acos tan atan degrees radians positive negative sign e pi \
  262 size map_keys map_values array_contains sort_array \
  263 binary cast \
  264 from_unixtime unix_timestamp to_date datediff date_add date_sub \
  265 from_utc_timestamp to_utc_timestamp \
  266 day hour minute second month year weekofyear \
  267 if case coalesce nullif \
  268 ascii concat concat_ws context_ngrams find_in_set format_number \
  269 get_json_object in_file instr length locate lower lpad ltrim ngrams parse_url \
  270 printf regexp_extract regexp_replace repeat reverse rpad rtrim sentences \
  271 space split str_to_map substr substring translate trim upper \
  272 hash
  273 
  274 # User keywords 4
  275 # Constants Types for Apache Hive SQL
  276 keywords8.$(file.patterns.hql)=\
  277 current_timestamp false none null true dayofweek \
  278 dow week years months weeks days hours minutes seconds \
  279 orc csv parquet rc
  280 
  281 # User keywords 1
  282 # Reserved Keywords for Apache PIG
  283 keywords.$(file.patterns.pig)=\
  284 and any all arrange as asc by cache case \
  285 %declare %default dense desc else end eval flatten full generate if \
  286 inner input in into is left matches not onschema or outer output \
  287 parallel partition returns right rollup ship stderr stdin stdout then \
  288 through using when
  289 
  290 # User keywords 2
  291 # Operators for Apache PIG
  292 keywords6.$(file.patterns.pig)=\
  293 assert cogroup cross cube define distinct filter foreach group  import join \
  294 limit load native order rank sample split set store stream union register
  295 
  296 # User keywords 3
  297 # Column/Field/Storage Types for Apache PIG
  298 keywords7.$(file.patterns.pig)=\
  299 int long float double chararray bytearray boolean datetime biginteger bigdecimal \
  300 tuple bag map \
  301 pigstorage pigdump jsonloader jsonstorage avrostorage orcstorage textloader \
  302 hbasestorage trevnistorage accumulostorage
  303 
  304 # User keywords 4
  305 # Constants Types for Apache PIG
  306 keywords8.$(file.patterns.pig)=\
  307 true false null void
  308 
  309 # Functions for Apache PIG
  310 keywords4.$(file.patterns.pig)=\
  311 avg bagtostring bagtotuple bloom buildbloom concat count count_star diff \
  312 isempty max min plucktuple size subtract sum tokenize \
  313 abs acos asin atan cbrt ceil cos cosh exp floor log log10 random round \
  314 round_to sin sinh sqrt tan tanh \
  315 endswith equalsignorecase indexof last_index_of lcfirst lower ltrim \
  316 regex_extract regex_extract_all regex_search replace rtrim sprintf startswith \
  317 strsplit strsplittobag substring trim ucfirst upper \
  318 uniqueid addduration currenttime daysbetween getday gethour getmillisecond \
  319 getminute getmonth getsecond getweek getweekyear getyear hoursbetween \
  320 millisecondsbetween minutesbetween monthsbetween secondsbetween \
  321 subtractduration todate tomilliseconds tostring tounixtime weeksbetween \
  322 yearsbetween \
  323 totuple tobag tomap top
  324 
  325 # User keywords 1
  326 # Commands for Apache PIG
  327 keywords5.$(file.patterns.pig)=\
  328 cat cd cp du ls mkdir mv pwd rm rmf \
  329 copyfromlocal copytolocal pig \
  330 fs sh clear exec help history kill quit run \
  331 describe dump explain illustrate
  332