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