Popular recipes by Michal Niklas

Printing list of ODBC data sources with pyodbc module (Python)

2014-01-28T10:40:56-08:00

Python recipe 578815 by Michal Niklas (database, odbc, sql).

I have similar recipe but with odbc module: http://code.activestate.com/recipes/578782-printing-list-of-odbc-data-sources/

Printing list of ODBC data sources (Python)

2013-12-10T11:07:37-08:00

Python recipe 578782 by Michal Niklas (database, odbc, sql).

This simple code shows ODBC data sources. It uses odbc module.

Mazovia encoding for Polish text from MS-DOS era (Python)

2012-02-15T09:24:13-08:00

Python recipe 578040 by Michal Niklas (encoding, mazovia, polish).

Some MS-DOS era text or databases in Poland use Mazovia encoding for letters such as: ą, ę, ś, ż, ź. It is very well described on Polish wikipedia: http://pl.wikipedia.org/wiki/Mazovia_(kod)

There is mazovia.py with Polish encoding. Copy it to the Python Lib/encodings directory. Tested with Python 2.7. For Python 3.2 I had to remove unicode string u prefix.

Usage:

def conv_file(fname):
    f = codecs.open(fname, 'rb', 'mazovia')
    s = f.read()
    f.close()

    f = codecs.open(fname + '_utf8', 'wb', 'utf8')
    f.write(s)
    f.close()

Binary BCD clock using curses (Python)

2010-10-19T10:40:36-07:00

Python recipe 577430 by Michal Niklas (curses, time).

Converts actual time to vertical BCD digits. So actual time, 12:37:51 looks like:

......
...**.
.***..
*.****

Python program that show .class files from *.jar (Python)

2010-07-22T09:13:59-07:00

Python recipe 577328 by Michal Niklas (jar, java).

This program iterate through .jar files and print .class files from it

Redate source files using SVN info from $Id:$ (Python)

2010-07-30T10:00:25-07:00

Python recipe 577341 by Michal Niklas (date, datetime, file, files, svn).

Iterates through a directory, reading the data from svn info that looks like:

$Id: svn_redater.py 747 2010-07-30 09:56:08Z mn $

from source files.

Parses the datetime from svn info and if it differs from file modification datetime then changes file datetime

Calculate distance from .kmz files (Python)

2009-05-31T23:59:34-07:00

Python recipe 576782 by Michal Niklas (distance, geocoding, google_earth, kmz, points). Revision 2.

Calculates distance in kilometers from points saved in .kmz file. Such files can be created by Google Earth

Dump Oracle db schema to text (Python)

2014-02-21T09:18:55-08:00

Python recipe 576534 by Michal Niklas (database, oracle, schema). Revision 19.

Export Oracle schema to text. Usable to compare databases that should be the same

Oracle schema info: http://www.eveandersson.com/writing/data-model-reverse-engineering

With --separate-files can save table information as CREATE TABLE statements and all view/function art objects are in separate files (sometime it is easier to compare directories with files than compare two big files)

Dump Informix schema to text (Python)

2014-02-21T09:16:15-08:00

Python recipe 576621 by Michal Niklas (database, informix, schema). Revision 6.

I needed "normalized" dump of Informix database so I can easily compare two databases. I have similar tools for other databases:

PostgreSQL: http://code.activestate.com/recipes/576557/

Oracle: http://code.activestate.com/recipes/576534/

Dump PostgreSQL db schema to text (Python)

2014-02-21T09:17:23-08:00

Python recipe 576557 by Michal Niklas (database, postgres, postgresql, schema). Revision 7.

With PostgreSQL there is:

pg_dump --schema_only

but I wanted to compare my PostgreSQL and Oracle database schema dumped by: http://code.activestate.com/recipes/576534/

Sort sections and keys in .ini file (Python)

2008-12-19T05:46:05-08:00

Python recipe 576587 by Michal Niklas (config, file, ini, sort). Revision 3.

I use this program when I want to make .ini file more readable or compare two .ini files

Searching .dll and .exe files in PATH (Python)

2014-10-06T09:22:53-07:00

Python recipe 576522 by Michal Niklas (dll, exe, file, version, windows). Revision 7.

Returns the pathnames of the file (.exe or .dll) which would be loaded/executed in the current environment. It uses some dirs from configuration (SystemDir, WindowsDir) and dirs from PATH.

To obtain version info it uses code from: http://pywin32.hg.sourceforge.net/hgweb/pywin32/pywin32/file/tip/win32/Demos/getfilever.py

Example of usage:

    c:\tools\pyscripts\scripts>which_dll.py libpq.dll
    2008-06-09 02:58:26   167936 [b]    c:\postgresql\8.3\bin\libpq.dll ver:8.3.3.8160
    2008-03-17 01:47:50   167936 [b]    c:\tools\libpq.dll  ver:8.3.1.8075
    2008-03-17 01:47:50   167936 [b]    g:\public\libpq.dll ver:8.3.1.8075
        trying to load "libpq.dll" ...
        c:\postgresql\8.3\bin\libpq.dll loaded

JPG files redater by EXIF data (Python)

2014-12-11T10:07:39-08:00

Python recipe 550811 by Michal Niklas (date, exif, e_uae, files, jpeg, jpg, pil). Revision 6.

Iterates through a directory, reading the EXIF data from each jpg/jpeg file. Parses the date/time from EXIF data and:

if it differs from file modification date/time then changes file date/time
moves file to YYYY/YYYY_MM_DD directory