Programming Forums > Script Programming > Python

Sane · Nov 21st, 2007, 5:52 PM

I have a project of .cgi scripts. This is a quick outline of how the files are being mapped together:

index.py

    import header
        <Display some header HTML>

    import mysqllib
        <Connect to MySQL and assign the instance to a local variable>

    <Display some information via variable mysqllib.db>
    
    import footer
        import mysqllib
            <Connect to MySQL and assign the instance to a local variable>

        <Display some information via variable mysqllib.db>

The problem should be apparent: both the main page and the footer connects to MySQL. How can I save time and use the same connection to MySQL?

I don't want to connect twice. And I don't want to remap any of the files, because this way makes most sense for how things need to be pieced together.

I have tried:

(Toggle Plain Text)

Set a global variable in index.py using globals()
"import footer"
    In footer.py, access the global variable using globals()
    The global variable does not exist

Therefore the global scope does not get passed into a file that is imported.

Your solution?

Jimbo · Nov 21st, 2007, 6:24 PM

Is there a way you could have index.py (or an equivalent outermost structure) keep track of the connection and the inner items could query the outer structure for a connection? I haven't used Python much at all, so I don't know if or how that would work out...

Dameon · Nov 21st, 2007, 6:50 PM

pconnect ('persistent' connect).

Specifics depend on whatever library you happen to be using.

Sane · Nov 21st, 2007, 7:22 PM

Quote:

Originally Posted by Jimbo

Is there a way you could have index.py (or an equivalent outermost structure) keep track of the connection and the inner items could query the outer structure for a connection? I haven't used Python much at all, so I don't know if or how that would work out...

That's exactly what I'm trying to figure out. Haha. The problem is an inner scope can't see the calling file's global scope.

Quote:

Originally Posted by Dameon

pconnect ('persistent' connect).

Specifics depend on whatever library you happen to be using.

There is no pconnect in the Python MySQL library, and even if there were, I want to avoid even trying to connect a second time. I don't even want to have to include my mysqllib.py wrapper and the MySQLdb module twice.

Sane · Nov 23rd, 2007, 12:42 PM

Too bad Arevos hasn't been posting lately. I know he'd know the way in a second flat.

Nov 21st, 2007, 5:52 PM	#1
Sane Programming Guru Join Date: Apr 2005 Location: Waterloo, Ontario Posts: 1,886 Rep Power: 5	Avoid Connecting To MySQL Multiple Times I have a project of .cgi scripts. This is a quick outline of how the files are being mapped together: (Toggle Plain Text) index.py import header <Display some header HTML> import mysqllib <Connect to MySQL and assign the instance to a local variable> <Display some information via variable mysqllib.db> import footer import mysqllib <Connect to MySQL and assign the instance to a local variable> <Display some information via variable mysqllib.db> index.py import header <Display some header HTML> import mysqllib <Connect to MySQL and assign the instance to a local variable> <Display some information via variable mysqllib.db> import footer import mysqllib <Connect to MySQL and assign the instance to a local variable> <Display some information via variable mysqllib.db> The problem should be apparent: both the main page and the footer connects to MySQL. How can I save time and use the same connection to MySQL? I don't want to connect twice. And I don't want to remap any of the files, because this way makes most sense for how things need to be pieced together. I have tried: (Toggle Plain Text) Set a global variable in index.py using globals() "import footer" In footer.py, access the global variable using globals() The global variable does not exist Set a global variable in index.py using globals() "import footer" In footer.py, access the global variable using globals() The global variable does not exist Therefore the global scope does not get passed into a file that is imported. Your solution?

Nov 21st, 2007, 6:24 PM	#2
Jimbo Battle Programmer Join Date: Feb 2006 Location: Bellevue, WA, USA Posts: 763 Rep Power: 3	Re: Avoid Connecting To MySQL Multiple Times Is there a way you could have index.py (or an equivalent outermost structure) keep track of the connection and the inner items could query the outer structure for a connection? I haven't used Python much at all, so I don't know if or how that would work out... __________________ <insert disclaimer here> <insert shameless plug for Visual Studio here>

Nov 21st, 2007, 6:50 PM	#3
Dameon Troll Join Date: Apr 2005 Location: Texas Posts: 732 Rep Power: 4	Re: Avoid Connecting To MySQL Multiple Times pconnect ('persistent' connect). Specifics depend on whatever library you happen to be using. __________________ MD5(sig) = bcef75433db02e9ad9bf81d6f7c5c270

Nov 23rd, 2007, 12:42 PM	#5
Sane Programming Guru Join Date: Apr 2005 Location: Waterloo, Ontario Posts: 1,886 Rep Power: 5	Re: Avoid Connecting To MySQL Multiple Times Too bad Arevos hasn't been posting lately. I know he'd know the way in a second flat.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Connecting MySQL and PHP	titaniumdecoy	PHP	10	Feb 25th, 2008 7:47 PM
MySQl simple problem	paulchwd	Other Web Development Languages	7	Feb 27th, 2007 10:31 AM
Connecting to MySQL through VB6	wrestlenovi	Visual Basic	3	May 25th, 2006 8:06 PM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 4:08 AM

Programming Forums > Script Programming > Python

Avoid Connecting To MySQL Multiple Times