Biz.ListModel
-
The query interface to the database.
-
Paging
-
Sorting
-
Customizable to any data source
internal_initialize()
declares attributes of the model (columns in the SQL SELECT statement)
express joins via equivalences
the columns actually selected in the resulting SQL join are sparse (whereas many ORM tools select every column for every table included in the join)
internal_prepare_statement()
used for expressing more complex joins than can be done with simple equivalences.
e.g. outer joins or greater than or less than or between kinds of clauses
internal_load_rows()
ability to completely override the results from SQL
provides a hook to allow us to query different kinds of data stores
must return an array ref of hashes whose keys match the declarations in internal_initialize.
internal_post_load_row()
mainly used for filtering the result set in perl, for places where SQL is insufficient or where perl would be less complex than the SQL
load_all() (and variations)
execute_load_all()
execute_load_all_with_query()
execute_unauth_load_all_with_query()
load_all()
unauth_load_all()
load_page() (and variations)
we have a built-in notion of paging through large data sets
prevents run-away queries, and keeps UI more responsive
execute_load_page()
execute_unauth_load_page()
load_page()
unauth_load_page()
load_this() (and variations)
If you display a list of things, you almost always want to be able to drill into the details for one of those things. Here's where we do that.
execute_load_this()
execute_load_this_or_first()
load_this()
unsafe_load_this()
load_this_or_first()
unsafe_load_this_or_first()
do_rows() (and other iterations)
Various ways to iterate the result set.
If you have a list of things, you want to be able to operate on the collection or subsets of the collection.
map_rows()
do_iterate()
map_iterate()
- Model.EmailAliasList
- Model.RealmUserList
- Model.BlogList
- Model.NumberedList
- Model.StringArrayList
- Model.SearchList
(Click for larger view)