| 15 | |
| 16 | |
| 17 | def create_parser(): |
| 18 | args_parser = argparse.ArgumentParser( |
| 19 | prog=u'mssql-cli', |
| 20 | description=u'Microsoft SQL Server CLI. ' + |
| 21 | u'Version {}'.format(mssqlcli.__version__)) |
| 22 | |
| 23 | args_parser.add_argument( |
| 24 | u'-U', u'--username', |
| 25 | dest=u'username', |
| 26 | default=os.environ.get(MSSQL_CLI_USER, None), |
| 27 | metavar=u'', |
| 28 | help=u'Username to connect to the database') |
| 29 | |
| 30 | args_parser.add_argument( |
| 31 | u'-P', u'--password', |
| 32 | dest=u'password', |
| 33 | default=os.environ.get(MSSQL_CLI_PASSWORD, None), |
| 34 | metavar=u'', |
| 35 | help=u'If not supplied, defaults to value in environment variable MSSQL_CLI_PASSWORD.') |
| 36 | |
| 37 | args_parser.add_argument( |
| 38 | u'-d', u'--database', |
| 39 | dest=u'database', |
| 40 | default=os.environ.get(MSSQL_CLI_DATABASE, None), |
| 41 | metavar=u'', |
| 42 | help=u'database name to connect to.') |
| 43 | |
| 44 | args_parser.add_argument( |
| 45 | u'-S', u'--server', |
| 46 | dest=u'server', |
| 47 | default=os.environ.get(MSSQL_CLI_SERVER, u'localhost'), |
| 48 | metavar=u'', |
| 49 | help=u'SQL Server instance name or address.') |
| 50 | |
| 51 | args_parser.add_argument( |
| 52 | u'-E', u'--integrated', |
| 53 | dest=u'integrated_auth', |
| 54 | action=u'store_true', |
| 55 | default=False, |
| 56 | help=u'Use integrated authentication on windows.') |
| 57 | |
| 58 | args_parser.add_argument( |
| 59 | u'-v', u'--version', |
| 60 | dest=u'version', |
| 61 | action=u'store_true', |
| 62 | default=False, |
| 63 | help=u'Version of mssql-cli.') |
| 64 | |
| 65 | args_parser.add_argument( |
| 66 | u'--mssqlclirc', |
| 67 | dest=u'mssqlclirc_file', |
| 68 | default=os.environ.get(MSSQL_CLI_RC, config_location() + 'config'), |
| 69 | metavar=u'', |
| 70 | help=u'Location of mssqlclirc config file.') |
| 71 | |
| 72 | args_parser.add_argument( |
| 73 | u'--row-limit', |
| 74 | dest=u'row_limit', |