Fix incorrect title in Transactions.pod

Re-add update example using existing field
Update to 1.2

diff --git a/Makefile.PL b/Makefile.PL
index fc8e635..afa68c2 100644 (file)
--- a/Makefile.PL
+++ b/Makefile.PL
@@ -5,7 +5,6 @@ use 5.006;
 
 use inc::Module::Install '1.01';
 
-version  '1.0';
 all_from 'lib/DBIx/Class/Manual/SQLHackers.pod';
 
 homepage 'http://dbix-class.org/manual/';

diff --git a/NOTES.txt b/NOTES.txt
index 8bf578f..115251c 100644 (file)
--- a/NOTES.txt
+++ b/NOTES.txt
@@ -1,41 +1,5 @@
 ## Removed from UPDATE.pod:
 
-=head2 Update a row or rows using a column calculation
-
-    -- Yet another pointless example
-    UPDATE users
-    SET username = username || '.uk'
-    WHERE id = 1;
-
-=over
-
-=item 1. Create a Schema object representing the database you are working with:
-
-        my $schema = MyDatabase::Schema->connect('dbi:SQLite:my.db');
-
-=item 2. Call the B<find> method on the resultset for the L<ResultSource|DBIx::Class::ResultSource> you wish to fetch data from:
-
-        my $fred_user = $schema->resultset('User')->find({ id => 1 });
-
-The Row object has an B<update> method that will change the values on
-the object, and send an UPDATE query to the database.
-
-=item 3. Call the B<update> method, passing it a hashref of new data:
-
-# this won't yet work, DBIC for now mandates the [ {} => $value ] format, the simple \[ $sql, $value1, $value2 ] will start being recognized later on 
-# the only documentation we currently have is this, if you can turn it into a DBIC pod-patch it will be freaking awesome
-# https://github.com/dbsrgits/dbix-class/commit/0e773352
-        $fred_user->update({ username => \['username || ?', '.uk'] }); 
-
-^^ you never got around to this
-
-# the DBIC syntax is a tad different from te thing above (i.e. we no longer encourage 'dummy' crap)
-The \[ .. ] syntax here is described in L<SQL::Abstract>
-documentation, used for passing bind parameters.
-
-
-=back
-
 =head2 Update a row based on data in other tables
 
     -- Slightly less pointless example

diff --git a/lib/DBIx/Class/Manual/SQLHackers.pod b/lib/DBIx/Class/Manual/SQLHackers.pod
index eff76b1..5ece11c 100644 (file)
--- a/lib/DBIx/Class/Manual/SQLHackers.pod
+++ b/lib/DBIx/Class/Manual/SQLHackers.pod
@@ -1,6 +1,6 @@
 package DBIx::Class::Manual::SQLHackers;
 
-our $VERSION = '1.1';
+our $VERSION = '1.2';
 
 =head1 NAME
 

diff --git a/lib/DBIx/Class/Manual/SQLHackers/Transactions.pod b/lib/DBIx/Class/Manual/SQLHackers/Transactions.pod
index c7bedb2..ad1552a 100644 (file)
--- a/lib/DBIx/Class/Manual/SQLHackers/Transactions.pod
+++ b/lib/DBIx/Class/Manual/SQLHackers/Transactions.pod
@@ -1,6 +1,6 @@
 =head1 NAME
 
-DBIx::Class::Manual::SQLHackers::DELETE - DBIx::Class for SQL Hackers - DELETE
+DBIx::Class::Manual::SQLHackers::Transactions - DBIx::Class for SQL Hackers - DELETE
 
 =over
 

diff --git a/lib/DBIx/Class/Manual/SQLHackers/UPDATE.pod b/lib/DBIx/Class/Manual/SQLHackers/UPDATE.pod
index 1620acd..ac291cb 100644 (file)
--- a/lib/DBIx/Class/Manual/SQLHackers/UPDATE.pod
+++ b/lib/DBIx/Class/Manual/SQLHackers/UPDATE.pod
@@ -112,6 +112,36 @@ the object, and send an UPDATE query to the database.
 
 See also: L</Direct update versus delayed update>.
 
+## Removed from UPDATE.pod:
+
+=head2 Update a row or rows using a column calculation
+
+    -- Yet another pointless example
+    UPDATE users
+    SET username = username || '.uk'
+    WHERE id = 1;
+
+=over
+
+=item 1. Create a Schema object representing the database you are working with:
+
+        my $schema = MyDatabase::Schema->connect('dbi:SQLite:my.db');
+
+=item 2. Call the B<find> method on the resultset for the L<ResultSource|DBIx::Class::ResultSource> you wish to fetch data from:
+
+        my $fred_user = $schema->resultset('User')->find({ id => 1 });
+
+The Row object has an B<update> method that will change the values on
+the object, and send an UPDATE query to the database.
+
+=item 3. Call the B<update> method, passing it a hashref of new data:
+
+        $fred_user->update({ username => \['username || ?', [ {} =>  '.uk'] ] }); 
+
+The \[ .. ] syntax here is base on L<SQL::Abstract/Literal SQL with placeholders and bind values (subqueries)>, and adds some extra syntax for the "values" to be able to supply things like the exact SQL bind type and so on. This extra syntax will be documented in DBIx::Class soon.
+
+=back
+
 =head2 Update multiple rows with simple values
 
     -- Warning, pointless example!