Migrate -ident and -value from dbic, reorganize docs

[scpubgit/Q-Branch.git] / t / 21op_ident.t

diff --git a/t/21op_ident.t b/t/21op_ident.t
new file mode 100644 (file)
index 0000000..5ba3f27
--- /dev/null
+++ b/t/21op_ident.t
@@ -0,0 +1,41 @@
+use strict;
+use warnings;
+
+use Test::More;
+use SQL::Abstract;
+use SQL::Abstract::Test import => [qw/is_same_sql_bind/];
+
+
+for my $q ('', '"') {
+  my $sql_maker = SQL::Abstract->new(
+    quote_char => $q,
+    name_sep => $q ? '.' : '',
+  );
+
+  my ($sql, @bind) = $sql_maker->select ('artist', '*', { 'artist.name' => { -ident => 'artist.pseudonym' } } );
+  is_same_sql_bind (
+    $sql,
+    \@bind,
+    "SELECT *
+      FROM ${q}artist${q}
+      WHERE ${q}artist${q}.${q}name${q} = ${q}artist${q}.${q}pseudonym${q}
+    ",
+    [],
+  );
+
+  ($sql, @bind) = $sql_maker->update ('artist',
+    { 'artist.name' => { -ident => 'artist.pseudonym' } },
+    { 'artist.name' => { '!=' => { -ident => 'artist.pseudonym' } } },
+  );
+  is_same_sql_bind (
+    $sql,
+    \@bind,
+    "UPDATE ${q}artist${q}
+      SET ${q}artist${q}.${q}name${q} = ${q}artist${q}.${q}pseudonym${q}
+      WHERE ${q}artist${q}.${q}name${q} != ${q}artist${q}.${q}pseudonym${q}
+    ",
+    [],
+  );
+}
+
+done_testing;