X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FManual%2FCookbook.pod;h=c18ab66a5663ca7b40bbb95157c91e5390afffe9;hb=5529838f7afff91467ef2664087999ab222da48d;hp=0cb560bdf9b9f84bf982e706e062f5d99a4b2060;hpb=a9697bd06f21230c6c98cbade589374103d16a0e;p=dbsrgits%2FDBIx-Class.git diff --git a/lib/DBIx/Class/Manual/Cookbook.pod b/lib/DBIx/Class/Manual/Cookbook.pod index 0cb560b..c18ab66 100644 --- a/lib/DBIx/Class/Manual/Cookbook.pod +++ b/lib/DBIx/Class/Manual/Cookbook.pod @@ -146,8 +146,9 @@ Next, you can execute your complex query using bind parameters like this: ); ... and you'll get back a perfect L (except, of course, -that you cannot modify the rows it contains, e.g. cannot call L, -L, ... on it). +that you cannot modify the rows it contains, e.g. cannot call +L or +L on it). Note that you cannot have bind parameters unless is_virtual is set to true. @@ -448,8 +449,8 @@ See also L is either too slow or does -not work at all, you can try the +and L is either +too slow or does not work at all, you can try the L L attribute, which skips over records to simulate limits in the Perl layer. @@ -1065,7 +1066,7 @@ See L for more documentation. Sometimes you have a (set of) result objects that you want to put into a resultset without the need to hit the DB again. You can do that by using the -L method: +L method: my @uploadable_groups; while (my $group = $groups->next) { @@ -1380,9 +1381,11 @@ row. } In this example it might be hard to see where the rollbacks, releases and -commits are happening, but it works just the same as for plain L<>: If -the C-block around C fails, a rollback is issued. If the C -succeeds, the transaction is committed (or the savepoint released). +commits are happening, but it works just the same as for plain +L: If the L-block +around L fails, a rollback is issued. +If the L succeeds, the transaction is committed +(or the savepoint released). While you can get more fine-grained control using C, C and C, it is strongly recommended to use C with coderefs. @@ -1840,7 +1843,7 @@ See L for further details. =head3 Oracle Information about Oracle support for unicode can be found in -L. +L. =head3 PostgreSQL @@ -2202,10 +2205,9 @@ classes dynamically based on the database schema then there will be a significant startup delay. For production use a statically defined schema (which can be generated -using L to dump -the database schema once - see +using L to dump the database schema once - see L and -L for more +L for more details on creating static schemas from a database). =head2 Move Common Startup into a Base Class @@ -2251,10 +2253,11 @@ avoiding L. =head2 Cached statements -L normally caches all statements with L<< prepare_cached()|DBI/prepare_cached >>. -This is normally a good idea, but if too many statements are cached, the database may use too much -memory and may eventually run out and fail entirely. If you suspect this may be the case, you may want -to examine DBI's L<< CachedKids|DBI/CachedKidsCachedKids_(hash_ref) >> hash: +L normally caches all statements with +L. This is normally a good idea, but if +too many statements are cached, the database may use too much memory and may +eventually run out and fail entirely. If you suspect this may be the case, +you may want to examine DBI's L hash: # print all currently cached prepared statements print for keys %{$schema->storage->dbh->{CachedKids}};