def log_incep_op(sqltext,dbtag,mycreatetime):
lastlogin = mycreatetime
create_time = mycreatetime
username = '******'
sqltype='incept'
ipaddr = 'localhost'
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname='',dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_incep_op(sqltext,dbtag,request,mycreatetime):
user = User.objects.get(username=request.user.username)
lastlogin = user.last_login
create_time = mycreatetime
username = user.username
sqltype='incept'
ipaddr = func.get_client_ip(request)
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname='',dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_incep_op(sqltext,dbtag,request,mycreatetime):
user = User.objects.get(username=request.user.username)
lastlogin = user.last_login
create_time = mycreatetime
username = user.username
sqltype='incept'
ipaddr = func.get_client_ip(request)
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname='',dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_mysql_op(user,sqltext,mydbname,dbtag,request):
user = User.objects.get(username=user)
#lastlogin = user.last_login+datetime.timedelta(hours=8)
#create_time = timezone.now()+datetime.timedelta(hours=8)
lastlogin = user.last_login
create_time = timezone.now()
username = user.username
sqltype=sqltext.split()[0].lower()
#获取ip地址
ipaddr = get_client_ip(request)
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname=mydbname,dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_mysql_op(user,sqltext,mydbname,dbtag,request):
user = User.objects.get(username=user)
#lastlogin = user.last_login+datetime.timedelta(hours=8)
#create_time = datetime.datetime.now()+datetime.timedelta(hours=8)
lastlogin = user.last_login
create_time = datetime.datetime.now()
username = user.username
sqltype=sqltext.split()[0].lower()
#获取ip地址
ipaddr = get_client_ip(request)
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname=mydbname,dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_oracle_op(user,sqltext,mydbname,dbtag,ipaddr):
user = User.objects.get(username=user)
#lastlogin = user.last_login+datetime.timedelta(hours=8)
#create_time = datetime.datetime.now()+datetime.timedelta(hours=8)
lastlogin = user.last_login
create_time = datetime.datetime.now()
username = user.username
sqltype=sqltext.split()[0].lower()
if sqltype in ['desc','describe']:
sqltype='show'
#获取ip地址
log = Oper_log (user=username,sqltext=sqltext,sqltype=sqltype,login_time=lastlogin,create_time=create_time,dbname=mydbname,dbtag=dbtag,ipaddr=ipaddr)
log.save()
return 1
def log_mongo_op(sqltext, dbtag, tbname, request):
user = User.objects.get(username=request.user.username)
lastlogin = user.last_login
create_time = datetime.datetime.now()
username = user.username
sqltype = 'select'
ipaddr = get_client_ip(request)
log = Oper_log(user=username,
sqltext=sqltext,
sqltype=sqltype,
login_time=lastlogin,
create_time=create_time,
dbname=tbname,
dbtag=dbtag,
ipaddr=ipaddr)
log.save()
return 1