def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
dbsession = DBSession()
redbook_species_db = dbsession.query(RedBook, RedBookSpecies, Taxon)\
.join(RedBookSpecies, RedBook.id == RedBookSpecies.red_book_id)\
.join(Taxon, RedBookSpecies.specie_id == Taxon.id)\
.order_by(RedBook.id, RedBookSpecies.specie_id)\
.all()
dbsession.close()
attribute_names = ['region', 'orig_name', 'lat_name', 'author', 'population', 'status', 'univ_status', 'year',
'bibl']
objects_for_dump = [
[
o[1].region,
o[1].orig_name,
o[2].name,
o[1].author,
o[1].population,
o[1].status,
o[1].univ_status,
o[1].year,
o[0].name
] for o in redbook_species_db
]
dump(filename, attribute_names, objects_for_dump, is_array=True)
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'doc_type_id', 'filename', 'fullname',
'author', 'magazine', 'pages', 'mammals', 'birds',
'reptiles', 'amphibians', 'fish', 'invertebrates', 'vascular',
'bryophytes', 'lichens', 'fungi', 'maps']
dump(filename, fieldnames, DBSession().query(Inforesources).order_by(Inforesources.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = [
'id', 'parent_id', 'old_id', 'taxon_type', 'name', 'russian_name',
'author', 'source'
]
dump(filename, fieldnames,
DBSession().query(Taxon).order_by(Taxon.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = [
'id', 'name', 'fullname', 'speciality', 'degree', 'organization',
'position', 'email', 'phone', 'address'
]
dbsession = DBSession()
dump(filename, fieldnames,
dbsession.query(Person).order_by(Person.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = [
'id', 'doc_type_id', 'filename', 'fullname', 'author', 'magazine',
'pages', 'mammals', 'birds', 'reptiles', 'amphibians', 'fish',
'invertebrates', 'vascular', 'bryophytes', 'lichens', 'fungi',
'maps'
]
dump(filename, fieldnames,
DBSession().query(Inforesources).order_by(Inforesources.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['square_id', 'key_area_id']
squares_from_db = DBSession().query(Squares).join(Squares.key_areas).order_by(Squares.id).all()
squares = []
for square in squares_from_db:
for key_area in square.key_areas:
squares.append([square.id, key_area.id])
dump(filename, fieldnames, squares, is_array=True)
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['square_id', 'key_area_id']
squares_from_db = DBSession().query(Squares).join(
Squares.key_areas).order_by(Squares.id).all()
squares = []
for square in squares_from_db:
for key_area in square.key_areas:
squares.append([square.id, key_area.id])
dump(filename, fieldnames, squares, is_array=True)
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
dbsession = DBSession()
redbook_species_db = dbsession.query(RedBook, RedBookSpecies, Taxon)\
.join(RedBookSpecies, RedBook.id == RedBookSpecies.red_book_id)\
.join(Taxon, RedBookSpecies.specie_id == Taxon.id)\
.order_by(RedBook.id, RedBookSpecies.specie_id)\
.all()
dbsession.close()
attribute_names = [
'region', 'orig_name', 'lat_name', 'author', 'population',
'status', 'univ_status', 'year', 'bibl'
]
objects_for_dump = [[
o[1].region, o[1].orig_name, o[2].name, o[1].author,
o[1].population, o[1].status, o[1].univ_status, o[1].year,
o[0].name
] for o in redbook_species_db]
dump(filename, attribute_names, objects_for_dump, is_array=True)
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'footprint', 'org_type', 'description']
dump(filename, fieldnames,
DBSession().query(Footprint).order_by(Footprint.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'abundance']
dump(filename, fieldnames,
DBSession().query(Abundance).order_by(Abundance.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'abundance']
dump(filename, fieldnames, DBSession().query(Abundance).order_by(Abundance.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'login', 'password', 'person_id', 'role']
dump(filename, fieldnames, DBSession().query(User).order_by(User.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ["id", "parent_id", "old_id", "taxon_type", "name", "russian_name", "author", "source"]
dump(filename, fieldnames, DBSession().query(Taxon).order_by(Taxon.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'area_type', 'legend', 'name']
dump(filename, fieldnames,
DBSession().query(Key_area).order_by(Key_area.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'taxa_scheme']
dump(filename, fieldnames, DBSession().query(Taxa_scheme).order_by(Taxa_scheme.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'area_type', 'legend', 'name']
dump(filename, fieldnames, DBSession().query(Key_area).order_by(Key_area.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'precision', 'count', 'description']
dump(filename, fieldnames, DBSession().query(Legend).order_by(Legend.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'anthr_press', 'description']
dump(filename, fieldnames, DBSession().query(Anthr_press).order_by(Anthr_press.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'doc_type']
dump(filename, fieldnames, DBSession().query(Doc_type).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'pheno', 'description', 'org_type']
dump(filename, fieldnames, DBSession().query(Pheno).order_by(Pheno.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'footprint', 'org_type', 'description']
dump(filename, fieldnames, DBSession().query(Footprint).order_by(Footprint.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'pheno', 'description', 'org_type']
dump(filename, fieldnames,
DBSession().query(Pheno).order_by(Pheno.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'doc_type']
dump(filename, fieldnames, DBSession().query(Doc_type).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'name', 'fullname', 'speciality', 'degree', 'organization', 'position', 'email', 'phone',
'address']
dbsession = DBSession()
dump(filename, fieldnames, dbsession.query(Person).order_by(Person.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'precision', 'count', 'description']
dump(filename, fieldnames,
DBSession().query(Legend).order_by(Legend.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'museum']
dump(filename, fieldnames, DBSession().query(Museum).order_by(Museum.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ["id", "species_id", "synonym", "author", "source"]
dump(filename, fieldnames, DBSession().query(Synonym).order_by(Synonym.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'login', 'password', 'person_id', 'role']
dump(filename, fieldnames,
DBSession().query(User).order_by(User.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'anthr_press', 'description']
dump(filename, fieldnames,
DBSession().query(Anthr_press).order_by(Anthr_press.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'vitality', 'org_type', 'description']
dump(filename, fieldnames,
DBSession().query(Vitality).order_by(Vitality.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'taxa_scheme']
dump(filename, fieldnames,
DBSession().query(Taxa_scheme).order_by(Taxa_scheme.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'vitality', 'org_type', 'description']
dump(filename, fieldnames, DBSession().query(Vitality).order_by(Vitality.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'species_id', 'synonym', 'author', 'source']
dump(filename, fieldnames,
DBSession().query(Synonym).order_by(Synonym.id).all())
def export_to_file(filename):
from nextgisbio.utils.dump_to_file import dump
fieldnames = ['id', 'museum']
dump(filename, fieldnames,
DBSession().query(Museum).order_by(Museum.id).all())