Miscellany

  def insert(self, table, dict):
    sql_key = ""
    sql_value = ""
    for key,value in dict.items():
      sql_key += key + ", "
      sql_value += "'" + str(value) + "', ";
    sql_key = sql_key[:-2]
    sql_value = sql_value[:-2]
    sql = "INSERT INTO " + table + " (" + sql_key + ") VALUES (" + sql_value + ")"
    self.query(sql);
    self.link.commit()