🌐 Mailman 3 September 2006 - Python-list - python.org

pysqlite - simple problem
by rdrink Sept. 1, 2006

Sept. 1, 2006

I am just getting into pysqlite (with a fair amount of Python and MySQL experience behind me) and have coded a simple test case to try to get the hang of things... yet have run into a 'stock simple' problem... I can create a database 'test.db', add a table 'foo' (which BTW I repeatedly DROP on each run) with one INTGER column 'id', and can insert data into with: cur.execute("INSERT INTO foo (id) VALUES (200)") con.commit() (and fetch back out) all with no problem. But... If I try to expand this to: num = 200 cur.execute("INSERT INTO foo (id) VALUES (?)", num) I get the error... Traceback (most recent call last): File "/home/rdrink/Programming/Python/Inner_Square/sqlite_test.py", line 46, in ? cur.execute("INSERT INTO foo (id) VALUES (?)", num) File "/usr/lib/python2.4/site-packages/sqlite/main.py", line 255, in execute self.rs = self.con.db.execute(SQL % parms) TypeError: not all arguments converted during string formatting ... which obviously points to a 'typing' problem. ?? but where ?? >From all the docs I have read Python 'int' and sqlite INTEGER should pass back and forth seemlessly... And I have even tried to reduce things to simply: cur.execute("INSERT INTO foo (id) VALUES (?)", 200) but still raise the same error. So this has to be something stupidly simple... but for the life of me I can't see it. Advice, suggestions, pointers for the noob? rd

4 4

Re: HTTPS Login
by Gerold Penz Sept. 1, 2006

Sept. 1, 2006

Tom Grove schrieb: > I am trying to login to a secure website and I am having some difficulty > understanding the process. Hi Tom! This code should do what you want: http://www.python-forum.de/post-18148.html#18148 Regards, Gerold :-) -- ________________________________________________________________________ Gerold Penz - bcom - Programmierung gerold.penz(a)tirol.utanet.at | http://gerold.bcom.at | http://sw3.at Ehrliche, herzliche Begeisterung ist einer der wirksamsten Erfolgsfaktoren. Dale Carnegie

1 0

Tkinter listbox question
by vedran_dekovic＠yahoo.com Sept. 1, 2006

Sept. 1, 2006

Hi, I need help about Tkinter listbox widget.I want,when somebody click on any item(file) in Listbox,then in new Label widget text must be selected item from server. my program (wrong example): import ftputil import Tkinter root=Tkinter.Tk() ftp=ftputil.FTPHost('some imaginary server') def LabelWidget(event): a=Tkinter.Label(root,text=) # Text must be only name and file format,example: sun.gif a.grid() b=Tkinter.Listbox(root) b.insert(Tkinter.END,ftp._dir('')) b.place() c=Tkinter.Button(root,text='PRINT THIS FILE IN NEW LABEL WIDGET') c.bind('<Button-1>',LabelWidget) c.grid() root.mainloop() THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

2 1

Re: genetic algorithms package for python ?
by Thomas Samson Aug. 31, 2006

Aug. 31, 2006

Xiao Jianfeng <fdu.xiaojf(a)gmail.com> writes: > Hi all, > > I am looking for a genetic algorithms package for Python. > > I have googled the web before posting and found some links. The link > of pygene(http://www.freenet.org.nz/python/pygene) cannot be opened. Strange, works for me... > > I also tried the recipe on ASPN, but it is too simple for my > application, and the ga model in SciPy, which is in testing in the > "sandbox". > > Are there any more genetic algorithms packages for Python ? > I am not (at all!) an specialist in genetic algorithms, but here are some links : http://pygp.sourceforge.net/ http://packages.qa.debian.org/g/genetic.html and of course, http://www.freenet.org.nz/python/pygene/ -- Thomas Samson BOFH Excuse #420: Feature was not beta tested

2 1

Re: Searching a string and extract all occurancies of a substring
by Nico Grubert Aug. 31, 2006

Aug. 31, 2006

> is this XML, or just something that looks a little like XML ? Unfortunately, something that looks a little XML so I can't use a XML parser. But the HTML parser does the job.

1 0

Re: all ip addresses of machines in the local network
by damacy Aug. 31, 2006

Aug. 31, 2006

Amit Khemka wrote: > > in my program so far, multiple threads (255 threads in total) spawned > > at once with each one of them trying to call socket.gethostbyaddr(ip) > > function. i.e. if exception thrown, no machine found. i used .join() to > > wait for the threads to terminate. it's fully working however the > > problem is that it's too slow. it takes approx. 14 seconds to process > > (i tried using 'ping' but it's even slower.). > > > > my question is.. is there a way to improve performance of the program > > if i know what the port number would be? in my case, the port number > > will always be constant although i have no clue on what ip addresses > > would be (that's the reason all of 255 different addresses must be > > tested). > > > > i tried the same function with the port number specified, > > gethostbyaddr(ip:portno), but it is even 10-second slower than using > > the same function without a port number specified (i.e. approx. 25 > > seconds to complete). > > You can save some (DNS) overheads by escaping the call > "gethostbyaddr", assuming you are not interested in knowing the > 'Names' of the machines in your Network. And directly attempt to find > the machines which are listenting on the specified port. A simple way > of > doing this would be to use socket.connect((ip, port)), if the > connections succeds you have > your machine ! > > ( There are various other ways of scanning ports, have a look at: > http://insecure.org/nmap/nmap_doc.html#connect ) > > Though I am not sure how 'fast' it would be. Also remember that the > time in scanning is affected by network-type, > response-time-of-remote-machine, number-of-machines scanned etc. > > I would still be interested, in seeing how nmap(with some smart > options) compares with the python code. ( In my network "nmap > -osscan_limit -p 22 -T5 Class_D_Network" completes in 1.5 seconds !) > > cheers, > amit. > -- > ---- > Amit Khemka -- onyomo.com > Home Page: www.cse.iitd.ernet.in/~csd00377 > Endless the world's turn, endless the sun's Spinning, Endless the quest; > I turn again, back to my own beginning, And here, find rest. hello. here are my test results; 1. using nmap with the options specified above: approx. 50 seconds or longer 2. using socket.connect((ip, port)): approx. 26 seconds 3. using socket.gethostbyaddr(ip): approx. 14 seconds all three above use multiple threads. and also, i tried using (in and out) queues to detect the threads termination (instead of .join()), however, it's also very slow and it needs to have deadlock detection mechanism implemented in it which would probably lower the performance of the program. hmm...

1 0

introspection
by brad tilley Aug. 31, 2006

Aug. 31, 2006

How do I import a module and then ask it to show me its methods or other aspects about itself during execution? I'd like to do something such as this: import win32api print win32api.methods() I'd like to write some test scripts that load modules and probe them for information about themselves.

4 3

Re: Allowing ref counting to close file items bad style?
by Dan Aug. 31, 2006

Aug. 31, 2006

BJörn Lindqvist wrote: > On 8/30/06, Dan <bounces(a)foo.org> wrote: >> Is my data safer if I explicitly close, like this?: >> fileptr = open("the.file", "w") >> foo_obj.write(fileptr) >> fileptr.close() > > Have you ever experienced a problem caused by not explicitly closing > your file handles? > No. If I had, I wouldn't have asked the question. It seems to work, but can I really count on it? I am a sample of one (In that happy place that Brooks described as quadrant 1, where a person writes programs for himself to be run on his own computer. Or perhaps to be run by a handful of co-workers.) Such a small sample isn't statistically significant; a 100% success rate doesn't mean much. I've also never had a burned CD go bad, but I know that they do. /Dan -- dedded att verizon dott net

2 1

Re: GC and security
by Paul Rubin Aug. 31, 2006

Aug. 31, 2006

Dennis Lee Bieber <wlfraed(a)ix.netcom.com> writes: > This is after they'd made an 11x14 enlargement of the "stolen" > print, cleaned it up with a marker, reduced to life size, and etched > onto printed circuit board to form a mold for making a latex "skin". > Which, BTW, also fooled the lock. I remember copying my own fingerprints with Elmer's glue when I was in third grade or so (just put a layer of glue on your fingertip, let it dry, and peel it off). I've always wanted to test that method on today's electronic scanners, but it worked (at least somewhat) for leaving visible fake prints on things. The prints would have had the wrong oils and stuff so maybe Sherlock Holmes-level forensics could have picked up the difference.

1 0

Table of Python Packages
by Sanghyeon Seo Aug. 31, 2006

Aug. 31, 2006

Hello, c.l.py, and catalog-sig, This post updates last year's post: http://mail.python.org/pipermail/catalog-sig/2005-March/000506.html Believe it or not, I am still maintaining this table, and it can be now found here: http://sparcs.kaist.ac.kr/~tinuviel/package/list.cgi?name=python Now you can see version comparison between distributions: http://sparcs.kaist.ac.kr/~tinuviel/package/list.cgi?name=python&version=1 Version information is updated daily by an automated cron job. Now the table contains over 400 entries. If you have any suggestions or corrections, please mail me. Seo Sanghyeon

1 0