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