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()
