← Back to branch summary

~jkakar/storm/fluidinfo-trunk

« back to all changes in this revision

Viewing changes to tests/store/mysql.py

  • Committer: Thomas Hervé
  • Date: 2008-06-27 16:52:34 UTC
  • mfrom: (215.8.19 resultset-groupby-2)
  • Revision ID: thomas@canonical.com-20080627165234-gun27a97rtktz2jk
Merge resultset-groupby-2 [f=233946] [r=jamesh,radix,niemeyer]

Add group_by and having methods on the ResultSet object, giving access to the
GROUP BY and HAVING features after calling store.find().

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/store/mysql.py
71
71
                           " INDEX (selfref_id),"
72
72
                           " FOREIGN KEY (selfref_id) REFERENCES selfref(id)) "
73
73
                           "ENGINE=InnoDB")
 
74
        connection.execute("CREATE TABLE foovalue "
 
75
                           "(id INT PRIMARY KEY AUTO_INCREMENT,"
 
76
                           " foo_id INTEGER,"
 
77
                           " value1 INTEGER, value2 INTEGER)")
74
78
        connection.commit()
75
79
 
76
80