コード例 #1
0
ファイル: coconut.py プロジェクト: manuelchacon07/Coconut-pro
def backups():
 # Check session
 v_user = functions.getcoockie('s_user')
 if v_user == "":
  abort(401, "Sorry, access denied.")
 else:
  # Request session
  v_password = functions.getcoockie('s_password')
  v_role = functions.getcoockie('s_role')
  print (v_role)
  # Filter role 1
  if str(v_role) in '1':
   print ('Soy profesor')
   v_fromdate = request.forms.get('date1')
   v_todate = request.forms.get('date2')
   v_hostname = request.forms.get('hostname')
   v_student = request.forms.get('students')
   print (v_student)
   print (v_hostname)
   selectallstudents="select user_name from users;"
   students=functions.selectall(selectallstudents, v_user, v_password)
   if v_student == "" or v_student == None:
    if v_hostname == "All" or v_hostname == None:
     if v_fromdate == None:
      sql_select="SELECT backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name FROM BACKUPS JOIN HOSTS ON host_ip = backup_host;"
     else:
      sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name FROM backups JOIN HOSTS ON host_ip = backup_host where backup_date between '%s 00:00:00' and '%s 23:59:59' order by backup_date desc;" %(v_fromdate, v_todate)
    else:
     sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name FROM backups JOIN HOSTS ON host_ip = backup_host where backup_date between '%s 00:00:00' and '%s 23:59:59' and backup_host in (select host_ip from hosts where host_name = '%s') order by backup_date desc;" %(v_fromdate, v_todate, v_hostname)
   else:
    if v_hostname == "All" or v_hostname == None:
     if v_fromdate == None:
      sql_select="SELECT backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name FROM BACKUPS JOIN HOSTS ON host_ip = backup_host where backup_user = '******';" %(v_student)
     else:
      sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name from backups JOIN HOSTS ON host_ip = backup_host where backup_date between '%s 00:00:00' and '%s 23:59:59' and backup_user = (select user_user from users where user_name = '%s') order by backup_date desc;" %(v_fromdate, v_todate, v_student)
    else:
     sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS'), host_owner, host_name from backups JOIN HOSTS ON host_ip = backup_host where backup_date between '%s 00:00:00' and '%s 23:59:59' and backup_host = (select host_ip from hosts where host_owner = (select user_user from users where user_name = '%s') and host_name = '%s') order by backup_date desc;" %(v_fromdate, v_todate, v_student, v_hostname)
   campos = functions.selectall(sql_select, v_user, v_password)
   gravatar_url = functions.miniavatar(v_user,v_password)
   return template('views/backups.tpl', students=students, user_user=v_user, user_urlimage=gravatar_url, backups=campos, rol=v_role)
  else:
   v_fromdate = request.forms.get('date1')
   v_todate = request.forms.get('date2')
   v_host = request.forms.get('host')
   # Filter querys
   if v_host == "" or v_host == None:
    if v_fromdate == None:
     sql_select="SELECT backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS') FROM BACKUPS WHERE backup_user='******'" %(v_user)
    else:
     sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS') from backups where backup_date between '%s 00:00:00' and '%s 23:59:59' and backup_user = '******' order by backup_date desc;" %(v_fromdate, v_todate, v_user)
   else:
    sql_select="select backup_host, backup_label, backup_description, backup_mode, to_char(backup_date, 'DD-MM-YYYY HH24:MI:SS') from backups where backup_date between '%s 00:00:00' and '%s 23:59:59' and backup_host = (select host_ip from hosts where host_owner = '%s' and host_ip = '%s') order by backup_date desc;" %(v_fromdate, v_todate, v_user, v_host)
   # Filter function
   campos=functions.selectall(sql_select, v_user, v_password)
   # Gravatar function
   gravatar_url = functions.miniavatar(v_user,v_password)
   return template('views/backups.tpl', backups=campos, user_user=v_user, user_urlimage=gravatar_url, rol=v_role)
コード例 #2
0
ファイル: coconut.py プロジェクト: manuelchacon07/Coconut-pro
def stats():
 v_user = functions.getcoockie('s_user')
 if v_user == "":
  abort(401, "Sorry, access denied.")
 else:
  v_password = functions.getcoockie('s_password')
  totalbackups="select count(backup_date) from backups;"
  sqlselectmode="select backup_mode, count(backup_host) from backups group by backup_mode;"
  sqlselecthosts="select h.host_name, count(b.backup_host) from backups b, hosts h where h.host_ip = b.backup_host group by h.host_name;"
  p_totalbackups=functions.database_select(totalbackups, v_user, v_password)
  backupsmode=functions.selectall(sqlselectmode, v_user, v_password)
  backupshost=functions.selectall(sqlselecthosts, v_user, v_password)
  total=int(p_totalbackups[0])
  gravatar_url = functions.miniavatar(v_user,v_password)
  return template('views/stats.tpl', user_user=v_user, user_urlimage=gravatar_url, total=total, modes=backupsmode, names=backupshost)
コード例 #3
0
ファイル: coconut.py プロジェクト: manuelchacon07/Coconut-pro
def dashboard():
 # Check session
 v_user = functions.getcoockie('s_user')
 if v_user == "":
  abort(401, "Sorry, access denied.")
 else:
  # Request session
  v_password = functions.getcoockie('s_password')
  v_name = functions.getcoockie('s_name')
  v_role = functions.getcoockie('s_role')
  # Last 5 backups query
  selectbackupusers="select backup_host, host_name, backup_user, to_char(backup_date, 'DD-MM-YYYY'), to_char(backup_date,'HH24:MI') from backups join hosts on host_ip = backup_host order by backup_date desc limit 5;"
  backupsusers=functions.selectall(selectbackupusers, v_user, v_password)
  # Stats querys & functions
  totalbackups="select count(backup_date) from backups;"
  sqlselectmode="select backup_mode, count(backup_host) from backups group by backup_mode;"
  sqlselecthosts="select h.host_name, count(b.backup_host) from backups b, hosts h where h.host_ip = b.backup_host group by h.host_name;"
  p_totalbackups=functions.database_select(totalbackups, v_user, v_password)
  backupsmode=functions.selectall(sqlselectmode, v_user, v_password)
  backupshost=functions.selectall(sqlselecthosts, v_user, v_password)
  total=int(p_totalbackups[0])
  # Gravatar function
  gravatar_url = functions.miniavatar(v_user,v_password)
  return template('views/index.tpl', user_user=v_user, user_name=v_name, user_urlimage=gravatar_url, backupsusers=backupsusers, total=total, modes=backupsmode, names=backupshost, rol=v_role)
コード例 #4
0
ファイル: coconut.py プロジェクト: manuelchacon07/Coconut-pro
def newbackup():
 # Check session
 v_user = functions.getcoockie('s_user')
 if v_user == "":
  abort(401, "Sorry, access denied.")
 else:
  # Request session
  v_password = functions.getcoockie('s_password')
  v_role = functions.getcoockie('s_role')
  # Host list query & function
  sql_select="select host_ip from hosts where host_owner  = '%s';" %(v_user)
  campos=functions.selectall(sql_select, v_user, v_password)
  # Gravatar function
  gravatar_url = functions.miniavatar(v_user,v_password)
  return template('views/newbackup.tpl', user_user=v_user, hosts=campos, user_urlimage=gravatar_url, rol=v_role)