skip to navigation
skip to content

Not Logged In

TecUtils 0.4.0

Various utilities for database and config files use. Text to Pdf converter

========
tecutils
========

tecutils provides various utilities to accelerate development
of programs design to use MySQL as a database and substitute
the use of global variables.
Also includes a standalone module to tranform a text file to pdf.

tecutils contains the following modules:

- mydb
- envvar
- simplecrypt
- txt2pdf

mydb
====

Requires:
    mysql-python (sudo apt-get install python-mysqldb)

Provides:
    There are three functions that take care the database interaction:

    - GetRecordset(sHost,sUser,sPwd,sDB,sSQL)
    - GetData(sHost,sUser,sPwd,sDB,sSQL)
    - ExecuteSQL(sHost,sUser,sPwd,sDB,sSQL)::

    from tecutils.mydb import ExecuteSQL, GetData, GetRecordset

    myHost = "localhost"
    myUser = "root"
    myPwd = "password"
    myDB = "test"

    ExecuteSQL(myHost, myUser, myPwd, myDB, "INSERT INTO animal (name, category) VALUES " + \
      ('snake', 'reptile'), ('frog', 'amphibian'), ('tuna', 'fish'), ('racoon', 'mammal'),
      ('lizard', 'reptile')")

    sql="SELECT name FROM animal WHERE category='reptile'"
    GetRecordset(myHost, myUser, myPwd, myDB,sql)

    thistype='fish'
    sql="SELECT name FROM animal WHERE category='%s'" % thistype
    GetData(myHost, myUser, myPwd, myDB,sql)


envvar
======

Provides:
    Reads a file containing <var>=<value> and loads in a container, so you can use container.var

    getVarFromFile(filename,container)

Use::

    from tecutils import getVarFromFile
    db = getVarFromFile('config/db.cfg','db')



Examples
--------

If use the two modules provides a way to use a configuration file to access de database::


    # this is the config file:
    # db.cfg
    HOST = 'localhost'
    USER = 'root'
    PWD = 'password'
    DB = 'test'


and use it in a program::

    from tecutils.envvar import getVarFromFile
    from tecutils.mydb import GetRecordset

    getVarFromFile('db.cfg',db)

    data = GetRecordset(db.HOST,db.USER,db.PWD,db.DB,"SELECT * FROM animal")
    for animal in data:
        print animal[0]


simplecrypt
===========

Many thanks to the Dabo team: Ed Leafe and Paul McNett (http://dabodev.com)
for this simple utility to "obscure" passwords so casual browsing on the database
connection info doesn't show the real one.

Use::

    from tecutils.simplecrypt import simplecrypt
    pwd = 'foobar'
    crypt = SimpleCrypt()
    pwd = crypt.encrypt(pwd)


or using the example from envvars::

    crypt = SimpleCrypt()
    db.PWD = crypt.decrypt(db.PWD)


txt2pdf
=======

requires reportlab and pyPDF for normal use
for windows printing requires win32api or ghostscript and ghostview

Usage: txt2pdf.py [options] text_file
The name of the outfile is the name on the text_file with pdf extension.

Options:
  -h, --help            show this help message and exit
  -c COPIES, --copies=COPIES
                        number of copies, only valid with -p option
  -g                    print through ghostprint, only valid with -w option
  -m                    use half letter as size of output, default letter
  --output=OUTPUT       use specific output file name
  -p, --print           print file after converting
  --printer=PRINTER     printer to send file, default: send to default printer
  -w                    use win32api to send file to print, only valid with -p
                        option
 
File Type Py Version Uploaded on Size
TecUtils-0.4.0.linux-i686.tar.gz (md5)
built for Linux-2.6.38-8-generic-i686-with-glibc2.4
"dumb" binary any 2012-08-16 10KB
TecUtils-0.4.0.tar.gz (md5) Source 2012-08-16 7KB
  • Downloads (All Versions):
  • 21 downloads in the last day
  • 128 downloads in the last week
  • 418 downloads in the last month