def export_from_mysql(self):
exporter = Exporter("examplestore.xml")
for product in self.session.query(Product):
item = Item(exporter.database, "product%s" % product.id)
item.add_tag("product")
exporter.export(item)
for customer in self.session.query(Customer):
item = Item(exporter.database, "customer%s" % customer.id)
item.add_tag("customer")
for purchase in self.session.query(Purchase).filter_by(
customer=customer.id):
item.link_to("product%s" % purchase.product)
exporter.export(item)
exporter.finish()
def export_to_xml(self, users):
exporter = Exporter('recommendstore.xml')
# loop thru users and words
k_exist = []
for u in users:
#pitem = Item(exporter.database,u.twitter)
#pitem.add_tag('person')
#exporter.export(pitem)
for k in u.bio_kws:
if k not in k_exist:
item = Item(exporter.database, "k_%s" % k)
item.add_tag('keyword')
k_exist.append(k)
exporter.export(item)
#re-loop!!
for u in users:
pitem = Item(exporter.database, u.twitter)
pitem.add_tag('person')
for k in u.bio_kws:
pitem.link_to("k_%s" % k)
exporter.export(pitem)
exporter.finish()
