-
Notifications
You must be signed in to change notification settings - Fork 0
/
gestion_spell.py
35 lines (31 loc) · 1.19 KB
/
gestion_spell.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
#-*- encoding: utf-8 -*-
import sqlite3
from flask import render_template, g, flash, session, url_for, redirect, request
from dota2 import app
from droits import get_droits
def connect_db(base):
return sqlite3.connect(base)
def delete_spell(id):
g.db = connect_db(app.config['USER_DB'])
g.db.execute('delete from spells where id = ?', [id])
g.db.commit()
g.db.close()
@app.route('/gestion_spell/')
@app.route('/gestion_spell/<int:id>')
def gestion_spell(id=0):
if 'logged_in' in session:
uid = session['user_id']
g.db = connect_db(app.config['USER_DB'])
droits = get_droits(uid)
g.db.close()
if droits['adm'] == 1:
if id != 0:
delete_spell(id)
flash(u'Le sort a ete correctement supprime')
g.db = connect_db(app.config['USER_DB'])
cur = g.db.execute('select * from spells order by id desc')
entries = [dict(id=row[0], name_hero=row[1], name=row[2], pos=row[5]) for row in cur.fetchall()]
g.db.close()
return render_template("gestion_spell.html", entries=entries)
flash(u"Vous n'avez pas les droits")
return redirect(url_for('default'))