Connecting to remote Oracle db via Python

2011-02-17 Thread pstatham
Hi Guys, I've installed the cx_Oracle module for Python and I'm trying to connect to my remote Oracle db. Like so (username, password and ip below aren't real don't worry) >>> uid = "scott" >>> pwd = "tiger" >>> service = "10.5.1.12:1521:PR10" >>> db = cx_Oracle.connect(uid + "/" + pwd + "@" + se

logging.handlers.SMTPHandler and fileConfig

2010-10-11 Thread pstatham
I'm trying to use pythons logging.handlers.SMTPHandler with a configuration file (so that I don't have to have passwords etc. inside of the script) Now the guide I'm following is [URL="http://docs.python.org/library/ logging.html#configuration-file-format"]here[/URL], now the RotatingFileHandler i

Using csv.DictReader with \r\n in the middle of fields

2010-10-13 Thread pstatham
Hello everyone! Hopefully this will interest some, I have a csv file (can be downloaded from http://www.paulstathamphotography.co.uk/45.txt) which has five fields separated by ~ delimiters. To read this I've been using a csv.DictReader which works in 99% of the cases. Occasionally however the desc

Re: Using csv.DictReader with \r\n in the middle of fields

2010-10-14 Thread pstatham
On Oct 13, 4:01 pm, Neil Cerutti wrote: > On 2010-10-13, pstatham wrote: > > > Hopefully this will interest some, I have a csv file (can be > > downloaded fromhttp://www.paulstathamphotography.co.uk/45.txt) which > > has five fields separated by ~ delimiters. To read th