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)
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)
