🌐 Mailman 3 November 2013 - Python-list - python.org

Re: convert Dbase (.dbf) files to SQLite databases
by John Machin March 1, 2016

March 1, 2016

On Jul 15, 8:39 pm, David Lyon <david.l...(a)preisshare.net> wrote: > On Wed, 15 Jul 2009 11:53:28 +0200, Helmut Jarausch > > <jarau...(a)igpm.rwth-aachen.de> wrote: > > Hi, > > > I have a lot of old Dbase files (.dbf) and I'll like to convert these > > to SQLite databases as automatically as possible. > > Does anybody know a tool/Python script to do so? > > > I know, I could use dbfpy and create the SQLite table and import all > > data. But is there something easier? > > yes... > > Use OpenOffice-Scalc or MS-Office-Excel to open the table... Max 64K rows for Scalc and Excel 2003; 2007 can take 2**20 rows. Only old dBase (not dBase 7). Memo fields not handled. Visual FoxPro DBFs not supported by Excel even tho' VFP is an MS product. > Export to csv.... Yuk. > > Use SQLite Manager (https://addons.mozilla.org/en-US/firefox/addon/5817) > > and use the import wizard to import your data.... > > It shouldn't take too long... ... before you get sick of the error-prone manual tasks. I'd write a script that took a DBF file, analysed the field descriptions, made a CREATE TABLE statement, executed it, and then started doing inserts. Fairly easy to write. Scripts have the great benefit that you can fix them and re-run a whole lot easier than redoing manual steps. If dbfpy can't handle any new-fangled stuff you may have in your files, drop me a line ... I have a soon-to-be released DBF module that should be able to read the "new" stuff up to dBase7 and VFP9, including memo files, conversion from whatever to Unicode if needed, ... Cheers, John

3 4

Paramiko Help. Execute command to Interactive Shell which is opened by SSHClient()
by sagar varule March 1, 2016

March 1, 2016

Hi All, Im using Paramiko for my SSH automation. Im using method that is shown in demo_simple.py example which comes with Paramiko. Below is code from demo_simple.py. As you can make out, below code opens SSH connection and opens Interactie Shell, and then wait for the command from user. I want to submit the command to this Interactive Shell using code. try: client = paramiko.SSHClient() client.load_system_host_keys() client.set_missing_host_key_policy(paramiko.WarningPolicy()) print '*** Connecting...' client.connect(hostname, port, username, password) chan = client.invoke_shell() print repr(client.get_transport()) print '*** Here we go!' print interactive.interactive_shell(chan) chan.close() client.close() Well Another approach I tried is instead of opening interactive_shell, directly issue command using; stdin, stdout, stderr = client.exec_command(bv_cmd) for line in stderr.readlines(): print line for line in stdout.readlines(): print line But problem here is client.exec_command(bv_cmd) waits for command to execute completely and then it returns to stdout,stderr. And I want to see the ouput from the command during its execution. Because my command takes long time for execution. Big Picture in My Mind: Big Picture I that want to achieve is, Opening different SSH connection to different host, and it will issue commands to all host, wait for execution. All execution should happen parallel.(just wanted to share my thought, and wanted to hear opinions from you all. Is this possible??). I am not big programmer, just 2 years experience with asp.net C# 2.0 so i would appreciate if discussion happens in simple english.

4 5

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

Re: How clean/elegant is Python's syntax?
by rusi Jan. 22, 2016

Jan. 22, 2016

On Thu, May 30, 2013 at 9:34 AM, Ma Xiaojun <damage3025(a)gmail.com> wrote: > > On Thu, May 30, 2013 at 10:49 AM, rusi <rustompmody(a)gmail.com> wrote: > > Ha,Ha! The join method is one of the (for me) ugly features of python. > > You can sweep it under the carpet with a one-line join function and > > then write clean and pretty code: > > > > #joinwith > > def joinw(l,sep): return sep.join(l) > > > > def mktable(m,n): > > return [[(j,i,i*j) for i in range(1,m+1)] for j in range(1,n+1)] > > > > def prettyrow(r): > > return joinw(['%d*%d=%d' % ele for ele in r],'\t') > > > > def prettytable(t): > > return joinw([prettyrow(r) for r in t],'\n') > > Wait a minute! Isn't the most nature way of doing/thinking "generating > 9x9 multiplication table" two nested loop? Thats like saying that the most natur(al) way of using a car is to attach a horse to it. Sure if all you've seen are horse-carriages then a horseless carriage will seem nonsensical. Once you get used to horseless carriages the horsed ones would seem quite a nuisance [global warming aside!!] The only problem with this analogy is that you have to imagine the world of horse/horseless 'cars' in 1900 and not 2013. Likewise in the world of programming, 90% of programmers think imperative/OO programming is natural while functional programming is strange. Just wait 10 years and see if things are not drastically different! > > I understand that using "join", we don't need to worry about "one > element doesn't need white space" issue. And that's it. More evidence of the above! join like list-comprehensions are tools for functional programming and not merely ways of writing loops in short. The key difference between the two is seen not in the code you write but in the natural language (English) you use to describe it: > Wait a minute! Isn't the most nature way of doing/thinking "generating > 9x9 multiplication table" two nested loop? You associate the primal (f)act of thinking about programming with *doing* the generating. By contrast the functional programmer thinks about what *is* the result. Please also note the difference in emphasis in your code and mine. Rewriting to make it more obvious: # The main multiplication table building function def multtable(m,n): return [[(j,i,i*j) for i in range(1,m+1)] for j in range(1,n+1)] # The 'icing' to get it into the shape you want def joinw(l,sep): return sep.join(l) def prettytable(t): return joinw([joinw(['%d*%d=%d' % ele for ele in r],'\t') for r in t],'\n') The call that puts them together: >>> print prettytable(multtable(6,7)) The nice thing about the last is that it separates three things: 1. Computing the actual table 2. The string form of that table that looks the way we want 3. Printing that string And I can see each of these separately: In [2]: multtable(2,3) Out[2]: [[(1, 1, 1), (1, 2, 2)], [(2, 1, 2), (2, 2, 4)], [(3, 1, 3), (3, 2, 6)]] In [3]: prettytable(_) Out[3]: '1*1=1\t1*2=2\n2*1=2\t2*2=4\n3*1=3\t3*2=6' In [4]: print _ 1*1=1 1*2=2 2*1=2 2*2=4 3*1=3 3*2=6 ------------------- I would be pleasantly surprised if the double nested loop you think natural, allowed for such a modular separation!

5 7

TypeError: 'float' object is not iterable
by Ana Dionísio Dec. 16, 2015

Dec. 16, 2015

Hi!! I keep having this error and I don't know why: TypeError: 'float' object is not iterable. I have this piece of code, that imports to python some data from Excel and saves it in a list: " t_amb = [] for i in range(sh2.nrows): t_amb.append(sh2.cell(i,2).value) print t_amb " Here is everything ok. But then, I need to pass the data again to exel, so I wrote this: " a=8 for b in range (len(t_amb)): a=8 for d in t_amb[b]: a=a+1 sheet.write(a,b+1,d) " The error appear in "for d in t_amb[b]:" and I don't understand why. Can you help me?

8 7

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

Determining version of OpenSSL linked against python?
by Adam Mercer Sept. 17, 2015

Sept. 17, 2015

Hi I'm trying to write a script that determines the version of OpenSSL that python is linked against, using python-2.7 this is easy as I can use: import ssl ssl.OPENSSL_VERSION but unfortunately I need to support python-2.6, from an older script I used the following: import _ssl ssl_lib = _ssl.__file__ to get the path to the _ssl.so module and then I parsed the output of ldd (on linux) to get the path to the OpenSSL library and then parsed the version from the filename. In other words it's very messy. I had a little success using this approach but I have recently received a bug report that this doesn't seem to work on Debian Squeeze. When I try to query the __file__ attribute of the _ssl module I get the following error: >>> import _ssl >>> _ssl.__file__ Traceback (most recent call last): File "<stdin>", line 1, in <module> AttributeError: 'module' object has no attribute '__file__' >>> Can anyone offer any suggestions as to what is going wrong with the above code or offer an alternative way of determining the OpenSSl version using python-2.6? Cheers Adam

3 4

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

Wholesale Sports Shoes Clear Air Force One AAA++quality(www.cnnshoe.com)
by cnnshoe Sept. 12, 2015

Sept. 12, 2015

supply sports shoes. The brand Sports shoes basketball shoes, Boot, walling shoes, Athletic shoes, Jogging shoes, running shoes, leather shoes, football, shoe sports shoe Footwear Sneaker, Shox Max Rift T- shirts, womens t-shirts, Clothing womens clothing, wear hats Caps Jersey jeans Sock Jacks, Watches, wallet, handbags, and Jeans Lady Clothing and so on. Please contact us by email to get more information. please kindly visite our website: http://www.cnnshoe.com msn: cnnshoe2010(a)hotmail.com email: cnnshoe(a)gmail.com

2 1