pymetrics(1) [debian man page]

PYMETRICS(1)							   User Commands						      PYMETRICS(1)

NAME

       pymetrics - Python source code metrics

SYNOPSIS

       pymetrics [options] files...

DESCRIPTION

       This manual page documents briefly the pymetrics command

       pymetrics  is  a  program that produces metrics for Python programs. Metrics include McCabe's Cyclomatic Complexity metric, LoC, %Comments,
       etc. Users can also define their own metrics using data from PyMetrics. PyMetrics optionally outputs to stdout, SQL command files  and  CSV
       files.

OPTIONS

       These  programs	follow	the  usual  GNU  command  line	syntax, with long options starting with two dashes (`-').  A summary of options is
       included below.

       -h, --help
	      show this help message and exit

       -s SQLFILENAME, --sql=SQLFILENAME
	      name of output SQL command file. (Default is metricData.sql)

       -t SQLTOKENTABLENAME, --tokentable=SQLTOKENTABLENAME
	      name of output SQL token table. (Default is metricTokens)

       -m SQLMETRICSTABLENAME, --metricstable=SQLMETRICSTABLENAME
	      name of output SQL metrics table. (Default is metricData)

       -c CSVFILENAME, --csv=CSVFILENAME
	      name of output CSV data file. (Default is metricData.csv)

       -f INFILELIST, --files=INFILELIST
	      File containing list of path names to modules for analysis.

       -i INCLUDEMETRICSSTR, --include=INCLUDEMETRICSSTR
	      list of metrics to include in run. This is a comma separated list of metric module names with no	whitespace.  Optionally,  you  can
	      specify  the  class name of the metric by following the module name with a colon (:) and the metric class name. (Default metrics are
	      'simple:SimpleMetric,mccabe:McCabeMetric,sloc:SLOC Metric'. Default metric class name for metric module 'wxYz' is 'WxYzMetric'  when
	      only module name given -- note capitalized metric class name.)

       -l LIBNAME, --library=LIBNAME
	      user-defined name applied to collection of modules (Default is '')

       -e, --exists
	      assume SQL tables exist and does not generate creation code. Using this option sets option -N. (Default is False)

       -N, --noold
	      create new command output files and tables after deleting old results, if any. Ignored if -e is set.  (Default is False)

       -B, --nobasic
	      suppress production of Basic metrics (Default is False)

       -S, --nosql
	      suppress production of output SQL command text file.  (Default is False)

       -C, --nocsv
	      suppress production of CSV output text file. (Default is False)

       -H, --noheadings
	      suppress heading line in csv file. (Default is False)

       -k, --kwcnt
	      generate keyword counts. (Default is False)

       -K, --nokwcnt
	      suppress keyword counts. (Default is True)

       -q, --quiet
	      suppress normal summary output to stdout. (Default is False)

       -z, --zero
	      display zero or empty values in output to stdout.  (Default is to suppress zero/empty output)

       -v, --verbose
	      Produce verbose output - more -v's produce more output. (Default is no verbose output to stdout)

       -d, --debug
	      Provide debug output, not usually generated - internal use only

AUTHOR

       pymetrics was written by Reg. Charney.

       This manual page was written by Andrew Pollock <apollock@debian.org>, for the Debian project (but may be used by others).

pymetrics 0.8.1 						  September 2009						      PYMETRICS(1)

MDBTools(1)															       MDBTools(1)

NAME

       mdb-sql - SQL interface to MDB Tools

SYNOPSIS

       mdb-sql [-HFp] [-d delimiter] [-i file] [-o file] [database]

DESCRIPTION

       mdb-sql is a utility program distributed with MDB Tools.

       mdb-sql allows querying of an MDB database using a limited SQL subset language.

OPTIONS

       -H     Supress header row.

       -F     Supress footer row.

       -p     Turn  off  pretty printing. By default results are printed in an ascii table format which looks nice but is not conducive to manipu-
	      lating the output with unix tools. This option prints output plainly in a tab separated format.

       -d     Specify an alternative column delimiter. If no delimiter is specified, columns will be delimited by a tab character if pretty print-
	      ing (-p) is turned off. If pretty printing is enabled this option is meaningless.

       -i     Specify an input file. This option allows an input file containing the SQL to be passed to mdb-sql.  See Notes.

       -o     Specify an output file. This option allows the name of an output file to be used instead of stdout.

COMMANDS

       mdb-sql in interactive mode takes some special commands.

       connect to <database>
	      If  no database was specified on the command line this command is necessary before any querys are issued. It also allows the switch-
	      ing of databases once in the tool.

       disconnect
	      Will disconnect from the current database.

       go     Each batch is sent to the parser using the 'go' command.

       reset A batch can be cleared using the 'reset' command.

       list tables
	      The list tables command will display a list of available tables in this database, similar to the mdb-tables utility on  the  command
	      line.

       describe table <table>
	      Will display the column information for the specified table.

       quit   Will exit the tool.

SQL LANGUAGE

       The  currently  implemented  SQL  subset is quite small, supporting only single table queries, no aggregates, and limited support for WHERE
       clauses. Here is a brief synopsis of the supported language.

       select:
	      SELECT [* | <column list>] FROM <table> WHERE <where clause>

       column list:
	      <column> [, <column list>]

       where clause:
	      <column> <operator> <literal> [AND <where clause>]

       operator:
	      =, =>, =<, <>, like, <, >

       literal:
	      integers, floating point numbers, or string literal in single quotes

NOTES

       When passing a file (-i) or piping output to mdb-sql the final 'go' is optional. This allow constructs like

       echo "Select * from Table1" | mdb-sql mydb.mdb

       to work correctly.

       The -i command can be passed the string 'stdin' to test entering text as if using a pipe.

ENVIRONMENT

       MDB_JET3_CHARSET
	      Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1).

       MDBICONV
	      Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv.

       MDBOPTS
	      semi-column separated list of options:

	      o  use_index

	      o  no_memo

	      o  debug_like

	      o  debug_write

	      o  debug_usage

	      o  debug_ole

	      o  debug_row

	      o  debug_props

	      o  debug_all is a shortcut for all debug_* options

HISTORY

       mdb-sql first appeared in MDB Tools 0.3.

SEE ALSO

       gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) mdb-tables(1)

AUTHORS

       The mdb-sql utility was written by Brian Bruns.

BUGS

       The supported SQL syntax is a very limited subset and deficient in several ways.

0.7								   13 July 2013 						       MDBTools(1)