Chapter 11. Mastering SQLObject


In This Chapter

  • 11.1 Mapping Relationships 166

  • 11.2 Straight SQL Queries 171

  • 11.3 Smart Queries 172

  • 11.4 Working with Large Result Sets 177

  • 11.5 Summary 182

SQLObject provides a simple object-oriented view of your tables, but if that were all it could do we'd still be in trouble. Sometimes you need to create one-to-many relationships, create complex queries, or handle very large datasets without bringing your server to its knees. Fortunately SQLObject has features that make all these tasks not only possible, but relatively easy.

Now that we know the basics of SQLObject, we can delve into a few of its more interesting capabilities. In this chapter, we look at how to set up relationships between tables, how to handle more complex database queries, and how to optimize queries for large or complex datasets.

We also take a deeper look at how sqlobject classes work, and how to modify the default behavior of SQLObjects using the sqlmeta class. Among other things, this is a critical piece of knowledge if you ever need to create model objects to match a "legacy" database.




Rapid Web Applications with TurboGears(c) Using Python to Create Ajax-Powered Sites
Rapid Web Applications with TurboGears: Using Python to Create Ajax-Powered Sites
ISBN: 0132433885
EAN: 2147483647
Year: 2006
Pages: 202

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net