def register(request):
errors= []
username=None
password=None
password1=None
email=None
if request.method == 'POST':
if not request.POST.get('username'):
errors.append('Please Enter username')
else:
username = request.POST.get('username')
if not request.POST.get('password'):
errors.append('Please Enter password')
else:
password= request.POST.get('password')
if not request.POST.get('password1'):
errors.append('Please Enter confirmpassword')
else:
password1= request.POST.get('password1')
if not request.POST.get('email'):
errors.append('Please Enter email')
else:
email = request.POST.get('email')
if username and password and password1 and email:
userid = create_user(username, password, email)
#database test_zxl , table user
sql = "insert into user(userid, account) value ('%s', '%s')"%(userid, 0)
Mysql.insertData(sql)
return HttpResponseRedirect('/horizon/auth/login')
return render(request,"auth/register.html")
def register(request):
errors = []
username = None
password = None
password1 = None
email = None
if request.method == 'POST':
if not request.POST.get('username'):
errors.append('Please Enter username')
else:
username = request.POST.get('username')
if not request.POST.get('password'):
errors.append('Please Enter password')
else:
password = request.POST.get('password')
if not request.POST.get('password1'):
errors.append('Please Enter confirmpassword')
else:
password1 = request.POST.get('password1')
if not request.POST.get('email'):
errors.append('Please Enter email')
else:
email = request.POST.get('email')
if username and password and password1 and email:
userid = create_user(username, password, email)
#database test_zxl , table user
sql = "insert into user(userid, account) value ('%s', '%s')" % (
userid, 0)
Mysql.insertData(sql)
return HttpResponseRedirect('/horizon/auth/login')
return render(request, "auth/register.html")
def get_account(userid): # userid = get_userid() print userid sql = "select account from user where userid = '%s'" % (userid) account = Mysql.selectData(sql) print account totalmoney = account[0][0] return totalmoney
def get_account(userid):
# userid = get_userid()
print userid
sql = "select account from user where userid = '%s'" % (userid)
account = Mysql.selectData(sql)
print account
totalmoney = account[0][0]
return totalmoney
def get_account(userid):
sql = "select account from user where userid = '%s'" % (userid)
account = Mysql.selectData(sql)
#print account[0]['account']
totalmoney = account[0]['account']
return totalmoney
def query_info(userid):
sql = "select * from user_info where userid = '%s'" % (userid)
userinfo = Mysql.selectData(sql)
return userinfo
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 query_info(userid): sql = "select * from user_info where userid = '%s'" % (userid) userinfo = Mysql.selectData(sql) return userinfo
def insert_userinfo(money, userid):
time = datetime.now()
print "this is time :::'%s'" % time
sql = "insert into user_info(userid, instanceid, op, money, time) value ('%s', '%s', '%s', '%s', '%s')" % (
userid, '', '+', money, time)
Mysql.insertData(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 insert_userinfo(money, userid):
time = datetime.now()
print "this is time :::'%s'" % time
sql = "insert into user_info(userid, instanceid, op, money, time) value ('%s', '%s', '%s', '%s', '%s')" % (userid,'', '+', money, time)
Mysql.insertData(sql)
def update_user(money, userid): sql = "update user set account = account + '%s' where userid = '%s'"%(money, userid) Mysql.updateData(sql)
def get_account(userid):
sql = "select account from user where userid = '%s'" % (userid)
account = Mysql.selectData(sql)
#print account[0]['account']
totalmoney = account[0]['account']
return totalmoney
def update_user_password(userid, password):
sql = "update user set password = '******' where userid = '%s'" % (password,
userid)
Mysql.updateData(sql)
def update_user_password(userid, password): sql = "update user set password = '******' where userid = '%s'" % (password, userid) Mysql.updateData(sql)
def update_user(money, userid):
sql = "update user set account = account + '%s' where userid = '%s'" % (
money, userid)
Mysql.updateData(sql)
