def env_prepare(request):
product_id = int(request.GET.get('product_id', 0))
all_product = Product.objects.filter(qa_id__isnull=False)
if product_id != 0:
project = Project.objects.filter(
Q(product_id=product_id) & Q(is_offline=False))
all_env = Environment.objects.filter(
Q(project__in=project) & Q(is_enable=True))
else:
all_env = Environment.objects.all()
page_len = request.GET.get('page_len', '')
envs_list, p, envs, page_range, current_page, show_first, show_end, end_page = pages(
all_env, request)
return render(request, 'tests/env_prepare.html', locals())
def deploy_list(request):
deploy_status = request.GET.get('deploy_status', '')
keyword = request.GET.get('keyword', '').encode('utf8')
if keyword:
keyword_deploy = Deploy.objects.filter(Q(app_name__name__icontains=keyword) \
| Q(order_user=keyword))
else:
keyword_deploy = Deploy.objects.all()
if request.user.is_superuser:
if not deploy_status:
all_deploy = Deploy.objects.filter(status=0) & keyword_deploy
elif deploy_status == '-1':
all_deploy = keyword_deploy
else:
all_deploy = Deploy.objects.filter(
status=deploy_status) & keyword_deploy
else:
username = request.user.username
if not deploy_status:
owner = Deploy.objects.filter(
Q(app_name__product__owner__username__username=username)
& Q(status=0)) & keyword_deploy
ops = Deploy.objects.filter(
Q(app_name__ops__username__username=username)
& Q(status=0)) & keyword_deploy
deploys = Deploy.objects.filter(
Q(order_user=username) & Q(status=0)) & keyword_deploy
all_deploy = owner | ops | deploys
elif deploy_status == '-1':
owner = Deploy.objects.filter(
app_name__product__owner__username__username=username
) & keyword_deploy
ops = Deploy.objects.filter(
app_name__ops__username__username=username) & keyword_deploy
deploys = Deploy.objects.filter(
order_user=username) & keyword_deploy
all_deploy = owner | ops | deploys
else:
owner = Deploy.objects.filter(
Q(app_name__product__owner__username__username=username)
& Q(status=deploy_status)) & keyword_deploy
ops = Deploy.objects.filter(
Q(app_name__ops__username__username=username)
& Q(status=deploy_status)) & keyword_deploy
deploys = Deploy.objects.filter(
Q(order_user=username)
& Q(status=deploy_status)) & keyword_deploy
all_deploy = owner | ops | deploys
page_len = request.GET.get('page_len', '')
deploys_list, p, deploys, page_range, current_page, show_first, show_end, end_page = pages(
all_deploy, request)
return render(request, 'orders/deploy_list.html', locals())
def config_list(request):
config_status = request.GET.get('config_status', '')
keyword = request.GET.get('keyword', '').encode('utf8')
if keyword:
keyword_config = Config.objects.filter(Q(app_name__name__icontains=keyword) \
| Q(order_user=keyword))
else:
keyword_config = Config.objects.all()
if request.user.is_superuser:
if not config_status:
all_config = Config.objects.filter(status=0) & keyword_config
elif config_status == '-1':
all_config = keyword_config
else:
all_config = Config.objects.filter(status=config_status) & keyword_config
else:
username = request.user.username
if not config_status:
owner = Config.objects.filter(
Q(app_name__product__owner__username__username=username) & Q(status=0)) & keyword_config
ops = Config.objects.filter(Q(app_name__ops__username__username=username) & Q(status=0)) & keyword_config
configs = Config.objects.filter(Q(order_user=username) & Q(status=0)) & keyword_config
all_config = owner | ops | configs
elif config_status == '-1':
owner = Config.objects.filter(app_name__product__owner__username__username=username) & keyword_config
ops = Config.objects.filter(app_name__ops__username__username=username) & keyword_config
configs = Config.objects.filter(order_user=username) & keyword_config
all_config = owner | ops | configs
else:
owner = Config.objects.filter(
Q(app_name__product__owner__username__username=username) & Q(status=config_status)) & keyword_config
ops = Config.objects.filter(
Q(app_name__ops__username__username=username) & Q(status=config_status)) & keyword_config
configs = Config.objects.filter(Q(order_user=username) & Q(status=config_status)) & keyword_config
all_config = owner | ops | configs
page_len = request.GET.get('page_len', '')
configs_list, p, configs, page_range, current_page, show_first, show_end, end_page = pages(all_config, request)
return render(request, 'orders/config_list.html', locals())
def versync_del(request):
status = 0
versync_id = int(request.GET.get('id', 0))
if id != 0:
try:
versync = Versync.objects.get(id=versync_id)
if versync.sync_status == 3 or versync.sync_status == 4:
VersyncDetail.objects.filter(versync=versync).delete()
versync.delete()
status = 1
else:
status = 2
except:
status = 3
else:
return HttpResponseRedirect(reverse('permission_deny'))
product_id = int(request.GET.get('product_id', 0))
all_product = Product.objects.filter(qa_id__isnull=False)
if product_id != 0:
all_versync = Versync.objects.filter(product_id=product_id)
else:
all_versync = Versync.objects.all()
page_len = request.GET.get('page_len', '')
versync_list, p, versyncs, page_range, current_page, show_first, show_end, end_page = pages(
all_versync, request)
return render(request, 'tests/versync_list.html', locals())
def versync_list(request):
product_id = int(request.GET.get('product_id', 0))
all_product = Product.objects.filter(qa_id__isnull=False)
if product_id != 0:
all_versync = Versync.objects.filter(product_id=product_id)
else:
all_versync = Versync.objects.all()
page_len = request.GET.get('page_len', '')
versyncs_list, p, versyncs, page_range, current_page, show_first, show_end, end_page = pages(
all_versync, request)
return render(request, 'tests/versync_list.html', locals())
def require_list(request):
require_status = request.GET.get('require_status', '')
keyword = request.GET.get('keyword', '').encode('utf8')
if keyword:
keyword_require = Require.objects.filter(Q(title__icontains=keyword) \
| Q(owner__username__username__icontains=keyword) \
| Q(order_user__icontains=keyword))
else:
keyword_require = Require.objects.all()
if request.user.is_superuser or request.user.is_staff:
if not require_status:
all_require = Require.objects.filter(status=0) & keyword_require
elif require_status == '-1':
all_require = keyword_require
else:
all_require = Require.objects.filter(
status=require_status) & keyword_require
else:
username = request.user.username
if not require_status:
owner = Require.objects.filter(
Q(owner__username__username=username)
& Q(status=0)) & keyword_require
requires = Require.objects.filter(
Q(order_user=username) & Q(status=0)) & keyword_require
all_require = owner | requires
elif require_status == '-1':
owner = Require.objects.filter(
owner__username__username=username) & keyword_require
requires = Require.objects.filter(
order_user=username) & keyword_require
all_require = owner | requires
else:
owner = Require.objects.filter(
Q(owner__username__username=username)
& Q(status=require_status)) & keyword_require
requires = Require.objects.filter(
Q(order_user=username)
& Q(status=require_status)) & keyword_require
all_require = owner | requires
page_len = request.GET.get('page_len', '')
requires_list, p, requires, page_range, current_page, show_first, show_end, end_page = pages(
all_require, request)
return render(request, 'orders/require_list.html', locals())
def dbscript_list(request):
dbscript_status = request.GET.get('dbscript_status', '')
keyword = request.GET.get('keyword', '').encode('utf8')
if keyword:
keyword_dbscript = DBScript.objects.filter(Q(db_name__name__icontains=keyword) \
| Q(order_user=keyword))
else:
keyword_dbscript = DBScript.objects.all()
if request.user.is_superuser:
if not dbscript_status:
all_dbscript = DBScript.objects.filter(status=0) & keyword_dbscript
elif dbscript_status == '-1':
all_dbscript = keyword_dbscript
else:
all_dbscript = DBScript.objects.filter(
status=dbscript_status) & keyword_dbscript
else:
username = request.user.username
if not dbscript_status:
owner = DBScript.objects.filter(
Q(db_name__product__owner__username__username=username)
& Q(status=0)) & keyword_dbscript
ops = DBScript.objects.filter(
Q(db_name__ops__username__username=username)
& Q(status=0)) & keyword_dbscript
dbscripts = DBScript.objects.filter(
Q(order_user=username) & Q(status=0)) & keyword_dbscript
all_dbscript = owner | ops | dbscripts
elif dbscript_status == '-1':
owner = DBScript.objects.filter(
db_name__product__owner__username__username=username
) & keyword_dbscript
ops = DBScript.objects.filter(
db_name__ops__username__username=username) & keyword_dbscript
dbscripts = DBScript.objects.filter(
order_user=username) & keyword_dbscript
all_dbscript = owner | ops | dbscripts
else:
owner = DBScript.objects.filter(
Q(db_name__product__owner__username__username=username)
& Q(status=dbscript_status)) & keyword_dbscript
ops = DBScript.objects.filter(
Q(db_name__ops__username__username=username)
& Q(status=dbscript_status)) & keyword_dbscript
dbscripts = DBScript.objects.filter(
Q(order_user=username)
& Q(status=dbscript_status)) & keyword_dbscript
all_dbscript = owner | ops | dbscripts
page_len = request.GET.get('page_len', '')
dbscripts_list, p, dbscripts, page_range, current_page, show_first, show_end, end_page = pages(
all_dbscript, request)
return render(request, 'orders/dbscript_list.html', locals())
def apply_del(request):
apply_id = int(request.GET.get('id', 0))
try:
Apply.objects.filter(id=apply_id).delete()
except:
return HttpResponseRedirect(reverse('permission_deny'))
apply_status = request.GET.get('apply_status', '-1')
if apply_status == '-1':
all_apply = Apply.objects.all()
else:
all_apply = Apply.objects.filter(status=apply_status)
page_len = request.GET.get('page_len', '')
apply_list, p, applys, page_range, current_page, show_first, show_end, end_page = pages(
all_apply, request)
return render(request, 'tests/apply_list.html', locals())
def apply_list(request):
apply_status = request.GET.get('apply_status', '-1')
if apply_status == '-1':
all_apply = Apply.objects.all()
else:
all_apply = Apply.objects.filter(status=apply_status)
page_len = request.GET.get('page_len', '')
apply_list, p, applys, page_range, current_page, show_first, show_end, end_page = pages(
all_apply, request)
return render(request, 'tests/apply_list.html', locals())
def apply_agree(request):
apply_id = int(request.GET.get('id', 0))
try:
apply = Apply.objects.filter(
Q(id=apply_id) & Q(status=True)
& Q(order_user=request.user.username))
if apply:
apply.update(feedback=1)
product = apply.first().product
all_project = Project.objects.filter(product=product)
for project in all_project:
env = Environment.objects.filter(
Q(project=project) & Q(is_enable=True)).first()
if env:
repo_name = "%s/%s" % (product.codename, project.name)
tag = "%s.Test" % (env.test_ver)
retag_image_release.delay(repo_name, tag)
else:
return HttpResponseRedirect(reverse('permission_deny'))
except:
return HttpResponseRedirect(reverse('permission_deny'))
apply_status = request.GET.get('apply_status', '-1')
if apply_status == '-1':
all_apply = Apply.objects.all()
else:
all_apply = Apply.objects.filter(status=apply_status)
page_len = request.GET.get('page_len', '')
apply_list, p, applys, page_range, current_page, show_first, show_end, end_page = pages(
all_apply, request)
return render(request, 'tests/apply_list.html', locals())
def asset_list(request):
keyword = request.GET.get('keyword','').encode("utf8")
all_asset = []
conn = get_conn()
if keyword:
sql = "select a.id,a.ip,a.public_ip,a.number,a.sn,a.comment,b.name \
from assets_asset a left join orgs_organization b \
on b.id = replace(a.org_id,'-','') \
where a.ip like '%{0}%' \
or a.public_ip like '%{0}%' \
or a.number like '%{0}%' \
or a.sn like '%{0}%' \
or a.comment like '%{0}%' \
order by a.ip".format(keyword)
else:
sql = "select a.id,a.ip,a.public_ip,a.number,a.sn,a.comment,b.name \
from assets_asset a left join orgs_organization b \
on b.id = replace(a.org_id,'-','') \
order by a.ip"
try:
cursor = conn.cursor()
cursor.execute(sql)
results = cursor.fetchall()
columns = cursor.description
finally:
cursor.close()
conn.commit()
conn.close()
for row in results:
asset_dict = {}
for col in range(len(columns)):
asset_dict[columns[col][0]] = row[col]
all_asset.append(asset_dict)
page_len = request.GET.get('page_len', '')
assets_list, p, assets, page_range, current_page, show_first, show_end, end_page = pages(all_asset, request)
return render(request, 'cmdb/asset_list.html', locals())
