def path():
query = "SELECT id FROM post;"
ids = DBconnect.select_query(query, ())
for id in ids:
id = id[0]
print(id)
res = DBconnect.select_query("SELECT parent, thread, id, path FROM post WHERE id = %s", (id, ))
parent = res[0][0]
if parent == "NULL" or parent is None:
query = "UPDATE post SET path = concat(thread, '.', id) WHERE id = %s;"
else:
query = "SELECT path FROM post WHERE id = %s;"
path = DBconnect.select_query(query, (parent, ))[0][0]
query = "UPDATE post SET path = concat('" + path + "', '.', id) WHERE id = %s;"
DBconnect.execute(query % (id, ))
query = "SELECT path FROM post WHERE id = %s;"
print(DBconnect.select_query(query, (id, ))[0][0])
return "ok"
def clear():
tables = ['post', 'thread', 'forum', 'subscription', 'follower', 'user']
DBconnect.execute("SET global foreign_key_checks = 0;")
for table in tables:
DBconnect.execute("TRUNCATE TABLE %s;" % table)
DBconnect.execute("SET global foreign_key_checks = 1;")
return
