def upgrade(): conn = Connection(op.get_bind()) # https://github.com/clld/wals-data/issues/50 fpk = conn.pk(Family, 'utoaztecan') gname = 'California Uto-Aztecan' gid = slug(gname) gpk = conn.insert(Genus, id=gid, name=gname, icon='fffff00', family_pk=fpk) for oid in ['takic', 'tubatulabal']: opk = conn.pk(Genus, oid) conn.update(WalsLanguage, dict(genus_pk=gpk), genus_pk=opk) conn.insert(Config, key=Config.replacement_key(Genus, oid), value=gid) conn.delete(Genus, id=oid) # https://github.com/clld/wals-data/issues/49 conn.update_name('aym', 'Aymara (Central)') conn.update_glottocode('aym', 'cent2142') conn.update_iso('aym', 'ayr', ayc='Southern Aymara') # https://github.com/clld/wals-data/issues/48 # The genus Guaymi should be renamed Guaymiic. conn.update(Genus, dict(name='Guaymiic'), id='guaymi') # The genus Aruak should be renamed Arhuacic. conn.update(Genus, dict(name='Arhuacic'), id='aruak') # The language Motilón should be renamed Barí (while keeping Motilón as the name of # the genus). conn.update_name('mti', 'Barí') # The genus Chibchan Proper should be split into two genera, Chibcha-Duit, containing # the language Muisca, and Tunebo, containing the language Tunebo. conn.update_genus('msc', ('chibchaduit', 'Chibcha-Duit', 'fffff00'), family='chibchan') conn.update_genus('tnb', ('tunebo', 'Tunebo', 'fffcc00'), family='chibchan') conn.insert(Config, key=Config.replacement_key(Genus, 'chibchanproper'), value=Config.gone) conn.delete(Genus, id='chibchanproper') # https://github.com/clld/wals-data/issues/44 conn.update_name('jlu', 'Luwo', other='Jur Luwo') # https://github.com/clld/wals-data/issues/43 conn.update_genus('ctw', ('catawban', 'Catawban', 'fffcc00'), family='siouan') conn.update(Genus, dict(name='Core Siouan'), id='siouan') # https://github.com/clld/wals-data/issues/40 conn.update_source('Sumbuk-2002', year='1999', name='Sumbuk 1999')
def upgrade(): conn = Connection(op.get_bind()) # https://github.com/clld/wals-data/issues/50 fpk = conn.pk(Family, 'utoaztecan') gname = 'California Uto-Aztecan' gid = slug(gname) gpk = conn.insert(Genus, id=gid, name=gname, icon='fffff00', family_pk=fpk) for oid in ['takic', 'tubatulabal']: opk = conn.pk(Genus, oid) conn.update(WalsLanguage, dict(genus_pk=gpk), genus_pk=opk) conn.insert(Config, key=Config.replacement_key(Genus, oid), value=gid) conn.delete(Genus, id=oid) # https://github.com/clld/wals-data/issues/49 conn.update_name('aym', 'Aymara (Central)') conn.update_glottocode('aym', 'cent2142') conn.update_iso('aym', 'ayr', ayc='Southern Aymara') # https://github.com/clld/wals-data/issues/48 # The genus Guaymi should be renamed Guaymiic. conn.update(Genus, dict(name='Guaymiic'), id='guaymi') # The genus Aruak should be renamed Arhuacic. conn.update(Genus, dict(name='Arhuacic'), id='aruak') # The language Motilón should be renamed Barí (while keeping Motilón as the name of # the genus). conn.update_name('mti', 'Barí') # The genus Chibchan Proper should be split into two genera, Chibcha-Duit, containing # the language Muisca, and Tunebo, containing the language Tunebo. conn.update_genus( 'msc', ('chibchaduit', 'Chibcha-Duit', 'fffff00'), family='chibchan') conn.update_genus( 'tnb', ('tunebo', 'Tunebo', 'fffcc00'), family='chibchan') conn.insert( Config, key=Config.replacement_key(Genus, 'chibchanproper'), value=Config.gone) conn.delete(Genus, id='chibchanproper') # https://github.com/clld/wals-data/issues/44 conn.update_name('jlu', 'Luwo', other='Jur Luwo') # https://github.com/clld/wals-data/issues/43 conn.update_genus('ctw', ('catawban', 'Catawban', 'fffcc00'), family='siouan') conn.update(Genus, dict(name='Core Siouan'), id='siouan') # https://github.com/clld/wals-data/issues/40 conn.update_source('Sumbuk-2002', year='1999', name='Sumbuk 1999')
def upgrade(): conn = Connection(op.get_bind()) # https://github.com/clld/wals-data/issues/64 conn.update_name('bnr', 'Bilinarra') conn.update_source( 'Nordlinger-1990', description='A Sketch Grammar of Bilinarra', title='A Sketch Grammar of Bilinarra') # https://github.com/clld/wals-data/issues/63 conn.update_name('jva', 'Karajá') conn.update_name('ghr', 'Bunan') # https://github.com/clld/wals-data/issues/59 conn.update_genus('lrd', 'tangkic') # https://github.com/clld/wals-data/issues/54 conn.update_source( 'Schauer-and-Schauer-1958', name='Schauer and Schauer 1978', year='1978', year_int=1978) # https://github.com/clld/wals-data/issues/53 conn.update_genus( 'ocu', ('matlatzincan', 'Matlatzincan', 't9999ff'), family='otomanguean') # https://github.com/clld/wals-data/issues/47 conn.update_name('bno', 'Waimaha') # https://github.com/clld/wals-data/issues/46 conn.update_source( 'Troike-1996', booktitle='Handbook of North American Indians. Volume 17: Languages') # https://github.com/clld/wals-data/issues/42 conn.update_name('cos', 'Rumsien')