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

cx_Oracle + array parameter
by lukasz.f24＠gmail.com March 4, 2016

March 4, 2016

Hello, I'm trying to pass array as an argument into PL/SQL procedure. According to cursor manual (http://cx-oracle.sourceforge.net/html/ cursorobj.html) arrayvar() should be use to do it. I've created my array type in PL/SQL: CREATE OR REPLACE TYPE cx_array_string is table of varchar2(200); and simple procedure: CREATE OR REPLACE PROCEDURE text(ret IN cx_array_string) IS BEGIN null; END text; My python code: p_array = curs.arrayvar(cx_Oracle.STRING, ['1','3']) curs.execute('BEGIN text( :1 ); end;', [p_array] ) And it gives me back an error: cx_Oracle.DatabaseError: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'TEXT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored It's the same when i try to use callproc() instead of execute(). I've searched whole internet with no luck. Could anyone please give me a working example python + pl/sql how to pass string array form py to oracle procedure, please. Thank you!

3 3

How to get all IP addresses in python?
by Yun Mao Feb. 25, 2016

Feb. 25, 2016

Hi. I did a little homework on google for this question. The answer was: >>> import socket >>> hostname = socket.gethostname() >>> ip = socket.gethostbyname(hostname) >>> print ip 192.168.55.101 But what if I have several interfaces, say eth0, eth0:1, eth1, etc. How to get all of them? It would be a little undesirable if people suggest to parse the result of ifconfig because I in particular want the code to be cross platform. Thanks a lot! Yun

7 7

Best programs written completly in Python
by Franz Steinh�usler Feb. 12, 2016

Feb. 12, 2016

Hello NG, wWhat are the best programs in your opinion, written entirly in pyhton, divided into categories like: a) Games b) Utilities/System c) Office d) Web/Newsreader/Mail/Browser ... I don't want to start a long thread, if a site of such an discussion already exists, a link will be enough. Many thanks in advance! -- Franz Steinhaeusler

14 15

Script to extract text from PDF files
by brad Nov. 6, 2015

Nov. 6, 2015

I have a very crude Python script that extracts text from some (and I emphasize some) PDF documents. On many PDF docs, I cannot extract text, but this is because I'm doing something wrong. The PDF spec is large and complex and there are various ways in which to store and encode text. I wanted to post here and ask if anyone is interested in helping make the script better which means it should accurately extract text from most any pdf file... not just some. I know the topic of reading/extracting the text from a PDF document natively in Python comes up every now and then on comp.lang.python... I've posted about it in the past myself. After searching for other solutions, I've resorted to attempting this on my own in my spare time. Using apps external to Python (pdftotext, etc.) is not really an option for me. If someone knows of a free native Python app that does this now, let me know and I'll use that instead! So, if other more experienced programmer are interested in helping make the script better, please let me know. I can host a website and the latest revision and do all of the grunt work. Thanks, Brad

8 10

Einstein's Riddle
by Steve Graham Sept. 17, 2015

Sept. 17, 2015

Who would be interested in using his/her brain (and his computer) to solve the following? Steve Graham === Einstein's Riddle Albert Einstein wrote this riddle this century [ed. 20th century]. He said 98% of the world could not solve it. There are 5 houses in 5 different colors. In each house lives a person with a different nationality. The 5 owners drink a certain type of beverage, smoke a certain brand of cigar, and keep a certain pet. No owners have the same pet, smoke the same brand of cigar or drink the same beverage. The question is: "Who owns the fish?" Hints: The Brit lives in the red house. The Sweed keeps dogs as pets. The Dane drinks tea. The green house is on the left of the white house. The green house's owner drinks coffee. The person who smokes Pall Mall rears birds. The owner of the yellow house smokes Dunhill. The man living in the center house drinks milk. The Norwegian lives in the first house. The man who smokes Blends lives next to the one who keeps cats. The man who keeps the horse lives next to the man who smokes Dunhill. The owner who smokes Bluemasters drinks beer. The German smokes Prince. The Norwegian lives next to the blue house. The man who smokes Blends has a neighbor who drinks water.

36 56

Python to C++ in a pickle
by Larry Whitley April 2, 2015

April 2, 2015

I'd like to pickle an object in python and unpickle it in C++. The object in question is a python dictionary so it will have to go into a C++ map. Has someone done this and is willing to share? Or, is the cPickle source available on the web somewhere? Larry

4 3

Re: feature request: a better str.endswith
by Irmen de Jong Feb. 17, 2015

Feb. 17, 2015

Jp Calderone wrote: > On Fri, Jul 18, 2003 at 05:01:47AM -0700, Michele Simionato wrote: > >>I often feel the need to extend the string method ".endswith" to tuple >>arguments, in such a way to automatically check for multiple endings. >>For instance, here is a typical use case: >> >>if filename.endswith(('.jpg','.jpeg','.gif','.png')): >> print "This is a valid image file" >> >>Currently this is not valid Python and I must use the ugly >> >>if filename.endswith('.jpg') or filename.endswith('.jpeg') \ >> or filename.endswith('.gif') or filename.endswith('.png'): >> print "This is a valid image file" > > > extensions = ('.jpg', '.jpeg', '.gif', '.png') > if filter(filename.endswith, extensions): > print "This is a valid image file > > Jp > Using filter Michele's original statement becomes: if filter(filename.endswith, ('.jpg','.jpeg','.gif','.png')): print "This is a valid image file" IMHO this is simple enough to not require a change to the .endswith method... --Irmen

11 22

Python Tk Tix GUI documentation & builder overview and tips
by baloand＠googlemail.com Jan. 3, 2015

Jan. 3, 2015

I have recently started development for a small video conversion project using a GUI. After some research I decided to use Tkinter/Tix (Tk/Tix). The reasons are mainly: 1. the GUI is rather simple, and 2. the end-user is not necessarily technically inclined so I want to keep a) required libraries as few as possible, and b) installation as painless as possible. 3. Tk/Tix is included with Python. Thus only a Python installation is needed. Nothing else. 4. Tk itsself misses some rudimentary widgets like meters, multi/colum lists, grid and scrolled widgets. Tix provides those. Good enough for my little application (more advanced and more modern widgets are available in frameworks like Qt, Gtk, or wxWindows). Before starting I spent some effort to find a) relevant documentation, b) GUI Builders which might help me, c) answers to non-obvious questions. The process took some time and effort so I want to share my findings: a) Documentation resources Python Docs http://docs.python.org/library/tkinter.html Tk Commands http://www.tcl.tk/man/tcl8.5/TkCmd/contents.htm Tix Reference http://tix.sourceforge.net/man/html/contents.htm Tix demo application You want to extract the Tix demo application coming with the Tix 8.4.3 source distribution. It contains examples for many widgets - unfortunately none for multi-column HList or the Grid (see below). https://sourceforge.net/project/showfiles.php?group_id=5649&package_id=5704 Tix8.4.3-src.tar.gz, then look in /Tix8.4.3/Python/Demo/tix Thinking in Tkinter I recommend the "Individual programs online" http://www.ferg.org/thinking_in_tkinter/index.html b) GUI development tools ActiveState GUI Builder (using grid layout) SpecTcl is the predecessor of GUI Builder (by ActivaState). http://spectcl.sourceforge.net/ FAQ (where to get source) http://aspn.activestate.com/ASPN/Mail/Message/komodo-announce/3355346 PAGE v3.0 by Stewart Allen (using placer layout) http://page.sourceforge.net/ There are many more for other GUI toolkits mentioned in this post: http://mail.python.org/pipermail/python-list/2004-February/250727.html Finally I decided to use the packer layout and create the widgets manually. Just the simplest and quickest way for me. c) How do I ...? How do I use all methods available in the Tix Grid? Tix Grid with full implementation of all methods http://klappnase.bubble.org/TixGrid/index.html How do I create a multi-column Tix.HList? import Tkinter as Tk import Tix root = Tix.Tk() # setup HList hl = Tix.HList(root, columns = 5, header = True) hl.header_create(0, text = "File") hl.header_create(1, text = "Date") hl.header_create(1, text = "Size") # create a multi-column row hl.add("row1", text = "filename.txt") hl.item_create(entry_path, 1, text = "2009-03-26 21:07:03") hl.item_create(entry_path, 2, text = "200MiB") I haven't found out how to right-justify individual columns? Anyone? How to implement Tk GUI with multiple threads? Usually there are two options to make threads wait for an event: * gui thread polling (lame) see here how to use Tk.after() (actually a Tcl command) to poll http://uucode.com/texts/pylongopgui/pyguiapp.html see here how to imitate the Tk event loop to poll for non-Tk events (a socket, for example) https://sourceforge.net/project/showfiles.php?group_id=5649&package_id=5704 Tix8.4.3-src.tar.gz, then look in /Tix8.4.3/Python/Demo/tix/ tixwidgets.py, find loop() * multithreaded with events (the option to choose) Basically this uses bind and event_generate to send "Notify" messages to the Tk instance. I suspect the following example failed due to not synchronising the event_generate call http://coding.derkeiler.com/Archive/Python/comp.lang.python/2006-07/msg0147… For multithreading Python Tk GUI applications the following rules apply: 1. same thread calling Tk must do all subsequent GUI calls, 2. other threads may send events with send_event to the root Tk instance, 3. with threading problems you might try to synchonise access to event_generate(). Using event_generate() with one non-GUI thread seems to be safe.

4 3

Creating interactive command-line Python app?
by planetthoughtful Dec. 18, 2014

Dec. 18, 2014

Hello All, Newbie to Python, and I'm wondering if it's possible to create a Python console app that prompts for further input on the command line when run (in Windows XP, if that's important)? I've tried Googling, but the results are overwhelmingly about interactive Python environments (IPython etc etc), instead of how to achieve prompting at the command line when running your own Python app. Any help appreciated! Much warmth, planetthoughtful

10 10

Need some help with NetGroupAddUser
by kcollins15＠cfl.rr.com Nov. 11, 2014

Nov. 11, 2014

New B question -- Need help with win32net.NetGroupAddUser. I used Mark Hammond sample code to create a new user from his book Python Programming on Win32. I then added one line to add the newuser to a group. def CreateUserAndShare(userName, fullName): homeDir = "%s\\%s" % (serverName, userName) # Create user data in information level 3 (PyUSER_INFO_3) format. userData = {} userData['name'] = userName userData['full_name'] = fullName userData['password'] = userName userData['flags'] = win32netcon.UF_NORMAL_ACCOUNT | win32netcon.UF_SCRIPT userData['priv'] = win32netcon.USER_PRIV_USER userData['home_dir'] = homeDir userData['home_dir_drive'] = "P:" userData['primary_group_id'] = ntsecuritycon.DOMAIN_GROUP_RID_USERS userData['password_expired'] = 1 # User must change password next logon. # Create the user win32net.NetUserAdd(serverName, 3, userData) win32net.NetGroupAddUser(serverName, "Administrator", userName) This is my error: pywintypes.api_error: (2220, 'NetGroupAddUser', 'The group name could not be found.') What should I be using for the groupname parameter, I've tried them all, Administrator, Guests, Users ext.... Any help will be greatly appreciated. Thanks, kc

3 2