def names2(s):
    return [(debr(first), debr(' '.join(n for n in (prelast, last) if n)), debr(lineage))
        for prelast, last, first, lineage in _bibtex.names(s)]
Esempio n. 2
0
def names2(s):  # pragma: no cover
    return [(debr(first), debr(' '.join(n for n in (prelast, last)
                                        if n)), debr(lineage))
            for prelast, last, first, lineage in _bibtex.names(s)]
    last = sa.Column(sa.Text, nullable=False)
    given = sa.Column(sa.Text, nullable=False)
    lineage = sa.Column(sa.Text, nullable=False)


engine = sa.create_engine(DB)
Entry.metadata.drop_all(engine)
Entry.metadata.create_all(engine)


for b in BIBFILES:
    print(b.filepath)
    with engine.begin() as conn:
        insert_entry = Entry.__table__.insert(bind=conn).execute
        insert_contrib = Contributor.__table__.insert(bind=conn).execute
        for bibkey, (entrytype, fields) in b.iterentries():
            pk, = insert_entry(filename=b.filename, bibkey=bibkey,
                entrytype=entrytype, fields=fields,
                glottolog_ref_id=fields.get('glottolog_ref_id'),
                author=fields.get('author'), editor=fields.get('editor'),
                year=fields.get('year'), title=fields.get('title')
                ).inserted_primary_key
            contribs = [{'entry_pk': pk, 'role': role, 'index': i,
                'prelast': prelast, 'last': last, 'given': given,
                'lineage': lineage}
                for role in ('author', 'editor')
                for i, (prelast, last, given, lineage)
                in enumerate(_bibtex.names(fields.get(role, '')), 1)]
            if contribs:
                insert_contrib(contribs)
for b in BIBFILES:
    print(b.filepath)
    with engine.begin() as conn:
        insert_entry = Entry.__table__.insert(bind=conn).execute
        insert_contrib = Contributor.__table__.insert(bind=conn).execute
        for bibkey, (entrytype, fields) in b.iterentries():
            pk, = insert_entry(filename=b.filename,
                               bibkey=bibkey,
                               entrytype=entrytype,
                               fields=fields,
                               glottolog_ref_id=fields.get('glottolog_ref_id'),
                               author=fields.get('author'),
                               editor=fields.get('editor'),
                               year=fields.get('year'),
                               title=fields.get('title')).inserted_primary_key
            contribs = [
                {
                    'entry_pk': pk,
                    'role': role,
                    'index': i,
                    'prelast': prelast,
                    'last': last,
                    'given': given,
                    'lineage': lineage
                } for role in ('author', 'editor')
                for i, (prelast, last, given, lineage
                        ) in enumerate(_bibtex.names(fields.get(role, '')), 1)
            ]
            if contribs:
                insert_contrib(contribs)