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()
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()
