def __init__(self, host, port, db_name, user, passwd, charset='utf8'):
"""
function:初始化数据库并连接
:param host: 数据库主机地址
:param port: 端口
:param db_name: 数据库名词
:param user: 数据库登录用户
:param passwd: 数据库登录密码
:param charset: 数据库字符集
"""
self.log = get_log("MySql")
self.host = host
self.port = port
self.user = user
self.passwd = passwd
self.db_name = db_name
self.charset = charset
self.log.info("开始连接数据库%s..." % self.host)
self.conn = connect(host=self.host,
port=self.port,
user=self.user,
passwd=self.passwd,
db=self.db_name,
charset=self.charset)
self.cur = self.conn.cursor()
self.log.info("连接数据库{}成功,库名%s！".format(self.host, self.db_name))
def __init__(self, host, user, password, database):
self.host = host
self.user = user
self.password = password
self.database = database
self.log = get_log("MySqlServer")
self.log.info("开始连接数据库%s..." % self.host)
self.conn = pymssql.connect(host=self.host,
user=self.user,
password=self.password,
database=self.database)
self.cur = self.conn.cursor()
self.log.info("连接数据库{}成功,库名为{}！".format(self.host, self.database))
# -*- coding:utf-8 -*-
"""
@author:WangYong
@workNumber:xy04952
@fileName: initEnvironment.py
@creatTime: 2019/09/20
"""
from download.common.insertSql import getSoftid
from download.models import SoftId, TestCase
from Logs.log import get_log
log = get_log("initEnvironment")
# softID查重
def rechecking(soft):
try:
count = TestCase.objects.filter(softId=soft)
except Exception as e:
log.info("登录用户查询异常：", e)
count = None
return count
# 初始化环境
def initEnviron():
data = getSoftid(100000)
soft_list = []
for d in data:
soft_list.append(SoftId(softId=d[0]))
from django.core.paginator import PageNotAnInteger, EmptyPage
from django.shortcuts import render, redirect, HttpResponse
from download.common.customPaginator import KingPaginator
from userinfo.common.tools import *
from Logs.log import get_log
from userinfo.common.userinit import *
from .models import User
import re
import threading
import time
log = get_log("login")
# 登录页面
def login(request):
if request.session.get("username"):
return redirect("index")
if request.method == "POST":
username = request.POST.get("username")
pwd = request.POST.get("pwd")
try:
count = User.objects.filter(username=username)
except Exception as e:
log.info("登录用户查询异常：", e)
count = None
if not count:
return render(request, 'user/login.html', {"massage": "账号密码输入错误！"})
from download.common.stepmodel import RecordConsumeLog, RecordBookShopLog, RecordDowninterfaceHits, \
RecordIncrePointFlowLog, \
UpdateSoftDownloadHit, GetFeedbackShieledUserGroupInfo, RecordFreePointDownFeeBackLog, \
RecordMonthlyExcellentDownFeeBackLog, \
AssetIncreasedMonthlyExcellentDown, AsserIncreasedForNormalFeeBack, FeeBackLogForMonthly, FeeBackLogForNormal, \
RecordSellIncomeLog, \
RecordUserGivePoint, GetIncrePointShieledGroupInfo, GetIncrePointRuleInfo, UpdateSoftPoint, \
RecordSoftPointIncreInfoLogAndUpdateDownNum, \
RecordFlowLogAfterSoftPointIncre, UpdateUserDown, AddSettlementLog, UpdateDownInfoStatus, HighWXTConsumeLog, \
HighWxtDownLoadStatisticsLog
from download.common.insertSql import getStatus, getRebate, getPoint
from download.common.sqlOprate import MySqlServer
from Logs.log import get_log
import time
log = get_log("rollBack")
# 获取执行结果
def getResult(softId, nowTime, funcPoint, softAuthor, AddTime):
"""
:param softId: 资料softId
:param nowTime: 获取结果执行时间
:param funcPoint: 功能，返利、升点
:param softAuthor: 资料作者
:param AddTime: 正常执行时间
:return:
"""
times = 0
while True:
if getStatus(softId, AddTime) == 1:
@fileName: performCase.py
@creatTime: 2019/09/17
"""
from download.models import TestCase, CaseResult, TestSoftId
from download.common.rollback import rollBackData
from download.common.inserts import initDate, initPoint, insertDate, getbate
from download.common.getCaseAttr import getNowTime, getDownloadId
from download.common.channel.initSnapshotData import insert_snapshots_table_data
from download.common.insertSql import initSoftPoint, updateDownloadDate, initDownloadDate, getStatus, getRebate, \
getPoint
from download.common.tools import getRandom
from Logs.log import get_log
import time
log = get_log("performCase")
# 用例执行函数
def runCase(caseIds, username, project):
if caseIds == 'all':
allId = TestCase.objects.filter(newCaseUser=username,
project=project).values('caseId')
ids = []
for d in allId:
ids.append(d["caseId"])
else:
ids = caseIds.split(',')
ids.reverse()
for caseId in ids:
try:
@workNumber:xy04952
@fileName: UserCaseManner.py
@creatTime: 2019/09/17
"""
from dateutil.parser import parse
import time
import re
import random
from download.models import TestCase
from userinfo.models import UserSoft
from download.common.getCaseAttr import getSoftInfo, isDate, getDownloadAuthorType
from Logs.log import get_log
log = get_log("caseOperate")
def getCaseId(project):
try:
Id = TestCase.objects.filter(
project=project).order_by("-createTime").values("caseId").first()
except Exception as e:
log.error(e)
if Id is None:
Id = "xkw-" + project + "_10" + "00"
else:
Id = "xkw-" + project + '_' + str(int(Id["caseId"].split('_')[1]) + 1)
return Id
# coding=utf-8
import time
import uuid
import requests
from download.common.sqlOprate import MySqlServer, MySql
from Logs.log import get_log
log = get_log("TestCase")
'''
不发放奖励 用户ID：26628667，26431488，4684283
---不涨点：
1.不升点用户ID: 4684283，13794598，10006491，资料classId=668, 1419, 850, 538, 4963, 1251, 5037, 4974, 1155
2. 资料栏目为理综，文综（classId=5247, 5248 ）,且上传用户为“蒋琳zok,mayanquan,zy1868,731486168,sunxinwei821,李辰辰”，不涨点
'''
# 初始化资料点数信息
def initSoftPoint(softId, authorId, AddTime, softPoint=0.00, softMoney=0.00, softCash=0.00, isSupply=0,
backCashRate=0, backMoneyRate=0):
"""
function:初始化数据，将资源点数设置为测试数据一致
:param isSupply: 高级点资料标识
:param softCash: 第三方资料价格
:param softMoney: 储值资料价格
:param backMoneyRate: 储值资料返现比
:param backCashRate:第三方资料返现比
:param AddTime:资料上传时间
:param authorId:资料上传者
:param softPoint: 资源普通点数
from django.core.paginator import PageNotAnInteger, EmptyPage
from django.shortcuts import render, redirect, HttpResponse
from download.common.customPaginator import JuncheePaginator
from UserInfo.common.userinit import initUserSoftId
from UserInfo.models import User
from Logs.log import get_log
from UserInfo.common.tools import decrypt, encrypt
import re
import threading
import time
log = get_log("UserInfo")
# 登录页面
def login(request):
if request.session.get("username"):
return redirect("index")
if request.method == "POST":
username = request.POST.get("username")
pwd = request.POST.get("pwd")
try:
count = User.objects.filter(username=username)
except Exception as e:
log.info("登录用户查询异常：", e)
count = None
if not count:
return render(request, 'user/login.html', {"massge": "账号密码输入错误！"})
# coding=utf-8
from download.common.sqlOprate import MySqlServer
from download.common.stepmodel import RecordBookShopLog, RecordConsumeLog,RecordDowninterfaceHits,\
RecordFlowLogAfterSoftPointIncre, RecordFreePointDownFeeBackLog, RecordIncrePointFlowLog, \
RecordMonthlyExcellentDownFeeBackLog, RecordSellIncomeLog, RecordUserGivePoint, \
RecordSoftPointIncreInfoLogAndUpdateDownNum, UpdateDownInfoStatus, UpdateSoftDownloadHit, UpdateSoftPoint, \
UpdateUserDown, GetFeedbackShieledUserGroupInfo, GetIncrePointRuleInfo, GetIncrePointShieledGroupInfo, \
AddSettlementLog, AsserIncreasedForNormalFeeBack, AssetIncreasedMonthlyExcellentDown, FeeBackLogForMonthly, \
FeeBackLogForNormal, HighWXTConsumeLog, HighWxtDownLoadStatisticsLog
from download.common.insertSql import getRebate, getPoint, getStatus
import time
from Logs.log import get_log
log = get_log("rollback")
# 获取执行结果
def getResult(softid, nowtime, funcPoint, softauthor, AddTime):
"""
:param softid: 资料softid
:param nowtime: 获取结果执行时间
:param funcPoint: 功能，返利、升点
:param softauthor: 资料作者
:param AddTime: 正常执行时间
:return:
"""
times = 0
while True:
if getStatus(softid, AddTime) == 1:
if funcPoint == '返利':
print("获取时间：", nowtime)
import time
import uuid
from Logs.log import get_log
from download.common.sqlOprate import MySqlServer
log = get_log("wxtChannel")
'''
不发放奖励 用户ID：26628667，26431488，4684283
---不涨点：
1.不升点用户ID: 4684283，13794598，10006491，资料classId=668, 1419, 850, 538, 4963, 1251, 5037, 4974, 1155
2. 资料栏目为理综，文综（classId=5247, 5248 ）,且上传用户为“蒋琳zok,mayanquan,zy1868,731486168,sunxinwei821,李辰辰”，不涨点
'''
# 插入快照数据
def insertWxt(SoftPoint, SoftMoney, isSupply, softCash, backMoneyRate,
authorUserID, SoftID, DownloadUserID, AddTime, route,
backCashRate):
"""
function:向快照表插入数据
:param backCashRate: 现金返现比例
:param AddTime:资料上传时间
:param softCash:现金
:param backMoneyRate:储值返现比例
:param isSupply:高级点
:param SoftMoney:储值
:param route: 通道类型ID
:param SoftPoint: 下载资料点数
:param authorUserID:资料作者
