🌐 Mailman 3 January 2006 - Pythonmac-SIG - python.org

MySQLdb lib help
by Chris Porter Jan. 18, 2006

Jan. 18, 2006

Hello, complete python newbie here. I've got: OSX 10.4.3 Python 2.3.5 MySQL 4.1.15-standard (of course, all pre-installed, except for MySQL) I don't seem to have the right python module that will allow python to interact with my MySQL databases. I am completely not a programmer, but I can follow a cookbook-type instruction set in Terminal, and have already set up several MySQL databases and php on my personal intranet. Now I want to run a python program (by someone else, of course) that also interacts with my MySQL databases. I've run the test query that searches for the MySQLdb python module, and found I don't have it, so I need to install it. So, I found this list. Looked for the past year for information about this issue: Bob said in June: "You can download a MySQL-python 1.2 installer from: http://pythonmac.org/packages/" So I did. And installed it (though it's for 10.3) and ran the test I found on the web in Terminal: >>> import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in ? ImportError: No module named MySQLdb >>> Would someone be kind enough to help me out, please? I'm sort of betting the package installed the lib into the wrong place. Is that possible? -- Chris Porter Illustration chrisporter(a)wi.rr.com, chrisporter(a)huntingthesnark.com http://chrisporter.huntingthesnark.com phone/fax: 262.843.3697

4 6

Resource forks and HFS-metadata
by Dimi Shahbaz Jan. 18, 2006

Jan. 18, 2006

Hi, My program deals with zip transferring archives. I'm curious as to whether Python (namely the 'zip' and 'zipfile') modules can be made to be aware of resource forks and HFS-metadata? Or is this a limitation of the zip format itself? According to this (old) hint: http://www.macosxhints.com/article.php?story=20031118111144197 I will have to have my program interact with `cpio` to preserve the metadata, which I'm trying to avoid. Thanks

4 5

Building multiple command-line( ( CLI ) programs with py2app
by Read Roberts Jan. 18, 2006

Jan. 18, 2006

I would like to distribute about 30 Python command-line programs that use a single stand-alone Python distribution. Looking at py2app, I only see the following two ways of doing it. Can anyone suggest a better approach? In all cases: build a *.app bundle app with py2app, and then use relative sym-links to run the command-line binary which is at "<target-name>.app/Contents/MacOS/<target-name>". so the user can see and access the CLI program without having to cd within the bundle app. 1) Build a single CLI app that runs a differnet CLI Python file based on the first command-line argument. - Build a single Python "<target-name>.app" that imports everything needed by any of my separate Python apps. - copy my Python programs into "<target-name>.app/Contents/Resources" - have the main "<target-name>" Python program simply do execfile with sys.argv[1] + ".py" - document that to run the program in the package, the user needs to say: "<target-name> <command-name> <command-arguments" 2) Change the "<target-name>.app" start-up data so that you can have several CLI apps in "<target-name>.app/Contents/MacOS", usch that one each runs a different Python program under "<target-name>.app/Contents/Resources". I notice that the "<target-name>.app/Contents/Info.plist" file contains the key-value pair " PyMainFileNames"-"<boot-file-name>". The CLI program "<target-name>.app/Contents/MacOS/<target-name>" references this key name to get the list of strings, and for each name, will try to run the matching Python boot file in "<target-name>.app/Contents/Resources". This boot file in turn fixes up the Python sys paths, and then uses execfile to run the Python file "<target-name>.py". I verified that I can achieve what I want to do here by a crude manual approach : - make multiple copies of the "<target-name>" file under "<target-name>.app/Contents/MacOS/" - edit the data string " PyMainFileNames" in each one to be a different string (of the same length!) - add key-value pairs to "<target-name>.app/Contents/Info.plist" defining a different boot-file name value for each different key value - make multiple copies of the boot file under "<target-name>.app/Contents/Resources", one for each name I supplied in the Info.plist file, and edit each so that it starts a different CLI program. Obviously, for production, I would modify the py2app code to do this. Any better ideas? Read Roberts Adobe SJ on Weds, home office 415-642-5642 other days

5 13

appscript: selecting many songs in iTunes
by Niko Matsakis Jan. 18, 2006

Jan. 18, 2006

I have a program which identifies duplicates in iTunes and attempts to delete them automatically. It seems to work like a charm, except for one problem: once I have identified the set of songs to delete, I have to go through them one-by-one and delete them. So, if I have accumulated the database_IDs for a set of songs into a list 'songdbids', I do something like: allsongs = app ('iTunes').sources['Library'].playlists ['Library'].tracks for songdbid in songdbids: allsongs.filter (its.database_ID == songdbid).get()[0].delete () This works fine when I test on small music collections, but when I try to run it across my full set of music it takes forever (as you might imagine). Now, the number one rule of appscript performance which has been drilled into my head is to avoid AppleEvents like the plague. To that end, it seems like what I want to do is something like: allsongs.filter (its.database_ID in songdbids]).delete () except I don't think that the 'in' operator works, and it looks like I'm missing a get() in there in any case. Can anyone think of a better way to do this? Perhaps I am on the wrong track altogether in working with database_IDs? I can't select by album or artist, however, as that would delete both copies of the duplicated album (naturally). thanks, Niko

2 9

Problem with applets on MacPython
by Nathaniel Rhein Jan. 17, 2006

Jan. 17, 2006

I know it'd be better to post this to a primarily MacPython group, but this is pretty much all I could find for Python. I'm very novice as far as programming languages go; basically I leanred Basic a while back and now, wanting to get into a more advanced langage, chose Python. I really don't know much about how languages work with operating systems (if you download just Python — not MacPython — for OS X you get a whole bunch of strange folders and files with Terminal icons), or any of that stuff, so I'm trying to start out pretty small. My problem right now is simply that whenever I build a simple program I have made in MacPython into an applet — from PythonIDE, BuildApplet, or py2app, — it never works. I open it up and it quits right away, without even an error message. I'm using ridiculously small programs (1-10 lines or so), and I don't know of anything else to do. Does anyone know how to fix this problem, or if I'm barking up the wrong tree, a better starting point for wanting to learn programming? Or is this just entirely the wrong place to ask? -- -Nat "Better to remain silent and be thought a fool than speak out and remove all doubt." -Abraham Lincoln

5 5

MySQLdb Lib Help
by Chris Porter Jan. 16, 2006

Jan. 16, 2006

Hello, complete python newbie here. I've got: OSX 10.4.3 Python 2.3.5 MySQL 4.1.15-standard (of course, all pre-installed, except for MySQL) I don't seem to have the right python module that will allow python to interact with my MySQL databases. I am completely not a programmer, but I can follow a cookbook-type instruction set in Terminal, and have already set up several MySQL databases and php on my personal intranet. Now I want to run a python program (by someone else, of course) that also interacts with my MySQL databases. I've run the test query that searches for the MySQLdb python module, and found I don't have it, so I need to install it. So, I found this list. Looked for the past year for information about this issue: Bob said in June: "You can download a MySQL-python 1.2 installer from: http://pythonmac.org/packages/" So I did. And installed it (though it's for 10.3) and ran the test I found on the web in Terminal: >>> import MySQLdb Traceback (most recent call last): File "<stdin>", line 1, in ? ImportError: No module named MySQLdb >>> Would someone be kind enough to help me out, please? I'm sort of betting the package installed the lib into the wrong place. Is that possible? -- Chris Porter Illustration chrisporter(a)wi.rr.com, chrisporter(a)huntingthesnark.com http://chrisporter.huntingthesnark.com phone/fax: 262.843.3697

3 6

Re: [Pythonmac-SIG] MySQLdb Lib Help
by Chris Porter Jan. 16, 2006

Jan. 16, 2006

Found the files, possibly in the wrong place. I found this: System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages(alias) Clicking on the alias brings up these files: Extras.pth README .DS_Store(system file, I know) I also found this: Library/Python/2.3/ Opening 2.3 shows me these files and directories _mysql_exceptions.py _mysql_exceptions.pyc _mysql_exceptions.pyo _mysql.so MySQLdb/(full of stuff) site-packages/(three files) Ss, should the files in Library/Python/2.3/ be moved to the System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3?

1 0

Re: [Pythonmac-SIG] MySQLdb Lib Help
by Craig Amundsen Jan. 16, 2006

Jan. 16, 2006

Hi - > >>> import MySQLdb > Traceback (most recent call last): > File "<stdin>", line 1, in ? > ImportError: No module named MySQLdb What is the output from ls /Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/ That's where you should find the MySQLdb directory if it got installed correctly. - Craig

2 1

Trouble installing PIL package
by Ken Brooks Jan. 13, 2006

Jan. 13, 2006

OS: Tiger 10.4.4 System: 1GHz / 1GB RAM Python: 2.3.5 Using PackageManager to install PIL, came to following problem (at end of quoted text): -------------------------------------------------------------------- PIL 1.1.5 BUILD SUMMARY -------------------------------------------------------------------- version 1.1.5 platform darwin 2.3.5 (#1, Mar 20 2005, 20:38:20) [GCC 3.3 20030304 (Apple Computer, Inc. build 1809)] -------------------------------------------------------------------- --- TKINTER support ok --- JPEG support ok --- ZLIB (PNG/ZIP) support ok *** FREETYPE2 support not available -------------------------------------------------------------------- To add a missing option, make sure you have the required library, and set the corresponding ROOT variable in the setup.py script. To check the build, run the selftest.py script. running build_scripts creating build/scripts-2.3 copying and adjusting Scripts/pilconvert.py -> build/scripts-2.3 copying and adjusting Scripts/pildriver.py -> build/scripts-2.3 copying and adjusting Scripts/pilfile.py -> build/scripts-2.3 copying Scripts/pilfont.py -> build/scripts-2.3 copying and adjusting Scripts/pilprint.py -> build/scripts-2.3 changing mode of build/scripts-2.3/pilconvert.py from 644 to 755 changing mode of build/scripts-2.3/pildriver.py from 644 to 755 changing mode of build/scripts-2.3/pilfile.py from 644 to 755 changing mode of build/scripts-2.3/pilfont.py from 664 to 775 changing mode of build/scripts-2.3/pilprint.py from 644 to 755 running install_lib copying build/lib.darwin-8.4.0-Power_Macintosh-2.3/_imaging.so -> /System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/PIL copying build/lib.darwin-8.4.0-Power_Macintosh-2.3/_imagingtk.so -> /System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/PIL running install_scripts copying build/scripts-2.3/pilconvert.py -> /System/Library/Frameworks/Python.framework/Versions/2.3/bin error: /System/Library/Frameworks/Python.framework/Versions/2.3/bin/pilconvert.py: Permission denied install PIL-1.1.5-source: running ""/Applications/MacPython-2.3/PackageManager.app/Contents/MacOS/Python" setup.py install " failed It really did fail: when I try PIL's selftest.py, it says, *** The _imaging C module is not installed If it was just a matter of copying files, I would use sudo and do it myself - but I've searched that setup.py script and I can't even find in it where the copy commands are being issued! I also tried downloading PIL separately and saying: sudo python setup.py install which got farther but still doesn't pass the selftest check. Help?? Ken Brooks

2 1

Trouble installing PIL package
by Ken Brooks Jan. 13, 2006

Jan. 13, 2006

OS: Tiger 10.4.4 System: 1GHz / 1GB RAM Python: 2.3.5 Using PackageManager to install PIL, came to following problem (at end of quoted text): -------------------------------------------------------------------- PIL 1.1.5 BUILD SUMMARY -------------------------------------------------------------------- version 1.1.5 platform darwin 2.3.5 (#1, Mar 20 2005, 20:38:20) [GCC 3.3 20030304 (Apple Computer, Inc. build 1809)] -------------------------------------------------------------------- --- TKINTER support ok --- JPEG support ok --- ZLIB (PNG/ZIP) support ok *** FREETYPE2 support not available -------------------------------------------------------------------- To add a missing option, make sure you have the required library, and set the corresponding ROOT variable in the setup.py script. To check the build, run the selftest.py script. running build_scripts creating build/scripts-2.3 copying and adjusting Scripts/pilconvert.py -> build/scripts-2.3 copying and adjusting Scripts/pildriver.py -> build/scripts-2.3 copying and adjusting Scripts/pilfile.py -> build/scripts-2.3 copying Scripts/pilfont.py -> build/scripts-2.3 copying and adjusting Scripts/pilprint.py -> build/scripts-2.3 changing mode of build/scripts-2.3/pilconvert.py from 644 to 755 changing mode of build/scripts-2.3/pildriver.py from 644 to 755 changing mode of build/scripts-2.3/pilfile.py from 644 to 755 changing mode of build/scripts-2.3/pilfont.py from 664 to 775 changing mode of build/scripts-2.3/pilprint.py from 644 to 755 running install_lib copying build/lib.darwin-8.4.0-Power_Macintosh-2.3/_imaging.so -> /System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/PIL copying build/lib.darwin-8.4.0-Power_Macintosh-2.3/_imagingtk.so -> /System/Library/Frameworks/Python.framework/Versions/2.3/lib/python2.3/site-packages/PIL running install_scripts copying build/scripts-2.3/pilconvert.py -> /System/Library/Frameworks/Python.framework/Versions/2.3/bin error: /System/Library/Frameworks/Python.framework/Versions/2.3/bin/pilconvert.py: Permission denied install PIL-1.1.5-source: running ""/Applications/MacPython-2.3/PackageManager.app/Contents/MacOS/Python" setup.py install " failed It really did fail: when I try PIL's selftest.py, it says, *** The _imaging C module is not installed If it was just a matter of copying files, I would use sudo and do it myself - but I've searched that setup.py script and I can't even find in it where the copy commands are being issued! I also tried downloading PIL separately and saying: sudo python setup.py install which got farther but still doesn't pass the selftest check. Help?? Ken Brooks

1 0