🌐 Mailman 3 March 2010 - Python-list - python.org

[newbie] - python list into a sql query
by João March 1, 2010

March 1, 2010

Hi. Can someone guide me into getting this to work? It's just really querying a DB of an Autodiscovery tool to have a bunch of updated dns files. (Thought I'm still building the first script steps) I was able to successfully query the DB against a single groupid, but am failing in passing a list of integers into the sql query. I'm failing miserably in, sql = '''SELECT ip, host, dns FROM zabbix_tst_db.hosts WHERE hostid IN ( select hostid from hosts_groups WHERE groupid IN (' + ','.join(map(str, %s)) + ')''' % grp_range with _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1") I'll gladly accept any other code change suggestion #!/usr/bin/env python import MySQLdb import sys, os import code builder_path = '/opt/scripts/dns_builder' grp_range = range(10,15) try: db = MySQLdb.connect(host="localhost", user="tst",passwd="tst",db="tst_db" ) except MySQLdb.Error, e: print "Error %d: %s" % (e.args[0], e.args[1]) cursor = db.cursor() sql = '''SELECT ip, host, dns FROM zabbix_tst_db.hosts WHERE hostid IN ( select hostid from hosts_groups WHERE groupid IN (' + ','.join(map(str, %s)) + ')''' % grp_range cursor.execute(sql) f = open('%s/dns_unknown_list.txt', 'w+') % builder_path data = cursor.fetchall() for row in data: ip = row[0] host = row[1] dns = row[2] if host == dns: #tmn if ip[0][:10] in ('140.254.30','10.13.74.') group1_file = open('%s/group1.zone', 'w') % builder_path print >>group1_file, '''$ORIGIN group1 ''' print >>group1_file, '%s IN A %s' % (dns, ip) elif ip[0][:3] in ('8.128.46.','6.128.101') group2_file = open('%s/group2.zone', 'w') % builder_path print >>group2_file, '''$ORIGIN group2 ''' print >>group2_file, '%s IN A %s' % (dns, ip) else: print >>f, 'unknown IN A %s' % ip db.close() input_file.close() f.close()

3 2

python shell crashing on paste
by Leo March 1, 2010

March 1, 2010

I just upgraded to Windows 7 (yes, I know) and I've been having a really strange problem with running python (2.6.4, installed from the python.org installer) from the command line. If I open the interpreter, and then paste in a long string, conhost.exe crashes. This doesn't happen when pasting the string just in the command line so its something with the python interpreter. Here's the details of the windows crash: Log Name: Application Source: Application Error Event ID: 1000 Task Category: (100) Level: Error Keywords: Classic Description: Faulting application name: conhost.exe, version: 6.1.7600.16385, time stamp: 0x4a5bc271 Faulting module name: conhost.exe, version: 6.1.7600.16385, time stamp: 0x4a5bc271 Exception code: 0xc0000005 Fault offset: 0x000048ca Faulting process id: 0x1aa8 Faulting application start time: 0x01cab4e450b97766 Faulting application path: C:\Windows\system32\conhost.exe Faulting module path: C:\Windows\system32\conhost.exe Report Id: 9c6afd6c-20d7-11df-bbd8-e390d387a902 Has anyone else seen anything like this? Any suggestions on how to even start figuring this out? --Leo

2 2

Re: Is there a better way to do this?
by Richard Brodie March 1, 2010

March 1, 2010

"Matt Mitchell" <mmitchell(a)transparent.com> wrote in message news:mailman.65.1267464765.23598.python-list@python.org... > My initial idea was to make a list of all the different > ways "project" has been capitalized in my repo and try each one. The > code looks like this: I would use pysvn.Client.list to get a list of files at whatever directory level you require. Then you can do a case insensitive compare or whatever else.

1 0

Is there a better way to do this?
by Matt Mitchell March 1, 2010

March 1, 2010

Hi, I wrote a python script that uses pysvn to export projects from an svn repo I have. The repo has hundreds of projects in it with a directory structure that is pretty uniform however it's not exactly uniform because of the capitalization. I.e.: \root \project English \Stuff \Stuff 2 \Project Spanish \Stuff 3 \Stuff 4 My svn repo is case sensitive so if I try to get \root\project Spanish\Stuff 3 I get an error. Fixing the capitalization is not an option for me. My initial idea was to make a list of all the different ways "project" has been capitalized in my repo and try each one. The code looks like this: import pysvn def getstuff(stuffiwant, languageiwantitin): projects = ("project %s/", "Project %s/", "pRojects %s/") c = pysvn.Client() for p in projects: exportme = p % languageiwantitin exportme = "http://localhost/" + exportme + stuffiwant try: c.export(exportme, "C:\\temp\\") break except pysvn.ClientError: print "Not the right capitalization." # do the rest of the stuff I need to do. This works, but to me it seems like there has to be a better way of doing it. Any feedback or suggestions would be appreciated. Thanks, Matt

1 0

Re: Looking for an Application
by Arnaud Delobelle March 1, 2010

March 1, 2010

Greg Lindstrom <greg.lindstrom(a)novasyshealth.com> writes: > A few months ago there was a post dealing with an application that > would power scripts based on graphical snippets of the screen. > Essentially, the script would "look" for a match with what you pasted > into it. I don't recall the name of the application, but would like > to try it. Does anyone remember what it is? > > Thanks, > --greg Project SIKULI? http://groups.csail.mit.edu/uid/sikuli/ -- Arnaud

1 0

Re: DreamPie - The Python shell you've always dreamed about!
by Noam Yorav-Raphael March 1, 2010

March 1, 2010

Can you try DreamPie 1.0.1 and say if it still happens? There's a bug report system at launchpad.net/dreampie. Thanks, Noam

1 0

Re: DreamPie - The Python shell you've always dreamed about!
by Noam Yorav-Raphael March 1, 2010

March 1, 2010

This is most probably a bug discovered in DreamPie 1.0 (See https://bugs.launchpad.net/dreampie/+bug/525652 ) Can you try to download DreamPie 1.0.1, and if it still happens, report a bug? Thanks! Noam

1 0

Looking for an Application
by Greg Lindstrom March 1, 2010

March 1, 2010

A few months ago there was a post dealing with an application that would power scripts based on graphical snippets of the screen. Essentially, the script would "look" for a match with what you pasted into it. I don't recall the name of the application, but would like to try it. Does anyone remember what it is? Thanks, --greg

2 1

loop through each line in a text file
by qtrimble March 1, 2010

March 1, 2010

I'm a python newbie but I do have some basic scripting experience. I need to take the line starting with "wer" and extract the year and day of year from that string. I want to be able to add the year and day of year from the last line having "wer*" to the lines occurring in between "wer*" lines. Python seems suitable to do this and I'm fairly certain I can eventually get this to work but I've been hit with a very short time frame so I'm looking for any generous help. The data below is just a sample. There are well over 500,000 lines that need processed. wer1999001 31.2234 82.2367 37.9535 82.3456 wer1999002 31.2234 82.2367 37.9535 82.3456

6 7

How to end TCP socket data while using readline()?
by Arjun March 1, 2010

March 1, 2010

Hi, I have a small script that runs a TCP server. A client connects to this server and transmits a stored file line-by-line, and then waits for a confirmation "done". However, when I run them the first loop never really ends -- as the TCP server keeps expecting more data. I am using a file-like-object, and so somehow I have to communicate to the server that it is the end-of-file. here is some server code <snip> sock1.bind(('', port)) print "Listening at port: ", port sock1.listen(1) # listening socket (conn, addr) = sock1.accept() # connected socket print 'Client (localhost) port: ', addr[1] cf = conn.makefile('r',0) # file like obj for socket lf = open('ccs.txt','w') for line in cf: lf.write(line) lf.flush() sys.stdout.write(line) print len(line) lf.close() (*here*) cf.close() cf = conn.makefile('w',0) print len(line) print 'sendin' stat = 'done' cf.write(stat) print stat print 'sent' cf.close() print 'script done & connection closed' </snip> The client is sending the lines through this code: <snip> s.connect((host,port)) sfp = open("dcs.txt") # script = sfp.readlines() stat = 'still' cf = s.makefile('w',0) for line in sfp.readlines(): cf.write(line) print len(line) print 'close' cf.flush() cf.close() sfp.close() cf = s.makefile('r',0) print stat, 'waiting' stat = cf.readline() print stat, 'waiting' # this should become "done waiting" cf.close() s.close() </snip> So what I am wondering is: 1. Using a file-like object means that the socket becomes uni- directional, until the mode of the file object is changed from 'r' to 'w' (or vice versa). This seems inefficient, and rather unPythonesque. Can somebody tell me if there is a more elegant way of receiving all the lines from the client, and then sending a "done" message to the client? 2. Where I have marked (*here*) in the server code, is where the execution seems to stay waiting... apparently for more input from the client. But then when I force-terminate the client script, the execution continues on the server-side!! So then it sends the "done" status to a (already dead) client, and then exits. How do I get the server to know when the EOF has been reached while using FLOs? Input on this will be much appreciated, because the documentation for readlines() didn't help me with this. Cheers, A

3 3