[SQL-CVS] SQLObject/examples leftjoin.py,NONE,1.1 codebits.py,1.1,1.2

[<ian...@us...>]

Update of /cvsroot/sqlobject/SQLObject/examples
In directory sc8-pr-cvs1:/tmp/cvs-serv28975/examples

Modified Files:
	codebits.py 
Added Files:
	leftjoin.py 
Log Message:
Added a FAQ, with requisite examples


--- NEW FILE: leftjoin.py ---
from SQLObject import *

## Use one of these to define your connection:
"""
conn = MySQLConnection(user='test', db='testdb')
conn = PostgresConnection('user=test dbname=testdb')
conn = SQLiteConnect('database.db')
conn = DBMConnection('database/')
"""
__connection__ = MySQLConnection(user='test', db='test')


class Customer(SQLObject):

    firstName = StringCol(length=100)
    lastName = StringCol(length=100)
    contacts = MultipleJoin('Contact')

class Contact(SQLObject):

    customer = ForeignKey('Customer')
    phoneNumber = StringCol(length=20)

Customer.dropTable(ifExists=True)
Customer.createTable()
Contact.dropTable(ifExists=True)
Contact.createTable()

data = [
    ['Joe Henry', '384-374-3584', '984-384-8594', '384-957-3948'],
    ['Tim Jackson', '204-485-9384'],
    ['Jane Austin'],
    ]

for insert in data:
    firstName, lastName = insert[0].split(' ', 1)
    customer = Customer.new(firstName=firstName, lastName=lastName)
    for number in insert[1:]:
        contact = Contact.new(customer=customer, phoneNumber=number)

## Snippet "leftjoin-simple"
for customer in Customer.select():
    print customer.firstName, customer.lastName
    for contact in customer.contacts:
        print '   ', contact.phoneNumber
## end snippet

## Snippet "leftjoin-more"
custContacts = {}
for contact in Contact.select():
    custContacts.setdefault(contact.customerID, []).append(contact)
for customer in Customer.select():
    print customer.firstName, customer.lastName
    for contact in custContacts.get(customer.id, []):
        print '   ', contact.phoneNumber
## end snippet

## Snippet "leftjoin-more-query"
query = Customer.q.firstName.startswith('J')
custContacts = {}
for contact in Contact.select(AND(Contact.q.customerID == Customer.q.id,
                                  query)):
    custContacts.setdefault(contact.customerID, []).append(contact)
for customer in Customer.select(query):
    print customer.firstName, customer.lastName
    for contact in custContacts.get(customer.id, []):
        print '   ', contact.phoneNumber
## end snippet

Index: codebits.py
===================================================================
RCS file: /cvsroot/sqlobject/SQLObject/examples/codebits.py,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** codebits.py	28 Jun 2003 22:17:36 -0000	1.1
--- codebits.py	21 Aug 2003 05:02:17 -0000	1.2
***************
*** 81,82 ****
--- 81,222 ----
  ## end snippet
  
+ ## Snippet "site-sqlobject"
+ class SiteSQLObject(SQLObject):
+     _connection = DBConnection.MySQLConnection(user='test', db='test')
+     _style = MixedCaseStyle()
+ 
+     # And maybe you want a list of the columns, to autogenerate
+     # forms from:
+     def columns(self):
+         return [col.name for col in self._columns]
+ ## end snippet
+ 
+ ## Snippet "inheritance"
+ class Person(SQLObject):
+     firstName = StringCol()
+     lastName = StringCol()
+ 
+ class Employee(Person):
+     position = StringCol()
+ ## end snippet
+ 
+ """
+ ## Snippet "inheritance-schema"
+ CREATE TABLE person (
+     id INT PRIMARY KEY,
+     first_name TEXT,
+     last_name TEXT
+ );
+ 
+ CREATE TABLE employee (
+     id INT PRIMARY KEY
+     first_name TEXT,
+     last_name TEXT,
+     position TEXT
+ )
+ ## end snippet
+ """
+ 
+ ## Snippet "inheritance-faked"
+ class Person(SQLObject):
+     firstName = StringCol()
+     lastName = StringCol()
+     
+     def _get_employee(self):
+         value = Employee.selectBy(person=self)
+         if value:
+             return value[0]
+         else:
+             raise AttributeError, '%r is not an employee' % self
+     def _get_isEmployee(self):
+         value = Employee.selectBy(person=self)
+         # turn into a bool:
+         return not not value
+     def _set_isEmployee(self, value):
+         if value:
+             # Make sure we are an employee...
+             if not self.isEmployee:
+                 Empoyee.new(person=self, position=None)
+         else:
+             if self.isEmployee:
+                 self.employee.destroySelf()
+     def _get_position(self):
+         return self.employee.position
+     def _set_position(self, value):
+         self.employee.position = value
+ 
+ class Employee(SQLObject):
+     person = ForeignKey('Person')
+     position = StringCol()
+ ## end snippet
+ 
+ """
+ ## Snippet "composite-schema"
+ CREATE TABLE invoice_item (
+     id INT PRIMARY KEY,
+     amount NUMERIC(10, 2),
+     currency CHAR(3)
+ );
+ ## end snippet
+ """
+ 
+ ## Snippet "composite"
+ class InvoiceItem(SQLObject):
+     amount = Currency()
+     currency = StringChar(length=3)
+ 
+     def _get_price(self):
+         return Price(self.amount, self.currency)
+     def _set_price(self, price):
+         self.amount = price.amount
+         self.currency = price.currency
+ 
+ class Price(object):
+     def __init__(self, amount, currency):
+         self._amount = amount
+         self._currency = currency
+ 
+     def _get_amount(self):
+         return self._amount
+     amount = property(_get_amount)
+ 
+     def _get_currency(self):
+         return self._currency
+     currency = property(_get_currency)
+ 
+     def __repr__(self):
+         return '<Price: %s %s>' % (self.amount, self.currency)
+ ## end snippet
+ 
+ ## Snippet "composite-mutable"
+ class Address(SQLObject):
+     street = StringCol()
+     city = StringCol()
+     state = StringCol(length=2)
+     
+     latitude = FloatCol()
+     longitude = FloatCol()
+ 
+     def _init(self, id):
+         SQLObject._init(self, id)
+         self._coords = SOCoords(self)
+         
+     def _get_coords(self):
+         return self._coords
+ 
+ class SOCoords(object):
+     def __init__(self, so):
+         self._so = so
+ 
+     def _get_latitude(self):
+         return self._so.latitude
+     def _set_latitude(self, value):
+         self._so.latitude = value
+     latitude = property(_get_latitude, set_latitude)
+ 
+     def _get_longitude(self):
+         return self._so.longitude
+     def _set_longitude(self, value):
+         self._so.longitude = value
+     longitude = property(_get_longitude, set_longitude)
+ ## end snippet