PastChangeLog

2007-03-18  fox

	* pysqlfunctions.py: working compare data second pass

2007-02-25  fox

	* pysqlqueries.py: order by name all search request.
	  add primaryKeys search request
	* pysqloraobjects.py: add getPrimaryKeys() and getNumberOfColumns()
	* pysqldb.py: add cursorSize parameter to execute()

2007-02-12  fox

	* pysqlfunctions.py, pysqlgraphics.py, pysqlhelpers.py,
	  pysqlshell.py: Refactoring time... Create pysqlhelper module to
	  put reused
	  code and refactorise some parts.
	  
	  First working release of data comparison (quite simple for the
	  moment)

2007-02-04  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlfunctions.py, pysqlshell.py: add a table compare function
	  (merged with schema compare syntax)
	* pysqlfunctions.py: raise exception if table is not found in a
	  comparison
	  fix i18n bug in desc
	* pysqlfunctions.py: add index desc,
	  separate compareTables and compare (for schema)
	  i18n all desc headers
	* pysqloraobjects.py, pysqlqueries.py: add index desc

2007-01-23  fox

	* pysqlfunctions.py: Colored schema diff to hint column changes

2007-01-21  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlfunctions.py, pysqlshell.py: enhance compare function
	  (separate diff and equal tables)
	* pysqlqueries.py: bugfix : don't show column twice when same
	  table if found in different schema

2007-01-17  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlfunctions.py, pysqlshell.py, pysqlupdate.py: add a schema
	  compare function
	* pysqlio.py: add null output

2007-01-06  fox

	* ChangeLog, ChangeLog.html: Changelog update

2007-01-02  fox

	* pysqlconf.py: add better default color for graphical parameters
	* ChangeLog, ChangeLog.html: Changelog update
	* pysql.py, pysqlcolor.py, pysqlconf.py, pysqldb.py,
	  pysqlexception.py, pysqlfunctions.py, pysqlgraphics.py,
	  pysqloraobjects.py, pysqlqueries.py, pysqlshell.py: huge grammar
	  cleanup by mister SDE !
	  "du" function enhancement

2006-12-26  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlgraphics.py: code factorisation

2006-12-25  fox

	* pysqlgraphics.py: resolve "auto" program before check if
	  installed (bugfix)
	* pysqlgraphics.py, pysqlqueries.py, pysqlshell.py: add "disk
	  usage" graphical function to display where your space is lost !
	* pysqlconf.py: graphviz prog can be "auto" to choose the better
	  one for each graphical function

2006-12-16  fox

	* .:

2006-12-13  fox

	* ChangeLog, ChangeLog.html: Changelog update
	  po/pysql.pot, pysqlshell.py: add analyse keyword (forget it !).
	  Doc update

2006-12-11  fox

	* TODO:
	* ChangeLog, ChangeLog.html: Changelog update
	* index.html:
	* pysqlshell.py: don't encode again LOB objects
	* pysqlshell.py: Don't read too much from LOB objects to avoid
	  pysql blow up
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlshell.py: preliminary support for LOB
	* pysqloraobjects.py: rework guessInfos() : cleanup and
	  interactive mode preparation
	* TODO, pysqldb.py, pysqlshell.py, pysqltest.sql: Implement PL/SQL
	  server output
	  (enable it with execute dbms_output.enable(1024) and print with
	  execute dbms_output.put_line('I love pysql'))

2006-12-09  fox

	  po/pysql.pot, pysqltest.sql, pysqlupdate.py: doc and translation
	  update
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlnet.py: telnet protocol negociation (still very alpha).

2006-12-08  fox

	* pysqlgraphics.py: add "off" option to graph_viewer to disable
	  viewer popup after image generation
	* pysqlgraphics.py: Image viewer is now open in background
	* pysqlupdate.py: Change pysqlupdate to use a Version class in
	  order to respect pysql release policy (major.minor.fix). Not
	  very usefull but was fun to code
	* pysqloraobjects.py: fix regression in getDDL
	* pysqlfunctions.py: fix bug in removeComment and add --+ hint type

2006-12-07  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlgraphics.py, pysqloraobjects.py, pysqlqueries.py,
	  pysqlshell.py: Change Oracle dictionary reading strategy : do
	  not use both user_* and all_* views. Use all_* only

2006-12-06  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlshell.py: Add start as an alias of script command.
	  If script file is not found with script/start, try with .sql
	  extension
	* pysqlshell.py: The / should recall statement only, not last
	  command
	* pysql.py: use new pysql@digitalfox.org address
	* pysqlshell.py: ed does no execute command immediatly anymore but
	  add it to history
	* pysql.py, pysqldb.py: Fix YA unicode bug

2006-12-05  fox

	* pysqlupdate.py: Cleanup installation files
	* pysql.py: Add -v (--version) to get current PySQL version
	* pysqlupdate.py: Add update function to be able to update PySQL
	  online ! (use pysql -h to see options)
	* pysql.py: Add update function to be able to update PySQL online
	  ! (use pysql -h to see options)
	* pysqlio.py: Add read method (needed by pysqlupdate)

2006-12-04  fox

	* pysql.py, pysqlgraphics.py: bugfix for dependancies and imageView

2006-12-03  fox

	* pysqlconf.py, pysqlgraphics.py: Call user prefered image viewer
	  when generating graph
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, po/fr/pysql.po, po/pysql.pot, pysqlexception.py,
	  pysqlshell.py: Code cleanup
	  More french translation

2006-12-02  fox

	* pysqlqueries.py, pysqlshell.py: add trace function to trace
	  waits and IOs of defined session
	* ChangeLog, ChangeLog.html: Changelog update

2006-12-01  fox

	* pysqlconf.py, pysqlgraphics.py, pysqlio.py, pysqlshell.py: Add
	  dependency object graph (graphviz powered)
	  Always flush IO when printing on screen
	* pysqlexception.py: Move ora Code at the begining of error message
	* pysqlqueries.py: add dependancies SQL
	* pysqlshell.py:
	* pysqlfunctions.py: don't strip Oracle with comments ;-)

2006-11-30  fox

	* ChangeLog, ChangeLog.html: Changelog update
	  po/pysql.pot, pysqltest.sql: Doc, translation and todo update
	  Add some more unit test

2006-11-29  fox

	* pysqlfunctions.py: remove useless column in top session
	* pysqlqueries.py, pysqlshell.py: add current statement and
	  explain plan for detailed stats on session

2006-11-28  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlnet.py: Use maxClient and listen port given in parameter
	  Better server closing (need some more work)
	* pysql.py, pysqlshell.py: Add command-line options for pysql
	* pysqlgraphics.py: escape stupid caracter in verb name before
	  applying regexp (fix crash for "pkgtree standard" because of
	  special operator ** definition)
	* pysqlconf.py, pysqlshell.py: add custom column separator.
	  Default is still space but | (pipe) could become new standard
	  (to be debate)
	* pysqlio.py, pysqlshell.py: use sys.stdout.write instead of print
	  in IO screen target
	  to avoid one extra space when printing zero length
	  strings.
	  Add explicit margin width in displayTab
	* pysql.py: init rc :D
	* pysqlshell.py: exit call bug fix when user type EOF (^D)

2006-11-27  fox

	* pysql.py, pysqlnet.py, pysqlshell.py: Don't exit from shell but
	  return rc to pysql main() (needed for pysqlnet)
	* pysqlshell.py: Complete also when object name is prefixed whith
	  schema or table
	* pysqlfunctions.py: Use correct type when adding desc result to
	  completeLists
	* pylintrc, pysqlgraphics.py, pysqlshell.py: Don't use multiple
	  link in pkgtree graph
	  Fix bug with a forgotten out(..) call in shell

2006-11-26  fox

	* pysqlgraphics.py, pysqlshell.py: enhance pkgtree function
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlfunctions.py, pysqlgraphics.py, pysqlqueries.py,
	  pysqlshell.py: Factorise sql comment stripping
	  Factorise help definition for search function
	  Add search method for procedure, function and package
	  Add graphical output for pkgtree method (still basic)
	  po/pysql.pot: Translation and doc update
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlnet.py, pysqlshell.py, pysqltest.sql: minor cleanup and
	  bugfix

2006-11-25  fox

	* index.html:
	* pysqlio.py, pysqlshell.py: pysq:IO everywhere. No more print or
	  sys.stdout
	* pysql.py, pysqlio.py: IO bug fix for number only output
	* pysql.py, pysqlconf.py, pysqlfunctions.py, pysqlqueries.py,
	  pysqlshell.py: Use temp dir for editing files
	  Little code cleanup

2006-11-24  fox

	* pysqldb.py: Handle error if Oracle env is not set
	* pysqlshell.py: call father contructor before connecting to
	  properly initialise stdout !
	* pysqlio.py: write does not append \n anymore but callable
	  interface does

2006-11-23  fox

	* pysqlshell.py: fix bug in transpose (bad line number)
	* pysqlnet.py: Pysql over the network ! This allow to create pysql
	  daemon that listen
	  to tcp for incoming telnet connexion to serve pysql shell.
	  No need to install Oracle client and python to use pysql !
	* pysql.py, pysqlconf.py, pysqlfunctions.py, pysqlgraphics.py,
	  pysqlio.py, pysqlshell.py: Full rewrite of IO backend to prepare
	  socket and file stdout
	  Add package call tree prototype (very very alpha)
	* pysqloraobjects.py: add getDDLAsList()

2006-11-20  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqltest.sql: add unit test for some pysql functions
	* po/fr/pysql.po, po/pysql.pot, pysqlfunctions.py,
	  pysqloraobjects.py, pysqlqueries.py, pysqlshell.py: add edit
	  function to edit last sql statement
	  add ddl function to get any object DDL code
	  i18n update

2006-11-19  fox

	* po/fr/pysql.po, po/pysql.pot: i18n update
	* pysqlshell.py: rework the decoding/encoding stuff in displayTab
	* pysqlfunctions.py: extract the editor part from the edit function
	* pysql.py: Add again exception handler at the top level to allow
	  user to see the evil
	  stackstrace before dying

2006-11-17  fox

	* pysql.py: Default to latin-1 if default system encoding is dumb
	* pysqlshell.py: much better encoding handling in displayTab

2006-11-16  fox

	* pysqlshell.py: history double encoding (bugfix)

2006-11-15  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlshell.py: update terminal title according to connection
	  state
	* LICENSE: Add GNU GPL v2 licence

2006-11-14  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlfunctions.py, pysqlqueries.py, pysqlshell.py: Search object
	  can now be filtered by owner (asked by Tristan)
	* pysqloraobjects.py, pysqlqueries.py: add getDDL
	  edit (read only) for package, package body and function
	* pysql.py, pysqlconf.py, pysqlshell.py: codec is now stored in
	  conf.
	  Harden unicode encoding
	* pysql.py, pysqloraobjects.py, pysqlshell.py: Support for
	  trigger, materialized views and doc fix
	* pysqlqueries.py: add trigger sql
	* pysqlfunctions.py: add trigger desc
	* pysqlconf.py: add circo and leffty graphviz program in conf
	* pysqlgraphics.py: Add progress info and check for graphviz
	  programs availability

2006-11-13  fox

	* pysqldb.py, pysqlfunctions.py, pysqlgraphics.py: some comment...
	* pysqloraobjects.py, pysqlqueries.py: add pl/sql procedure
	  editing (read-only for the moment)

2006-11-12  fox

	* pysqloraobjects.py: desc bugfix for sys objects
	* ChangeLog, ChangeLog.html: Changelog update
	  po/fr/pysql.po, po/pysql.pot: Translation and documentation
	  update
	* pysql.py, pysqldb.py, pysqlfunctions.py, pysqlgraphics.py,
	  pysqloraobjects.py, pysqlshell.py: Finish naming convention
	  update
	  Minor fix
	  Doc and comment update
	* pysqlconf.py: Add all graph_ parameters
	* pysqlshell.py: Add parameter to datamodel function
	* pysqlqueries.py: Move datamodel SQL request to pysqlqueries
	* pysqlgraphics.py: Add user conf for datamodel
	* pysqlException.py, pysqlFunctions.py, pysqlOraObjects.py,
	  pysqlQueries.py, pysqlTest.sql, pysqlexception.py,
	  pysqlfunctions.py, pysqloraobjects.py, pysqlqueries.py,
	  pysqltest.sql: New module naming convention (all lowercase)

2006-11-11  fox

	* ChangeLog, ChangeLog.html: Changelog update
	  po/pysql.pot, pysql.py, pysqlOraObjects.py, pysqlgraphics.py:
	  Doc and translation update
	* pysqlOraObjects.py: desc bugfix when owner if provided in name
	  (ie desc scott.emp)
	* pylintrc: Adopt new pysql convention (max 109 caracters per line)

2006-11-10  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py,
	  pysqldb.py, pysqlgraphics.py, pysqlshell.py: Add graphical desc
	  ! (powered by graphviz)
	  Add show version
	* pysqlshell.py: Add datamodel function (graphical desc using
	  graphviz)

2006-11-08  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysql.py, pysqlFunctions.py, pysqlOraObjects.py, pysqlshell.py:
	  code cleanup (reduce long line)
	* pysql.py, pysqlshell.py: Default to latin-1 if env. codec cannot
	  be found
	* ChangeLog, ChangeLog.html: Changelog update
	* pysql.py, pysqlException.py, pysqlFunctions.py, pysqlconf.py,
	  pysqldb.py, pysqlshell.py: Now pysql is full UTF-8 and ready for
	  internationilsation (huge update)
	  Use locale client encoding to diplay on screen
	* po/fr/pysql.po, po/pysql.pot: i18n update
	* pysqlFunctions.py, pysqlconf.py, pysqldb.py, pysqlshell.py: Use
	  explicit import (avoid *) when possible (code cleanup)
	  pysqlQueries.py, pysqldb.py: Documentation update and code
	  cleanup (again)
	* pysqlException.py, pysqlFunctions.py, pysqlOraObjects.py,
	  pysqlconf.py, pysqlshell.py: Code cleanup
	  Add comments
	* pylintrc: Add my pylintrc file to help developpers using pylint
	  with pysql

2006-11-07  fox

	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py,
	  pysqlconf.py: Tuesday bugfix ;-)
	* pysqlshell.py: i18n user messages
	* pysqlshell.py: csv command is now multiline (as explain)
	  float numbers are also numbers ;-)
	* pysqlFunctions.py: better privilege handling
	  unit management
	* pysqlOraObjects.py: much better privilege handling when
	  accessing to sys views in guessInfos
	* pysqlQueries.py: User dba_views for sys objects
	* pysqlconf.py: Add unit parameter to select unit (kb, Mb, Gb) to
	  display with desc function
	* locale/fr/LC_MESSAGES/pysql.mo:
	* i18.sh, po/fr/pysql.po, po/pysql.pot, pysql.py:
	* locale, locale/fr, locale/fr/LC_MESSAGES,
	  locale/fr/LC_MESSAGES/pysql.mo, po, po/fr:
	* pysqlException.py: Add action denied exception

2006-11-05  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py: Make edit functions more generic (not only
	  for views)
	* pysqlFunctions.py, pysqlOraObjects.py: object type cannot be
	  empty anymore. If no type is given, None is return
	* pysqlcolor.py: Don't use color for debuging with PyDev (it
	  breaks console)
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlTest.sql: Set echo to yes in test file.
	  Add basic pl/sql tests
	* pysqlconf.py, pysqlshell.py: Add "lib" function to allow user to
	  save and recall custom SQL statement

2006-11-04  fox

	* pysqlshell.py: echo parameter bugfix
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlTest.sql: Add a test script. Very usefull to check non
	  regression
	* pysqlshell.py: Rework completely SQL comment handling (thanks to
	  test script to check all strange cases !)
	  Do not use completion if pysql is used in a script (pipe)
	  Fix bug with multi line command if some keyword in SQL request
	  looks like pysql command at the begining of the line ("table"
	  for example)
	* pysqlconf.py: add echo parameter to echo command on prompt
	  (usefull for script debug)

2006-11-03  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlFunctions.py, pysqlshell.py: Add comment to detailed
	  session command
	  Do not update view after edit if SQL does not change
	  Honor EDITOR value for edit command
	  Complete with views for edit command
	* TODO, pysqlFunctions.py, pysqlOraObjects.py, pysqlconf.py,
	  pysqlshell.py: Add pylint hint
	  Use correct TODO tags
	  Minor typo bugfix
	* pysqlrc: Use empty config file
	* pysqlshell.py: explain plan can now be used with multiline
	  request
	* pysqlrc: add default config file to avoid warning at startup
	* pysqlOraObjects.py: indent bugfix
	* pysql.py, pysqlException.py, pysqlFunctions.py,
	  pysqlOraObjects.py, pysqlQueries.py, pysqlcolor.py,
	  pysqlconf.py, pysqldb.py, pysqlshell.py: Convert tabs to space
	  (hey, at least)
	* pysqldb.py: don't give explicit numRows parameter to fetch
	  (bugfix for AIX compatibility

2006-11-02  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlshell.py: Add history command
	  Fix stupid bug in bg command argument parsing
	* pysqlshell.py: Change command aliases implementation (use python
	  alias instead of new method)
	  Add some online help and aliases for help commands
	* pysqlFunctions.py: typo bugfix in desx
	* pysqlException.py: - add structured exception formating
	* TODO, pysqlException.py, pysqldb.py, pysqlshell.py: - Proper ORA
	  code handling in error sum up
	  - blank the prompt and toggle fetching flag in case of Oracle
	  disconnection
	  - catch Oracle error while fetching
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlOraObjects.py: minor bug fix
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py,
	  pysqlshell.py: Add command doc
	  Fix desc bug if same table if found in many schemas

2006-10-31  fox

	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py: Real
	  tablespace and datafile desc
	  Add table's comment

2006-10-29  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py: Cosmectic for desc
	* pysqlFunctions.py, pysqlOraObjects.py: Add tablespace name when
	  describing a datafile.
	  Correct getTablespace method of datafile class that was
	  returning a str instead of a Tablespace Object
	* pysqlFunctions.py, pysqlOraObjects.py: add list of datafiles
	  when describing a tablespace
	* TODO, pysqlOraObjects.py: Fix bug in desc (public synonym pb)
	  and simplify code
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqldb.py, pysqlshell.py: Handle properly backgound query
	  error message
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlException.py, pysqlFunctions.py, pysqlconf.py, pysqldb.py:
	  Change print error message to standard pysql Exceptions
	  Add correct constructor to NotImplemented exception
	  Use exceptions instead of boolean return for validate function
	  Use locale transaction for validate to avoid nasty side effect

2006-10-28  fox

	* pysqlException.py, pysqlFunctions.py, pysqlOraObjects.py,
	  pysqlshell.py: Convert print statement to exceptions.
	  Add a NotImplemented exception
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlshell.py: Uppercase
	  last try is now in guessInfos rather than in callers
	  Cosmetic fix for view editing
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py,
	  pysqldb.py, pysqlshell.py: - User description
	  - View editing
	  - fix tablespace free space computation
	  - show instance parameters (command show)

2006-10-27  fox

	* pysqlshell.py: show all parameters if get or set are given
	  without any parameters (MBA request !)
	* pysqlFunctions.py, pysqlQueries.py, pysqlshell.py: Add 'execute'
	  SQLPLus function and detailed sessions stat

2006-10-10  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py, pysqlshell.py: add lock function (SDE)
	* TODO, pysqlshell.py: Much better os shell interaction (win &
	  Unix) (SDE)

2006-10-04  fox

	* TODO, pysqlshell.py: as readline seems not to be correctly
	  initialised in pipe mode check history length to avoid negative
	  history browsing
	  honor multi line sql comment with /* and */
	  add comment keyword
	* pysqlshell.py: cancel current fetch if user begin a new
	  mutliline query (bugfix)
	* pysqlshell.py: add pl/sql bloc handling

2006-10-03  fox

	* TODO, pysqlOraObjects.py, pysqlQueries.py, pysqlshell.py: move
	  more sql to pysqlQueries
	* pysqlQueries.py, pysqlshell.py: add tablespace and datafile
	  search command
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py,
	  pysqldb.py: use bind queries !
	* TODO, pysqldb.py, pysqlshell.py: simplifiy thread status handling

2006-10-02  fox

	* TODO, pysqlFunctions.py: Don't lookup indexed columns for
	  views...
	* TODO, pysqlFunctions.py, pysqlOraObjects.py: upper case mess
	  division byb zero bugfix

2006-10-01  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlFunctions.py, pysqlOraObjects.py: try to clean
	  upper/lower case problem (not finished)
	* pysqlconf.py, pysqlshell.py: add shrink parameter to remove
	  column shrinking

2006-09-27  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlException.py, pysqlFunctions.py, pysqlshell.py: add
	  execute script function (@) and fix a bug in pysqlException
	  error code trapping
	* TODO, pysqlFunctions.py, pysqlOraObjects.py: Finish code moving
	  from pysqlFunctions to OraObjects

2006-09-26  fox

	* TODO, pysqlFunctions.py, pysqlOraObjects.py, pysqlshell.py:
	  better datafile detection in setFullName
	  don't use uppercase for objects name
	* TODO, pysqlFunctions.py, pysqlQueries.py: don't use upper for
	  data file names
	  don't divide by zero mister SDE !
	* pysqlOraObjects.py: try to guess if a dot in a name is for
	  owner.name or name.dbf...
	* pysqlshell.py: honor sql comment
	  don't display error if none occured !
	* TODO, pysqlException.py, pysqlshell.py: add error sum up
	* pysqlshell.py: exit gracefully when user hit ctrl-C at init when
	  prompting for passwd
	* TODO, pysqlFunctions.py, pysqlOraObjects.py: fix desc bug (when
	  schema name is explicitely given)

2006-09-21  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* index.html: add dev guys
	  pysqldb.py: major doc update and docstring bugfix
	* ChangeLog, ChangeLog.html: Changelog update
	* index.html, pysqlOraObjects.py, pysqlconf.py, pysqldb.py,
	  pysqlshell.py: Add configurable csv separator and minor bugfix
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py: Merge
	  from SDE to handle more Oracle objects
	* pysqlcolor.py: Use os.name to detect if we need color

2006-09-20  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlshell.py: Add time function to get query executation
	  duration
	* pysqlshell.py: quote item in csv output
	* pysqlshell.py: detect typing error in the first line
	* pysqldb.py, pysqlshell.py: factorise and clean code for query
	  paging
	* TODO, pysqldb.py, pysqlshell.py: add export to csv ;-)

2006-09-19  fox

	* pysqlcolor.py: No color for stupid windows
	* pysqlshell.py: shell escape (!) don't need ; (bugfix)

2006-09-18  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py, pysqlshell.py: add sequence desc and where
	  statement for count (SDE)
	* pysqlQueries.py: add sequence SQL (SDE)
	* pysqlOraObjects.py: add sequence object (SDE)
	  add where statement for getRowCount method (SDE)

2006-09-14  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysql.py, pysqldb.py, pysqlshell.py: add backgound query
	  option (need more test)

2006-09-13  fox

	* pysqlshell.py: Honor $ORACLE_SID env. variable if exist to log
	  on (thanks SDE)
	* pysqlshell.py: Keep ";" in history for sql request
	  Add interactive password input (Thanks mister SDE)
	* pysqlFunctions.py, pysqlOraObjects.py, pysqlQueries.py: move
	  directory to objects

2006-09-12  fox

	* pysqlFunctions.py, pysqlshell.py: Sort searched objects by owner
	  !
	* pysqlOraObjects.py: Use owner for synonym target
	  Add template for some objects and method
	* pysqlQueries.py: Add owner for all searchObject request
	  Add synonym targets requests
	* pysqlFunctions.py: move (or mark to be moved) functions to
	  pysqlOraObject
	* pysqlOraObjects.py: add OraTabular for objects like view,
	  table... and move the count method to it

2006-09-11  fox

	* TODO: update
	* pysqlFunctions.py: Use pysqlOraObjects
	  Remove code moved to pysqlOraObjects
	* pysqlOraObjects.py: Create basic classes to handle oracle
	  objects.
	  Move here some code from pysqlFunctions (getObjetType,
	  getSynonymTarget)
	* pysqlQueries.py: Use separate file for SQL queries
	* pysqlshell.py: Use dumb completion for windows as readline is
	  incomplete

2006-09-10  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py: cleanup
	* pysqlshell.py: smarter completion for sql request
	* pysqlFunctions.py, pysqlshell.py: code factorisation for all
	  oracle object search stuff
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py: add synonym resolver.
	* pysqlFunctions.py, pysqlshell.py: Merge stuff from Sebastien
	  Delcros :
	  - resultset header are now managed at functions level
	  - much better getObjectType functions
	  - add directory handling (search and desc)
	* TODO, pysqlshell.py: Add watch command to loop on a command.
	  Mostly broken because of mysterious ctrl-C bug

2006-09-06  fox

	* pysqlshell.py: no need of ; after EOF to exit ;-)
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlshell.py: add DROP, CREATE and ALTER handling
	  repeat last order if / is entered
	* pysqlshell.py: change prompt building method (use connection
	  info instead of parsing connect_string)
	  revert to B&W prompt because it makes bogus line editing if line
	  is too long
	  add multiline editing in automatic way (pysql commands do not
	  need ; but sql order do).
	  Handle smartly history for multiline sql orders
	* pysqldb.py: add method to get info from connection (username and
	  dsn). This is used to build the prompt

2006-09-04  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlFunctions.py, pysqlshell.py: add session function
	* pysqldb.py: use instance cursor for executeAll method
	* pysqlFunctions.py, pysqlshell.py: add transpose displaying
	  add comments for desc
	* pysqlconf.py: add transpose parameter

2006-09-03  fox

	* pysqlshell.py: colorise important words in explain plan
	* pysqlshell.py: colorise prompt
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO, pysqlcolor.py, pysqlconf.py, pysqlshell.py: simplify color
	  handling
	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py, pysqlshell.py: add shell (!) method and
	  explain plan method
	* pysqlcolor.py: use explicit \033 caracter
	  use sys.stdout.write low level function instead of print to
	  avoid nasty spaces added
	* pysqlshell.py: control-C break current line instead of exiting
	* pysqlcolor.py, pysqlconf.py, pysqlshell.py: Use bold for error
	  message
	  Colorise table header
	  Split cprint to allow access to startColor and endColor easily

2006-09-02  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlconf.py, pysqlshell.py: color color ! green for ok, red for
	  error, cyan for info
	* TODO: update
	* pysqlconf.py, pysqlshell.py: Start to colorize
	* pysqlcolor.py: hello new world in color, bye bye black and white
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO: update
	* pysqlshell.py: save history at exit
	* pysqlconf.py: save and load history do disk
	* pysqlFunctions.py: add sequence handling and correct index one
	  (change by Sebastien Delcros)
	* pysqlshell.py: add do_sequence method and correct some comments
	  (change by Sebastien Delcros)

2006-09-01  fox

	* pysqlshell.py: ctrl-D make exit
	  pretty showCompletion output
	* pysqlshell.py: fancy display of all parameters
	  add completion for get/set
	  generate on the fly completion list theme instead of static
	  definition
	* pysqlconf.py: bugfix : cast to int before verifying parameter
	  value
	  change getAll return format from dict to list
	* pysqlconf.py: handle completionLists in conf (instead of shell)
	  load/dump completion list to disk
	  change stupid variable names
	* pysqlshell.py: move completionLists to conf class
	  save completion cache to disk at exit
	* pysqlconf.py: simplify default parameter handling
	  real get all with default and user parameter
	* pysqlshell.py: use completionlistsize parameter instead of
	  hardcoded value
	* pysqlshell.py: squash bug of oracle connexion loose that prevent
	  exiting or reconnecting properly

2006-08-31  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlFunctions.py: split desc into modular functions
	  handle synonym desc
	  search for uppsercase object if desc fails

2006-08-30  fox

	* pysqlconf.py: add verify for widthMin
	* pysqlshell.py: refacor to use a more generic complete code. Use
	  separate completion list
	* pysqlconf.py: bugfix (conf writing, missing default value, don't
	  raise exception if using default value...)

2006-08-28  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* TODO: update
	* pysqlFunctions.py, pysqlshell.py: Enhance desc to display
	  indexed columns
	  Change header beahviour for __displayTab : header must be given
	  as a parameter
	* ChangeLog, ChangeLog.html: Changelog update
	* TODO: update

2006-08-27  fox

	* pysqlshell.py: Add "---" under titles when displaying results
	  Add next method to fetch n next lines
	  Add last method to display the n last lines of a result set
	* pysqldb.py: Use config and classe constant
	  Now, we can choose the number of lines to fetch

2006-08-25  fox

	* index.html: remove stupid trailing caracter

2006-08-24  fox

	* ChangeLog, ChangeLog.html: Changelog update
	* pysqlconf.py, pysqlshell.py: Add a separate config module & class
	  Handle config in file

2006-08-23  fox

	* index.html: add changelog entry
	* changelog.sh: add HTML version and automatic commit
	* ChangeLog, ChangeLog.html: Changelog update
	* ChangeLog, changelog.sh: add changelog & script to generate
	  changelog
	* pysqlshell.py: better algo for column shrinking

2006-08-22  fox

	* TODO: update
	* pysql.py: Add global exception trapping
	* pysqlshell.py: handle properly initial connection failure
	  shhrink column if resultset is too large
	* doc.sh: add dot graph generation
	* pysqlshell.py: add argCheck, connectionCheck and proper
	  disconnect management

2006-08-21  fox

	* pysqlshell.py: add commit/rollback
	  fix desc bug
	  handle correctly update/delete/insert
	* pysqldb.py: add rowcount, commit and rollback
	  execute return resultset for select and rowcount else
	* doc.sh: shell to generate doc
	* pysql.py, shell.py: Change shell module & class name
	* pysqlshell.py: change name
	* shell.py: adding pysql prefix to class and module name
	* index.html: add doc link
	* pysql.py, shell.py: doc update
	  (thanks epydoc)
	* TODO: update
	* shell.py: add connect/disconnect method
	  add completion for connect method with tnsnames.ora SID
	  use PsqylException, not DatabaseError
	  add count help
	  add option in displayTab not to add header
	* pysqldb.py: add some sanity check
	  use exception instead of print/exit
	  default to a short description with long description as an option
	* index.html: add PyReadLine link
	* pysql.py: remove arg checking and start "not connected" instead
	* pysqlException.py: Generic class to handle pysql errors
	  Only shell should be allow to catch this exception
	  All classes can (should) raise this exception

2006-08-20  fox

	* shell.py: Add table header and use tabular display for sql
	  request
	* pysqldb.py: Add getDescription method
	* TODO: update
	* pysqlFunctions.py: rename execute impact
	  add desc function
	* shell.py: add desc funtions
	  add autocompltetion for results of table, index and view command
	  add compltetion list handling
	  add fetching by parts
	* pysqldb.py: rename execute functions

2006-08-19  fox

	* TODO: update
	* pysqldb.py: fetching by parts
	* shell.py: begining of fetching by parts
	* TODO, pysql.py, pysqlFunctions.py, pysqldb.py, shell.py: Major
	  refactoring with splitting in different modules
	* TODO, pysql.py: Create __display method
	  Use a proper __init__ instead of using loop for that
	  Organise code by theme not by alpha
	* TODO, index.html, pysql.py: cosmetics and index.html adding
	* sqlnet.log:
	* ., TODO, pysql, pysql.py, sqlnet.log: Initial SVN entry