def validationRegionID(region_id): if region_id is None: raise ValidationException("Region is required field") elif not isinstance(region_id, int): raise ValidationException("Role has invalid integer value") elif not RegionDao.getRegionByID(region_id): raise NotFoundException("Unable to find a region with given id")
def region_page(page): all_rec = RegionDao.getlistRegion() records_per_page = 5 pagination = Pagination(records_per_page, all_rec, page) prods = pagination.pager() records_amount = len(all_rec) regions_arr = [] for i in prods: regions_arr.append({'name': i.name}) return make_response(jsonify(regions=regions_arr, records_amount=records_amount, records_per_page=records_per_page), 200)
ProductStock.add_new_record(3,2,115) ProductStock.add_new_record(4,2,118) ProductStock.add_new_record(5,1,115) ProductStock.add_new_record(6,2,125) ProductStock.add_new_record(11,3,115) ProductStock.add_new_record(2,3,310) ProductStock.add_new_record(4,3,118) ProductStock.add_new_record(5,3,115) ProductStock.add_new_record(6,3,125) RoleDao.createNewRole("Administrator") RoleDao.createNewRole("Merchandiser") RoleDao.createNewRole("Supervisor") RoleDao.createNewRole("Customer") RegionDao.createNewRegion("North") RegionDao.createNewRegion("West") RegionDao.createNewRegion("South") RegionDao.createNewRegion("East") UserDao.createNewUser('Max', '1111','Maxim','Sidorov', '*****@*****.**',1,2) UserDao.createNewUser('Nikol', '1111','Nikolay','Lobanov', '*****@*****.**', 4,1) UserDao.createNewUser('Vanya', '1111','Ivan','Ivanov', '*****@*****.**', 2,1) UserDao.createNewUser('Andrew', '1111','Andrew','Petrov', '*****@*****.**', 3,4) UserDao.createNewUser('Katya', '1111','Ekaterina','Ivanova', '*****@*****.**', 4,3) UserDao.createNewUser('Roma', '1111','Roman','Melnishin', '*****@*****.**', 2,1) UserDao.createNewUser('Den', '1111','Dennis','Popov', '*****@*****.**', 3,1) UserDao.createNewUser('Max90', '1111','Maxim','Smirnov', '*****@*****.**', 4,4) UserDao.createNewUser('Yaroslav', '1111','Yaroslav','Lobanov', '*****@*****.**', 4,2) UserDao.createNewUser('Seriy', '1111','Sergey','Lobanov', '*****@*****.**', 1,2) UserDao.createNewUser('Dona', '1111','Donna','Popova', '*****@*****.**', 3,1)
#!/usr/bin/env python # ---Fill test data for user and related entities---- from models.region_dao import RegionDao from models.role_dao import RoleDao from models.user_dao import UserDao RoleDao.createNewRole("Admin") RegionDao.createNewRegion("Crimea") UserDao.createNewUser('Anton', '111','Maxim','Sidorov', '*****@*****.**', 1,1) UserDao.createNewUser('Vanya', '111','Ivan','Ivanov', '*****@*****.**', 1,1) UserDao.createNewUser('Andrew', '111','Andrew','Petrov', '*****@*****.**', 1,1) UserDao.createNewUser('Katya', '111','Ekaterina','Ivanova', '*****@*****.**', 1,1) for instance in UserDao.getAllUsers(): print(instance.id,instance.login,instance.password,instance.first_name, instance.last_name, instance.email, RoleDao.getRoleByID(instance.role_id).name, RegionDao.getRegionByID(instance.region_id).name)
def getRegionByID(region_id): validationRegionID(region_id) return RegionDao.getRegionByID(region_id)
def deleteRegion(region_id): validationRegionID(region_id) RegionDao.deleteRecord(region_id)
def updateRegion(region_id, name): validationRegionID(region_id) validationRegionName(name) RegionDao.updateRegion(region_id, name)
def createRegion(name): validationRegionName(name) RegionDao.createNewRegion(name)
def getlistRegion(): return RegionDao.getAllRegions()