def import_shares(): admin = User.objects.get(username='******') select = """SELECT sp.description, sp.random_dir, sp.submitted, p.description as pdescription, p.project_title as ptitle, g.db_group, t.type as type, t.description as type_description FROM sub_project sp join project p on sp.project_id = p.project_id join type t on sp.type_id = t.type_id join db_group g on g.group_id = p.group_id""" subprojects = dictfetchall(select) for sp in subprojects: share_id = '00000%s'%sp['random_dir'] try: share = Share.objects.get(id=share_id) share.delete() except: pass share = Share(id=share_id) share.name = ('%s: %s- %s, %s'%(sp['db_group'],sp['ptitle'],sp['type'],sp['submitted']))[:99] print 'Creating %s'%share.name[:99] share.notes = "Project Description:%s\nSubproject Description:%s"%(sp['pdescription'],sp['description']) share.owner=admin share.created = sp['submitted'] share.save() tag = Tag.objects.get_or_create(name=sp['db_group'])[0] share.tags.add(tag) share.save()
def import_shares(): admin = User.objects.get(username='******') select = """SELECT sp.description, sp.random_dir, sp.submitted, p.description as pdescription, p.project_title as ptitle, g.db_group, t.type as type, t.description as type_description FROM sub_project sp join project p on sp.project_id = p.project_id join type t on sp.type_id = t.type_id join db_group g on g.group_id = p.group_id""" subprojects = dictfetchall(select) for sp in subprojects: share_id = '00000%s' % sp['random_dir'] try: share = Share.objects.get(id=share_id) share.delete() except: pass share = Share(id=share_id) share.name = ( '%s: %s- %s, %s' % (sp['db_group'], sp['ptitle'], sp['type'], sp['submitted']))[:99] print 'Creating %s' % share.name[:99] share.notes = "Project Description:%s\nSubproject Description:%s" % ( sp['pdescription'], sp['description']) share.owner = admin share.created = sp['submitted'] share.save() tag = Tag.objects.get_or_create(name=sp['db_group'])[0] share.tags.add(tag) share.save()