def get_disks_pconn(session, user_id, project_id, is_system=1):
if not session:
session = get_mysql_session("cinder")
ret = []
disk_size = 0
#for row in session.execute('select * from volumes where user_id="%s" and project_id="%s" ;'%(user_id, project_id)).fetchall():
session.execute("use cinder")
for row in session.execute(
'select * from volumes where ( status != "deleted" ) and user_id="%s" and project_id="%s" ;'
% (user_id, project_id)).fetchall():
#for row in session.execute('select * from volumes where bootable=0 and ( status != "deleted" ) ;').fetchall():
#for row in session.execute('select * from volumes where ( status != "deleted" ) ;').fetchall():
row = dict(zip(row.keys(), row.values()))
tmp = {}
id = row['id']
user_id = row['user_id']
project_id = row['project_id']
size = row['size']
disk_size += size
#host=row['host'];
bootable = row['bootable']
tmp['id'] = id
tmp['user_id'] = user_id
tmp['project_id'] = project_id
tmp['size'] = size
tmp['bootable'] = bootable
ret.append(tmp)
return (ret, disk_size)
def add_discount_record():
session = get_mysql_session("billing")
account_id = "account_id"
rows = session.execute(
'insert discount values ( 222, 1, "%s", 0.77, null, null ) ;' %
account_id)
session.close()
def get_user_routers_pconn(session, project_id):
if not session:
session = get_mysql_session("neutron")
ret = []
session.execute("use neutron")
for row in session.execute(
'select * from routers where tenant_id="%s" ;' %
project_id).fetchall():
#for row in session.execute('select * from routers ').fetchall():
row = dict(zip(row.keys(), row.values()))
tenant_id = row['tenant_id']
id = row['id']
#name=row['name'];
status = row['status']
bandwidth = row['bandwidth']
tmp = {}
tmp['tenant_id'] = tenant_id
tmp['id'] = id
tmp['status'] = status
#tmp['name']=name;
tmp['bandwidth'] = bandwidth
ret.append(tmp)
return ret
def get_disks():
disks_size = []
session = get_mysql_session("cinder")
ret = get_disks_pconn(session)
session.close()
return ret
def get_cpu_count_pconn(session, uuid):
if not session:
session = get_mysql_session("nova")
vcpus = 0
session.execute("use nova")
for row in session.execute('select * from instances where uuid="%s" ;' %
uuid).fetchall():
row = dict(zip(row.keys(), row.values()))
vcpus = row['vcpus']
return vcpus
#!/usr/bin/python
#coding: gbk
from mysql_db import get_mysql_session;
session=get_mysql_session("keystone");
#让密码验证 一定返回正确的方式:
#1. check_passwd 返回值 指定写成 True
#2. 把所有的 keystone user 表里面的 passwd 修改成 hash 值 .
rows= session.execute("select user.name as user_name,user.password as user_passwd,project.name as tenant_name from user left join project ON project.id=user.default_project_id ;").fetchall();
for each in rows:
#print each['user_name'];
url="""
curl -s -X POST http://localhost:35357/v2.0/tokens \
-d '{"auth": {"passwordCredentials": {"username":"******", "password":"******"}, "tenantName":"%s"}}' -H "Content-type: application/json" |jq -r .access.token.id
""" %(each['user_name'], each['tenant_name']);
print url;
