Exemple #1
0
def disable_req(request):
    if request.POST:
        if 'disable' in request.POST:
            mcid = normalize_mcid(request.POST['mcid'])
            user = User.objects.get(mcid=mcid)

            sql_execute('DELETE FROM groupmembers WHERE memberaccid=%s',
                        user.mcid)

            user.sha1 = None
            user.acctype = 'DISABLED'
            user.save()

        return HttpResponseRedirect('.')

    mcid = normalize_mcid(request.GET['mcid'])
    user = User.objects.get(mcid=mcid)
    ts = datetime.fromtimestamp(user.ccrlogupdatetime)

    where = [
        'groupmembers.memberaccid = %s' % mcid,
        'groupmembers.groupinstanceid = groupinstances.groupinstanceid'
    ]

    member_of = Group.objects.extra(where=where, tables=['groupmembers'])

    return render_to_response(
        'users/disable.html',
        default_context(request,
                        mcuser=user,
                        ccrlogupdatetime=ts,
                        member_of=member_of))
Exemple #2
0
def create_group(name, mcid, url_root):
    """Create a group and a related practice.

    name is the name of the group and practice
    mcid is the account id of the owner
    url_root is the base URL of the for 'https://host'
    """
   
    group_mcid = mcid_generator.next_mcid()

    g = Group()
    g.name = name
    g.grouptypeid = 0
    g.accid_id = group_mcid
    g.save()

    p = Practice()
    p.providergroupid = g
    p.practicename = name
    p.accid_id = group_mcid
    p.save()

    p.practiceRlsUrl = url_root + '/acct/ws/R.php?pid=%d' % p.practiceid
    p.save()

    g.parentid = p.practiceid

    sql_execute("INSERT INTO groupmembers (groupinstanceid, memberaccid) " + \
                "VALUES (%s, %s)", int(g.groupinstanceid), mcid)

    sql_execute("INSERT INTO groupadmins (groupinstanceid, adminaccid, comment) " + \
                "VALUES (%s, %s, %s)", int(g.groupinstanceid), mcid, "")
    return g
Exemple #3
0
def upload_req(request):
    from base64 import b64decode

    if request.FILES and 'csv' in request.FILES:
        s = request.FILES['csv']['content']

    elif 'url' in request.REQUEST:
        s = urlopen(request.REQUEST['url']).read()

    else:
        return render_to_response('idps/upload.html',
                                  default_context(request))

    r = reader(StringIO(s))
    # okay to remove first column, the 'id' field
    columns = r.next()
    assert columns[0] == 'id'
    if 'png16x16' in columns:
        image_row = columns.index('png16x16')
    else:
        image_row = None

    columns = columns[1:]
    sql = "INSERT INTO identity_providers (" + ', '.join(columns) + \
          ") VALUES (" + ', '.join(['%s'] * len(columns)) + ')'

    for row in r:
        if image_row is not None and row[image_row]:
            row[image_row] = b64decode(row[image_row])
        sql_execute(sql, *row[1:]) 

    return HttpResponseRedirect('.')
Exemple #4
0
def add_to_group_req(request):
    mcid = normalize_mcid(request.GET["mcid"])
    group = request.GET["group"]

    sql_execute("INSERT INTO groupmembers (groupinstanceid, memberaccid) " + "VALUES (%s, %s);", int(group), mcid)

    return HttpResponseRedirect("user?mcid=" + mcid)
Exemple #5
0
def remove_from_group_req(request):
    mcid = normalize_mcid(request.GET["mcid"])
    group = request.GET["group"]

    sql_execute("DELETE FROM groupmembers " + "WHERE groupinstanceid=%s AND memberaccid=%s;", int(group), mcid)

    return HttpResponseRedirect("user?mcid=" + mcid)
Exemple #6
0
def disable_req(request):
    if request.POST:
        if "disable" in request.POST:
            mcid = normalize_mcid(request.POST["mcid"])
            user = User.objects.get(mcid=mcid)

            sql_execute("DELETE FROM groupmembers WHERE memberaccid=%s", user.mcid)

            user.sha1 = None
            user.acctype = "DISABLED"
            user.save()

        return HttpResponseRedirect(".")

    mcid = normalize_mcid(request.GET["mcid"])
    user = User.objects.get(mcid=mcid)
    ts = datetime.fromtimestamp(user.ccrlogupdatetime)

    where = ["groupmembers.memberaccid = %s" % mcid, "groupmembers.groupinstanceid = groupinstances.groupinstanceid"]

    member_of = Group.objects.extra(where=where, tables=["groupmembers"])

    return render_to_response(
        "users/disable.html", default_context(request, mcuser=user, ccrlogupdatetime=ts, member_of=member_of)
    )
Exemple #7
0
def my_uploads():
    """我的上传记录页面"""
    nid = session['id']
    sql = "select id, lines_num,user,upload_time from codes_upload where user=%d" % nid
    ret = sql_execute(sql)

    categories = []
    for item in ret:
        categories.append(str(item[3]))
    import json
    categories = json.dumps(categories)
    print('categories>>>>>>>>>>>>>>', categories, type(categories))

    lines_count = []
    for item in ret:
        lines_count.append(item[1])

    sql1 = 'select id,nick_name from user_profile where id=%s' % nid
    ret1 = sql_execute(sql1)
    ret = {
        'user': ret1,
        'data': ret,
        'categories': categories,
        'lines_count': lines_count
    }
    return render_template('codes/my_codes.html', data=ret)
def login():
    # 拿到用户信息
    if request.method == 'POST':
        username = request.form.get('username', '')
        password = request.form.get('password', '')
        print(username, password)

        # 进入数据库验证用户信息
        sql = 'select id, nick_name from user_profile where name = "%s" and password = "******"' % (
            username, password)
        rets = sql_execute(sql)
        ret = {'user': username, "data": rets}
        if ret:
            session['user'] = username
            session['id'] = ret['data'][0][0]
            session['is_login'] = True
            # 取出当前用户的所有权限url列表
            sql = '''select url from permmision where id in (select permission_id from role_permission where role_id in 
                      (select role from user_profile_role u_r where u_r.user =%d))''' % ret[
                'data'][0][0]
            ret = sql_execute(sql)
            ret = [item[0] for item in ret if item]
            print('urls>>>', ret)

            session['permission_urls'] = ret
            return redirect('/users')

    return render_template('account/login.html')
Exemple #9
0
def upload_req(request):
    from base64 import b64decode

    if request.FILES and 'csv' in request.FILES:
        s = request.FILES['csv']['content']

    elif 'url' in request.REQUEST:
        s = urlopen(request.REQUEST['url']).read()

    else:
        return render_to_response('idps/upload.html', default_context(request))

    r = reader(StringIO(s))
    # okay to remove first column, the 'id' field
    columns = r.next()
    assert columns[0] == 'id'
    if 'png16x16' in columns:
        image_row = columns.index('png16x16')
    else:
        image_row = None

    columns = columns[1:]
    sql = "INSERT INTO identity_providers (" + ', '.join(columns) + \
          ") VALUES (" + ', '.join(['%s'] * len(columns)) + ')'

    for row in r:
        if image_row is not None and row[image_row]:
            row[image_row] = b64decode(row[image_row])
        sql_execute(sql, *row[1:])

    return HttpResponseRedirect('.')
Exemple #10
0
def add_to_group_req(request):
    mcid = normalize_mcid(request.GET['mcid'])
    group = request.GET['group']

    sql_execute("INSERT INTO groupmembers (groupinstanceid, memberaccid) " + \
                "VALUES (%s, %s);", int(group), mcid)

    return HttpResponseRedirect("user?mcid=" + mcid)
Exemple #11
0
def remove_from_group_req(request):
    mcid = normalize_mcid(request.GET['mcid'])
    group = request.GET['group']

    sql_execute("DELETE FROM groupmembers " + \
                "WHERE groupinstanceid=%s AND memberaccid=%s;",
                int(group), mcid)

    return HttpResponseRedirect("user?mcid=" + mcid)
Exemple #12
0
def update_logo(id, file):
    i = Image.open(StringIO(file['content']))
    i.thumbnail((16, 16), Image.ANTIALIAS)

    o = StringIO()
    i.save(o, format='PNG')

    sql_execute("UPDATE identity_providers SET png16x16 = %s WHERE id = %s",
                o.getvalue(), id)
Exemple #13
0
def update_logo(id, file):
    i = Image.open(StringIO(file['content']))
    i.thumbnail((16, 16), Image.ANTIALIAS)

    o = StringIO()
    i.save(o, format='PNG')

    sql_execute("UPDATE identity_providers SET png16x16 = %s WHERE id = %s",
                o.getvalue(), id)
Exemple #14
0
def unlink_user(request, redirect):
    mcid = normalize_mcid(request.POST['mcid'])
    idp = request.POST['idp']
    username = request.POST['username']

    sql_execute("DELETE FROM external_users " + \
                "WHERE provider_id = %s AND mcid = %s AND username = %s",
                int(idp), mcid, username)

    return HttpResponseRedirect(redirect % locals())
Exemple #15
0
def remove_from_group_req(request):
    mcid = request.REQUEST['mcid']
    group = request.REQUEST['group']

    if 'delete' in request.POST or 'delete.x' in request.POST:
	sql_execute("DELETE FROM groupmembers " + \
	            "WHERE groupinstanceid=%s AND memberaccid=%s;",
	            int(group), mcid)

    return HttpResponseRedirect("group?id=" + group)
Exemple #16
0
def unlink_user(request, redirect):
    mcid = normalize_mcid(request.POST['mcid'])
    idp = request.POST['idp']
    username = request.POST['username']

    sql_execute("DELETE FROM external_users " + \
                "WHERE provider_id = %s AND mcid = %s AND username = %s",
                int(idp), mcid, username)

    return HttpResponseRedirect(redirect % locals())
Exemple #17
0
def remove_from_group_req(request):
    mcid = request.REQUEST['mcid']
    group = request.REQUEST['group']

    if 'delete' in request.POST or 'delete.x' in request.POST:
        sql_execute("DELETE FROM groupmembers " + \
                    "WHERE groupinstanceid=%s AND memberaccid=%s;",
                    int(group), mcid)

    return HttpResponseRedirect("group?id=" + group)
Exemple #18
0
def upload_code():
    error = None
    if request.method == 'POST':
        # 1、上传的文件不能为空
        if 'file' not in request.files:
            error = '需要上传文件'
            return render_template('codes/upload.html', error=error)

        file = request.files['file']
        print(file.filename)  # 文件名称
        print(file.stream)  # 文件内容
        # 2、上传的文件格式必须符号要求
        if file and allowed_file(file.filename):
            # 3、判断当前用户是否是首次上传
            today_str = str(datetime.datetime.now())[:10]
            sql = 'select * from codes_upload where user=%s and upload_time=%s' % (
                int(session.get('id', '')), "'" + today_str + "'")
            rets = sql_execute(sql)
            # print('查询结果:', rets)

            if not rets:
                # 4、接收用户上传文件并解压到指定的目录,生成随机文件夹名称,防止重名覆盖
                # 注意必须确保上传的文件是以zip方式压缩的,单纯的修改zip后缀仍然不算zip格式
                target_path = os.path.join(DevelopmentConfig.UPLOAD_FOLDER,
                                           str(uuid.uuid4()))
                shutil._unpack_zipfile(file.stream, target_path)

                # 6、遍历目录下的所有文件,并汇总出解压后的所有的文件的行数
                total_num = 0
                for root, dirs, files in os.walk(target_path):
                    # print(dirs)
                    # print(root)  # 文件夹的绝对路径
                    for filename in files:
                        line_count = 0
                        file_path = os.path.join(root, filename)
                        with open(file_path, 'rb') as f:
                            for line in f:
                                line = line.strip()
                                if not line or line.startswith(b'#'):
                                    continue
                                line_count += 1
                        total_num += line_count
                print(total_num)
                add_sql = 'insert into codes_upload (user,lines_num,upload_time) values (%s, %s, %s)' % (
                    session.get('id', ''), total_num, "'" + today_str + "'")
                rets = sql_execute(add_sql, type='insert')
                return redirect(
                    url_for('co.my_uploads', nid=int(session.get('id'))))

            error = '今天代码已上传'

        else:
            error = '文件必须为zip格式'
    return render_template('codes/upload.html', error=error)
Exemple #19
0
def delete_user(mcid):
    for ga in Groupadmin.objects.filter(adminaccid=mcid):
        g = Group.objects.get(groupinstanceid=ga.groupinstanceid)

        delete_group(g)
        ga.delete()

    sql_execute("DELETE FROM ccrlog WHERE accid = %s", mcid)
    sql_execute("DELETE FROM todir WHERE accid = %s", mcid)
    sql_execute("DELETE FROM groupmembers WHERE memberaccid = %s", mcid)
    sql_execute("DELETE FROM document_type WHERE dt_account_id = %s", mcid)
    sql_execute("DELETE FROM users WHERE mcid = %s", mcid)
Exemple #20
0
def delete_user(mcid):
	for ga in Groupadmin.objects.filter(adminaccid = mcid):
		g = Group.objects.get(groupinstanceid = ga.groupinstanceid)

		delete_group(g)
		ga.delete()

	sql_execute("DELETE FROM ccrlog WHERE accid = %s", mcid)
	sql_execute("DELETE FROM todir WHERE accid = %s", mcid)
	sql_execute("DELETE FROM groupmembers WHERE memberaccid = %s", mcid)
	sql_execute("DELETE FROM document_type WHERE dt_account_id = %s", mcid)
	sql_execute("DELETE FROM users WHERE mcid = %s", mcid)
Exemple #21
0
def delete_data():
    properties = get_properties()

    delete_user(properties['DemoDoctor'])

    for first_name, last_name, email, ccr, reason, ccrs in PATIENTS:
        users = User.objects.filter(first_name=first_name,
                                    last_name=last_name,
                                    email=email)

        for user in users:
            delete_user(user.mcid)

    sql_execute("DELETE FROM mcproperties WHERE property='acDemoDoctor'")
Exemple #22
0
def delete_data():
	properties = get_properties()

	delete_user(properties['DemoDoctor'])

	for first_name, last_name, email, ccr, reason, ccrs in PATIENTS:
		users = User.objects.filter(first_name = first_name,
					    last_name = last_name,
					    email = email)

		for user in users:
			delete_user(user.mcid)

	sql_execute("DELETE FROM mcproperties WHERE property='acDemoDoctor'")
Exemple #23
0
def delete_wl_entry_req(request):
    pid = int(request.REQUEST['pid'])

    practice = Practice.objects.get(practiceid = pid)

    if request.POST:
	guid = request.POST['guid']

	if 'delete' in request.POST or 'delete.x' in request.POST:
	    sql_execute("DELETE FROM practiceccrevents WHERE Guid=%s AND practiceid=%s",
			guid, pid)
	return HttpResponseRedirect('group?id=%d' % practice.providergroupid.groupinstanceid)

    guid = request.GET['guid']
    event = Practiceccrevent.objects.get(Guid=guid, practiceid=pid)

    return render_to_response('groups/delete_wl_entry.html',
                              default_context(request, entry=entry,
                                              practice=practice))
Exemple #24
0
def user_list():
    # 进入数据库验证用户信息
    sql = 'select * from codes_upload'
    ret = sql_execute(sql)

    # 1、查询用户的所有上传总量
    sql1 = "select u.name, sum(c.lines_num) as lines_count from codes_upload c inner join user_profile u on c.user = u.id group by c.user"
    ret_total = sql_execute(sql1)
    print('ret_total', ret_total)
    users = []
    total_counts = []
    import json
    for item in ret_total:
        users.append(item[0])
        total_counts.append(int(item[1]))
    users = json.dumps(users)

    # 2、查询本周的所有用户的上传总量
    sql2 = 'select u.name, sum(c.lines_num) as lines_count from codes_upload c inner join user_profile u on c.user = u.id  where YEARWEEK(upload_time)=YEARWEEK(now()) group by c.user'
    ret_week = sql_execute(sql2)
    print('ret_week', ret_week)
    week_count = []
    import json
    for item in ret_week:
        week_count.append(int(item[1]))

    # 3、查询本月的数据
    sql3 = 'select u.name, sum(c.lines_num) as lines_count from codes_upload c inner join user_profile u on c.user = u.id where DATE_FORMAT(upload_time, "%Y-%m")= DATE_FORMAT(now(), "%Y-%m") group by c.user'
    ret_month = sql_execute(sql3)
    print('ret_month', ret_month)
    month_count = []
    for item in ret_month:
        month_count.append(int(item[1]))

    ret = {
        'total': total_counts,
        'week': week_count,
        'month': month_count,
        'users': users,
        'ret': ret
    }
    return render_template('codes/users.html', data=ret)
Exemple #25
0
def delete_wl_entry_req(request):
    pid = int(request.REQUEST['pid'])

    practice = Practice.objects.get(practiceid=pid)

    if request.POST:
        guid = request.POST['guid']

        if 'delete' in request.POST or 'delete.x' in request.POST:
            sql_execute(
                "DELETE FROM practiceccrevents WHERE Guid=%s AND practiceid=%s",
                guid, pid)
        return HttpResponseRedirect('group?id=%d' %
                                    practice.providergroupid.groupinstanceid)

    guid = request.GET['guid']
    event = Practiceccrevent.objects.get(Guid=guid, practiceid=pid)

    return render_to_response(
        'groups/delete_wl_entry.html',
        default_context(request, entry=entry, practice=practice))
Exemple #26
0
def delete_req(request):
    id = request.REQUEST['id'].strip()
    object = IdentityProvider.objects.get(id = id)

    where = ['external_users.mcid = users.mcid',
             'external_users.provider_id = %s' % id]

    qs = User.objects.extra(where = where,
                            select = {'username': '******'},
                            tables = ['external_users'])

    if request.POST:
        if 'delete' in request.POST:
            sql_execute("DELETE FROM external_users WHERE provider_id = %s", id)
            object.delete()
        return HttpResponseRedirect('.')

    else:
        return render_to_response('idps/delete.html',
                                  default_context(request, object = object,
                                                  count = qs.count()))
Exemple #27
0
def add_users(request, this_action, next_action, template):
    id = request.REQUEST['id'].strip()
    group = Group.objects.get(groupinstanceid=int(id))

    context = default_context(request, action=this_action, group=group, id=id)

    if 'q' in request.REQUEST:
        q = request.REQUEST['q']
        qs = search_query_set(q)
        context['q'] = q
    else:
        qs = all_query_set()

    if 'mcid' in request.POST:
        mcid = normalize_mcid(request.POST['mcid'])

        if 'remove.x' in request.POST:
            sql_execute("DELETE FROM groupmembers " + \
                        "WHERE groupinstanceid = %s AND memberaccid = %s",
                        int(id), mcid)
        elif 'add.x' in request.POST:
            # Only one group per user
            sql_execute("DELETE FROM groupmembers " + \
          "wHERE memberaccid = %s", mcid)

            sql_execute("INSERT INTO groupmembers " + \
                        "(groupinstanceid, memberaccid) " + \
                        "VALUES (%s, %s)", int(id), mcid)

        return HttpResponseRedirect(this_action)

    if 'prev' in request.POST:
        return HttpResponseRedirect('wiz_name?id=%s' % id)

    if 'finish' in request.POST:
        return HttpResponseRedirect(next_action)

    where = [
        'groupmembers.memberaccid = users.mcid',
        'groupmembers.groupinstanceid = %s' % id
    ]
    context['members'] = User.objects.extra(where=where,
                                            tables=['groupmembers'])

    where = [
        'mcid NOT IN (SELECT memberaccid FROM groupmembers WHERE groupinstanceid = %s)'
        % id
    ]
    select = {
        'groupname':
        'SELECT DISTINCT(name) FROM groupinstances, groupmembers WHERE groupmembers.groupinstanceid = groupinstances.groupinstanceid AND groupmembers.memberaccid = users.mcid'
    }

    return object_list(request,
                       queryset=qs.extra(where=where, select=select),
                       template_name=template,
                       paginate_by=20,
                       extra_context=context)
Exemple #28
0
def merge_req(request):
    id = int(request.REQUEST['id'].strip())

    object = Appliance.objects.get(id = id)
    augment(object)

    objects = Appliance.objects.all()

    same_objects = []
    diff_objects = []

    # divide out the appliances: those with the same IP address and those
    # with different IP addresses
    for o in objects:
        augment(o)

        if o.id == object.id:
            continue

        if o.ipaddr == object.ipaddr:
            same_objects.append(o)
        else:
            diff_objects.append(o)

    if request.POST:
        to_id = int(request.REQUEST['to'].strip())
        if to_id != id:
            sql_execute("UPDATE alloc_log SET appliance_id = %s WHERE appliance_id = %s",
                        to_id, id)
            object.delete()

        return HttpResponseRedirect('.')

    return render_to_response('appliances/merge.html',
                              default_context(request, object=object,
                                              same_objects=same_objects,
                                              diff_objects=diff_objects))
Exemple #29
0
def delete_req(request):
    id = request.REQUEST['id'].strip()
    object = IdentityProvider.objects.get(id=id)

    where = [
        'external_users.mcid = users.mcid',
        'external_users.provider_id = %s' % id
    ]

    qs = User.objects.extra(where=where,
                            select={'username': '******'},
                            tables=['external_users'])

    if request.POST:
        if 'delete' in request.POST:
            sql_execute("DELETE FROM external_users WHERE provider_id = %s",
                        id)
            object.delete()
        return HttpResponseRedirect('.')

    else:
        return render_to_response(
            'idps/delete.html',
            default_context(request, object=object, count=qs.count()))
Exemple #30
0
def add_users(request, this_action, next_action, template):
    id = request.REQUEST['id'].strip()
    group = Group.objects.get(groupinstanceid=int(id))

    context = default_context(request, action=this_action, group=group, id=id)

    if 'q' in request.REQUEST:
	q = request.REQUEST['q']
	qs = search_query_set(q)
	context['q'] = q
    else:
	qs = all_query_set()

    if 'mcid' in request.POST:
        mcid = normalize_mcid(request.POST['mcid'])

        if 'remove.x' in request.POST:
            sql_execute("DELETE FROM groupmembers " + \
                        "WHERE groupinstanceid = %s AND memberaccid = %s",
                        int(id), mcid)
        elif 'add.x' in request.POST:
	    # Only one group per user
	    sql_execute("DELETE FROM groupmembers " + \
			"wHERE memberaccid = %s", mcid)

            sql_execute("INSERT INTO groupmembers " + \
                        "(groupinstanceid, memberaccid) " + \
                        "VALUES (%s, %s)", int(id), mcid)

        return HttpResponseRedirect(this_action)

    if 'prev' in request.POST:
        return HttpResponseRedirect('wiz_name?id=%s' % id)

    if 'finish' in request.POST:
        return HttpResponseRedirect(next_action)

    where = ['groupmembers.memberaccid = users.mcid',
             'groupmembers.groupinstanceid = %s' % id]
    context['members'] = User.objects.extra(where = where,
                                            tables = ['groupmembers'])

    where = ['mcid NOT IN (SELECT memberaccid FROM groupmembers WHERE groupinstanceid = %s)' % id]
    select = {'groupname': 'SELECT DISTINCT(name) FROM groupinstances, groupmembers WHERE groupmembers.groupinstanceid = groupinstances.groupinstanceid AND groupmembers.memberaccid = users.mcid'}

    return object_list(request,
                       queryset = qs.extra(where = where,
					   select = select),
                       template_name = template,
                       paginate_by = 20,
                       extra_context = context)
Exemple #31
0
def add_to_group(g, mcid):
	sql_execute("""INSERT INTO groupmembers (groupinstanceid, memberaccid)
			VALUES (%s, %s)""", g.groupinstanceid, mcid)
Exemple #32
0
def delete_group(group):
    i = group.groupinstanceid
    sql_execute("DELETE FROM groupmembers WHERE groupinstanceid = %s", i)
    sql_execute("DELETE FROM practice WHERE providergroupid = %s", i)
    group.delete()
Exemple #33
0
def create_data(url_root):
	gateway = urljoin(url_root, 'router/')

	transaction.enter_transaction_management()

	doctor = User()
	doctor.mcid = mcid_generator.next_mcid()
	doctor.first_name = 'Demo'
	doctor.last_name = 'Doctor'
	doctor.email = '*****@*****.**'
	doctor.updatetime = 0
	doctor.ccrlogupdatetime = 0
	doctor.save()

	physician = User()
	physician.mcid = mcid_generator.next_mcid()
	physician.first_name = 'Demo'
	physician.last_name = 'Physician'
	physician.email = '*****@*****.**'
	physician.updatetime = 0
	physician.ccrlogupdatetime = 0
	physician.save()

	g, p = create_group('Demo Group Worklist',
			    '*****@*****.**', url_root,
			    doctor.mcid)

	add_to_group(g, physician.mcid)

	patients = []
	for first_name, last_name, email, currentccr, reason, ccrs in PATIENTS:
		user = User()
		user.first_name = first_name
		user.last_name = last_name
		user.email = email
		user.mcid = mcid_generator.next_mcid()
		user.acctype = 'USER'
		user.rolehack = 'ccrlhm'
		user.updatetime = 0
		user.ccrlogupdatetime = 0
		user.save()

		patients.append(user)

		# Set worklist
		sql_execute(ACCOUNT_RLS_SQL, user.mcid, p.practiceRlsUrl)

		if not currentccr:
			continue

		sql_execute(DOCUMENT_TYPE_SQL, user.mcid, currentccr)

		ev = Practiceccrevent()
		ev.practiceid = p
		ev.PatientGivenName = user.first_name
		ev.PatientFamilyName = user.last_name
		ev.PatientIdentifier = user.mcid
		ev.PatientIdentifierSource = 'Patient Medcommons ID'
		ev.Guid = currentccr
		ev.Purpose = reason
		ev.SenderProviderId = 'idp'
		ev.ReceiverProviderId = 'idp'
		ev.DOB = '16 Jan 1968 05:00:00 GMT'
		ev.CXPServerURL = ''
		ev.CXPServerVendor = 'Medcommons'
		ev.ViewerURL = urljoin(gateway, 'access?g=%s' % currentccr)
		ev.Comment = '\n            3D Imaging Consult\n            '
		ev.CreationDateTime = 1162365858
		ev.ConfirmationCode = tn_generator.next_tracking_number()
		ev.RegistrySecret = ''
		ev.PatientSex = 'Female'
		ev.PatientAge = ''
		ev.Status = 'New'
		ev.ViewStatus = 'Visible'
		ev.save()

		sql_execute(CCRLOG_SQL, user.mcid, currentccr, 'CCR',
			    ev.ConfirmationCode)

		for ccr in ccrs:
			sql_execute(CCRLOG_SQL, user.mcid, ccr, 'CCR',
				    tn_generator.next_tracking_number())

	sql_execute(TODIR_SQL, g.groupinstanceid, doctor.email,
		    doctor.email, doctor.mcid)

	sql_execute(TODIR_SQL, g.groupinstanceid, physician.email,
		    physician.email, physician.mcid)

	demoCCR = 'fdfbbb9cf53f8577b420ed72567cd2104589fb0d'

	sql_execute(CCRLOG_SQL, doctor.mcid, demoCCR, 'DICOM Import',
		    tn_generator.next_tracking_number())

	sql_execute(CCRLOG_SQL, patients[0].mcid, demoCCR, 'DICOM Import',
		    tn_generator.next_tracking_number())

	sql_execute(CCRLOG_SQL, patients[0].mcid, PATIENTS[0][3],
		    'DICOM Import',
		    tn_generator.next_tracking_number())


	# Secondary group
	if 0:
		g2, p2 = create_group('Healthy Doctors',
				      '*****@*****.**',
				      url_root, doctor.mcid)

	p = MCProperty()
	p.property = 'acDemoDoctor'
	p.value = doctor.mcid
	p.save()

	transaction.leave_transaction_management()
Exemple #34
0
def create_data(url_root):
    gateway = urljoin(url_root, 'router/')

    transaction.enter_transaction_management()

    doctor = User()
    doctor.mcid = mcid_generator.next_mcid()
    doctor.first_name = 'Demo'
    doctor.last_name = 'Doctor'
    doctor.email = '*****@*****.**'
    doctor.updatetime = 0
    doctor.ccrlogupdatetime = 0
    doctor.save()

    physician = User()
    physician.mcid = mcid_generator.next_mcid()
    physician.first_name = 'Demo'
    physician.last_name = 'Physician'
    physician.email = '*****@*****.**'
    physician.updatetime = 0
    physician.ccrlogupdatetime = 0
    physician.save()

    g, p = create_group('Demo Group Worklist',
                        '*****@*****.**', url_root,
                        doctor.mcid)

    add_to_group(g, physician.mcid)

    patients = []
    for first_name, last_name, email, currentccr, reason, ccrs in PATIENTS:
        user = User()
        user.first_name = first_name
        user.last_name = last_name
        user.email = email
        user.mcid = mcid_generator.next_mcid()
        user.acctype = 'USER'
        user.rolehack = 'ccrlhm'
        user.updatetime = 0
        user.ccrlogupdatetime = 0
        user.save()

        patients.append(user)

        # Set worklist
        sql_execute(ACCOUNT_RLS_SQL, user.mcid, p.practiceRlsUrl)

        if not currentccr:
            continue

        sql_execute(DOCUMENT_TYPE_SQL, user.mcid, currentccr)

        ev = Practiceccrevent()
        ev.practiceid = p
        ev.PatientGivenName = user.first_name
        ev.PatientFamilyName = user.last_name
        ev.PatientIdentifier = user.mcid
        ev.PatientIdentifierSource = 'Patient Medcommons ID'
        ev.Guid = currentccr
        ev.Purpose = reason
        ev.SenderProviderId = 'idp'
        ev.ReceiverProviderId = 'idp'
        ev.DOB = '16 Jan 1968 05:00:00 GMT'
        ev.CXPServerURL = ''
        ev.CXPServerVendor = 'Medcommons'
        ev.ViewerURL = urljoin(gateway, 'access?g=%s' % currentccr)
        ev.Comment = '\n            3D Imaging Consult\n            '
        ev.CreationDateTime = 1162365858
        ev.ConfirmationCode = tn_generator.next_tracking_number()
        ev.RegistrySecret = ''
        ev.PatientSex = 'Female'
        ev.PatientAge = ''
        ev.Status = 'New'
        ev.ViewStatus = 'Visible'
        ev.save()

        sql_execute(CCRLOG_SQL, user.mcid, currentccr, 'CCR',
                    ev.ConfirmationCode)

        for ccr in ccrs:
            sql_execute(CCRLOG_SQL, user.mcid, ccr, 'CCR',
                        tn_generator.next_tracking_number())

    sql_execute(TODIR_SQL, g.groupinstanceid, doctor.email, doctor.email,
                doctor.mcid)

    sql_execute(TODIR_SQL, g.groupinstanceid, physician.email, physician.email,
                physician.mcid)

    demoCCR = 'fdfbbb9cf53f8577b420ed72567cd2104589fb0d'

    sql_execute(CCRLOG_SQL, doctor.mcid, demoCCR, 'DICOM Import',
                tn_generator.next_tracking_number())

    sql_execute(CCRLOG_SQL, patients[0].mcid, demoCCR, 'DICOM Import',
                tn_generator.next_tracking_number())

    sql_execute(CCRLOG_SQL, patients[0].mcid, PATIENTS[0][3], 'DICOM Import',
                tn_generator.next_tracking_number())

    # Secondary group
    if 0:
        g2, p2 = create_group('Healthy Doctors',
                              '*****@*****.**', url_root,
                              doctor.mcid)

    p = MCProperty()
    p.property = 'acDemoDoctor'
    p.value = doctor.mcid
    p.save()

    transaction.leave_transaction_management()
Exemple #35
0
def add_to_group(g, mcid):
    sql_execute(
        """INSERT INTO groupmembers (groupinstanceid, memberaccid)
			VALUES (%s, %s)""", g.groupinstanceid, mcid)