github.com/apache/beam/sdks/v2@v2.48.2/java/extensions/sql/jdbc/src/main/resources/sqlline/SqlLine.properties (about)

     1  #    Licensed to the Apache Software Foundation (ASF) under one or more
     2  #    contributor license agreements.  See the NOTICE file distributed with
     3  #    this work for additional information regarding copyright ownership.
     4  #    The ASF licenses this file to You under the Apache License, Version 2.0
     5  #    (the "License"); you may not use this file except in compliance with
     6  #    the License.  You may obtain a copy of the License at
     7  #
     8  #       http://www.apache.org/licenses/LICENSE-2.0
     9  #
    10  #    Unless required by applicable law or agreed to in writing, software
    11  #    distributed under the License is distributed on an "AS IS" BASIS,
    12  #    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    13  #    See the License for the specific language governing permissions and
    14  #    limitations under the License.
    15  
    16  ##########################################################################
    17  # Modified SqlLine.properties to hardcode Beam specializations
    18  #
    19  # TODO: Only store the modifications here, and wrap the ResourceBundle
    20  ##########################################################################
    21  
    22  # Printed when BeamSqlLine starts up
    23  app-introduction: Welcome to Beam SQL @beam.version@ (based on sqlline version {1})
    24  
    25  # Not generally applicable to Beam, but still available for power users or vendors:
    26  #
    27  #  -u <database url>               the JDBC URL to connect to\n \
    28  #  -n <username>                   the username to connect as\n \
    29  #  -p <password>                   the password to connect as\n \
    30  #  -d <driver class>               the driver class to use\n \
    31  #  -nn <nickname>                  nickname for the connection\n \
    32  #  --autoCommit=[true/false]       enable/disable automatic transaction commit\n \
    33  #  --isolation=LEVEL               set the transaction isolation level\n \
    34  cmd-usage: Usage: java -jar beam-sdks-java-extensions-sql-jdbc-@beam.version@.jar \n \
    35  \  Usage: java org.apache.beam.sdk.java.extensions.sql.jdbc.BeamSqlLine \n \
    36  \  -f <file>                       script file to execute (same as --run)\n \
    37  \  --color=[true/false]            control whether color is used for display\n \
    38  \  --showHeader=[true/false]       show column names in query results\n \
    39  \  --headerInterval=ROWS           the interval between which headers are displayed\n \
    40  \  --fastConnect=[true/false]      skip building table/column list for tab-completion\n \
    41  \  --verbose=[true/false]          show verbose error messages and debug info\n \
    42  \  --showTime=[true/false]         display execution time when verbose\n \
    43  \  --showWarnings=[true/false]     display connection warnings\n \
    44  \  --showNestedErrs=[true/false]   display nested errors\n \
    45  \  --numberFormat=[pattern]        format numbers using DecimalFormat pattern\n \
    46  \  --force=[true/false]            continue running script even after errors\n \
    47  \  --maxWidth=MAXWIDTH             the maximum width of the terminal\n \
    48  \  --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns\n \
    49  \  --silent=[true/false]           be more silent\n \
    50  \  --autosave=[true/false]         automatically save preferences\n \
    51  \  --outputformat=[table/vertical/csv/tsv]   format mode for result display\n \
    52  \  --run=/path/to/file             run one script and then exit
    53  \  --help                          display this message
    54  
    55  # Similar to command line, hiding help for irrelevant things,
    56  # some of which already do not work (like !set propertiesFile)
    57  #
    58  # \nautoCommit      true/false Enable/disable automatic\
    59  # \n                transaction commit\
    60  # \nisolation       LEVEL      Set transaction isolation level\
    61  # \npropertiesFile  path       File from which SqlLine reads\
    62  #                              properties on startup; default is\
    63  #                              $HOME/.sqlline/sqlline.properties\
    64  #                              (UNIX, Linux, Mac OS),\
    65  #                              $HOME/sqlline/sqlline.properties\
    66  #                              (Windows)\
    67  help-set: Set a sqlline variable\
    68  \n\
    69  \nVariable        Value      Description\
    70  \n=============== ========== ================================\
    71  \nautoSave        true/false Automatically save preferences\
    72  \ncolor           true/false Control whether color is used\
    73  \n                           for display\
    74  \nfastConnect     true/false Skip building table/column list\
    75  \n                           for tab-completion\
    76  \nforce           true/false Continue running script even\
    77  \n                           after errors\
    78  \nheaderInterval  integer    The interval between which\
    79  \n                           headers are displayed\
    80  \nhistoryFile     path       File in which to save command\
    81  \n                           history. Default is\
    82  \n                           $HOME/.sqlline/history (UNIX,\
    83  \n                           Linux, Mac OS),\
    84  \n                           $HOME/sqlline/history (Windows)\
    85  \nincremental     true/false Do not receive all rows from\
    86  \n                           server before printing the first\
    87  \n                           row. Uses fewer resources,\
    88  \n                           especially for long-running\
    89  \n                           queries, but column widths may\
    90  \n                           be incorrect.\
    91  \nmaxColumnWidth  integer    The maximum width to use when\
    92  \n                           displaying columns\
    93  \nmaxHeight       integer    The maximum height of the\
    94  \n                           terminal\
    95  \nmaxWidth        integer    The maximum width of the\
    96  \n                           terminal\
    97  \nnumberFormat    pattern    Format numbers using\
    98  \n                           DecimalFormat pattern\
    99  \noutputFormat    table/vertical/csv/tsv Format mode for\
   100  \n                           result display\
   101  \nrowLimit        integer    Maximum number of rows returned\
   102  \n                           from a query; zero means no\
   103  \n                           limit\
   104  \nshowElapsedTime true/false Display execution time when\
   105  \n                           verbose\
   106  \nshowHeader      true/false Show column names in query\
   107  \n                           results\
   108  \nshowNestedErrs  true/false Display nested errors\
   109  \nshowWarnings    true/false Display connection warnings\
   110  \nsilent          true/false Be more silent\
   111  \ntimeout         integer    Query timeout in seconds; less\
   112  \n                           than zero means no timeout\
   113  \ntrimScripts     true/false Remove trailing spaces from\
   114  \n                           lines read from script files\
   115  \nverbose         true/false Show verbose error messages and\
   116  \n                           debug info
   117  
   118  #### UNMODIFIED PROPERTIES BELOW HERE ####
   119  jline-version: The version of the required {0} library is too old. Version \
   120   "{1}" was found, but "{2}" is required.
   121  
   122  enter-for-more: [ Hit "enter" for more ("q" to exit) ]
   123  no-manual: Could not find manual resource.
   124  executing-command: Executing command: {0}
   125  unknown-command: Unknown command: {0}
   126  autocommit-needs-off: Operation requires that autocommit be turned off.
   127  no-current-connection: No current connection
   128  connection-is-closed: Connection is closed
   129  reconnecting: Reconnecting to "{0}"...
   130  connecting: Connecting to "{0}"...
   131  no-driver: No known driver to handle "{0}"
   132  setting-prop: Setting property: {0}
   133  saving-options: Saving preferences to: {0}
   134  loaded-options: Loaded preferences from: {0}
   135  
   136  jdbc-level: JDBC level
   137  compliant: Compliant
   138  jdbc-version: Version
   139  driver-class: Driver Class
   140  
   141  help-quit: Exits the program
   142  help-dropall: Drop all tables in the current database
   143  help-connect: Open a new connection to the database.
   144  help-manual: Display the SQLLine manual
   145  help-typeinfo: Display the type map for the current connection
   146  help-describe: Describe a table
   147  help-reconnect: Reconnect to the database
   148  help-metadata: Obtain metadata information
   149  help-dbinfo: Give metadata information about the database
   150  help-rehash: Fetch table and column names for command completion
   151  help-verbose: Set verbose mode on
   152  help-run: Run a script from the specified file
   153  help-list: List the current connections
   154  help-all: Execute the specified SQL against all the current connections
   155  help-go: Select the current connection
   156  help-script: Start saving a script to a file
   157  help-brief: Set verbose mode off
   158  help-close: Close the current connection to the database
   159  help-closeall: Close all current open connections
   160  help-isolation: Set the transaction isolation for this connection
   161  help-nativesql: Show the native SQL for the specified statement
   162  help-call: Execute a callable statement
   163  help-autocommit: Set autocommit mode on or off
   164  help-commit: Commit the current transaction (if autocommit is off)
   165  help-rollback: Roll back the current transaction (if autocommit is off)
   166  help-batch: Start or execute a batch of statements
   167  help-help: Print a summary of command usage
   168  help-save: Save the current variabes and aliases
   169  help-native: Show the database''s native SQL for a command
   170  help-alias: Create a new command alias
   171  help-unalias: Unset a command alias
   172  help-scan: Scan for installed JDBC drivers
   173  help-sql: Execute a SQL command
   174  help-history: Display the command history
   175  help-record: Record all output to the specified file
   176  help-indexes: List all the indexes for the specified table
   177  help-primarykeys: List all the primary keys for the specified table
   178  help-exportedkeys: List all the exported keys for the specified table
   179  help-importedkeys: List all the imported keys for the specified table
   180  help-procedures: List all the procedures
   181  help-tables: List all the tables in the database
   182  help-columns: List all the columns for the specified table
   183  help-properties: Connect to the database specified in the properties file(s)
   184  help-outputformat: Set the output format for displaying results (table,vertical,csv,tsv,xmlattrs,xmlelements)
   185  help-nickname: Create a friendly name for the connection (updates command prompt)
   186  
   187  jline-missing: SQLLine static class check reports the {0} class was not found. Please ensure JLine is on classpath.
   188  
   189  batch-start: Batching SQL statements. Run "batch" again to execute the batch.
   190  running-batch: Running batched SQL statements...
   191  
   192  arg-usage: Usage: {0} <{1}>
   193  
   194  scanning: Scanning {0}...
   195  no-such-method: No such method "{0}"
   196  possible-methods: Possible methods:
   197  
   198  closing: Closing: {0}
   199  already-closed: Connection is already closed.
   200  error-setting: Error setting configuration: {0}: {1}
   201  no-method: No method matching "{0}" was found in {1}.
   202  
   203  
   204  connected: Connected to: {0} (version {1})
   205  driver: Driver: {0} (version {1})
   206  autocommit-status: Autocommit status: {0}
   207  isolation-status: Transaction isolation: {0}
   208  unknown-format: Unknown output format "{0}". Possible values: {1}
   209  
   210  closed: closed
   211  open: open
   212  
   213  executing-con: Executing SQL against: {0}
   214  comments: Comments, bug reports, and patches go to {0}
   215  building-tables: Building list of tables and columns for tab-completion \
   216   (set fastconnect to true to skip)...
   217  done: Done
   218  state: state
   219  code: code
   220  
   221  invalid-connections: Invalid connection: {0}
   222  
   223  script-closed: Script closed. Enter "run {0}" to replay it.
   224  script-already-running: Script ({0}) is already running. Enter "script" with no arguments to stop it.
   225  script-started: Saving command script to "{0}". Enter "script" with no arguments to stop it.
   226  
   227  command-canceled: Command canceled.
   228  
   229  record-closed: Recording stopped.
   230  record-already-running: Output already being saved to ({0}). Enter "record" with no arguments to stop it.
   231  record-started: Saving all output to "{0}". Enter "record" with no arguments to stop it.
   232  
   233  autoloading-known-drivers: No known driver to handle "{0}". Searching for known drivers...
   234  
   235  Warning: Warning: {0} (state={1},code={2,number,#})
   236  Error: Error: {0} (state={1},code={2,number,#})
   237  
   238  commit-complete: Commit complete
   239  rollback-complete: Rollback complete
   240  
   241  halt-query: Canceling query
   242  
   243  abort-on-error: Aborting command set because "force" is false and \
   244   command failed: "{0}"
   245  
   246  multiple-matches: Ambiguous command: {0}
   247  
   248  really-drop-all: Really drop every table in the database? (y/n)\
   249  abort-drop-all: Aborting drop all tables.
   250  
   251  drivers-found-count: 0#No driver classes found|1#{0} driver class found|1<{0} driver classes found
   252  rows-selected: 0#No rows selected|1#{0} row selected|1<{0} rows selected
   253  rows-affected: 0#No rows affected|1#{0} row affected|1<{0} rows affected|0>Unknown rows affected
   254  active-connections: 0#No active connections|1#{0} active connection:|1<{0} active connections:
   255  
   256  time-ms: ({0,number,#.###} seconds)