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