def generate_partners():
try:
partner_names = [
'EURASIAN FOODS', 'Келешек - STAR', 'Dala-Kent', 'Южный Престиж',
'Madina', 'ИП "Кофейные напитки"', 'Бөрте Милка',
'Доставка лепешек', 'ИП Хасанова', 'ASDECOR', 'ИП НҰРМҰХАММЕД',
'Южная Корона', 'ИП Париж', 'Красивая Меча', 'ТОО АРСЕНОВ',
'ИП Ерганов'
'PANDORA GROUP', 'ТОО Омар(Yunus, Comili,Elvan,Today)',
'ИП Санжар', 'ИП Шым-Бизнес (Bionix, Voka)', 'VOKA', 'BIONIX',
'Нирвана', 'ИП Ахмедов', 'ТОО "Dena Distribution"',
'ТОО "Hydrolife Bottlers Kazakhstan"', 'Anadolu Marketing',
'ИП Юдаков', 'BASTAU', 'ТОО "РАУАН"', 'ТОО "NIK 1"',
'BRIS -Company', 'ТОО "Чайный центр"', 'Разновидный курт',
'TURKUAZ Group of Companies', 'ТОО "Салем"', 'ТОО "ЖанИС"',
'ТОО "Московские Деликатесы"', 'ИП Хадиметов',
'ТОО "Line Logistic"', 'ТОО "Аврора Брендс"', 'Арахис Ташкентский',
'ИП Леспеков', 'ТОО "АсКом-Азия"', 'ТОО OASIS GROUP',
'ТОО "Гәкку Әулие ата құс"', 'Адам', 'ИП "Дарина"',
'ТОО "Sea Bass" (Русалочка)', 'ИП Болатбек Т', 'ТОО "TASS GROUP"',
'ИП Пак', 'aДәм'
]
for name in partner_names:
data = {'name': name}
partner = PartnersCatalog(data)
session.add(partner)
session.commit()
pass
except Exception as e:
pass
def generate_gallery():
try:
# user_login = session.query(UserLogins).filter(and_(
# UserLogins.login == login,
# UserLogins.password == encrypted_password)) \
# .first()
products = session.query(Products).filter(and_(
Products.default_image_id!=None,
Products.gallery_images==None
)).all()
for p in products:
arr = []
arr.append(p.default_image_id)
p.gallery_images = arr
session.add(p)
session.commit()
t=p
pass
e=0
pass
except Exception as e:
pass
def post(self):
try:
json_data = request.get_json(force=True)
login = json_data["login"]
password = json_data["password"]
o_password = copy.copy(password)
t = bytes(password, 'utf-8')
password = str(base64.b64encode(t))
user_login = session.query(UserLogins).filter(and_(
UserLogins.login == login,
UserLogins.password == password))\
.first()
if user_login is None:
message = "Попытка авторизации с IP адреса " + request.remote_addr + ". Данными Login="******" Password="******"User doesn't exist")
user_login.last_login_date = datetime.datetime.now()
session.add(user_login)
message = "Пользователь " + user_login.user_data.first_name + " " + user_login.user_data.last_name + " зашел в кабинет (компания " + user_login.user_data.client.name + ")"
log = Log(message)
session.add(log)
session.commit()
return user_login
except Exception as e:
session.rollback()
abort(400, message="Error Auth")
def check_default_address(entity):
try:
client_id = entity.client_id
is_default = entity.is_default
id = entity.id
client_addresses = session.query(ClientAddresses).filter(
ClientAddresses.client_id == client_id).all()
if (len(client_addresses) == 1):
for client_address in client_addresses:
client_address.is_default = True
session.add(client_address)
session.commit()
return
if (is_default == False):
return
for client_address in client_addresses:
if (client_address.id == id):
client_address.is_default = True
else:
client_address.is_default = False
session.add(client_address)
session.commit()
pass
except Exception as e:
pass
def get(self):
try:
action_type = 'GET'
parser = reqparse.RequestParser()
parser.add_argument('user_id')
args = parser.parse_args()
if (len(args) == 0):
abort(400, message='Arguments not found')
user_id = args['user_id']
user_bonuses = session.query(UserBonuses).filter(and_(
UserBonuses.user_id == user_id,
UserBonuses.state== True)) \
.all()
for bonus in user_bonuses:
bonus.state = False
session.add(bonus)
session.commit()
response = {'status': 200}
return response
except Exception as e:
if (hasattr(e, 'data')):
if (e.data != None and "message" in e.data):
abort(400, message=e.data["message"])
abort(400, message="Неопознанная ошибка")
def fan_out(self, period=30):
LOGGER.debug('Fanning out rows...')
stations = session.query(WeatherStation).filter_by(is_sent=0).all()
for station in stations:
session.begin()
try:
LOGGER.debug('Fanning out station %s' % str(station))
self.publish_station(station)
station.is_sent = 1
session.commit()
except Exception as e:
LOGGER.error('Error %s when processing station.', str(e))
session.rollback()
raise
metrics = session.query(Metric).filter_by(is_sent=0).all()
for metric in metrics:
session.begin()
try:
LOGGER.debug('Fanning out metric %s' % str(metric))
self.publish_metric(metric)
metric.is_sent = 1
session.commit()
except Exception as e:
LOGGER.error('Error %s when processing metric.', str(e))
session.rollback()
raise
threading.Timer(period, self.fan_out, [period]).start() # Periodic loop.
def config_import():
with open(config_path, 'r') as f:
cc_json = json.load(f)
cc = ChimeraConfig()
for key, value in cc_json.items():
setattr(cc, key, value)
session.query(ChimeraConfig).delete()
session.add(cc)
session.commit()
print('Config imported, restart chimera!')
def post(self):
try:
json_data = request.get_json(force=True)
action_log_type = ActionLogTypes(message=json_data["message"])
session.add(action_log_type)
session.commit()
return action_log_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Action Log Type")
def clean_log_by_condition():
try:
logs = session.query(Log).all()
if (len(logs) > 2000):
session.query(Log).delete()
session.commit()
pass
except Exception as e:
session.rollback()
def post(self):
try:
json_data = request.get_json(force=True)
user_role = UserRoles(json_data['name'])
session.add(user_role)
session.commit()
return user_role, 201
except Exception as e:
session.rollback()
abort(400, message="Error in adding User Role")
def post(self):
try:
json_data = request.get_json(force=True)
client_type = ClientTypes(name=json_data["name"])
session.add(client_type)
session.commit()
return client_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Client Type")
def post(self):
try:
json_data = request.get_json(force=True)
log = Log(message=json_data["message"])
session.add(log)
session.commit()
return log, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Log")
def post(self):
try:
json_data = request.get_json(force=True)
entity = MODEL(json_data)
session.add(entity)
session.commit()
return entity, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record " + ENTITY_NAME)
def put(self, id):
try:
# session.autocommit = False
# session.autoflush = False
json_data = request.get_json(force=True)
entity = session.query(MODEL).filter(MODEL.id == id).first()
if not entity:
abort(404,
message=ENTITY_NAME + " {} doesn't exist".format(id))
product_positions = session.query(ProductsPositions).filter(
ProductsPositions.products_positions.any(entity.id)).all()
if product_positions is not None:
session.bulk_update_mappings(ProductsPositions, [{
'id':
x.id,
'products_positions':
list(filter(lambda y: y != entity.id,
x.products_positions))
} for x in product_positions])
session.commit()
db_transformer.transform_update_params(entity, json_data)
session.add(entity)
session.commit()
# api_url = settings.API_URL
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.file_path != None):
# entity.default_image_data.file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.thumb_file_path != None):
# entity.default_image_data.thumb_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.thumb_file_path)
# if hasattr(entity, 'default_image_data'):
# if (entity.default_image_data != None and entity.default_image_data.optimized_size_file_path != None):
# entity.default_image_data.optimized_size_file_path = urllib.parse.urljoin(api_url,
# entity.default_image_data.optimized_size_file_path)
entity.images_data = []
if (entity.gallery_images != None
and len(entity.gallery_images) > 0):
for img_id in entity.gallery_images:
image = session.query(Attachments).filter(
Attachments.id == img_id).first()
if not image:
continue
entity.images_data.append(image)
return entity, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update " + ENTITY_NAME)
finally:
pass
def populate_aws(eventSlug, start, end, pageSize):
games = []
for i in range(start, end):
try:
games.extend(get_games(eventSlug, i, pageSize))
except Exception as e:
print(e)
for game in games:
session.add(game)
session.commit()
def post(self):
try:
json_data = request.get_json(force=True)
client = Clients(name=json_data["name"], registration_number=json_data["registration_number"],
lock_state=json_data["lock_state"], client_type_id=json_data["client_type_id"])
session.add(client)
session.commit()
return client, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Client")
def delete(self, id):
try:
setting = session.query(Settings).filter(Settings.id == id).first()
if not setting:
abort(404, message=" Settings {} doesn't exist".format(id))
session.delete(setting)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Settings")
def delete(self, id):
try:
object = session.query(Objects).filter(Objects.id == id).first()
if not object:
abort(404, message="Object {} doesn't exist".format(id))
session.delete(object)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Entity")
def delete(self, id):
try:
client = session.query(Clients).filter(Clients.id == id).first()
if not client:
abort(404, message="Client type {} doesn't exist".format(id))
session.delete(client)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Client")
def delete(self, id):
try:
entity = session.query(MODEL).filter(MODEL.id == id).first()
if not entity:
abort(404, message=ENTITY_NAME+" {} doesn't exist".format(id))
session.delete(entity)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove "+ENTITY_NAME)
def delete(self, id):
try:
schema = session.query(Schemas).filter(Schemas.id == id).first()
if not schema:
abort(404, message="Client type {} doesn't exist".format(id))
session.delete(schema)
session.commit()
return {}, 204
except Exception as e:
# db.db.init_session()
session.rollback()
abort(400, message="Error in remove schema".format(id))
def put(self, id):
try:
json_data = request.get_json(force=True)
client_type = session.query(ClientTypes).filter(
ClientTypes.id == id).first()
client_type.name = json_data['name']
session.add(client_type)
session.commit()
return client_type, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Client Type")
def post(self):
try:
json_data = request.get_json(force=True)
action_log = ActionLog(message=json_data["message"],
user_id=json_data["user_id"],
action_type_id=json_data["action_type_id"])
session.add(action_log)
session.commit()
return action_log, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Action Log")
def put(self, id):
try:
json_data = request.get_json(force=True)
user_role = session.query(UserRoles).filter(
UserRoles.id == id).first()
user_role.task = json_data['name']
session.add(user_role)
session.commit()
return user_role, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update user role")
def delete(self, id):
try:
user_role = session.query(UserRoles).filter(
UserRoles.id == id).first()
if not user_role:
abort(404, message="User role {} doesn't exist".format(id))
session.delete(user_role)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove user role")
def put(self, id):
try:
json_data = request.get_json(force=True)
group_object_right = session.query(GroupObjectRights).filter(
GroupObjectRights.id == id).first()
group_object_right.data = json_data['data']
session.add(group_object_right)
session.commit()
return group_object_right, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Group Object Rights")
def delete(self, id):
try:
action_log = session.query(ActionLog).filter(
ActionLog.id == id).first()
if not action_log:
abort(404, message="Action log {} doesn't exist".format(id))
session.delete(action_log)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Action Type")
def put(self, id):
try:
json_data = request.get_json(force=True)
object_view = session.query(ObjectViews).filter(
ObjectViews.id == id).first()
object_view.data = json_data['data']
session.add(object_view)
session.commit()
return object_view, 201
except Exception as e:
session.rollback()
abort(400, message="Error while update Object Views")
def delete(self, id):
try:
user_login = session.query(UserLogins).filter(
UserLogins.id == id).first()
if not user_login:
abort(404, message="User Login {} doesn't exist".format(id))
session.delete(user_login)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error remove user login")
def delete(self, id):
try:
client_info = session.query(ClientInfo).filter(
ClientInfo.id == id).first()
if not client_info:
abort(404, message="Attachment {} doesn't exist".format(id))
session.delete(client_info)
session.commit()
return {}, 204
except Exception as e:
session.rollback()
abort(400, message="Error while remove Attachment ")
def post(self):
try:
json_data = request.get_json(force=True)
setting = Settings(name=json_data["name"],
value=json_data["value"])
session.add(setting)
session.commit()
return setting, 201
except Exception as e:
session.rollback()
abort(400, message="Error while adding record Settings")
def on_message(self, unused_channel, basic_deliver, properties, body):
LOGGER.info('Received message # %s from %s: %s',
basic_deliver.delivery_tag, properties.app_id, body)
try:
msg_dict = json.loads(body)
action = msg_dict['action']
data = msg_dict['data']
if action == 'add_metric':
metric_type = session.query(MetricType).filter_by(
id=data['metric_type_id']).first()
station = session.query(WeatherStation).filter_by(
id=data['weather_station_id']).first()
metric = Metric(id=data['id'], value=data['value'],
metric_type=metric_type,
weather_station=station, is_sent=1,
timestamp=datetime.datetime.fromtimestamp(
data['timestamp']))
session.begin()
session.merge(metric)
session.commit()
elif action == 'add_station':
types = session.query(MetricType).filter(
MetricType.id.in_(data['metric_types'])).all()
station = WeatherStation(id=data['id'], name=data['name'],
latitude=data['latitude'],
longitude=data['longitude'],
metric_types=types, is_sent=1)
session.begin()
session.merge(station)
session.commit()
except Exception as e:
LOGGER.error('Error %s when processing message.', str(e))
self.acknowledge_message(basic_deliver.delivery_tag)
