def update_user_password(userid, password): sql = "update user set password = '******' where userid = '%s'" % (password, userid) Mysql.updateData(sql)
def set_delete_status(instanceid): sql = "update user_pay set status = 3 where instanceid = '%s'" % instanceid Mysql.updateData(sql)
def set_delete_status(instanceid): sql = "update user_pay set status = 3 where instanceid = '%s'" % instanceid Mysql.updateData(sql)
def handle(self, request, context): custom_script = context.get('customization_script', '') dev_mapping_1 = None dev_mapping_2 = None image_id = '' # Determine volume mapping options source_type = context.get('source_type', None) if source_type in ['image_id', 'instance_snapshot_id']: image_id = context['source_id'] elif source_type in ['volume_id', 'volume_snapshot_id']: dev_mapping_1 = { context['device_name']: '%s::%s' % (context['source_id'], int(bool(context['delete_on_terminate']))) } elif source_type == 'volume_image_id': dev_mapping_2 = [{ 'device_name': str(context['device_name']), 'source_type': 'image', 'destination_type': 'volume', 'delete_on_termination': int(bool(context['delete_on_terminate'])), 'uuid': context['source_id'], 'boot_index': '0', 'volume_size': context['volume_size'] }] netids = context.get('network_id', None) if netids: nics = [{"net-id": netid, "v4-fixed-ip": ""} for netid in netids] else: nics = None avail_zone = context.get('availability_zone', None) # Create port with Network Name and Port Profile # for the use with the plugin supporting port profiles. # neutron port-create <Network name> --n1kv:profile <Port Profile ID> # for net_id in context['network_id']: ## HACK for now use first network if api.neutron.is_port_profiles_supported(): net_id = context['network_id'][0] LOG.debug("Horizon->Create Port with %(netid)s %(profile_id)s", { 'netid': net_id, 'profile_id': context['profile_id'] }) try: port = api.neutron.port_create( request, net_id, policy_profile_id=context['profile_id']) except Exception: msg = (_('Port not created for profile-id (%s).') % context['profile_id']) exceptions.handle(request, msg) if port and port.id: nics = [{"port-id": port.id}] try: userid = context['user_id'] totalmoney = judge_account(userid) print totalmoney print context['totalPrice'] if (float(totalmoney) >= float(context['totalPrice'])): # for i in range(int(context['count'])): instance_info = api.nova.server_create( request, context['name'], image_id, context['flavor'], context['keypair_id'], normalize_newlines(custom_script), context['security_group_ids'], block_device_mapping=dev_mapping_1, block_device_mapping_v2=dev_mapping_2, nics=nics, availability_zone=avail_zone, instance_count=context['count'], admin_pass=context['admin_pass']) instanceid = instance_info.id sql = "update user set account = account - '%s' where userid = '%s'" % ( context['totalPrice'], context['user_id']) Mysql.updateData(sql) time = datetime.datetime.now() instancename = context['name'] # print time sql = "insert into user_info(userid, instanceid, instancename,op, money, time) value ('%s', '%s', '%s', '%s', '%s', '%s')" % ( userid, instanceid, instancename, '-', context['totalPrice'], time) Mysql.insertData(sql) sql = "insert into user_pay(userid, instanceid, instancename, updatetime, status, unit_price) value ('%s', '%s', '%s', '%s', '%s', '%s')" % ( userid, instanceid, instancename, time, '1', context['totalPrice']) Mysql.insertData(sql) return True except Exception: exceptions.handle(request) return False
def update_user_password(userid, password): sql = "update user set password = '******' where userid = '%s'" % (password, userid) Mysql.updateData(sql)
def handle(self, request, context): custom_script = context.get('customization_script', '') dev_mapping_1 = None dev_mapping_2 = None image_id = '' # Determine volume mapping options source_type = context.get('source_type', None) if source_type in ['image_id', 'instance_snapshot_id']: image_id = context['source_id'] elif source_type in ['volume_id', 'volume_snapshot_id']: dev_mapping_1 = {context['device_name']: '%s::%s' % (context['source_id'], int(bool(context['delete_on_terminate'])))} elif source_type == 'volume_image_id': dev_mapping_2 = [ {'device_name': str(context['device_name']), 'source_type': 'image', 'destination_type': 'volume', 'delete_on_termination': int(bool(context['delete_on_terminate'])), 'uuid': context['source_id'], 'boot_index': '0', 'volume_size': context['volume_size'] } ] netids = context.get('network_id', None) if netids: nics = [{"net-id": netid, "v4-fixed-ip": ""} for netid in netids] else: nics = None avail_zone = context.get('availability_zone', None) # Create port with Network Name and Port Profile # for the use with the plugin supporting port profiles. # neutron port-create <Network name> --n1kv:profile <Port Profile ID> # for net_id in context['network_id']: ## HACK for now use first network if api.neutron.is_port_profiles_supported(): net_id = context['network_id'][0] LOG.debug("Horizon->Create Port with %(netid)s %(profile_id)s", {'netid': net_id, 'profile_id': context['profile_id']}) try: port = api.neutron.port_create(request, net_id, policy_profile_id= context['profile_id']) except Exception: msg = (_('Port not created for profile-id (%s).') % context['profile_id']) exceptions.handle(request, msg) if port and port.id: nics = [{"port-id": port.id}] try: userid = context['user_id'] totalmoney = judge_account(userid) print totalmoney print context['totalPrice'] if(float(totalmoney) >= float(context['totalPrice'])): # for i in range(int(context['count'])): instance_info=api.nova.server_create(request, context['name'], image_id, context['flavor'], context['keypair_id'], normalize_newlines(custom_script), context['security_group_ids'], block_device_mapping=dev_mapping_1, block_device_mapping_v2=dev_mapping_2, nics=nics, availability_zone=avail_zone, instance_count=context['count'], admin_pass=context['admin_pass']) instanceid = instance_info.id sql = "update user set account = account - '%s' where userid = '%s'"%(context['totalPrice'], context['user_id']) Mysql.updateData(sql) time = datetime.datetime.now() instancename = context['name'] # print time sql = "insert into user_info(userid, instanceid, instancename,op, money, time) value ('%s', '%s', '%s', '%s', '%s', '%s')" % (userid, instanceid,instancename, '-', context['totalPrice'], time) Mysql.insertData(sql) sql = "insert into user_pay(userid, instanceid, instancename, updatetime, status, unit_price) value ('%s', '%s', '%s', '%s', '%s', '%s')" % (userid, instanceid, instancename, time, '1', context['totalPrice']) Mysql.insertData(sql) return True except Exception: exceptions.handle(request) return False
def update_user(money, userid): sql = "update user set account = account + '%s' where userid = '%s'"%(money, userid) Mysql.updateData(sql)
def update_user(money, userid): sql = "update user set account = account + '%s' where userid = '%s'" % ( money, userid) Mysql.updateData(sql)