Confused about modules

[MooseMiester]

Hi
I'm new to Python but old to programming. Using Python 2.5 on Windoze.

Trying to turn my program into a re-usable component and having all kinds of problems.

I have a class that represents a MySql database connection. In the constructor for the class it connects to the database, which creates an instance of a variable called DB.

Another class in the module needs DB access, so it gets passed the DB variable in the constructor.

Well this works with the code in the same file, but when this code gets moved into a module, the compiler seems to "forget" the method table for DB between calls. In other words when it runs it says "instance X has no attribute Y" -- put it all in the same file and it runs just fine.

WTF? When I open the database in the main file, and pass the connection to other modules it works just fine. Its as if the method table for an object instanced in a module other than main has some different kind of scoping rule.

Any ideas?

[bartonc]

I have posted my implementations of your exact goal in the Articles Section.

The proper thing to do is pass the instance of your class that has the DB within it.
Given that instance variable, any module may then call any of the methods of that class without the need to import the module itself.

Have a look at the articles and then we can have a class/module primer here.

Thanks for joining.

[MooseMiester]

Thanks got it all figured out. My confusion stemmed from Python's subtle syntax!!