db.create_all()

missing = Topic.query.filter_by(topicname = 'General').first()

if missing is None:

t = Topic('General', None)

db.session.add(t)

db.session.commit()

langs = Language.query.filter_by(code = 'mn').first()

if langs is None:

t = Language('Azerbaijan', 'az')

db.session.add(t)

t = Language('Malayalam', 'ml')

db.session.add(t)

t = Language('Albanian', 'sq')

db.session.add(t)

t = Language('Maltese', 'mt')

db.session.add(t)

t = Language('Amharic', 'am')

db.session.add(t)

t = Language('Macedonian', 'mk')

db.session.add(t)

t = Language('English', 'en')

db.session.add(t)

t = Language('Maori', 'mi')

db.session.add(t)

t = Language('Arabic', 'ar')

db.session.add(t)

t = Language('Marathi', 'mr')

db.session.add(t)

t = Language('Armenian', 'hy')

db.session.add(t)

t = Language('Mari', 'mhr')

db.session.add(t)

t = Language('Afrikaans', 'af')

db.session.add(t)

t = Language('Mongolian', 'mn')

db.session.add(t)

t = Language('Basque', 'eu')

db.session.add(t)

t = Language('German', 'de')

db.session.add(t)

t = Language('Bashkir', 'ba')

db.session.add(t)

t = Language('Nepali', 'ne')

db.session.add(t)

t = Language('Belarusian', 'be')

db.session.add(t)

t = Language('Norwegian', 'no')

db.session.add(t)

t = Language('Bengali', 'bn')

db.session.add(t)

t = Language('Punjabi', 'pa')

db.session.add(t)

t = Language('Burmese', 'my')

db.session.add(t)

t = Language('Papiamento', 'pap')

db.session.add(t)

t = Language('Bulgarian', 'bg')

db.session.add(t)

t = Language('Persian', 'fa')

db.session.add(t)

t = Language('Bosnian', 'bs')

db.session.add(t)

t = Language('Polish', 'pl')

db.session.add(t)

t = Language('Welsh', 'cy')

db.session.add(t)

t = Language('Portuguese', 'pt')

db.session.add(t)

t = Language('Hungarian', 'hu')

db.session.add(t)

t = Language('Romanian', 'ro')

db.session.add(t)

t = Language('Vietnamese', 'vi')

db.session.add(t)

t = Language('Russian', 'ru')

db.session.add(t)

t = Language('Creole', 'ht')

db.session.add(t)

t = Language('Cebuano', 'ceb')

db.session.add(t)

t = Language('Galician', 'gl')

db.session.add(t)

t = Language('Serbian', 'sr')

db.session.add(t)

t = Language('Dutch', 'nl')

db.session.add(t)

t = Language('Sinhala', 'si')

db.session.add(t)

t = Language('Hill Mari', 'mrj')

db.session.add(t)

t = Language('Slovakian', 'sk')

db.session.add(t)

t = Language('Greek', 'el')

db.session.add(t)

t = Language('Slovenian', 'sl')

db.session.add(t)

t = Language('Georgian', 'ka')

db.session.add(t)

t = Language('Swahili', 'sw')

db.session.add(t)

t = Language('Gujarati', 'gu')

db.session.add(t)

t = Language('Sundanese', 'su')

db.session.add(t)

t = Language('Danish', 'da')

db.session.add(t)

t = Language('Tajik', 'tg')

db.session.add(t)

t = Language('Hebrew', 'he')

db.session.add(t)

t = Language('Thai', 'th')

db.session.add(t)

t = Language('Yiddish', 'yi')

db.session.add(t)

t = Language('Tagalog', 'tl')

db.session.add(t)

t = Language('Indonesian', 'id')

db.session.add(t)

t = Language('Tamil', 'ta')

db.session.add(t)

t = Language('Irish', 'ga')

db.session.add(t)

t = Language('Tatar', 'tt')

db.session.add(t)

t = Language('Italian', 'it')

db.session.add(t)

t = Language('Telugu', 'te')

db.session.add(t)

t = Language('Icelandic', 'is')

db.session.add(t)

t = Language('Turkish', 'tr')

db.session.add(t)

t = Language('Spanish', 'es')

db.session.add(t)

t = Language('Udmurt', 'udm')

db.session.add(t)

t = Language('Kazakh', 'kk')

db.session.add(t)

t = Language('Uzbek', 'uz')

db.session.add(t)

t = Language('Kannada', 'kn')

db.session.add(t)

t = Language('Ukrainian', 'uk')

db.session.add(t)

t = Language('Catalan', 'ca')

db.session.add(t)

t = Language('Urdu', 'ur')

db.session.add(t)

t = Language('Kyrgyz', 'ky')

db.session.add(t)

t = Language('Finnish', 'fi')

db.session.add(t)

t = Language('Chinese', 'zh')

db.session.add(t)

t = Language('French', 'fr')

db.session.add(t)

t = Language('Korean', 'ko')

db.session.add(t)

t = Language('Hindi', 'hi')

db.session.add(t)

t = Language('Xhosa', 'xh')

db.session.add(t)

t = Language('Croatian', 'hr')

db.session.add(t)

t = Language('Khmer', 'km')

db.session.add(t)

t = Language('Czech', 'cs')

db.session.add(t)

t = Language('Laotian', 'lo')

db.session.add(t)

t = Language('Swedish', 'sv')

db.session.add(t)

t = Language('Latin', 'la')

db.session.add(t)

t = Language('Scottish', 'gd')

db.session.add(t)

t = Language('Latvian', 'lv')

db.session.add(t)

t = Language('Estonian', 'et')

db.session.add(t)

t = Language('Lithuanian', 'lt')

db.session.add(t)

t = Language('Esperanto', 'eo')

db.session.add(t)

t = Language('Luxembourgish', 'lb')

db.session.add(t)

t = Language('Javanese', 'jv')

db.session.add(t)

t = Language('Malagasy', 'mg')

db.session.add(t)

t = Language('Japanese', 'ja')

db.session.add(t)

t = Language('Malay', 'ms')

db.session.add(t)

if db.session.query("1").from_statement("SELECT 1").all():

return 'It works.'

else:

form = TopicForm()

topics = Topic.query.all()

users = User.query.all()

messages = Message.query.all()

banned_from = [];

moderated_rooms = [];

session['room'] = 'General'

if 'email' not in session:

return redirect(url_for('signin'))

user = User.query.filter_by(email = session['email']).first()

if BannedUser.query.filter_by(user_id=user.uid).first() is not None:

flagged_rooms = BannedUser.query.filter_by(user_id=user.uid).all()

for room in flagged_rooms:

if room.times_flagged >= 5 and room.topic_id != 1:

print("banned from:")

print(room.topic_id)

banned_from.append(room.topic_id)

if Moderator.query.filter_by(user_id=user.uid).first() is not None:

print("mod exists")

mod_for = Moderator.query.filter_by(user_id=user.uid).all()

for room in mod_for:

print("mod")

print(room.topic_id)

if room.topic_id != 1:

moderated_rooms.append(Topic.query.filter_by(uid=room.topic_id).first().topicname)

if user is None:

return redirect(url_for('signin'))

else:

session['uid'] = user.uid

if request.method == 'POST':

if form.validate() == False:

return render_template('chat.html', form=form, topics=topics, users=users, messages=messages, banned_from=banned_from, moderated_rooms=moderated_rooms)

else:

uid = user.uid

newtopic = Topic(form.topicname.data, uid)

db.session.add(newtopic)

db.session.commit()

session['topic'] = newtopic.topicname

newtopic = Topic.query.filter_by(topicname=form.topicname.data).first()

mod = Moderator(user.uid, newtopic.uid)

db.session.add(mod)

db.session.commit()

return redirect('/chat/' + newtopic.topicname)

if request.method == 'GET':

form = TopicForm()

topics = Topic.query.all()

users = User.query.all()

messages = Message.query.all()

banned_from = []

moderated_rooms = []

banned_users = []

topic = Topic.query.filter_by(topicname = chatroom_title).first()

user = User.query.filter_by(email = session['email']).first()

if BannedUser.query.filter_by(user_id=user.uid).first() is not None:

flagged_rooms = BannedUser.query.filter_by(user_id=user.uid).all()

for room in flagged_rooms:

if room.times_flagged >= 5 and room.topic_id != 1:

print("banned from:")

print(room.topic_id)

banned_from.append(room.topic_id)

if BannedUser.query.filter_by(topic_id=topic.uid).first() is not None:

users = BannedUser.query.filter_by(topic_id=topic.uid).all()

for u in users:

if u.times_flagged >= 5 and u.topic_id != 1:

print(u.topic_id)

banned_users.append(User.query.filter_by(uid=u.user_id).first().username)

if Moderator.query.filter_by(user_id=user.uid).first() is not None:

print("mod exists")

mod_for = Moderator.query.filter_by(user_id=user.uid).all()

for room in mod_for:

print("mod")

print(room.topic_id)

if room.topic_id != 1:

moderated_rooms.append(Topic.query.filter_by(uid=room.topic_id).first().topicname)

if topic is None:

return redirect(url_for('chat'))

if topic.uid in banned_from:

return redirect(url_for('chat'))

session['room'] = topic.topicname

if 'email' not in session:

return redirect(url_for('signin'))

user = User.query.filter_by(email = session['email']).first()

if user is None:

return redirect(url_for('signin'))

else:

if request.method == 'POST':

if form.validate() == False:

return render_template('chat.html', form=form, topics=topics, users=users, messages=messages, banned_from=banned_from, moderated_rooms=moderated_rooms, banned_users=banned_users)

else:

uid = user.uid

newtopic = Topic(form.topicname.data, uid)

db.session.add(newtopic)

db.session.commit()

session['topic'] = newtopic.topicname

newtopic = Topic.query.filter_by(topicname=form.topicname.data).first()

mod = Moderator(user.uid, newtopic.uid)

db.session.add(mod)

db.session.commit()

return redirect('/chat/' + newtopic.topicname)

if request.method == 'GET':

form = TopicForm()

topics = Topic.query.all()

users = User.query.all()

messages = PrivateMessage.query.all()

chat_partner = User.query.filter_by(email = username).first()

if chat_partner is None:

return redirect(url_for('chat'))

session['room'] = convertToNumber(chat_partner.email) + convertToNumber(session['email'])

session['private'] = chat_partner.email

if 'email' not in session:

return redirect(url_for('signin'))

user = User.query.filter_by(email = session['email']).first()

if user is None:

return redirect(url_for('signin'))

else:

if request.method == 'POST':

if form.validate() == False:

return render_template('private.html', form=form, topics=topics, users=users, messages=messages, private=username)

else:

uid = user.uid

newtopic = Topic(form.topicname.data, uid)

db.session.add(newtopic)

db.session.commit()

session['topic'] = newtopic.topicname

return redirect('/chat/' + newtopic.topicname)

if request.method == 'GET':

form = TopicForm()

users = User.query.all()

messages = RandomMessage.query.all()

if 'email' not in session:

return redirect(url_for('signin'))

user = User.query.filter_by(email = session['email']).first()

if user is None:

return redirect(url_for('signin'))

if user.random is "":

return redirect(url_for('random_setting'))

session['room'] = convertToNumber(user.random+"random") + convertToNumber(session['email']+"random")

session['random'] = user.random

allUsers = User.query.all()

user = User.query.filter_by(email = session['email']).first()

if user is None:

return redirect(url_for('signin'))

form = RandomForm()

session['room'] = 'General'

if 'email' not in session:

return redirect(url_for('signin'))

if request.method == 'POST':

if form.validate() == False:

return render_template('random_setting.html', form=form, user=user, allUsers=allUsers)

else:

user.interests.append(Interest(form.interest.data))

db.session.commit()

return redirect(url_for('random_setting'))

if request.method == 'GET':

user = User.query.filter_by(email = session['email']).first()

if user is None:

return redirect(url_for('signin'))

form = ProfileForm(language=user.lang)

session['room'] = 'General'

form.language.choices = [(g.uid, g.name) for g in Language.query.order_by('name')]

if 'email' not in session:

return redirect(url_for('signin'))

if request.method == 'POST':

if form.validate() == False:

return render_template('profile.html', form=form, user=user)

else:

user.firstname = form.firstname.data

user.lastname = form.lastname.data

user.lang = form.language.data

db.session.commit()

return redirect(url_for('profile'))

if request.method == 'GET':

form = SignupForm()

session['room'] = 'General'

form.language.choices = [(g.uid, g.name) for g in Language.query.order_by('name')]

if 'email' in session:

return redirect(url_for('chat'))

if request.method == 'POST':

if form.validate() == False:

return render_template('signup.html', form=form)

else:

newuser = User(form.firstname.data, form.lastname.data, form.email.data, form.username.data, form.password.data, None, None, form.language.data)

db.session.add(newuser)

db.session.commit()

session['email'] = newuser.email

session['username'] = newuser.username

return redirect(url_for('chat'))

if request.method == 'GET':

form = SigninForm()

session['room'] = 'General'

if 'email' in session:

return redirect(url_for('chat'))

if request.method == 'POST':

if form.validate() == False:

return render_template('signin.html', form=form)

else:

session['email'] = form.email.data

return redirect(url_for('chat'))

elif request.method == 'GET':

if 'email' not in session:

return redirect(url_for('signin'))

session.pop('email', None)

session.pop('room', None)

if 'email' not in session:

return redirect(url_for('signin'))

user = User.query.filter_by(username = email).first()

if user is None:

return redirect(url_for('signin'))

else:

lang = Language.query.filter_by(uid = user.lang).first()

if lang:

return lang.code

if request.method == 'POST':

data = request.get_json()

try:

user = User.query.filter_by(username=data['email']).first()

lang = Language.query.filter_by(uid=user.lang).first()

if user is None:

return redirect(url_for('signin'))

return jsonify(result=tr.translate(data['text'], lang.code,

"", data['msg_id']))

except KeyError:

print('message =', message)

room = message['data']['room']

session['room'] = room

join_room(room)

print(session.get('email'))

print('has joined')

emit('status', {'user': session.get('username'), 'msg': session.get('username') + ' has entered ' + room + '.'}, room=room)

user = User.query.filter_by(email=session.get('email')).first()

user.topic_name = room

print(user.topic_name)

print(session['room'])

print('message =', message)

room = message['data']['room']

session['room'] = room

join_room(room)

print(session.get('email'))

print('has joined')

print('message =', message)

room = message['data']['room']

session['room'] = room

join_room(room)

print(session.get('email'))

print('has joined')

email = session.get('email')

room = session.get('room')

user = User.query.filter_by(email=email).first()

uid = user.uid

email = user.email

username = user.username

room = Topic.query.filter_by(topicname=room).first()

topic_uid = room.uid

topic_name = room.topicname

message_text = message['data']['message']

print(message_text)

r = requests.post("https://commentanalyzer.googleapis.com/v1alpha1/comments:analyze?key=AIzaSyAj5W2revGlFYriELZLCAXa5RvyA8FMUUA", data='{"comment": {"text": "' + message_text + '"},"languages": ["en"], "requestedAttributes": {"TOXICITY":{}}}')

print(r.text)

json = r.json()

score = json['attributeScores']['TOXICITY']['spanScores'][0]['score']['value']

score = round(score*100)

print(score)

msg = Message(message['data']['message'], uid, email, topic_uid, topic_name, score)

db.session.add(msg)

db.session.flush()

emit('message', {'id':msg.uid, 'text': message['data']['message'], 'author': username, 'time': ' just now', 'score': score}, room=topic_name)

db.session.refresh(msg)

print("ban")

print(message)

banned_user = User.query.filter_by(username=message['data']['user']).first()

room = Topic.query.filter_by(topicname=message['data']['room']).first()

banned_user = BannedUser(banned_user.uid, room.uid)

banned_user.times_flagged = 500;

banFromRoom(banned_user.user_id, room.uid)

db.session.add(banned_user)

print("unban")

print(message)

unbanned_user = User.query.filter_by(username=message['data']['user']).first()

room = Topic.query.filter_by(topicname=message['data']['room']).first()

if BannedUser.query.filter_by(user_id=unbanned_user.uid).first() is not None:

for u in BannedUser.query.filter_by(user_id=unbanned_user.uid):

if u.topic_id == room.uid:

emit('unbanned', {'user': unbanned_user.username, 'room': room.topicname}, broadcast=True)

db.session.delete(u)

room = session.get('room')

print(message)

flagging_user = session.get('username')

flag = message['data']['flag']

flagged_user = message['data']['user']

if flagging_user != flagged_user:

flagged_user = User.query.filter_by(username=message['data']['user']).first()

room = Topic.query.filter_by(topicname=room).first()

if flagged_user != User.query.filter_by(uid=room.user_id).first().username:

if flag == 'offensive' or flag == 'spam':

print('offensive')

banned_user = BannedUser(flagged_user.uid, room.uid)

if BannedUser.query.filter_by(user_id=flagged_user.uid).first() is None:

banned_user.times_flagged = 1

db.session.add(banned_user)

db.session.commit()

# increment num bans

else:

for p in BannedUser.query.all():

print(p.user_id)

if p.user_id == flagged_user.uid:

if p.topic_id == room.uid:

p.times_flagged = p.times_flagged + 1

print("flagged: ")

print(p.times_flagged)

if p.times_flagged >= 5 and p.topic_id != 1:

print("banned user from room")

banFromRoom(p.user_id, room.uid)

db.session.add(p)

db.session.commit()

return

banned_user.times_flagged =1

db.session.add(banned_user)

db.session.commit()

print("message = ", message)

print(message['data']['message'])

email = session.get('email')

room = session.get('room')

receiver_email = session.get('private')

emit('private_message', {'text': message['data']['message'], 'author': email, 'time': ' just now'}, room=room)

sender = User.query.filter_by(email=email).first()

sender_id = sender.uid

sender_email = sender.email

receiver = User.query.filter_by(email=receiver_email).first()

receiver_id = receiver.uid

message = PrivateMessage(message['data']['message'], sender_id, sender_email, receiver_id, receiver_email)

db.session.add(message)

print("message = ", message)

print(message['data']['message'])

email = session.get('email')

room = session.get('room')

receiver_email = session.get('random')

emit('random_message', {'text': message['data']['message'], 'author': email, 'time': ' just now'}, room=room)

sender = User.query.filter_by(email=email).first()

sender_id = sender.uid

sender_email = sender.email

receiver = User.query.filter_by(email=receiver_email).first()

receiver_id = receiver.uid

message = RandomMessage(message['data']['message'], sender_id, sender_email, receiver_id, receiver_email)

db.session.add(message)

# add email to active_list

# loop: max 3 tries, 5 sec wait

# check if user is on the list. If not, means user already matched, break.

# get other users who's also in session

# search for partner, add to same_interests

# if not found, do it again

# if found, check if user is already matched.

# check if partner is still active

# remove email from active_list

print("message = ", message)

print(message['data']['message'])

myEmail = session.get('email')

active_list.add(myEmail)

user = User.query.filter_by(email=myEmail).first()

others = User.query.filter(User.email != myEmail).all()

interests = user.interests

interests_set = set()

for i in interests:

interests_set.add(i.interest_name.lower())

# list of other users who have same interests as you do, and

# how many same interets they have.

same_interests = []

# search for same interests

tries = 5

partner_email = ""

# the loop

while tries > 0:

print ("in loop")

print (active_list)

if myEmail not in active_list:

break

for other in others:

if other.email in active_list:

count = 0

for i in other.interests:

print(other.email + " " + i.interest_name)

if i.interest_name.lower() in interests_set:

count = count - 1

if count != 0:

heappush(same_interests, (count, other.email))

if len(same_interests) != 0 and myEmail in active_list:

while len(same_interests) != 0:

other_email = heappop(same_interests)[1]

if other_email in active_list:

active_list.remove(other_email)

active_list.remove(myEmail)

partner_email = other_email

break

if partner_email != "":

new_partner = User.query.filter_by(email=partner_email).first()

old_of_new_partner = User.query.filter_by(random=partner_email).first()

if old_of_new_partner != None and old_of_new_partner != user:

old_of_new_partner.random = ""

old_partner = User.query.filter_by(random=myEmail).first()

if old_partner != None and old_partner != new_partner:

old_partner.random = ""

new_partner.random = user.username

user.random = new_partner.username

RandomMessage.query.filter_by(sender_email=myEmail).delete()

RandomMessage.query.filter_by(receiver_email=myEmail).delete()

RandomMessage.query.filter_by(sender_email=partner_email).delete()

RandomMessage.query.filter_by(sender_email=partner_email).delete()

db.session.commit()

break

# next loop

tries -= 1

time.sleep(2)

# loop ends

print ("loop ends")

emit('new_random', {'partner': partner_email})

print("message = ", message)

print(message['data']['message'])

myEmail = session.get('email')

user = User.query.filter_by(email=myEmail).first()

others = User.query.filter(User.email != myEmail).all()

interests = user.interests

interests_set = set()

for i in interests:

interests_set.add(i.interest_name.lower())

# list of other users who have same interests as you do, and

# how many same interets they have.

same_interests = []

# wait 10 seconds for others to join

time.sleep(10)

active_list.add(myEmail)

# search for same interests

partner_email = ""

if myEmail in active_list:

for other in others:

if other.email in active_list:

count = 0

for i in other.interests:

print(other.email + " " + i.interest_name)

if i.interest_name.lower() in interests_set:

count = count - 1

if count != 0:

heappush(same_interests, (count, other.email))

if len(same_interests) != 0 and myEmail in active_list:

while len(same_interests) != 0:

other_email = heappop(same_interests)[1]

if other_email in active_list:

active_list.remove(other_email)

active_list.remove(myEmail)

partner_email = other_email

break

if partner_email != "":

new_partner = User.query.filter_by(email=partner_email).first()

old_of_new_partner = User.query.filter_by(random=partner_email).first()

if old_of_new_partner != None and old_of_new_partner != user:

old_of_new_partner.random = ""

old_partner = User.query.filter_by(random=myEmail).first()

if old_partner != None and old_partner != new_partner:

old_partner.random = ""

new_partner.random = user.username

user.random = new_partner.username

RandomMessage.query.filter_by(sender_email=myEmail).delete()

RandomMessage.query.filter_by(receiver_email=myEmail).delete()

RandomMessage.query.filter_by(sender_email=partner_email).delete()

RandomMessage.query.filter_by(sender_email=partner_email).delete()

db.session.commit()

emit('new_random', {'partner': partner_email})

print("message = ", message)

print(message['data']['message'])

myEmail = session.get('email')

user = User.query.filter_by(email=myEmail).first()

others = User.query.filter(User.email != myEmail).all()

interests = user.interests

interests_set = set()

for i in interests:

print (i.interest_name)

interests_set.add(i.interest_name.lower())

same_interests = []

interest_to_users = {}

topic_name = ""

for i in interests_set:

count = 0

friends = []

for other in others:

for other_i in other.interests:

if other_i.interest_name.lower() == i:

count += 1;

friends.append(other.username)

if count > 0:

heappush(same_interests, (-count, i))

interest_to_users[i] = friends

print(same_interests)

interest = ""

while len(same_interests) > 0:

interest = heappop(same_interests)[1]

print("interest" + interest)

if Topic.query.filter_by(topicname=interest).first() != None:

continue

topic_name = interest

room = Topic(topic_name, user.uid)

db.session.add(room)

db.session.commit()

room = Topic.query.filter_by(topicname=topic_name).first()

mod = Moderator(user.uid, room.uid)

db.session.add(mod)

db.session.commit()

break

if topic_name == "":

emit('redirect', '/random_setting')

else:

emit('redirect', '/chat/' + room.topicname)

room = session.get('room')

leave_room(room)

print(session.get('email'))

print('left room')

emit('status', {'user': session.get('username'), 'msg': session.get('username') + ' has left ' + room + '.'}, room=room)

user = User.query.filter_by(email=session.get('email')).first()

session.pop('room', None)

user.topic_name = None

room = session.get('room')

leave_room(room)

print(session.get('email'))

print('left room')

emit('private_status', {'msg': session.get('email') + ' is offline.'}, room=room)

room = session.get('room')

leave_room(room)

print(session.get('email'))

print('left room')

emit('random_status', {'msg': session.get('email') + ' is offline.'}, room=room)

print("New topic\n")

user = User.query.filter_by(email=session.get('email')).first()

print(user)

print(message)

print(message['data']['room'])

print("Added")

print(message['data']['user'])

user = User.query.filter_by(email=message['data']['user']).first()

room = Topic.query.filter_by(topicname=session.get('room')).first()

mod = Moderator(user.uid, room.uid)

db.session.add(mod)

print("Removed")

print(message['data']['user'])

user = User.query.filter_by(email=message['data']['user']).first()

room = Topic.query.filter_by(topicname=session.get('room')).first()

for mod in Moderator.query.filter_by(user_id=user.id):

if mod.topic_id == room.id:

db.session.delete(mod)

print("delete_my_chatroom\n")

print("This is message ")

print(message)

topic_id = message['data']['id']

parent = message['data']['parent']

topic = Topic.query.filter_by(uid=topic_id).first()

print("hi")

for room in BannedUser.query.filter_by(topic_id=topic_id):

print(room.topic_id)

db.session.delete(room)

print("do")

for mod in Moderator.query.filter_by(topic_id=topic_id):