def get_records_by_zone(zone):
zone_id = zone_model.get_zone_id(zone)
query = 'SELECT * FROM "record" WHERE "zone_id"=%(zone_id)s'
value = {"zone_id": zone_id}
records = model.plain_get("record", query, value)
return records
def delete(self):
"""Remove domain (zone) and all its related records."""
parser = reqparse.RequestParser()
parser.add_argument("zone", type=str, required=True)
args = parser.parse_args()
zone = args["zone"]
try:
zone_id = zone_model.get_zone_id(zone)
except Exception:
return response(404, message=f"Zone Not Found")
try:
records = record_model.get_records_by_zone(zone)
for record in records:
# zone-purge didn't work
# all the records must be unset one-by-one. otherwise old record
# will appear again if the same zone name crated.
command.set_zone(record["id"], "zone-unset")
command.set_config(zone, zone_id, "conf-unset")
# other data (e.g record) deleted automatically
# by cockroach when no PK existed
model.delete(table="zone", field="id", value=zone_id)
return response(204, data=zone)
except Exception as e:
current_app.logger.error(f"{e}")
return response(500)
def post(self):
"""Add new record.
note:
Adding any record with other record is allowed. IETF best practice
is not handled automatically. Knot didn't handle this too, and let the
user know the standards themselves.
See https://tools.ietf.org/html/rfc1912
"""
parser = reqparse.RequestParser()
parser.add_argument("zone", type=str, required=True)
parser.add_argument("owner", type=str, required=True)
parser.add_argument("rtype", type=str, required=True)
parser.add_argument("rdata", type=str, required=True)
parser.add_argument("ttl", type=str, required=True)
args = parser.parse_args()
owner = args["owner"].lower()
rtype = args["rtype"].lower()
rdata = args["rdata"]
zone = args["zone"]
ttl = args["ttl"]
try:
ttl_id = ttl_model.get_ttlid_by_ttl(ttl)
type_id = type_model.get_typeid_by_rtype(rtype)
zone_id = zone_model.get_zone_id(zone)
except Exception as e:
return response(404, message=f"{e}")
try:
rules.check_add(rtype, zone_id, type_id, owner, rdata, ttl_id)
except Exception as e:
return response(409, message=f"{e}")
try:
# rtype no need to be validated & no need to check its length
# `get_typeid` will raise error for non existing rtype
validator.validate(rtype, rdata)
validator.validate("owner", owner)
except Exception as e:
return response(422, message=f"{e}")
try:
serial_resource = get_serial_resource(zone)
check_serial_limit(serial_resource)
except Exception as e:
return response(429, message=f"{e}")
try:
data = {
"owner": owner,
"zone_id": zone_id,
"type_id": type_id,
"ttl_id": ttl_id,
}
record_id = model.insert(table="record", data=data)
content_data = {"rdata": rdata, "record_id": record_id}
model.insert(table="rdata", data=content_data)
command.set_zone(record_id, "zone-set")
# increment serial after adding new record
rtype = type_model.get_type_by_recordid(record_id)
if rtype != "SOA":
update_serial(serial_resource)
record = model.get_one(table="record", field="id", value=record_id)
data = record_model.get_other_data(record)
return response(201, data=data)
except Exception as e:
current_app.logger.error(f"{e}")
return response(500)
def put(self, record_id):
parser = reqparse.RequestParser()
parser.add_argument("zone", type=str, required=True)
parser.add_argument("owner", type=str, required=True)
parser.add_argument("rtype", type=str, required=True)
parser.add_argument("rdata", type=str, required=True)
parser.add_argument("ttl", type=str, required=True)
args = parser.parse_args()
owner = args["owner"].lower()
rtype = args["rtype"].lower()
rdata = args["rdata"]
zone = args["zone"]
ttl = args["ttl"]
try:
ttl_id = ttl_model.get_ttlid_by_ttl(ttl)
record_model.is_exists(record_id)
type_id = type_model.get_typeid_by_rtype(rtype)
zone_id = zone_model.get_zone_id(zone)
except Exception as e:
return response(404, message=f"{e}")
try:
rules.check_edit(rtype, zone_id, type_id, owner, rdata, ttl_id, record_id)
except Exception as e:
return response(409, message=f"{e}")
try:
validator.validate(rtype, rdata)
validator.validate("owner", owner)
except Exception as e:
return response(422, message=f"{e}")
try:
serial_resource = get_serial_resource(zone)
check_serial_limit(serial_resource)
except Exception as e:
return response(429, message=f"{e}")
try:
data = {
"where": {"id": record_id},
"data": {
"owner": owner,
"zone_id": zone_id,
"type_id": type_id,
"ttl_id": ttl_id,
},
}
content_data = {
"where": {"record_id": record_id},
"data": {"rdata": rdata, "record_id": record_id},
}
command.set_zone(record_id, "zone-unset")
model.update("rdata", data=content_data)
model.update("record", data=data)
command.set_zone(record_id, "zone-set")
# increment serial after adding new record
rtype = type_model.get_type_by_recordid(record_id)
if rtype != "SOA":
update_serial(serial_resource, "02")
record = model.get_one(table="record", field="id", value=record_id)
data_ = record_model.get_other_data(record)
return response(200, data=data_)
except Exception as e:
current_app.logger.error(f"{e}")
return response(500)
