else: sql += "'unknown'" sql += ');\n' if (sql != "insert into articles(year,venue,title) values(1900, 'unknown', 'unknown');\n") and ('\\' not in sql): return sql else: return "" print "opening file..." with open("InsertingData/dblp1.xml", buffering=200000) as input: output = open("dump.data", "w") for line in input: article = get_data(line) if article.__str__(): if article.author: author = Authors().get(name=article.author) if author: article.author_id = author.id else: author = Authors() author.name = article.author[1:][:-1] author.save() author = Authors().get(name=author.name)[0] article.author = [author.id, ] output.write(article.__str__()) for i in article.author: sql = ''' insert into authorlists(author_id,article_id) values ({author},{article}); '''.format(author=i, article=ArticleModel().get(title=article.title))