[Twisted-Python] db connections

[Pet]

On Tue, Mar 24, 2009 at 2:45 PM, Alvin Delagon <adelagon at gmail.com> wrote:
> Put self.dbcon in the MyFactory class. MyProtocol instances can access it
> via self.factory.

Thanks for your help! Could you give me an example? I'm getting an error

MyProtocol instance has no attribute 'factory'

if I do as you suggested.



>
>
> On Tue, Mar 24, 2009 at 6:10 PM, Pet <petshmidt at googlemail.com> wrote:
>>
>> Hi,
>>
>> I've wrote an daemon which does some queries to db and sends response
>> back to client. Do I need to make for every request from client (new
>> instance of  MyProtocol) a new connection to DB? Or can I somehow
>> prepare connection, so I could save some time? Maybe make connection
>> in Factory and pass it to Protocol? But what happens if too much
>> clients are connected to server? What is the way to control it?
>>
>> Regards, Pet
>>
>>
>> class MyProtocol(basic.LineReceiver):
>>
>>    def __init__(self):
>>        print "new connection"
>>        self.dbcon = adbapi.ConnectionPool("pyPgSQL.PgSQL",
>> database="data", user='pet', host='local', password='some')
>>
>>
>> class MyFactory(protocol.ServerFactory):
>>    protocol = MyProtocol
>>
>> class MyService(internet.TCPServer):
>>    def __init__(self):
>>        internet.TCPServer.__init__(self,PORT,MyFactory())
>>
>> def main():
>>    reactor.listenTCP(PORT, MyFactory())
>>    reactor.run()
>>
>>
>> if __name__ == '__main__':
>>    main()
>>
>> _______________________________________________
>> Twisted-Python mailing list
>> Twisted-Python at twistedmatrix.com
>> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>
>
>
> --
> http://www.alvinatorsplayground.blogspot.com/
>
> _______________________________________________
> Twisted-Python mailing list
> Twisted-Python at twistedmatrix.com
> http://twistedmatrix.com/cgi-bin/mailman/listinfo/twisted-python
>
>