X-Git-Url: https://git.stderr.nl/gitweb?p=matthijs%2Fupstream%2Fdjango-ldapdb.git;a=blobdiff_plain;f=ldapdb%2Fmodels%2Fquery.py;h=d49b44a41d1977c8b37fdd6266b3df9fca662bfb;hp=b35c12311d29bead6b88b0ebba43f74b4ee681e1;hb=c04580563f978929bc4f06dfa85ea7a26248d688;hpb=6baded55b00e883c2612c013b884e8135baeaebe diff --git a/ldapdb/models/query.py b/ldapdb/models/query.py index b35c123..d49b44a 100644 --- a/ldapdb/models/query.py +++ b/ldapdb/models/query.py @@ -75,11 +75,12 @@ class WhereNode(BaseWhereNode): obj = Constraint(obj.alias, obj.col, obj.field) super(WhereNode, self).add((obj, lookup_type, value), connector) - def as_sql(self): + def as_sql(self, qn=None, connection=None): bits = [] for item in self.children: - if isinstance(item, WhereNode): - bits.append(item.as_sql()) + if hasattr(item, 'as_sql'): + sql, params = item.as_sql(qn=qn, connection=connection) + bits.append(sql) continue constraint, lookup_type, y, values = item @@ -106,19 +107,42 @@ class WhereNode(BaseWhereNode): else: bits.append(clause) if len(bits) == 1: - return bits[0] + sql_string = bits[0] elif self.connector == AND: - return '(&%s)' % ''.join(bits) + sql_string = '(&%s)' % ''.join(bits) elif self.connector == OR: - return '(|%s)' % ''.join(bits) + sql_string = '(|%s)' % ''.join(bits) else: raise Exception("Unhandled WHERE connector: %s" % self.connector) + return sql_string, [] class Query(BaseQuery): + def __init__(self, *args, **kwargs): + super(Query, self).__init__(*args, **kwargs) + self.connection = ldapdb.connection + + def get_count(self): + filterstr = ''.join(['(objectClass=%s)' % cls for cls in self.model.object_classes]) + sql, params = self.where.as_sql() + filterstr += sql + filterstr = '(&%s)' % filterstr + + try: + vals = ldapdb.connection.search_s( + self.model.base_dn, + ldap.SCOPE_SUBTREE, + filterstr=filterstr, + attrlist=[], + ) + except: + raise self.model.DoesNotExist + + return len(vals) + def results_iter(self): - # FIXME: use all object classes - filterstr = '(objectClass=%s)' % self.model.object_classes[0] - filterstr += self.where.as_sql() + filterstr = ''.join(['(objectClass=%s)' % cls for cls in self.model.object_classes]) + sql, params = self.where.as_sql() + filterstr += sql filterstr = '(&%s)' % filterstr attrlist = [ x.db_column for x in self.model._meta.local_fields if x.db_column ] @@ -161,20 +185,22 @@ class Query(BaseQuery): for field in iter(self.model._meta.fields): if field.attname == 'dn': row.append(dn) + elif hasattr(field, 'from_ldap'): + row.append(field.from_ldap(attrs.get(field.db_column, []), connection=ldapdb.connection)) else: - row.append(attrs.get(field.db_column, None)) + row.append(None) yield row class QuerySet(BaseQuerySet): def __init__(self, model=None, query=None, using=None): if not query: import inspect - spec = inspect.getargspec(Query.__init__) + spec = inspect.getargspec(BaseQuery.__init__) if len(spec[0]) == 3: # django 1.2 query = Query(model, WhereNode) else: # django 1.1 query = Query(model, None, WhereNode) - super(QuerySet, self).__init__(model, query) + super(QuerySet, self).__init__(model=model, query=query)