def add_dns_record(cls, domain_id, record, ttl, type, value, line):
sql = "insert into dns_record (domain_id, record, ttl, type, value, create_time, state, line) values (%s, %s, %s, %s, %s, now(), '1', %s)"
rows = db_conn.insert(sql, (domain_id, record, ttl, type, value, line))
sql = "select max(id) from dns_record"
rows = db_conn.query_all(sql)
return rows[0][0]
def update_dns_record(cls, domain_id, record_id, record, ttl, type, value, line):
sql = "update dns_record set record=%s, ttl=%s, type=%s, value=%s, line=%s where domain_id=%s and id=%s"
rows = db_conn.insert(sql, (record, ttl, type, value, line, domain_id, record_id))
return True
