Home > net-ldap-filter-sql

net-ldap-filter-sql

Net-ldap-filter-sql is a project mainly written in Perl, it's free.

Net::LDAP::Filter to SQL clause transformer

Net::LDAP::Filter::SQL

Synopsis


my $ldapfilter = new Net::LDAP::Filter::SQL('(&(name=Marge)(city=Springfield))');

my $sql = 'select * from sometable where '.$ldapfilter->sql_clause;

$dbh->selectall_arrayref($sql, undef, $ldapfilter->sql_values);

Data tranformation

.source data

"(&(name=Marge)(city=Springfield))";

.target data

['name = ? and city = ?', ['Marge', 'Springfield'] ]

// vim: syn=asciidoc