def get_row_count():
nodes = SelectQuery(Node).select()
ways = SelectQuery(Way).select()
relations = SelectQuery(Relation).select()
print("nodes count = ", nodes.count())
print("ways count = ", ways.count())
print("relations count = ", relations.count())
def dataClean():
if EdulistModel.table_exists() == False:
EdulistModel.create_table()
schools = SelectQuery(EdulistModel).select().where(
EdulistModel.postcode == '')
print(schools.count())
for school in schools:
# category = school.category
print(school.postcode)
def paginate(query: peewee.SelectQuery,
page: int = 0,
per_page: int = 100) -> tuple[peewee.SelectQuery, int]:
"""Paginate the results of a query.
Returns results and number of pages.
"""
total_results = query.count()
pages = math.ceil(total_results / per_page)
if pages and page >= pages:
raise utils.RequestError(3201)
page = query.offset(page * per_page).limit(per_page)
return page, pages
def fixData():
# p = Pool(100)
schools = SelectQuery(EdulistModel).select().where(
EdulistModel.postcode == '')
print(schools.count())
