[Dbix-class] NOT operator for SQLA

Ivan Fomichev ifomichev at gmail.com
Thu Jul 30 06:16:39 GMT 2009


Hello,

Is there a conceptual obstacle to introduce NOT operator, that accepts
hashref as an argument, like this:

  my ($where, @bind) = $sql->where(
      {
          -not => {
              id => {
                  '>' => 5,
                  '<' => 10,
              }
          }
      }
  );
  is_deeply(
      [$where, @bind],
      [' WHERE ( NOT ( ( id < ? AND id > ? ) ) )', 10, 5],
      '-not');


Regards,
Ivan



More information about the DBIx-Class mailing list