Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread Bryan
bruceg113 wrote: > Thank you for your reply. > Are you saying having a sqlite database file on a > shared LOCAL network drive is problematic? Yes, mostly, I think I am saying that. A "LOCAL network drive" is network drive, and is not a local drive, local as the network may be. We read and write s

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread ian douglas
>From the sqlite documentation he quoted, it appears that ANY network filesystem, local or otherwise, should be avoided. On Aug 27, 2012 8:13 PM, wrote: > On Monday, August 27, 2012 10:32:47 PM UTC-4, Bryan wrote: > > bruceg113 wrote: > > > > > I selected sqlite for the following reasons: > > > >

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread bruceg113355
On Monday, August 27, 2012 10:32:47 PM UTC-4, Bryan wrote: > bruceg113 wrote: > > > I selected sqlite for the following reasons: > > > > > > 1) Ships with Python. > > > 2) Familiar with Python. > > > 3) The Sqlite description athttp://www.sqlite.org/whentouse.htmlappears to > > meet my requir

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread Bryan
bruceg113 wrote: > I selected sqlite for the following reasons: > > 1) Ships with Python. > 2) Familiar with Python. > 3) The Sqlite description athttp://www.sqlite.org/whentouse.htmlappears to > meet my requirements: >     Very low volume and concurrency, small datasets, simple to use. All good

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread bruceg113355
Demian, I am not a database expert! I selected sqlite for the following reasons: 1) Ships with Python. 2) Familiar with Python. 3) The Sqlite description at http://www.sqlite.org/whentouse.html appears to meet my requirements: Very low volume and concurrency, small datasets, simple to use.

Re: Flexible string representation, unicode, typography, ...

2012-08-27 Thread Neil Hodgson
wxjmfa...@gmail.com: Go "has" the integers int32 and int64. A rune ensure the usage of int32. "Text libs" use runes. Go has only bytes and runes. Go's text libraries use UTF-8 encoded byte strings. Not arrays of runes. See, for example, http://golang.org/pkg/regexp/ Are you claiming

Re: popen4 - get exit status

2012-08-27 Thread Tim Johnson
* Dave Angel [120827 15:20]: > On 08/27/2012 06:39 PM, Tim Johnson wrote: > > In bash I do the following: > > linus:journal tim$ /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl hiccup > > -bash: /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl: No such file or > > directory > > linus:journal tim

Re: popen4 - get exit status

2012-08-27 Thread Tim Johnson
* Benjamin Kaplan [120827 15:20]: > The popen* functions are deprecated. You should use the subprocess module > instead. No, I'm stuck with py 2.4 on one of the servers I'm using and there will not be an upgrade for a few months. I'm really trying to set up something portable between linux->

Re: popen4 - get exit status

2012-08-27 Thread Benjamin Kaplan
On Aug 27, 2012 3:47 PM, "Tim Johnson" wrote: > > In bash I do the following: > linus:journal tim$ /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl hiccup > -bash: /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl: No such file or directory > linus:journal tim$ echo $? > 127 > > In python, use os.p

Re: popen4 - get exit status

2012-08-27 Thread Dave Angel
On 08/27/2012 06:39 PM, Tim Johnson wrote: > In bash I do the following: > linus:journal tim$ /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl hiccup > -bash: /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl: No such file or > directory > linus:journal tim$ echo $? > 127 > > In python, use os.pope

popen4 - get exit status

2012-08-27 Thread Tim Johnson
In bash I do the following: linus:journal tim$ /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl hiccup -bash: /home/AKMLS/cgi-bin/perl/processJournal-Photo.pl: No such file or directory linus:journal tim$ echo $? 127 In python, use os.popen4 I do the following: >>> fin,fout = os.popen4('/home/AKM

Re: Python list archives double-gzipped?

2012-08-27 Thread Tim Chase
On 08/27/12 12:21, Ned Deily wrote: > In article <503ba5f0.3020...@tim.thechases.com>, Tim Chase > wrote: >> To whomever controls the python.org web-server, is it possible >> to tweak Apache so that it doesn't try to gzip *.gz files? It >> may ameliorate the problem, as well as reduce server load

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread Demian Brecht
Is there a reason that you're using SQLite in a network environment rather than a database server? -- http://mail.python.org/mailman/listinfo/python-list

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread bruceg113355
Uli, Answers to your questions: 1) There are approx 65 records and each record is 68 bytes in length. 2) Not applicable because number of records is fixed. 3) Takes less than a second to read all 65 records when all is well. Takes 17 seconds to read all 65 records when all is NOT WELL 4) Perfor

Re: Flexible string representation, unicode, typography, ...

2012-08-27 Thread wxjmfauth
Le lundi 27 août 2012 22:14:07 UTC+2, Ian a écrit : > On Mon, Aug 27, 2012 at 1:16 PM, wrote: > > > - Why int32 and not uint32? No idea, I tried to find an > > > answer without asking. > > > > UCS-4 is technically only a 31-bit encoding. The sign bit is not used, > > so the choice of int32

Re: Flexible string representation, unicode, typography, ...

2012-08-27 Thread Ian Kelly
On Mon, Aug 27, 2012 at 1:16 PM, wrote: > - Why int32 and not uint32? No idea, I tried to find an > answer without asking. UCS-4 is technically only a 31-bit encoding. The sign bit is not used, so the choice of int32 vs. uint32 is inconsequential. (In fact, since they made the decision to limit

Re: VPS For Python

2012-08-27 Thread Matej Cepl
On 26/08/12 09:41, coldfire wrote: I will really appreciate if someone type the address of any of the following for use with python If you can live just with PaaS (i.e., no shell account in the strict sense of the word, although you have ssh access) then my employer is introducing OpenShift

Re: set and dict iteration

2012-08-27 Thread Ian Kelly
On Thu, Aug 23, 2012 at 10:49 AM, Aaron Brady wrote: > The patch for the above is only 40-60 lines. However it introduces two new > concepts. Is there a link to the patch? > The first is a "linked list", a classic dynamic data structure, first > developed in 1955, cf. http://en.wikipedia.org/

Re: Flexible string representation, unicode, typography, ...

2012-08-27 Thread wxjmfauth
Le dimanche 26 août 2012 22:45:09 UTC+2, Dan Sommers a écrit : > On 2012-08-26 at 20:13:21 +, > > Steven D'Aprano wrote: > > > > > I note that not all 32-bit ints are valid code points. I suppose I can > > > see sense in having rune be a 32-bit integer value limited to those > > > valid

Re: set and dict iteration

2012-08-27 Thread Aaron Brady
On Thursday, August 23, 2012 1:11:14 PM UTC-5, Steven D'Aprano wrote: > On Thu, 23 Aug 2012 09:49:41 -0700, Aaron Brady wrote: > > > > [...] > > > The patch for the above is only 40-60 lines. However it introduces two > > > new concepts. > > > > > > The first is a "linked list", a classic

Re: Python list archives double-gzipped?

2012-08-27 Thread Ned Deily
In article <503ba5f0.3020...@tim.thechases.com>, Tim Chase wrote: > That corresponds with what I see in various testing. To whomever > controls the python.org web-server, is it possible to tweak Apache > so that it doesn't try to gzip *.gz files? It may ameliorate the > problem, as well as redu

Re: What do I do to read html files on my pc?

2012-08-27 Thread Jean-Michel Pichavant
mikcec82 wrote: [snip] CODE CHECK : NOT PASSED Depending on this check I have to fill a cell in an excel file with answer: NOK (if Not passed or is present), or OK (if Not passed and are not present). Thanks again for your help (and sorry for my english) Html is not a

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread ahsanraza211
On Monday, August 27, 2012 8:50:15 AM UTC-7, Ulrich Eckhardt wrote: > Am 27.08.2012 03:23, schrieb bruceg113...@gmail.com: > > > My program uses Python 2.6 and Sqlite3 and connects to a network > > > database 100 miles away. > > > > Wait, isn't SQLite completely file-based? In that case, SQLit

Re: Python list archives double-gzipped?

2012-08-27 Thread Tim Chase
On 08/27/12 08:52, Andreas Perstinger wrote: > On 27.08.2012 03:40, Tim Chase wrote: >> So it looks like some python-list@ archiving process is double >> gzip'ing the archives. Can anybody else confirm this and get the >> info the right people? > > If you send the "Accept-Encoding: gzip, deflate"

Re: Python 2.6 and Sqlite3 - Slow

2012-08-27 Thread Ulrich Eckhardt
Am 27.08.2012 03:23, schrieb bruceg113...@gmail.com: My program uses Python 2.6 and Sqlite3 and connects to a network database 100 miles away. Wait, isn't SQLite completely file-based? In that case, SQLite accesses a file, which in turn is stored on a remote filesystem. This means that there a

Re: What do I do to read html files on my pc?

2012-08-27 Thread Chris Angelico
On Mon, Aug 27, 2012 at 11:51 PM, mikcec82 wrote: > I have this html data and I want to check if it is present a string "" > or/and a string "NOT PASSED": Start by scribbling down some notes in your native language (that is, don't bother trying to write code yet), defining exactly what you'r

Re: What do I do to read html files on my pc?

2012-08-27 Thread Joel Goldstick
On Mon, Aug 27, 2012 at 9:51 AM, mikcec82 wrote: > Il giorno lunedì 27 agosto 2012 12:59:02 UTC+2, mikcec82 ha scritto: >> Hallo, >> >> >> >> I have an html file on my pc and I want to read it to extract some text. >> >> Can you help on which libs I have to use and how can I do it? >> >> >> >> tha

Re: What do I do to read html files on my pc?

2012-08-27 Thread mikcec82
Il giorno lunedì 27 agosto 2012 12:59:02 UTC+2, mikcec82 ha scritto: > Hallo, > > > > I have an html file on my pc and I want to read it to extract some text. > > Can you help on which libs I have to use and how can I do it? > > > > thank you so much. > > > > Michele Hi ChrisA, Hi Mark.

Re: Python list archives double-gzipped?

2012-08-27 Thread Andreas Perstinger
On 27.08.2012 03:40, Tim Chase wrote: So it looks like some python-list@ archiving process is double gzip'ing the archives. Can anybody else confirm this and get the info the right people? In January, "random joe" noticed the same problem[1]. I think, Anssi Saari[2] was right in saying that th

Re: Extract Text Table From File

2012-08-27 Thread Tim Chase
On 08/27/12 04:53, Huso wrote: > Below is just ONE block of the traffic i have in the log files. There will be > more in them with different data. > > ROUTES TRAFFIC RESULTS, LSR > TRG MP DATE TIME > 37 17 120824 > > R TRAFF NBIDS CCONG NDV ANBLO MHTIME NBANSW > A

Re: What do I do to read html files on my pc?

2012-08-27 Thread Mark Lawrence
On 27/08/2012 11:59, mikcec82 wrote: Hallo, I have an html file on my pc and I want to read it to extract some text. Can you help on which libs I have to use and how can I do it? thank you so much. Michele Type something like "python html parsing" into the box of your favourite search engi

Re: What do I do to read html files on my pc?

2012-08-27 Thread Chris Angelico
On Mon, Aug 27, 2012 at 8:59 PM, mikcec82 wrote: > Hallo, > > I have an html file on my pc and I want to read it to extract some text. > Can you help on which libs I have to use and how can I do it? > > thank you so much. Try BeautifulSoup. You can find it at the opposite end of a web search. No

Re: Extract Text Table From File

2012-08-27 Thread Laszlo Nagy
On 2012-08-27 13:23, Huso wrote: Hi, There can be any number of blocks in the log file. I distinguish the block by the start header 'ROUTES TRAFFIC RESULTS, LSR' and ending in 'END'. Each block will have a unique [date + time] value. I tried the code you mentioned, it works for the data part.

Re: Your favorite test tool and automation frameworks

2012-08-27 Thread Mark Lawrence
On 27/08/2012 12:04, Alex Naumov wrote: Hello everybody, I would like to ask about your favorite python test frameworks. I never used it before (beginner in testing) and would like to start to learn Unit- and GUI-testing. I look now at PyUnit/unittest and dogtail. Maybe someone can recommend so

Re: Extract Text Table From File

2012-08-27 Thread Huso
Hi, There can be any number of blocks in the log file. I distinguish the block by the start header 'ROUTES TRAFFIC RESULTS, LSR' and ending in 'END'. Each block will have a unique [date + time] value. I tried the code you mentioned, it works for the data part. But I need to get the TRG, MP, DATE

Re: Extract Text Table From File

2012-08-27 Thread Laszlo Nagy
Hi, Thank you for the information. The exact way I want to extract the data is like as below. TRG, MP and DATE and TIME is common for that certain block of traffic. So I am using those and dumping it with the rest of the data into sql. Table will have all headers (TRG, MP, DATE, TIME, R, TRAFF

Your favorite test tool and automation frameworks

2012-08-27 Thread Alex Naumov
Hello everybody, I would like to ask about your favorite python test frameworks. I never used it before (beginner in testing) and would like to start to learn Unit- and GUI-testing. I look now at PyUnit/unittest and dogtail. Maybe someone can recommend something better or just share experiences?

What do I do to read html files on my pc?

2012-08-27 Thread mikcec82
Hallo, I have an html file on my pc and I want to read it to extract some text. Can you help on which libs I have to use and how can I do it? thank you so much. Michele -- http://mail.python.org/mailman/listinfo/python-list

Re: Extract Text Table From File

2012-08-27 Thread Huso
On Monday, August 27, 2012 3:12:14 PM UTC+5, Laszlo Nagy wrote: > On 2012-08-27 11:53, Huso wrote: > > > Hi, > > > > > > I am trying to extract some text table data from a log file. I am trying > > different methods, but I don't seem to get anything to work. I am kind of > > new to python as w

Re: Extract Text Table From File

2012-08-27 Thread Laszlo Nagy
On 2012-08-27 11:53, Huso wrote: Hi, I am trying to extract some text table data from a log file. I am trying different methods, but I don't seem to get anything to work. I am kind of new to python as well. Hence, appreciate if someone could help me out. # # Write test data to test.txt # da

Extract Text Table From File

2012-08-27 Thread Huso
Hi, I am trying to extract some text table data from a log file. I am trying different methods, but I don't seem to get anything to work. I am kind of new to python as well. Hence, appreciate if someone could help me out. Below is just ONE block of the traffic i have in the log files. There wil

Extract Text Format Table Data

2012-08-27 Thread hussain . a . rasheed
Hi, I am trying to extract some data from a log file that outputs tables in text format. I've been trying to accomplish this for some time but without any luck. Hence, appreciate if any of you could help out. Below is a just one block of table from the file. There will be many blocks like this

Re: sys.path in python3.3

2012-08-27 Thread Nicholas Cole
On Mon, Aug 27, 2012 at 10:05 AM, Ned Deily wrote: > In article <503b3247$0$6877$e4fe5...@news2.news.xs4all.nl>, > Hans Mulder wrote: >> On 26/08/12 20:47:34, Nicholas Cole wrote: >> It has been changed to >> >> ~/Library/Python/$py_version_short/lib/python/site-packages >> >> You can find the p

Re: sys.path in python3.3

2012-08-27 Thread Ned Deily
In article <503b3247$0$6877$e4fe5...@news2.news.xs4all.nl>, Hans Mulder wrote: > On 26/08/12 20:47:34, Nicholas Cole wrote: > It has been changed to > > ~/Library/Python/$py_version_short/lib/python/site-packages > > You can find the path it's looking for in site.USER_SITE That is correct. >

Re: sys.path in python3.3

2012-08-27 Thread Ned Deily
In article , Nicholas Cole wrote: > The only user configuration I've done is to create the following > configuration file: > > NPSC:~ nicholas$ cat .pydistutils.cfg > [install] > install_lib = ~/Library/Python/$py_version_short/site-packages > install_scripts = ~/bin > > I should say, this has

Re: sys.path in python3.3

2012-08-27 Thread Hans Mulder
On 26/08/12 20:47:34, Nicholas Cole wrote: > Dear List, > > In all previous versions of python, I've been able to install packages > into the path: > > ~/Library/Python/$py_version_short/site-packages > > but in the rc builds of python 3.3 this is no longer part of sys.path. It has been changed

Re: Calling External (Perl)Script in Python

2012-08-27 Thread Ben Finney
Pervez Mulla writes: > I am trying to call perl script in my python view.py and store that > data in logfile To run external programs and connect to their standard streams, use the ‘subprocess’ module http://docs.python.org/library/subprocess.html> from the Python standard library. -- \

Re: sys.path in python3.3

2012-08-27 Thread Nicholas Cole
On Mon, Aug 27, 2012 at 12:18 AM, Ned Deily wrote: > In article > , > Nicholas Cole wrote: >> It certainly does exist. Distutils will happily put packages into it, >> but import won't find them. > > That's odd! It works for me on 10.8 and it worked for me yesterday on > 10.7 which I tested just