undocumented example in DBIx::Class

tqisjim has asked for the wisdom of the Perl Monks concerning the following question:

http://search.cpan.org/~ribasushi/DBIx-Class-0.08270/lib/DBIx/Class/ResultSet.pm#alias

There's an example on this page that uses the -not-exists operator.

I can't find any documentation for that operator anywhere in SQL::Abstract. Does anybody know if -not-exists and -exists operators are supported anywhere in DBIx::Class?

Comment on undocumented example in DBIx::Class Select or Download Code

Replies are listed 'Best First'.
Re: undocumented example in DBIx::Class ( -not-exists ) by Anonymous Monk on Apr 23, 2014 at 22:06 UTC
http://search.cpan.org/dist/DBIx-Class/ http://search.cpan.org/grep?cpanid=RIBASUSHI&release=DBIx-Class-0.08270&string=not_&i=1&n=1&C=0 `lib/DBIx/Class/Manual/Cookbook.pod 83:_not_ accept search attributes. However one can always chain a sing +le() to 337:The usual operators ( '=', '!=', -in, -not_in, etc.) are supported +.` [download] http://search.cpan.org/dist/SQL-Abstract/ http://search.cpan.org/grep?cpanid=RIBASUSHI&release=SQL-Abstract-1.77&string=not_&i=1&n=1&C=0 `lib/SQL/Abstract.pm 2228:The reverse operator C<-not_in> generates SQL C<NOT IN> and is us +ed in 2232:(by default : C<1=0>). Similarly, C<< -not_in => [] >> generates 2257:Another pair of operators is C<-between> and C<-not_between>, 2263: -not_between => ['2002-10-01', '2003-02-06'] 2301:database you can use the C<-bool> and C<-not_bool> operators.` [download]	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re: undocumented example in DBIx::Class ( -not-exists )
by Anonymous Monk on Apr 23, 2014 at 22:06 UTC

http://search.cpan.org/dist/DBIx-Class/

http://search.cpan.org/grep?cpanid=RIBASUSHI&release=DBIx-Class-0.08270&string=not_&i=1&n=1&C=0

lib/DBIx/Class/Manual/Cookbook.pod
83:_not_ accept search attributes. However one can always chain a sing
+le() to
337:The usual operators ( '=', '!=', -in, -not_in, etc.) are supported
+.
[download]

http://search.cpan.org/dist/SQL-Abstract/

http://search.cpan.org/grep?cpanid=RIBASUSHI&release=SQL-Abstract-1.77&string=not_&i=1&n=1&C=0

 lib/SQL/Abstract.pm 
2228:The reverse operator C<-not_in> generates SQL C<NOT IN> and is us
+ed in
2232:(by default : C<1=0>). Similarly, C<< -not_in => [] >> generates
2257:Another pair of operators is C<-between> and C<-not_between>,
2263:           -not_between => ['2002-10-01', '2003-02-06']
2301:database you can use the C<-bool> and C<-not_bool> operators.
[download]

[reply]
[d/l]
[select]