pf::SearchBuilder An SQL select query builder inspired by Fey
use pf::SearchBuilder;
new $builder = new pf::SearchBuilder;
$builder ->select(qw( mac pid voip bypass_vlan status category_id detect_date regdate unregdate lastskip user_agent computername dhcp_fingerprint last_arp last_dhcp notes) )->from( 'node', { 'join' => 'LEFT', table => 'node_category', using => 'category_id' }, )->where( 'mac','=','00:00:00:00:00:00:' )->and( 'category','LIKE','gaming_%' );
my $sql = $builder->sql();
pf::SearchBuilder
A convenience function for creating literals my $builder = new pf::SearchBuilder; $builder ->select(L_("count(*)") => 'node_count') ->from('node'); my $sql = $builder->sql();
Some syntax sugar for where('and')
Some syntax sugar for where('or)
Inverse inc. <info@inverse.ca>
Copyright (C) 2005-2015 Inverse inc.
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.