New database interface

Dev Shed Forums Sponsor:

November 22nd, 2003, 06:56 AM

telex4

Wacky hack

Join Date: Apr 2001

Location: London, England

Posts: 513

Time spent in forums: 1 h 38 m 37 sec
Reputation Power: 13

New database interface

As part of my project to make a decent framework to develop web sites with that isn't as "heavy" as Zope, I've started work on a module to make handling databases nice and easy.

There are two things that annoy me about databases:

1) When you use a new host and find that you have to change all of your MySQL code to, for example, flat-file database code

2) Having to write the same lines over and over for queries, etc.

So this module tries to make the kinds of simple operations I need for web sites nice and easy. I've attached the module so far to this message along with the requisite config.py.

But here's an example of its use:

Code:

>>> import db
>>> mydb = db.DB('mysql')
>>> mydb.info()
{'tables': ['calendar', 'campaigns', 'pages', 'pressreleases', 'rdb_articles', 'rdb_categories', 'resources'],
 'hostname': 'localhost', 'dbname': 'readingc_campaignforum', 'ctime': 'Sat, 22 Nov 2003 12:46:46 +0000'}
>>> mydb.fetchRow('calendar', 'name,eventdate', 'id', '6')
{'name': 'Human Rights in Chechnya', 'eventdate': '2003-03-10'}

Attached Files

db.tar.gz (1.4 KB, 406 views)

Last edited by telex4 : November 22nd, 2003 at 06:59 AM.

November 26th, 2003, 02:13 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

You might find the PDO project interesting Telex:

http://sourceforge.net/docman/displ...&group_id=86244

Mark.

__________________
programming language development: www.netytan.com – Hula

November 26th, 2003, 05:29 AM

telex4

Wacky hack

Join Date: Apr 2001

Location: London, England

Posts: 513

Time spent in forums: 1 h 38 m 37 sec
Reputation Power: 13

Ah, magic; had I found that first, I might have used it instead of making my own. Then again, it's always fun and educational trying to roll your own solution

It's quite frustrating coming from Perl to Python in this respect; I find Python much nicer to code with, but the standard library is missing some really useful and time saving features found in Perl's CPAN.

November 26th, 2003, 08:24 AM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

Yeah i gotta agree with you there, def loadsa fun! The thing you have to remember though is that where the vaults of parnassus are pretty small.. CPAN is backed by Sun

.. and with that much comercial input what can you expect!

http://www.vex.net/parnassus/

Give it a little time and see what happens

.. Pythons becoming more popular every day.. but if parnassus hasn't grown considerably within the next 5 years where gonna have to make our own CPAN style resource for Python!

Mark.

November 26th, 2003, 09:22 AM

telex4

Wacky hack

Join Date: Apr 2001

Location: London, England

Posts: 513

Time spent in forums: 1 h 38 m 37 sec
Reputation Power: 13

Yers, I think Parnassus and Python are just young, or rather they haven't been in the limelight and haven't had as many "3rd party" developers making good modules for it for as long.

The PDO project does look very promising, though in a way it'd be nice if they made it as similar as possible to the Perl DBI system, which is also AFAIK similar to something in C.

November 26th, 2003, 03:34 PM

netytan

Hello World :)

Join Date: Mar 2003

Location: Hull, UK

Posts: 2,537

Time spent in forums: 1 Week 2 Days 18 h 17 m 47 sec
Reputation Power: 68

def, just wait till Python hits the big screen, and i know it will eventually

Yeah, would be nice if we could keep the DBI the same (or as close as poss) for all/most langs, this way if you know DBI in one you know it in the other