🌐 Mailman 3 July 2007 - Python-list - python.org

SQLObject 0.9.1
by Oleg Broytmann July 26, 2007

July 26, 2007

Hello! I'm pleased to announce the 0.9.1 release of SQLObject. What is SQLObject ================= SQLObject is an object-relational mapper. Your database tables are described as classes, and rows are instances of those classes. SQLObject is meant to be easy to use and quick to get started with. SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, and Firebird. It also has newly added support for Sybase, MSSQL and MaxDB (also known as SAPDB). Where is SQLObject ================== Site: http://sqlobject.org Development: http://sqlobject.org/devel/ Mailing list: https://lists.sourceforge.net/mailman/listinfo/sqlobject-discuss Archives: http://news.gmane.org/gmane.comp.python.sqlobject Download: http://cheeseshop.python.org/pypi/SQLObject/0.9.1 News and changes: http://sqlobject.org/News.html What's New ========== News since 0.9.0 ---------------- Bug Fixes ~~~~~~~~~ * Replaced calls to style.dbColumnToPythonAttr() in joins.py by name/dbName lookup in case the user named columns differently using dbName. * Minor correction in the tests: we fully support EnumCol in Postgres. * MySQLConnection now recognizes Enum, Double and Time columns when drawing the database scheme from DB. * Fixed misspelled methods in col.py. * Minor fix in FirebirdConnection.fromDatabase. * Fixed a bug with default field values for columns for firebird connection. * Prevent a deadlock in declarative.threadSafeMethod() by not reacquiring the class lock. * Run post_funcs after sending RowCreatedSignal. * Suppress the second RowUpdateSignal in .set() called from ._SO_setValue(). * Fixed a bug in col.createSQL(). * Fixed a bug in converting date/time for years < 1000 (time.strptime() requires exactly 4 digits for %Y, hence a year < 1000 must be 0-padded). Other Changes ~~~~~~~~~~~~~ * Changed string quoting style for PostgreSQL and MySQL from \' to ''. For a more complete list, please see the news: http://sqlobject.org/News.html Oleg. -- Oleg Broytmann http://phd.pp.ru/ phd(a)phd.pp.ru Programmers don't die, they just GOSUB without RETURN.

2 1

Re: Can a low-level programmer learn OOP?
by Wolfgang Strobl July 26, 2007

July 26, 2007

Steve Holden <steve(a)holdenweb.com>: >I'm happy you are proceeding with so little trouble. Without wishing to >confuse you, however, I should point out that this aspect of Python has >very little to do with its object-orientation. There was a language >called Icon, for example, 20 years ago, that used similar semantics but >wasn't at all object-oriented. Actually, there was a language called SNOBOL, 40 years ago, that used similar semantics, developed by Griswold et al. Its object model was remarkably similar to that of Python without classes. And it even had dictionaries (called "tables") :-). For an explaination of the concept "variable" in SNOBOL see <http://www.cacs.louisiana.edu/~mgr/404/burks/language/snobol/catspaw/tutori…> SNOBOLs powerfull patterns still shine, compared to Pythons clumsy regular expressions. I've used the language a lot in the past, first on the mainframe (SPITBOL on System/360), later on the PC (Catspaws SNOBOL4 &SPITBOL). When I switched to Python, it wasn't because of the expressiveness of the language, but of the rich library ("batteries included") and the IMO elegant syntax, i.e. blocks by identation. <http://en.wikipedia.org/wiki/SNOBOL> <http://en.wikipedia.org/wiki/Ralph_E._Griswold> Icon came later. Griswold developed Icon as a successor to SNOBOL, constructing it around the concept of generators and co-expressions. I didn't like it. -- Thank you for observing all safety precautions

9 16

Re: Why PHP is so much more popular for web-development
by Paul Rubin July 26, 2007

July 26, 2007

"Chris Mellon" <arkanes(a)gmail.com> writes: > Would you make this directory name be the username+the password? If > not, why not? The answer is the same reason why this isn't a reliable > method of security. I would not store plaintext passwords in a database, but that doesn't mean it's security by obscurity to do so.

1 0

Comparing Dictionaries
by Kenneth Love July 26, 2007

July 26, 2007

Hello, I am new to Python, but not programming. I would like to start my Python career by developing programs according to the "best practices" of the industry. Right now, that appears to be unit tests, patterns, and source code control. So, I am trying to write a unit test for some code that reads a Windows style INI file and stores the section, key, and values in a dictionary (recipe originally found on ASPN, but heavily modified for my needs). ------------------------------ class LoadIni(unittest.TestCase): knownDefault = { "database$dbms": "mysql", "database$name": "thelarch", "database$user": "nobody", "database$password": "special", "database$host": "127.0.0.1" } def testNoIniFilename(self): """A default configuration list should be returned.""" result = ini.load() # These next two print statement show the same key/value pairs, # but in a different order. #print knownDefault #print result self.assertEqual(result, self.knownDefault) # does not work ------------------------------- In this case, I need to compare the returned dictionary (result) with the known default dictionary (knownDefault). This needs to be a comparison of the dictionary key/value pairs. If all of the key/value pairs are an exact match and no extra key/value pairs are in either dictionary then I consider the two dictionaries to be equivalent. In other words, I consider these two dictionaries to be equivalent: { 'dog' : 'bone', 'cat' : 'fever', 'mouse' : 'mickey' } { 'mouse' : 'mickey', 'dog' : 'bone', 'cat' : 'fever' } while these two are not: { 'dog' : 'bone', 'cat' : 'fever', 'mouse' : 'mickey' } { 'dog' : 'bone', 'cat' : 'fever', 'mouse' : 'michael' } Any suggestions on how to compare these via some assert statement? Am I even on the right track with the INI file storing results in a dictionary? When I found the code, it just "felt right". NOTE: The code works, I can load the INI file, programmatically change a few settings, save the results to a new INI file, and manually compare the resulting files. I get the expected results. It is the automation of this testing process that appears to be the stumbling block. adTHANKSvance, Kenneth Love -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Kenneth Love | Oklahoma Tax Commission DP Programmer/Analyst | Information Technology (405) 522 - 5864 | http://www.tax.ok.gov/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

1 0

Re: I am giving up perl because of assholes on clpm -- switching to Python
by Paul Rubin July 26, 2007

July 26, 2007

John K Masters <johnmasters(a)oxtedonline.net> writes: > As a complete amateur in the world of programming (barring 25 years > programming machine tools in the aerospace industry) I would like to > point out that the more arcane the ['language', 'operating system', > 'application'] the more unfriendly the community. I mentioned comp.lang.functional in another post but I'll add that except for a couple of semi-difficult personalities it's a very friendly place, and a lot of the subjects discussed are so arcane that even as a dedicated software geek I can barely comprehend what they're about.

1 0

Re: Why PHP is so much more popular for web-development
by Paul Rubin July 26, 2007

July 26, 2007

Steve Holden <steve(a)holdenweb.com> writes: > > That sounds trivial to ameliorate (at least somewhat) by putting your > > uploads in a directory whose name is known only to you (let's say it's > > a random 20-letter string). The parent directory can be protected to > > not allow reading the subdirectory names. > > But you have to admit that's "security by obscurity". I'm not completely sure it's security by obscurity if the system setup is careful. The pathname is like a password and maybe it can be proteced from exposure to the same degree that other file system contents are protected. This would not pass review for protecting launch codes, but neither most things done on even serious commercial web sites.

2 1

removing items from a dictionary ?
by Stef Mientki July 26, 2007

July 26, 2007

hello, I want to remove some items from a dictionary, so I would expect this should work: Nets = {} ... fill the dictionary Nets for net in Nets: if net.upper() in Eagle_Power_Nets : del Nets [ net ] But it gives me Message File Name Line Position Traceback ? D:\data_to_test\JALsPy\Eagle_import.py 380 RuntimeError: dictionary changed size during iteration Now I can solve this problem in the following way power_nets = [] for net in Nets: if net.upper() in Eagle_Power_Nets : power_nets.append ( net ) # remove power nets from netlist for net in power_nets: del Nets [ net ] But I wonder if this is the best way to manipulate a dictionary, because I've to do more "complex" operations on the dictionary, like joining items, I would like to have a better understanding of what can and what can't be done. thanks, Stef Mientki

3 2

Re: Fwd: I am giving up perl because of assholes on clpm -- switching to Python
by Kay Schluehr July 26, 2007

July 26, 2007

On Jul 26, 8:18 pm, jed drury <jeddr...(a)yahoo.com> wrote: > Hey, Perl's new motto is "There is more than 1 way to > be an ASSHOLE!" Do you think the unique asshole constraint feels more natural? I tend to agree.

1 0

Fwd: I am giving up perl because of assholes on clpm -- switching to Python
by matt westerburg July 26, 2007

July 26, 2007

---------- Forwarded message ---------- From: matt westerburg <westymatt(a)gmail.com> Date: Jul 26, 2007 11:09 AM Subject: Re: I am giving up perl because of assholes on clpm -- switching to Python To: zentara <zentara(a)highstream.net> Welcome, the people here are friendly occasional argument, not very often of course. Welcome to python by the way.

4 3

Generating PDF reports
by marcpp July 26, 2007

July 26, 2007

Hi i'm introducing to do reports from python, any recomendation?

4 3