app = Flask(__name__)
-#DATABASE = os.path.join(os.path.dirname(__file__), '..', 'data', 'fachschaften.sqlite')
-DATABASE = os.path.join(os.path.dirname(__file__), 'fachschaften.sqlite')
+DATABASE = os.path.join(os.path.dirname(__file__), '..', 'data', 'fachschaften.sqlite')
+#DATABASE = os.path.join(os.path.dirname(__file__), 'fachschaften.sqlite')
def get_db():
db = sqlite3.connect(DATABASE)
db = get_db()
cursor = db.cursor()
data = request.form
-
- print data
cursor.execute("INSERT INTO fachschaft "
"(langname, kurzname, land, stadt, studenten, "
- "organ, vertreten, organisation, fachschaftler) "
- "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)",
+ "organ, vertreten, organisation, fachschaftler, homepage) "
+ "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[data['unilang'],
data['unikurz'],
data['bundesland'],
data['fsorgan'],
data['vertretenestudis'],
data['organisationsform'],
- data['aktive']])
+ data['aktive'],
+ data['homepage']])
rowid = cursor.lastrowid
for i in range(0, 10):
if data['studiengang%d' % i] != '':
fachschaft = fachschaft,
studiengaenge = studiengaenge)
fdata = fdata.encode('utf-8')
- info = tarfile.TarInfo(name=fachschaft['kurzname'])
+ info = tarfile.TarInfo(name='%s.tex' % fachschaft['kurzname'].strip().lower().replace(' ', '_').replace('/','_'))
info.size = len(fdata)
tar.addfile(info, StringIO.StringIO(fdata))
print fdata