def export_to_file(filename): fieldnames = ['card_id', 'image_id'] with open(filename, 'wb') as file: writer = csv_utf.UnicodeWriter(file) writer.writerow(fieldnames) session = DBSession() images = [[cards_image.card_id, cards_image.image_id] for cards_image in session.query(CardsImages).order_by( CardsImages.card_id, CardsImages.image_id).all()] session.close() writer.writerows(images)
def export_to_file(filename): fieldnames = ['id', 'name', 'description', 'url', 'local', 'size'] with open(filename, 'wb') as file: writer = csv_utf.UnicodeWriter(file) writer.writerow(fieldnames) session = DBSession() images = [[ image.id, image.name, image.description, image.url, image.local, image.size ] for image in session.query(Images).order_by(Images.id).all()] session.close() writer.writerows(images)
def update_csv(initial_data_dir_name): from nextgisbio.utils import csv_utf for csv_file_name, new_csv_data in data.iteritems(): csv_path = path.join(initial_data_dir_name, csv_file_name) with open(csv_path, "w"): pass with open(csv_path, 'wb') as csv_file: writer = csv_utf.UnicodeWriter(csv_file) for new_csv_data_row in new_csv_data: writer.writerow(new_csv_data_row) print '%s updated successfully.' % csv_file_name
def export_to_file(filename): from nextgisbio.utils import csv_utf fieldnames = Cards.get_all_fields_names() with open(filename, 'wb') as file: writer = csv_utf.UnicodeWriter(file) writer.writerow(fieldnames) dbsession = DBSession() cards = [ card.to_row() for card in dbsession.query(Cards).order_by(Cards.id).all() ] dbsession.close() writer.writerows(cards)
def export_to_file(filename): fieldnames = ['id', 'species', 'inserter', 'key_area', 'identifier', 'collecter', 'biblioref', 'original_name', 'location', 'lon', 'lat', 'biotop', 'difference', 'substrat', 'status', 'frequency', 'quantity', 'annotation', 'infosourse', 'year', 'month', 'day', 'exposure'] with open(filename, 'wb') as file: writer = csv_utf.UnicodeWriter(file) writer.writerow(fieldnames) dbsession = DBSession() annotations = [[ann.id, ann.species, ann.inserter, ann.key_area, ann.identifier, ann.collecter, ann.biblioref, ann.original_name, ann.location, ann.lon, ann.lat, ann.biotop, ann.difference, ann.substrat, ann.status, ann.frequency, ann.quantity, ann.annotation, ann.infosourse, ann.year, ann.month, ann.day, ann.exposure] for ann in dbsession.query(Annotation).order_by(Annotation.id).all()] writer.writerows(annotations)
def dump(filename, attributes, objects, fieldnames=None, is_array=False): from nextgisbio.utils import csv_utf with open(filename, 'wb') as file: writer = csv_utf.UnicodeWriter(file) if fieldnames: writer.writerow(fieldnames) else: writer.writerow(attributes) if is_array: writer.writerows(objects) return object_rows = [] for object in objects: object_as_array = [] for attribute_name in attributes: object_as_array.append(getattr(object, attribute_name)) object_rows.append(object_as_array) writer.writerows(object_rows)