[Tutor] Exceptions while dealing with MySQL

[Thanos Panousis]

Thanks to everybody for the replies. I got some nice pointers.

I know my design is nasty, but that is because I am learning...Putting
object orientation in the mix, I have this question:

I have an object, person, which is assosiated with some statistical
data. Say for each person object, I need an object variable called
"hairColor". This haircolor variable has to be filled through an SQL
query, so the object must have some way to access a database cursor.
The cool thing would be that all person objects use the same
connection/cursor to get their haircolors filled in, so there would be
only one connection to the SQL server.

Could this  done with a class variable? From what I understand, it
fits nice because its available to all objects of the class, and it is
unique. So would this be a nice way to have objects of the same class
share a "pipe" to the sql database?


On 4/23/07, Alan Gauld <alan.gauld at btinternet.com> wrote:
>
> "Kent Johnson" <kent37 at tds.net> wrote
> >
> > I like Martin Fowler's "Patterns of Enterprise Application
> > Architecture".
>
>
> I agree, except the title can be slightly misleading. Just to make it
> clear, the book is about application architecture for larger scale
> applications (not really enterprise scale just larger scale than the
> usual book examples) and has virtually nothing to say about
> enterprise architecture in the sense of say Zachman etc.
>
> But as a book about application architectures its a very good guide.
> I rate it along with Booch's classic OOAD book which deals with
> similar issues in a different context.
>
> Alan G
>
>
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>