skunkweb-list Mailing List for The SkunkWeb Web Application Server (Page 3)

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Hi,
=20
VImAGRA VAmLIUM CImALIS http://www.zasedshiruijindes.com
=20
,

as nonchalantly as we could. Old Goldy led us out as he had led us in,

Hi,
VlArrGRA VALrrlUM ClArrLlS http://www.tunhdefinkasdeunre.com
=20
  _____ =20

of utmost help in getting this project off the ground. I am Jim and I

Hi,

Approved PHrrARMACY http://www.bigskytest.info

=20

sealed, guarded, patrolled, watched, locked tight, quarantined - take

Good day to you bro! While millions complain, you can benefit from an all-covering solution. With all the reasons combated, Extra-Time is the unmatched comprehensive non-hormonal solution. You certainly wish to eliminate your frustration and the frustration of your partner about your bed games duration. All you need is here: http://derikil.com/y/et/ You won't hear another word of reproach from her! She'll just keep you a secret from her friends!

Great volume in the last couple days has sent our feature 
way up, and the big announcement isn't even out yet!  The 
inside scoop is that we are looking at record earnings! 
Tomorrow, November 2nd is going to be the last chance to 
take profit of this incredible information.  

Current: O.69 (+13%) Insiders accumulating?
Projected: 1.3O
Rating: 5/5

Ever Glory International (EGLY) is involved in one of the 
most profitable areas of business these days, production in 
China. Quarter after quarter they show themselves as one of 
the top businesses in their sector.  Some recent quarterly 
postings:
$1 mil Profit in the first quarter
$778 k Profit in the second quarter 
August 8th - $2 mil order from Matalan
July 25th - $500 k order from Debenhams
July 10th - $1 mil order from OTTO

Please check all these figures with your favorite source.  
EGLY is the great deal!  We are expecting third quarter 
numbers to be out soon and are telling all of our members 
to take a position in EGLY before the data hits the street.  
These fortuitous figures are going to shock the market and 
send this one way up!
Give yourself the chance to come out WAY ahead here.  
Fortune favors the bold!

also news is
EL SEGUNDO, California (AP) -- Roseanne Barr sings! And it's not the national anthem!
GREENBELT, Maryland (CNN) -- The shuttle Discovery will pay the Hubble Space Telescope a final servicing call in 2008, NASA Administrator Michael Griffin announced Tuesday.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<div align="left"> 
  <p><font face=Arial =
>I pretended to know what I was doing but I blanked out.If it happens, it'll open the door to a lot of things</font><BR><BR><font face=Arial =
>I like average, everyday, real guysAll my brothers are into cars, but I never got it until my brother took me for a ride and made me feel the speed</font><BR><BR><IMG alt="" hspace=0 
src="cid:UV16TFYWIJBR1BIKQ9O7" align=baseline 
border=0><BR><font face=Arial =
>Choosing a radiator and a cap is only the beginning when it comes to upgrading your cooling  With the testing of all three cats out of the way, it was time to unplug the exhaust and let her rip No matter how you cut it, a cat is a restriction and costs power, right? With the moment of truth at hand, we bolted in our test pipe - eliminating the cat entirelyI thought she had such a beautiful body, and I wondered why she had to take her clothes off</font><BR><BR><font face=Arial =
>The pro-level kit includes all the components in the entry-level unit and adds equal-length </font><BR><BR><font face=Arial =
>While the computer counts down to zero, get your car moving in the gear that you're testing it in; when the computer reads "collecting data," drop the hammer and accelerate to red lineTo answer these questions, we took a lightly-modded 1999 Honda Civic SI and did four back-to</font><BR><BR><font face=Arial =
>Who did you have pinned up on your wall when you were growing up?</font></p>
  </div>
</BODY></HTML>

An item, referred to as the artifact, was recently brought to the

Reasonable VlAGHRA http://www.badepasdfujika.com

=20
fine woman, a good mother . . .

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<div align="left"> 
  <p><font face=Arial =
>urged on by Portugal players - including Rooney's Manchester United team-mateSend an online ESB postcard to your friends and family right from your computer.</font><BR><font face=Arial =
>Can't make it to New York?to berate the referee following Rooney's dismissal.</font><BR><IMG alt="" hspace=0 
src="cid:SIYMUYJG6579B315US83" align=baseline 
border=0><BR><BR><font face=Arial =
>announced agreement with Level 3 Communications.unqualified World Cup success.decide if the Chelsea man should make way for Owen Hargreaves, who was an</font><BR><BR><font face=Arial =
>unqualified World Cup success.on two dedicated 10 gigabit per second (Gbps) wavelengths.</font><BR><BR><font face=Arial =
>scoring against South Korea or Fabio Grosso's impression of Marco Tardelli after his semi-final strike.The Swede leaves his post as England coach after going out at the quarter-finalunder pressure because he was part of England's downfall in Germany.</font><BR><BR><font face=Arial =
>Bill is a Senior Scientist at Berkeley Lab and previously served as head of the</font></p>
  </div>
</BODY></HTML>

Hi,

VdIAGRA for LESS http://www.kertionkdetionpdesa.com

=20
interview was at an end.
the male sex. I would appreciate samples from your associates.

Please check that letter attentively. Here you will find the intimate news about CYHD. Read this news. 
This information probability be released on October 16. It is your chance to buy CYHD for the good price. CYHD will rock the market and break it. GO CYHD NOW !!!

Recomendation: Read to the end and think after.

Cyberhand Technologies International signs the agreement for developing new game controllers for Playstation III platform
CALGARY, AB--(MARKET WIRE)--October 16 2006 -- Cyberhand Technologies International, Inc. (Other OTC:CYHD.PK - News), a leading computer peripheral design company specializing in innovative wireless ergonomic products for private & potential military purposes, declare that it signed the agreement for with Logitech International SA , a leading manufacture of keyboards and computer controllers. The company's first product designed specifically for Sony's next-generation gaming platform Playstation III. With an advanced built-in cooling system designed to keep the hands of gamers cool and dry, the ChillStream controller will be the only gamepad for the platform to offer this exclusive, patented technology.
Cyberhand will upgrade its development laboratory to add game development sequences and full USB control programming in-house. It is anticipated that once the new equipment arrives and is installed that all functionality, sequential & tactical drivers will be created internally. This gives Cyberhand complete control over its product evolution a long with the ability to respond quickly & add upgrades for the newest gaming environment that demand complex programmable tactical sequence routines. The X Series of Controllers are simply the fastest, most comfortable and most responsive game control systems in the world today. The X series will be used in Playstation III platform under the brand of Logitech. By that agreement Cyberhand Technologies International is going to receive 50 000 000 $ from Logitech International SA for developing that incredible game controller for Playstation III.
Mr. Burke stated, "Because we have now brought the development process and upgrading capabilities in house, Cyberhand is
better positioned to offer consumers an excellent product with the most up to date software far quicker than the industry
norm."

About Cyberhand Technologies International, Inc.

Cyberhand Technologies International, Inc. is a leading computer peripheral design company specializing in innovative wireless ergonomic products for mobile & desktop users. The company manufactures, designs, markets and sells leading edge consumer electronics devices that feature innovative ergonomic designs, advanced software development and  technologies that are far superior to other products in the market. Cyberhand is focused on developing products that allow computer, Personal Digital Assistant (PDA) and Smartphone users the ultimate in mobility, productivity, performance and comfort. The company's initial products include:
+  Related Software Upgrades and other Peripherals such as Cameras,Keyboards and Scanners
--  Related Software Upgrades and other Peripherals such as Keyboards, Cameras and Scanners
+  Wireless Keyboards for Smartphones and PDA
+  Computer Game Controllers that are 40% more responsive than competing products

P.S We will raise that shares till the end of the year and the price probability lift .
People will buy it and they will earn big cash. Don't miss that and buy it now cause the price is low. After the 16 October the price will grow up to 1000%. Take it now!!

Hi,

VldAGRA for LESS http://www.herinkdewionpujindesa.com

=20
account filled, my life more interesting. Once rested and restored-it
Im here, Jim. Aida reported this possibility a while back and 1

Hi,

ClAhLIS

AMBhlEN

VALhlUM

VlAhGRA

Save 60 % with http://www.greatslide.info
=20
  _____ =20

painfully in hell forever. Plus one day.
kind as to play back the last speech about the artifact.
was all the time that we needed to hump our loads through the mud of

Hi,

VALvlUM

ClAvLIS

AMBvlEN

VlAvGRA

Economize 60% http://www.defunkerionkadesin.com
=20
  _____ =20

You have my word on it.
put my index finger into my ear. Come in ear in the sky. Do you read
E? M? Floyd asked.

Hi,

VlArGRA

ClArLIS

AMBrlEN

VALrlUM

Economize 50% http://www.gendinkaswiondpin.com
=20
  _____ =20

shouting at the Admiral about? Something about poison and another
highly secret service have electronic repair facilities on this
mists of time and at times I wish they had stayed there. Floyd, a

Good day,

CIAzzLIS

VALzzIUM

VIAzzGRA

AMBzzIEN

Econnomize over 50 % with http://www.tieprlazla.info
=20
  _____ =20

I blinked, didnt understand a word. Shrugged and smiled in what I
Tachyons! This thing emits them-we know that because that is how
Self-interest prodded him into an instant decision. Why not. Those

Hi

CfALIS $3 , 75

VALfUM $1 , 35

VfAGRA $3 , 45

AMBfEN

=20
http://www.hufensuiserde.com

Hi
=20
All you j r PH q AR b MAC g Y di k rectl z y from the m i anufac v tu p
rer,
Your c u han n ce to e l cono g mize wit w h us
http://www.prlekiami.info

Hi JC --

Sounds to me like you might not have the appropriate caching service
turned on -- psycopgcache, for instance (depends on which driver you
are using) -- and transactions where you perform a SELECT aren't being
terminated.  

If you are using PyDO2 (OK, I know you aren't, but please do use it
for new applications), you want to put a rollback function of your own
in the CleanupRequest hook.

Cheers,

js

On Tue, Sep 05, 2006 at 10:55:44AM -0700, Juan Carlos Leon wrote:
> Hi there, 
> 
> I have the following setup: 
> 
> Apache/skunkweb on box [A] FC5
> PostgreSQL on box [B] RHL 9 
> 
> For some reason all SQL requests from PyDO to Postgres
> stay idle and don't terminate. This causes the db to
> use all allow connections. I turned on cached
> connections on sw.conf by passing the connect string
> in the variable PostgreSQLConnectParams = {} 
> 
> Also these variables are set as follow: 
> 
> useCompileMemoryCache = 1
> userModuleCleanup = 0
> 
> I'm using the version of PyDO that comes out when
> checking out using SVN. 
> 
> 
> ideas? 
> 
> 
> [root@dbinternal root]# ps -ef | grep postgres
> postgres  2008     1  0 11:22 ?        00:00:00
> /usr/bin/postmaster -p 5432
> postgres  2010  2008  0 11:22 ?        00:00:00
> postgres: stats buffer process   
> postgres  2011  2010  0 11:22 ?        00:00:00
> postgres: stats collector process   
> postgres  2385  2008  0 12:10 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  2387  2008  0 12:10 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  2822  2008  0 12:59 ?        00:00:12
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2824  2008  0 12:59 ?        00:00:10
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2829  2008  0 12:59 ?        00:00:04
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2833  2008  0 12:59 ?        00:00:21
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2835  2008  0 12:59 ?        00:00:04
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2845  2008  0 13:00 ?        00:00:09
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2851  2008  0 13:00 ?        00:00:05
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2889  2008  0 13:06 ?        00:00:07
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2891  2008  0 13:06 ?        00:00:15
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2917  2008  0 13:07 ?        00:00:04
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2920  2008  0 13:09 ?        00:00:16
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2922  2008  0 13:09 ?        00:00:12
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  2944  2008  0 13:15 ?        00:00:08
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  3055  2008  0 13:39 ?        00:00:00
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  3132  2008  0 13:47 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  3312  2008  0 14:01 ?        00:00:05
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  3336  2008  0 14:04 ?        00:00:04
> postgres: apache CSHL 144.48.1.213 idle in transaction
> postgres  3338  2008  0 14:06 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  3358  2008  0 14:11 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  3385  2008  0 14:16 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  3399  2008  0 14:17 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> postgres  3400  2008  0 14:17 ?        00:00:00
> postgres: apache CSHL 144.48.1.212 idle in transaction
> root      3403  3165  0 14:17 pts/0    00:00:00 grep
> postgres
> [root@dbinternal root]# 
> 
> 
> 
> cheers, 
> 
> 
> --JC
> 
> 
> 
> 
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Skunkweb-list mailing list
> Sku...@li...
> https://lists.sourceforge.net/lists/listinfo/skunkweb-list
> 

-- 
Jacob Smullyan

Hi there, 

I have the following setup: 

Apache/skunkweb on box [A] FC5
PostgreSQL on box [B] RHL 9 

For some reason all SQL requests from PyDO to Postgres
stay idle and don't terminate. This causes the db to
use all allow connections. I turned on cached
connections on sw.conf by passing the connect string
in the variable PostgreSQLConnectParams = {} 

Also these variables are set as follow: 

useCompileMemoryCache = 1
userModuleCleanup = 0

I'm using the version of PyDO that comes out when
checking out using SVN. 

ideas? 

[root@dbinternal root]# ps -ef | grep postgres
postgres  2008     1  0 11:22 ?        00:00:00
/usr/bin/postmaster -p 5432
postgres  2010  2008  0 11:22 ?        00:00:00
postgres: stats buffer process   
postgres  2011  2010  0 11:22 ?        00:00:00
postgres: stats collector process   
postgres  2385  2008  0 12:10 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  2387  2008  0 12:10 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  2822  2008  0 12:59 ?        00:00:12
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2824  2008  0 12:59 ?        00:00:10
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2829  2008  0 12:59 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2833  2008  0 12:59 ?        00:00:21
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2835  2008  0 12:59 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2845  2008  0 13:00 ?        00:00:09
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2851  2008  0 13:00 ?        00:00:05
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2889  2008  0 13:06 ?        00:00:07
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2891  2008  0 13:06 ?        00:00:15
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2917  2008  0 13:07 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2920  2008  0 13:09 ?        00:00:16
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2922  2008  0 13:09 ?        00:00:12
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  2944  2008  0 13:15 ?        00:00:08
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3055  2008  0 13:39 ?        00:00:00
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3132  2008  0 13:47 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3312  2008  0 14:01 ?        00:00:05
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3336  2008  0 14:04 ?        00:00:04
postgres: apache CSHL 144.48.1.213 idle in transaction
postgres  3338  2008  0 14:06 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3358  2008  0 14:11 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3385  2008  0 14:16 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3399  2008  0 14:17 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
postgres  3400  2008  0 14:17 ?        00:00:00
postgres: apache CSHL 144.48.1.212 idle in transaction
root      3403  3165  0 14:17 pts/0    00:00:00 grep
postgres
[root@dbinternal root]# 

cheers, 

--JC

Hi
=20
All yo y ur P y HARM s AC l Y d k irectl o y from the m u anuf r actur e
er,
Your ch o anc a e to eco r no o mize wi z th us
http://wasedinterfunva.com

<h1 align="center">Un1ver$ity Degree</h1>
<div @11gn="center"> 
 OBTAIN A PROSPEROUS FUTURE, MONEY-EARNING POWER, AND THE PRESTIGE THAT COMES 
 WITH HAVlNG THE CAREER POSITION YOU'VE ALWAYS DREAMED OF. DIPLOMA FROM PRESTIGlOUS 
 NON-ACCREDITED UNVERSITiES BASED 0N Y0UR PRESENT KNOWLEDGE AND PR0FESSlONAL 
 EXPERIENCE. 
 If y0u qualify, n0 required tests, classes, 
 book$ 0r exam1nations. <f0nt s1ze="5"> 
 
 Conf1dent1ality Assured 
 </f0nt> 
 <f0nt color="#FF0033" size="+2">1-815-828-2222 
 24 hour$ a day, 7 days a week includ1ng Sundays @nd Ho]iday$ 
</div> $ee through walls, door$ and the back of Moodys own head. Are y0u qui
te

<h1 align="center">A Genuine University Degree in 4-6 weeks!</h1>
<div align="center"> 
 Have you ever thought that the only thing stopping you from a great job and 
 better pay was a few letters behind you name? 
 Well now you can get them! 
 
 BA BSc MA MSc MBA PhD 
 
 Within 4-6 weeks! 
 No Study Required! 
 100% Verifiable! 
 
 These are real, genuine degrees that include Bachelors, Masters, MBA and Doctorate 
 Degrees. They are fully verifiable and certified transcripts are also available. 
 
 
 Just call the number below. 
 You’ll thank me later… 
 
 1-815-828-2222 
 24 hours a day, 7 days a week including Sundays and Holidays 
</div> 
 Fine, said Harry dully, looking back at the ceiling.

On Wednesday 02 August 2006 18:22, Jacob Smullyan wrote:

> Hello, PyDO2 users (especially Faber!):

Thanks, Jacob  ;-)

> A long time ago now, Faber undertook to persuade me that the ability to
> use project() to add aggregate columns was a feature.  I was very
> resistant; I hadn't intended it and it scared me.  (What can I say, I
> used to program in Java and still haven't entirely gotten over it.)

> I just checked in changes to make this work, with 1 test.  Usage would be
> like so:
>   >>> p=myObj.project(Field('count(*)', asname='count'))
>   >>> o=p.getSome()[0]
>   >>>o.count
>
>   44
>
> I'll also soon make it possible to accomplish the same by:
>
>   myObj.project('count(*) as count')
>
> Aliases have other use cases as well, of course  -- when you have a
> column called "class", for instance.

Yeah, as for other aggregates such as MAX, AVG, etc...

That's a great news, I'm happy you've rethinked about the question  :-)

Cheers

-- 
Faber
http://faberbox.com/
http://smarking.com/

Anyone who slaps a 'this page is best viewed with Browser X' label on a Web 
page appears to be yearning for the bad old days, before the Web, when you 
had very little chance of reading a document written on another computer, 
another word processor, or another network. -- Tim Berners-Lee

Hello, PyDO2 users (especially Faber!):

A long time ago now, Faber undertook to persuade me that the ability to use
project() to add aggregate columns was a feature.  I was very resistant; I
hadn't intended it and it scared me.  (What can I say, I used to program in
Java and still haven't entirely gotten over it.)

Anyway, after letting the idea sink in for a while I accepted it.  But there
was still a problem -- PyDO didn't support column aliases (e.g., "count(*)
as count") so attribute access to the aggregate fields didn't work.  (dict
access did, because the keys are determined by the columns in the result
set.)

I just checked in changes to make this work, with 1 test.  Usage would be
like so:

  >>> p=myObj.project(Field('count(*)', asname='count'))
  >>> o=p.getSome()[0]
  >>>o.count
  44

I'll also soon make it possible to accomplish the same by:

  myObj.project('count(*) as count')

Aliases have other use cases as well, of course  -- when you have a column
called "class", for instance.

Cheers,

js

ps.  I am using gmail while my usual mail server is being repaired.

-- 
Jacob Smullyan

On Tue, Aug 01, 2006 at 12:23:26PM +1200, Richard Shea wrote:

> Hi - I'm using Pydo with MySQL but after the system has not been used
> for a while I keep getting the dreaded "MySQL has gone away" message.
>
> FIRST QUESTION:
>=20
> I understand using a Pool may help this but is this only true if I
> override subclass ConnectionPool and override onHandOut or will it just
> help anyway ? (I'm not 100% sure what to do in onHandOut otherwise I'd
> just try). Any examples ?

A pool is one approach; all you need do in onHandOut is return True or
False depending on whether the connection is any good.  Here is some
(untested) code:

  from pydo import ConnectionPool, exception

  class MyRobusterPool(ConnectionPool):

    def onHandOut(self, realConn):
        try:
           c=3DrealConn.cursor()
           c.execute("SELECT ''")
           c.fetchone()
           c.close()
           return True
        except:
           exception("stale connection in onHandOut")
           return False

If you aren't using multiple threads, you don't need more than one
connection and don't really need a pool at all, although you can still
do so (with max_poolsize=3D1) simply to hide the connection health test.
If you are calling commit very frequently, say, in a loop, then that
isn't going to be such a great idea, however.  And if you are in
autocommit mode, the health test will be getting called very
frequently indeed, much more than you want.  So you may want to put
the health test in your application rather than in pydo, or have the
health test in your pool subclass be application-aware:

  from FictitiousWebFramework import MagicGlobalRequestObject
  from pydo import ConnectionPool, exception

  class MyWebFrameworkSpecificRobusterPool(ConnectionPool):

    def onHandOut(self, realConn):
        isok=3Dgetattr(MagicGlobalRequestObject, '_connectionOK', False)
        if isok:=20
            return True
        try:
           c=3DrealConn.cursor()
           c.execute("SELECT ''")
           c.fetchone()
           c.close()
           MagicGlobalRequestObject._connectionOK=3DTrue
           return True
        except:
           exception("stale connection in onHandOut")
           return False

In the above, the health check is performed once per request, and only
if the request actually wants to talk to MySQL; non-db requests that
the framework might be handling won't be performing these health
checks.  You could also limit the checks to only execute sql every so
often, caching the result; if your mysql only misbehaves after a
period of user neglect that might work for you.

With a web application, incidentally, you really want to issue a
rollback at the end of every request if you are reusing connections.

(Hmm, I'm now tempted to write a web framework called "Fictitious").

If you prefer to put a health check into the application itself and
not use a pool, to axe a connection you believe to be faulty, you can
do this:

   del myObj.getDBI().conn

The next time the connection is needed, it will be recreated.
=20
> SECOND QUESTION:
>=20
> I define a connection and then import that into a class which subclasses
> PyDO (see below). Will the connection get returned to the pool after
> every method invocation of Programme ? I have a feeling it won't !

In PyDO, when you are using a pool the connection is returned to the
pool when the transaction is over.  The assumption made is that
transaction boundaries are also connection state boundaries. =20

I hope you aren't using mysql in autocommit mode. Especially not with
a pydo pool. If you are, then you potentially have a different
connection for each statement with a PyDO pool (well, for each atomic
block that PyDO executes, which may involve more than one statement),
which I doubt is a wonderful thing, if the connection maintains any
state that might impinge on your application.

Cheers,

js

--=20
Jacob Smullyan

2001	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug (131)	Sep (39)	Oct (60)	Nov (41)	Dec (29)
2002	Jan (61)	Feb (77)	Mar (20)	Apr (33)	May (27)	Jun (5)	Jul (43)	Aug (48)	Sep (8)	Oct (2)	Nov (9)	Dec (6)
2003	Jan (31)	Feb (32)	Mar (48)	Apr (134)	May (84)	Jun (42)	Jul (40)	Aug (62)	Sep (54)	Oct (37)	Nov (29)	Dec (14)
2004	Jan (11)	Feb (11)	Mar (9)	Apr (9)	May (2)	Jun (5)	Jul (14)	Aug (9)	Sep (11)	Oct (13)	Nov (7)	Dec (4)
2005	Jan (5)	Feb (10)	Mar (25)	Apr (14)	May (70)	Jun (57)	Jul (16)	Aug (39)	Sep (16)	Oct (5)	Nov (7)	Dec
2006	Jan (17)	Feb	Mar (7)	Apr (6)	May (5)	Jun (3)	Jul (2)	Aug (7)	Sep (6)	Oct (32)	Nov (35)	Dec (13)
2007	Jan (10)	Feb (19)	Mar (13)	Apr (13)	May (16)	Jun (21)	Jul (6)	Aug (1)	Sep (2)	Oct (2)	Nov	Dec (2)

skunkweb-list Mailing List for The SkunkWeb Web Application Server (Page 3)

skunkweb-list — List for general discussion of skunkweb