problem with writing a simple module

nephish at xit.net nephish at xit.net
Mon May 22 09:47:53 EDT 2006


ello there. i am having a problem getting a module to work right.

i wrote a class that is going to be used in a few different scripts in
the same directory.

it looks like this:

#!/usr/bin/python

import MySQLdb

class DbConnector(object):
	"""
	Database Connection object.
	class receives the db argument to specify the database.
	"""

	def __init__(self, db='test_db', host="10.10.10.16",user="me",
passwd="mypass"):
		self.host   =   host
		self.user   =   user
		self.passwd =   passwd
		self.db = db
		# Unpack Other Database Arguments Here
		self.CreateConnection()

	def createConnection(self):
		self.connection = MySQLdb.connect(self.host, self.user, self.passwd,
self.db)

	def killConnection(self):
		self.connection.close()

	def getMany(self, sql_statement):
		cursor = self.connection.cursor()
		try:
			cursor.execute(sql_statement)
			result = cursor.fetchall()
			self.connection.close()
			return result
		except:
			self.connection.close()

the file is saved as DbConnector.py and made executable.
then i get this in idle

>> import DbConnector
>> x = DbConnector()

then it tells me that the module object is not callable.

this works though
>> import DbConnector
>> x = DbConnector
>> x.db = 'other_db'
>> results = x.getOne("SELECT * FROM `stuff`")

it tells me that the module has no attribute getOne.

i am really not trying for an attribute, but a method.

anyone know what i am doing wrong?

thanks




More information about the Python-list mailing list