Hi there
I just completed the Object Relational Tutorial [1] and want to use
that knowledge to start a little project of mine.
So I have a customer table in my database, and I want a "helper
function" that converts the password to a SHA1 hash and performs other
things. This is just a simple example and I wanted to ask you guys how
I should do this.
So my table just looks like this:
customer_table = Table(
'customer', metadata,
Column('id', Integer, primary_key=True),
Column('login', Unicode(25), nullable=False),
Column('password', Unicode(40), nullable=False),
Column('firstname', Unicode(40), nullable=False),
Column('lastname', Unicode(40), nullable=False),
Column('street', Unicode(40)),
Column('zip', Unicode(10)),
Column('city', Unicode(40)),
Column('country_id', Integer, ForeignKey('country.id')),
Column('phonebusiness', Unicode(20)),
Column('phoneprivate', Unicode(20)),
Column('phonemobile', Unicode(20)),
)
Then follows a class definition "Customer", from what I've learnt in
the tutorial:
class Customer(object):
def __init__(self, login, password, firstname, lastname, street,
plz, city):
self.login = login
self.password = password
self.firstname = firstname
self.lastname = lastname
self.street = street
self.zip = zip
self.city = city
self.phonebusiness = phonebusiness
self.phoneprivate = phoneprivate
self.phonemobile = phonemobile
def __repr__(self):
return "<Customer('%s', '%s')>" % (self.login, self.password)
I know how to query the database, and to add a new database entry. But
I really wanna know where my helper code goes. My idea is that there
is a function addCustomer() in the Customer class, but I tried this
out and it didnt work. Any suggestions or examples how to proceed?
Thanks!
[1] http://www.sqlalchemy.org/docs/05/ormtutorial.html
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
