def getLastScrappedDocId(): lastId = DBSession.query(Setting.value).filter(Setting.key == u'lastFactorizedDocId').all() if len(lastId) == 0: DBSession.add(Setting(key = u'lastFactorizedDocId', value = u'0')) transaction.commit() return 0 else: return int(lastId[0][0])
def getLastScrappedDocId(): lastId = DBSession.query( Setting.value).filter(Setting.key == u'lastFactorizedDocId').all() if len(lastId) == 0: DBSession.add(Setting(key=u'lastFactorizedDocId', value=u'0')) transaction.commit() return 0 else: return int(lastId[0][0])
def saveFactsToDatabase(docid, facts, intFacts): data = FactData() data.scraped_data_id = docid for fact in facts: setattr(data, fact, True) for name, value in intFacts: setattr(data, name, value) DBSession.add(data) transaction.commit()
def uploadFacts(): import sys from factCodeBase import facts, factLinks initializeBase(sys.argv[1], sys.argv[2]) for key, value in facts.items(): DBSession.add(Fact(name=unicode(key), type=FACT_TYPE_BOOL, args=unicode(json.encode(value)))) for key, value in factLinks.items(): DBSession.add(FactLinks(name=unicode(key), args=json.encode(value))) transaction.commit()
def uploadFacts(): import sys from factCodeBase import facts, factLinks initializeBase(sys.argv[1], sys.argv[2]) for key, value in facts.items(): DBSession.add( Fact(name=unicode(key), type=FACT_TYPE_BOOL, args=unicode(json.encode(value)))) for key, value in factLinks.items(): DBSession.add(FactLinks(name=unicode(key), args=json.encode(value))) transaction.commit()
def filter_add(request): """ UserFilter add/edit view """ schema = UserFilterSchema() schema = schema.bind(request=request) form = SubmitForm(schema) form.children[-1].renderer = renderer success_message = isinstance(request.context, RootFactory) \ and _(u'The filter was created') \ or _(u'The filter was updated') if request.method == 'GET': if isinstance(request.context, RootFactory): return dict(form=form) else: return dict(form=form, appstruct=request.context.__json__()) else: try: controls = request.POST.items() captured = form.validate(controls) except deform.ValidationFailure, e: return dict(form=e, errors=e.error.children) if isinstance(request.context, RootFactory): filter = UserFilter(user=request.user, name=captured['name'], filter_details=captured['filter_details']) else: filter = request.context filter.name = captured['name'] filter.filter_details = captured['filter_details'] DBSession.add(filter) request.session.flash(success_message, 'success') return HTTPFound( location=request.route_url('filter_list') )
def filter_add(request): """ UserFilter add/edit view """ schema = UserFilterSchema() schema = schema.bind(request=request) form = SubmitForm(schema) form.children[-1].renderer = renderer success_message = isinstance(request.context, RootFactory) \ and _(u'The filter was created') \ or _(u'The filter was updated') if request.method == 'GET': if isinstance(request.context, RootFactory): return dict(form=form) else: return dict(form=form, appstruct=request.context.__json__()) else: try: controls = request.POST.items() captured = form.validate(controls) except deform.ValidationFailure, e: return dict(form=e, errors=e.error.children) if isinstance(request.context, RootFactory): filter = UserFilter(user=request.user, name=captured['name'], filter_details=captured['filter_details']) else: filter = request.context filter.name = captured['name'] filter.filter_details = captured['filter_details'] DBSession.add(filter) request.session.flash(success_message, 'success') return HTTPFound(location=request.route_url('filter_list'))