def _put_all(self, kv_list, **kwargs):
    (id_name, feature_name_list, id_delimiter) = self._get_id_feature_name()
    (feature_sql, feature_list) = StorageTable.get_meta_header(feature_name_list)
    id_size = 'varchar(100)'
    create_table = 'create table if not exists {}({} {} NOT NULL, {} PRIMARY KEY({}))'.format(self._address.name, id_name, id_size, feature_sql, id_name)
    self._cur.execute(create_table)
    sql = 'REPLACE INTO {}({}, {})  VALUES'.format(self._address.name, id_name, ','.join(feature_list))
    for kv in kv_list:
        sql += '("{}", "{}"),'.format(kv[0], '", "'.join(kv[1].split(id_delimiter)))
    sql = (','.join(sql.split(',')[:(- 1)]) + ';')
    self._cur.execute(sql)
    self._con.commit()
def _put_all(self, kv_list, **kwargs):
    (id_name, feature_name_list, id_delimiter) = self._get_id_feature_name()
    (feature_sql, feature_list) = StorageTable.get_meta_header(feature_name_list)
    id_size = 'varchar(100)'
    create_table = 'create table if not exists {}({} {} NOT NULL, {} PRIMARY KEY({}))'.format(self._address.name, id_name, id_size, feature_sql, id_name)
    self._cur.execute(create_table)
    sql = 'REPLACE INTO {}({}, {})  VALUES'.format(self._address.name, id_name, ','.join(feature_list))
    for kv in kv_list:
        sql += '("{}", "{}"),'.format(kv[0], '", "'.join(kv[1].split(id_delimiter)))
    sql = (','.join(sql.split(',')[:(- 1)]) + ';')
    self._cur.execute(sql)
    self._con.commit()