skip to navigation
skip to content

TecUtils 0.4.0

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


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


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

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)

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


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



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


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


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


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


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)


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

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

-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
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):
  • 5 downloads in the last day
  • 65 downloads in the last week
  • 346 downloads in the last month