def get_records(self): return (ModelRecord.select(ModelDomain, ModelRecord).join( ModelDomain, on=ModelDomain.domain_id == ModelRecord.domain_id).where( ModelDomain.status == 'active').order_by( ModelDomain.domain.asc(), ModelRecord.type.asc(), ModelRecord.host.asc(), ModelRecord.val.asc()))
def get_records(self): return ( ModelRecord.select(ModelDomain, ModelRecord) .join( ModelDomain, on=ModelDomain.domain_id == ModelRecord.domain_id ) .where(ModelDomain.status == 'active') .order_by( ModelDomain.domain.asc(), ModelRecord.type.asc(), ModelRecord.host.asc(), ModelRecord.val.asc() ) )
def count_records(self, filter_record_type, search_name=None, search_value=None): if not self.domain_id: raise Exception("Cannot get records, domain_id is not set") query = Record.select(Record).where(Record.domain_id == self.domain_id) if filter_record_type is not None: query = query.where(Record.type == RecordType().set(filter_record_type)) if search_name is not None: query = query.where((Record.host ** ("%" + search_name + "%"))) if search_value is not None: query = query.where((Record.val ** ("%" + search_value + "%"))) return query.count()
def count_records(self, filter_record_type, search_name=None, search_value=None): if not self.domain_id: raise Exception("Cannot get records, domain_id is not set") query = Record.select(Record).where(Record.domain_id == self.domain_id) if filter_record_type is not None: query = query.where( Record.type == RecordType().set(filter_record_type)) if search_name is not None: query = query.where((Record.host**('%' + search_name + '%'))) if search_value is not None: query = query.where((Record.val**('%' + search_value + '%'))) return query.count()
def get_records(self): if not self.domain_id: raise Exception("Cannot get records, domain_id is not set") return Record.select(Record).where(Record.domain_id == self.domain_id)