sqlalchemy

from sqlalchemy import *
from sqlalchemy.orm import sessionmaker
import database as db
import csv

keyword_list = []
i = 1
while i < 7:
    db_loc = 'sqlite:///./resource/'+str(i)+'/database.db'
    engine = create_engine(db_loc)
    Session = sessionmaker(bind=engine)
    session =  Session()
    q = session.query(db.Keyword.value).all()
    q = [r for r, in q]
    session.close()
    keyword_list += q
    keyword_list = list(set(keyword_list))
    i += 1
   
with open('keyword_file.csv', mode='w', encoding="utf8", newline='') as keyword_file:
    writer = csv.writer(keyword_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
    for k in keyword_list:
        writer.writerow([k, k])