def import_countries(self, country_csv): countries = [] lines = country_csv.split('\n') for line in lines: if len(line.strip()) > 0: fields = line.split(';') country = Country() country.order = int(fields[0]) country.name = fields[1].strip() country.local_name = fields[2].strip() country.put() countries.append(country) return countries
def import_countries(self, country_csv): countries = [] lines = country_csv.split('\n') for line in lines: if len(line.strip()) > 0: fields = line.split(';') country = Country() country.order = int(fields[0]) country.name = fields[1].strip() country.local_name = fields[2].strip() country.put() countries.append(country) return countries;
def parseTable(page: str) -> List[Country]: list = [] soup = BeautifulSoup(page, "html.parser") codeTable = soup.find_all('table', attrs={'class': 'wikitable'})[0].find_all('tr') for countryTable in codeTable: country = Country() try: country.code = countryTable.span.text country.name = countryTable.a.text # country.flag_page_link = Flag(domain + countryTable.a['href']) # 需要svg格式时 country.flag_page_link = Flag( "https:" + countryTable.img['src'].replace("22px", "480px")) # 需要png格式 list.append(country) except AttributeError: pass return list
from sqlalchemy import Column, DateTime, Integer, String, Boolean from sqlalchemy.ext.declarative import declarative_base import pycountry from model import Base, Country, City, Post, Continent from sqlalchemy import create_engine from sqlalchemy.orm import sessionmaker engine = create_engine('sqlite:///project.db') Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() import pycountry my_countries = list(pycountry.countries) for i in my_countries: country = Country() country.name = i.name session.add(country) continents = [ 'Europe', 'Africa', 'Asia', 'North America', 'South America', 'Australia' ] for i in continents: con = Continent() con.name = i session.add(con) session.commit()
def task_country_restore(items): for item in items: country = Country(key_name=item['countryId']) country.order = item['order'] country.name = item['name'] country.put()