IT Sharing

Create Term

#New Element
@route('/create')
def create():
	return template("create")

@route('/create', method="POST")
def success():
	term = request.forms.get('term')
	define = request.forms.get('define')
	cat = request.forms.get('category')
	conn = sqlite3.connect('glossary.db')
	#Used to get the count of the row, very inefficent
	count = 1
	c = conn.execute("SELECT * from table_definitions")
	rows = c.fetchall()
	for row in rows:
		count += 1
	if term != "" and define != "":
		#Definitions are accepted without categories
		if cat !="":
			c = conn.execute("INSERT INTO table_definitions (ID, str_term, str_definition, str_category) VALUES ('%s', '%s', '%s', '%s')" %(count, term, define, cat, ))
		else :
			c = conn.execute("INSERT INTO table_definitions (ID, str_term, str_definition) VALUES ('%s', '%s', '%s')" %(count, term, define,))
		conn.commit()
		conn.close()
		print(term + " added")
		return template("success")
	else : 
		conn.commit()
		conn.close()
		return template("failure")