def edit_tags(request):
if request.method == 'POST':
if request.POST.get('tagName'):
tg = request.POST.get('tagName')
conn = sqlite3.connect('db.sqlite3')
c = conn.cursor()
c.execute("SELECT * FROM bookmarks_tag_list")
result = c.fetchall()
tgs = [r[1] for r in result]
if tg not in tgs:
newTag = Tag_list(tags = tg)
newTag.save()
elif request.POST.get('deleteTag'):
tggs = request.POST.get('delete_tag')
conn = sqlite3.connect('db.sqlite3')
o = conn.cursor()
mydata = o.execute("DELETE FROM bookmarks_tag_list WHERE tags = ?", (tggs,))
conn.commit()
conn = sqlite3.connect('db.sqlite3')
b = conn.cursor()
b.execute("SELECT * FROM bookmarks_tag_list")
resultt = b.fetchall()
context = {'list': resultt}
return render(request, 'edit_tags.html', context)
def bookmarks(request):
if request.method == 'POST':
if request.POST.get('deleteUrl'):
urls = request.POST.get('delete_url')
conn = sqlite3.connect('db.sqlite3')
o = conn.cursor()
o.execute("DELETE FROM bookmarks_bookmark WHERE task = ?", (urls,))
conn.commit()
o.close()
conn = sqlite3.connect('db.sqlite3')
c = conn.cursor()
c.execute("SELECT * FROM bookmarks_bookmark")
result = c.fetchall()
ids = [r[0] for r in result]
tags = [r[1] for r in result]
urls = [r[2] for r in result]
j = ",".join(tags) #Converting list into string i.e. from ['abc, xyz'] to 'abc, xyz'
k = j.split(',') # 'abc, xyz' to ['abc', 'xyz']
s_tags = unique(k)
s = conn.cursor() #Filling Tag_list Table if for some additional tags
s.execute("SELECT * FROM bookmarks_tag_list")
res = s.fetchall()
tg_ids = [f[0] for f in res]
tg_list = [f[1] for f in res]
inter = intersect(s_tags, tg_list)
new_tags = [x for x in s_tags if x not in inter]
i = [idx for idx,t in enumerate(new_tags)]
for y in i:
tagInstance = Tag_list(tags = new_tags[y])
tagInstance.save()
list = zip(ids, urls)
context = {'list': list, 'all_tags': s_tags}
return render(request, 'bookmark.html', context)
