def export(post_id, idc): pdf_Channel = db.session.query(Channel).filter(Channel.id == idc).first() if pdf_Channel is not None: channel_config = pdf_Channel.config myPost = db.session.query(Post).filter(Post.id == post_id).first() myPub = Publishing() myPub.description = myPost.description myPub.title = myPost.title run(myPub, channel_config) return redirect(url_for('index'))
def create(client): post = Post(user_id='myself', title='title_post', description='descr_post', link_url='link_post', image_url='image_post', date_from=datetime_converter('2017-06-02'), date_until=datetime_converter('2017-06-03')) db.session.add(post) db.session.commit() chan = Channel( name='rss', id=-1, module='superform.plugins.rss', config='{"feed_title": "test_title", "feed_description": "test_desc"}') db.session.add(chan) db.session.commit() pub = Publishing(post_id=post.id, channel_id=chan.id, state=0, title=post.title, description=post.description, link_url=post.link_url, image_url=post.image_url, date_from=post.date_from, date_until=post.date_until) db.session.add(pub) db.session.commit() return post, chan, pub
def create_a_resubmit_publishing(pub, chn, form): validate = pre_validate_post(chn, pub) if validate == -1 or validate == 0: return validate title_post = form.get('titlepost') descr_post = form.get('descrpost') link_post = form.get('linkurlpost') image_post = form.get('imagepost') if chn.module == 'superform.plugins.gcal': pub.date_start = datetime_converter(form.get('datedebut')) pub.hour_start = form.get('heuredebut') pub.date_end = datetime_converter(form.get('datefin')) pub.hour_end = form.get('heurefin') pub.location = form.get('location') pub.color = form.get('color') pub.visibility = form.get('visibility') pub.availability = form.get('availability') else: date_from = datetime_converter(form.get('datefrompost')) date_until = datetime_converter(form.get('dateuntilpost')) latest_version_publishing = db.session.query(Publishing).filter(Publishing.post_id == pub.post_id, Publishing.channel_id == chn.id).order_by( Publishing.num_version.desc() ).first() new_pub = Publishing(num_version=latest_version_publishing.num_version + 1, post_id=pub.post_id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) return new_pub
def export(post_id, idc): pdf_Channel = db.session.query(Channel).filter(Channel.id == idc).first() if pdf_Channel is not None: channel_config = pdf_Channel.config myPost = db.session.query(Post).filter(Post.id == post_id).first() myPub = Publishing() myPub.description = myPost.description myPub.title = myPost.title run(myPub, channel_config) # TODO get the post information # db.session... TODO # pub = {'description': post.description, 'title': post.title} TODO # config = TODO # run(publishing = pub, channel_config = config) return redirect(url_for('index'))
def create_a_publishing(post, chn, form): chan = str(chn.name) title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title descr_post = form.get(chan + '_descriptionpost') if form.get( chan + '_descriptionpost') is not None else post.description link_post = form.get(chan + '_linkurlpost') if form.get( chan + '_linkurlpost') is not None else post.link_url image_post = form.get(chan + '_imagepost') if form.get( chan + '_imagepost') is not None else post.image_url date_from = datetime_converter( form.get(chan + '_datefrompost')) if datetime_converter( form.get(chan + '_datefrompost')) is not None else post.date_from date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if datetime_converter( form.get(chan + '_dateuntilpost')) is not None else post.date_until pub = Publishing(post_id=post.id, channel_id=chn.id, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) db.session.add(pub) db.session.commit() return pub
def prefill_db(client): post = Post(user_id='myself', title='title_post', description='descr_post', link_url='link_post', image_url='image_post', date_from=datetime_converter('2020-01-01'), date_until=datetime_converter('2020-01-01')) db.session.add(post) db.session.commit() chan = Channel( name='my_mail', id=-1, module='superform.plugins.mail', config='{"sender":"*****@*****.**", "receiver":"*****@*****.**"}') db.session.add(chan) db.session.commit() pub = Publishing(post_id=post.id, channel_id=chan.id, state=0, title=post.title, description=post.description, link_url=post.link_url, image_url=post.image_url, date_from=post.date_from, date_until=post.date_until) db.session.add(pub) db.session.commit() return post, chan, pub
def test_delete_publishing(client): user_id = "myself" login(client, user_id) title_post = "title_test" descr_post = "description" link_post = "link" image_post = "img" date_from = datetime_converter("2018-01-01") date_until = datetime_converter("2018-01-10") p = Post(user_id=user_id, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) db.session.add(p) db.session.commit() id_post = p.id id_channel = 1 # Try with a publishing submitted for review (state=0) pub1 = Publishing(post_id=id_post, channel_id=id_channel, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) db.session.add(pub1) db.session.commit() path = '/delete_publishing/' + str(id_post) + '/' + str(id_channel) client.get(path) deleted_publishing = db.session.query(Publishing).filter(Publishing.post_id == id_post).first() assert deleted_publishing is None # Try with a publishing already posted (state=1) pub2 = Publishing(post_id=id_post, channel_id=id_channel, state=1, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) db.session.add(pub2) db.session.commit() path = '/delete_publishing/' + str(id_post) + '/' + str(id_channel) client.get(path) deleted_publishing = db.session.query(Publishing).filter(Publishing.post_id == id_post).first() assert deleted_publishing is None db.session.delete(p) db.session.commit()
def create_a_publishing_edit(post, chn, data): """ This method is used in publish_edit_post in order to generate a publication. Since the request used in publish_edit_post is different than the request in create_a_publishing in post.py, this methode had the same behaviour but instead of using a request.form we use a request.get_json :param post : the post linked to the publication, chn : the channel used for the publication, data : data used to make the publishing :return: the publishing """ field = data.get('fields') title_post = field.get('title') if (field.get('title') is not None) else post.title descr_post = field.get('description') if field.get('description') is not None else post.description link_post = field.get('link_url') if field.get('link_url') is not None else post.link_url image_post = field.get('image_url') if field.get('image_url') is not None else post.image_url if field.get('date_from') is '': date_from = date.today() else: date_from = datetime_converter(field.get('date_from')) if datetime_converter( field.get('date_from')) is not None else post.date_from if field.get('date_until') is '': date_until = date.today() + timedelta(days=7) else: date_until = datetime_converter(field.get('date_until')) if datetime_converter( field.get('date_until')) is not None else post.date_until if chn.module == 'superform.plugins.ICTV': logo = field.get('logo') subtitle = field.get('subtitle') duration = field.get('duration') pub = Publishing(user_id=session.get("user_id", ""), post_id=post.id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, logo=logo, subtitle=subtitle, duration=duration) else: pub = Publishing(user_id=session.get("user_id", ""), post_id=post.id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) db.session.add(pub) db.session.commit() return pub
def test_publish_link(client): new_publish = Publishing( title="Coucou", description="J'aime faire des tests unitaires", link_url="https://docs.pytest.org/en/latest/index.html") assert fb.get_link( new_publish) == "https://docs.pytest.org/en/latest/index.html"
def create_a_publishing(post, chn, form): chan = str(chn.name) plug_name = chn.module from importlib import import_module plug = import_module(plug_name) if 'forge_link_url' in dir(plug): link_post = plug.forge_link_url(chan, form) else: link_post = form.get(chan + '_linkurlpost') if form.get( chan + '_linkurlpost') is not None else post.link_url title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title descr_post = form.get(chan + '_descriptionpost') if form.get( chan + '_descriptionpost') is not None else post.description rss_feed = form.get(chan + '_linkrssfeedpost') image_post = form.get(chan + '_imagepost') if form.get( chan + '_imagepost') is not None else post.image_url date_from = datetime_converter( form.get(chan + '_datefrompost')) if form.get( chan + '_datefrompost') is not None else post.date_from time_from = time_converter(form.get(chan + '_timefrompost')) if form.get( chan + '_timefrompost') is not None else None if date_from and time_from: date_from = date_from.replace(hour=time_from.hour, minute=time_from.minute) date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if form.get( chan + '_dateuntilpost') is not None else post.date_until time_until = time_converter(form.get(chan + '_timeuntilpost')) if form.get( chan + '_timeuntilpost') is not None else None if date_until and time_until: date_until = date_until.replace(hour=time_until.hour, minute=time_until.minute) pub = Publishing(post_id=post.id, channel_id=chn.id, state=State.NOTVALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, rss_feed=rss_feed) db.session.add(pub) db.session.commit() return pub
def export(post_id, idc): pdf_Channel = db.session.query(Channel).filter(Channel.id == idc).first() if pdf_Channel is not None: channel_config = pdf_Channel.config else: flash("PDF channel not found", category='success') return redirect(url_for('index')) myPost = db.session.query(Post).filter(Post.id == post_id).first() myPub = Publishing() myPub.description = myPost.description myPub.title = myPost.title code = run(myPub, channel_config) if code[0].value != StatusCode.OK.value: flash(code[1], category='error') return redirect(url_for('index')) else: # flash("The PDF has successfully been generated.", category='success') return send_from_directory("plugins/pdf/", code[1], as_attachment=True, attachment_filename=code[1])
def create_a_publishing(post, chn, form): chan = str(chn.name) title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title chn.count += 1 # TODO (team02) find utility user_id = session.get("user_id", "") if session.get("logged_in", False) else -1 if "twitter" in chn.module: descr_post = form.get('tweets') elif form.get(chan + '_descriptionpost') is not None : descr_post = form.get(chan + '_descriptionpost') else : descr_post = post.description link_post = form.get(chan + '_linkurlpost') if form.get(chan + '_linkurlpost') is not None else post.link_url image_post = form.get(chan + '_imagepost') if form.get(chan + '_imagepost') is not None else post.image_url date_from = datetime_converter(form.get(chan + '_datefrompost')) if datetime_converter( form.get(chan + '_datefrompost')) is not None else post.date_from date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if datetime_converter( form.get(chan + '_dateuntilpost')) is not None else post.date_until pub = Publishing(post_id=post.id, user_id=user_id, channel_id=chn.id, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until) c = db.session.query(Channel).filter( Channel.id == pub.channel_id).first() if c is not None: plugin_name = c.module ##If it is a pdf chanel we don't need to save it, printing it would be enough # TEAM6: MODIFICATION FOR PDF if str(plugin_name).endswith("pdf"): c_conf = c.config from importlib import import_module plugin = import_module(plugin_name) plugin.run(pub, c_conf) # Does not save the pdf posts return pub # END OF MODIFICATION if is_gcal_channel(chan) and not gcal_plugin.is_valid(pub): return None if is_gcal_channel(chan): generate_google_user_credentials(chan) db.session.add(pub) db.session.commit() return pub
def validate_rework_publishing(id, idc): """ Validate the modifications applied to the publishing :param id: post id :param idc: channel id :return: an error message if the publishing has already been reworked else redirect to the index """ pub = db.session.query(Publishing).filter( Publishing.post_id == id, Publishing.channel_id == idc).first() post = db.session.query(Post).filter(Post.id == id).first() # Only pubs that have yet to be moderated can be accepted if pub.state == State.VALIDATED.value: flash("This publication has already been reworked.", category='error') return redirect(url_for('index')) new_post = Post(user_id=post.user_id, title=pub.title, description=pub.description, date_created=post.date_created, link_url=pub.link_url, image_url=pub.image_url, date_from=pub.date_from, date_until=pub.date_until) db.session.add(new_post) db.session.commit() new_pub = Publishing(post_id=new_post.id, channel_id=pub.channel_id, state=pub.state, title=pub.title, date_until=pub.date_until, date_from=pub.date_from, rss_feed=pub.rss_feed) pub.state = State.OUTDATED.value db.session.add(new_pub) db.session.commit() update_pub(new_pub, State.NOTVALIDATED.value) db.session.commit() create_a_moderation(request.form, new_post.id, new_pub.channel_id, parent_post_id=id) flash("The rework has been submitted.", category='success') return redirect(url_for('index'))
def create_a_resubmit_publishing(pub, chn, form): user_id = session.get("user_id", "") if session.get("logged_in", False) else -1 title_post = form.get('titlepost') descr_post = form.get('descrpost') link_post = form.get('linkurlpost') image_post = form.get('imagepost') date_from = datetime_converter(form.get('datefrompost')) date_until = datetime_converter(form.get('dateuntilpost')) start_hour = time_converter(form.get('starthour')) end_hour = time_converter(form.get('endhour')) latest_version_publishing = db.session.query(Publishing).filter(Publishing.post_id == pub.post_id, Publishing.channel_id == chn.id).order_by( Publishing.num_version.desc() ).first() new_pub = Publishing(num_version=latest_version_publishing.num_version + 1, post_id=pub.post_id, channel_id=chn.id, state=State.NOT_VALIDATED.value, user_id=user_id, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, start_hour=start_hour, end_hour=end_hour) return new_pub
def create_a_publishing(post, chn, form): chan = str(chn.name) title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title descr_post = form.get(chan + '_descriptionpost') if form.get( chan + '_descriptionpost') is not None else post.description link_post = form.get(chan + '_linkurlpost') if form.get( chan + '_linkurlpost') is not None else post.link_url image_post = form.get(chan + '_imagepost') if form.get( chan + '_imagepost') is not None else post.image_url date_from = datetime_converter( form.get(chan + '_datefrompost')) if datetime_converter( form.get(chan + '_datefrompost')) is not None else post.date_from date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if datetime_converter( form.get(chan + '_dateuntilpost')) is not None else post.date_until extra = dict() plugin_name = chn.module from importlib import import_module plugin = import_module(plugin_name) if 'get_channel_fields' in dir(plugin): extra = plugin.get_channel_fields(form, chan) pub = Publishing(post_id=post.id, channel_id=chn.id, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, extra=json.dumps(extra)) db.session.add(pub) db.session.commit() return pub
def create_a_publishing(post, chn, form): chan = str(chn.name) title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title descr_post = form.get(chan + '_descriptionpost') if form.get( chan + '_descriptionpost') is not None else post.description plugin = import_module(chn.module) if "saveExtraFields" in vars(plugin): misc_post = plugin.saveExtraFields( chan, form) # plugin will handle extra fields here link_post = form.get(chan + '_linkurlpost') if form.get( chan + '_linkurlpost') is not None else post.link_url image_post = form.get(chan + '_imagepost') if form.get( chan + '_imagepost') is not None else post.image_url date_from = datetime_converter( form.get(chan + '_datefrompost')) if datetime_converter( form.get(chan + '_datefrompost')) is not None else post.date_from date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if datetime_converter( form.get(chan + '_dateuntilpost')) is not None else post.date_until pub = Publishing(post_id=post.id, channel_id=chn.id, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, misc=misc_post) db.session.add(pub) db.session.commit() return pub
def create_a_publishing(post, chn, form): # called in publish_from_new_post() chan = str(chn.name) plug = import_module(chn.module) title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title # Team2 stat chn.count += 1 user_id = session.get("user_id", "") if session.get("logged_in", False) else -1 # Team2 stat # TEAM 10 twitter if "twitter" in chn.module: descr_post = form.get('tweets') elif form.get(chan + '_descriptionpost') is not None: descr_post = form.get(chan + '_descriptionpost') else: descr_post = post.description # TEAM 10 twitter # TEAM 3 ictv if 'forge_link_url' in dir(plug): link_post = plug.forge_link_url(chan, form) else: link_post = form.get(chan + '_linkurlpost') if form.get( chan + '_linkurlpost') is not None else post.link_url # TEAM 3 ictv image_post = form.get(chan + '_imagepost') if form.get( chan + '_imagepost') is not None else post.image_url if form.get(chan + '_datefrompost') is '': date_from = date.today() else: date_from = datetime_converter( form.get(chan + '_datefrompost')) if form.get( chan + '_datefrompost') is not None else post.date_from if form.get(chan + '_dateuntilpost') is '': date_until = date.today() + timedelta(days=7) else: date_until = datetime_converter( form.get(chan + '_dateuntilpost')) if form.get( chan + '_datefrompost') is not None else post.date_until if form.get(chan + '_starthour') is '': start_hour = time_converter("00:00") else: start_hour = time_converter(form.get(chan + '_starthour')) if form.get( chan + '_starthour') is not None else post.start_hour if form.get(chan + '_endhour') is '': end_hour = time_converter("23:59") else: end_hour = time_converter(form.get(chan + '_endhour')) if form.get( chan + '_endhour') is not None else post.end_hour latest_version_publishing = db.session.query(Publishing).filter( Publishing.post_id == post.id, Publishing.channel_id == chn.id).order_by( Publishing.num_version.desc()).first() version_number = 1 if latest_version_publishing is None else latest_version_publishing.num_version + 1 pub = Publishing(num_version=version_number, post_id=post.id, user_id=user_id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, start_hour=start_hour, end_hour=end_hour) # TEAM6: MODIFICATION FOR PDF c = db.session.query(Channel).filter(Channel.id == pub.channel_id).first() if c is not None: plugin_name = c.module # If it is a pdf chanel we don't need to save it, printing it would be enough if str(plugin_name).endswith("pdf"): c_conf = c.config plugin = import_module(plugin_name) plugin.run(pub, c_conf) # Does not save the pdf posts return pub # TEAM6: END OF MODIFICATION db.session.add(pub) db.session.commit() if latest_version_publishing is None: user_comment = "" date_user_comment = str_converter_with_hour(datetime_now()) comm = Comment(publishing_id=pub.publishing_id, user_comment=user_comment, date_user_comment=date_user_comment) db.session.add(comm) db.session.commit() return pub
def test_moderate(client): id_channel, id_post = pytest.helpers.plugin.setup_db( channelName, "superform.plugins.Twitter") driver = webdriver.Firefox() try: driver.get('http://localhost:5000/') wait = WebDriverWait(driver, 20) driver.find_element_by_link_text("Login").click() wait.until(EC.element_to_be_clickable((By.NAME, "j_username"))) driver.find_element_by_name("j_username").click() driver.find_element_by_name("j_username").clear() driver.find_element_by_name("j_username").send_keys("myself") driver.find_element_by_name("j_password").click() driver.find_element_by_name("j_password").clear() driver.find_element_by_name("j_password").send_keys("myself") driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='Password:'******'New post'))) driver.find_element_by_link_text("New post").click() driver.find_element_by_id("chan_option_" + str(id_channel)).click() driver.find_element_by_id("descriptionpost").click() driver.find_element_by_id("descriptionpost").click() driver.find_element_by_id("descriptionpost").clear() driver.find_element_by_id("descriptionpost").send_keys( "An duis ubique mei, amet commodo dignissim ne eam, vide velit adipiscing est ad. Has eu inani gloriatur. Ius ea zril malorum aliquid. Et pri deleniti euripidis adversarium. Cum hinc putant laoreet ei, ea ullum tamquam vis, cu quo modus ignota officiis.\n\nEum ea nulla exerci, paulo dolore recusabo mel et. Per altera salutatus ad. Cu veri dicat has. Ex erant viris vis, id senserit interesset referrentur nec. Periculis salutatus reformidans eam an, eum te aliquid probatus, no ius corpora petentium." ) driver.find_element_by_id("linkurlpost").click() driver.find_element_by_id("linkurlpost").clear() driver.find_element_by_id("linkurlpost").send_keys( "http://localhost:5000/new") driver.find_element_by_id("datefrompost").click() driver.find_element_by_id("datefrompost").clear() driver.find_element_by_id("datefrompost").send_keys("2020-11-21") driver.find_element_by_id("dateuntilpost").click() driver.find_element_by_id("dateuntilpost").clear() driver.find_element_by_id("dateuntilpost").send_keys("2021-01-29") driver.find_element_by_link_text(channelName).click() extra = get_channel_fields( { 'Twitter_test_tweet_1': driver.find_element_by_id(channelName + "_tweet_1").get_attribute("value"), 'Twitter_test_tweet_2': driver.find_element_by_id(channelName + "_tweet_2").get_attribute("value") }, 'Twitter_test') pub = Publishing( post_id=id_post, channel_id=id_channel, state=0, title="", description= "That know ask case sex ham dear her spot. Weddings followed the all marianne nor whatever settling. Perhaps six prudent several her had offence. Did had way law dinner square tastes. Recommend concealed yet her procuring see consulted depending. Adieus hunted end plenty are his she afraid. Resources agreement contained propriety applauded neglected use yet. ", link_url="http://localhost:5000/new", image_url="pas", date_from=datetime_converter("2018-07-01"), date_until=datetime_converter("2018-07-01"), extra=json.dumps(extra)) db.session.add(pub) db.session.commit() driver.get('http://localhost:5000/') # wait.until(EC.element_to_be_clickable((By.ID, "moderate_" + str(id_channel)))) driver.find_element_by_id("moderate_" + str(id_post)).click() driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='(264 out of 280 characters)'])[1]/following::input[2]" ).click() driver.find_element_by_id("tweet_3").click() driver.find_element_by_id("tweet_3").clear() driver.find_element_by_id("tweet_3").send_keys( "some random text to test") driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='(24 out of 280 characters)'])[1]/following::input[2]" ).click() driver.find_element_by_id("tweet_4").click() driver.find_element_by_id("tweet_4").clear() driver.find_element_by_id("tweet_4").send_keys("uiocfzuo") driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='Moderate this publication'])[1]/following::div[2]" ).click() driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='(8 out of 280 characters)'])[1]/following::input[1]" ).click() # sleep(5) print(driver.find_element_by_id("tweet_1").get_attribute("value")) assert driver.find_element_by_id("tweet_1").get_attribute( "value" ) == "[1/2] An duis ubique mei, amet commodo dignissim ne eam, vide velit adipiscing est ad. Has eu inani gloriatur. Ius ea zril malorum aliquid. Et pri deleniti euripidis adversarium. Cum hinc putant laoreet ei, ea ullum tamquam vis, cu quo modus ignota officiis.\n\nEum ea nulla…" assert driver.find_element_by_id("tweet_2").get_attribute( "value" ) == "[2/2] exerci, paulo dolore recusabo mel et. Per altera salutatus ad. Cu veri dicat has. Ex erant viris vis, id senserit interesset referrentur nec. Periculis salutatus reformidans eam an, eum te aliquid probatus, no ius corpora petentium. http://localhost:5000/new" assert driver.find_element_by_id("tweet_3").get_attribute( "value") == "some random text to test" try: driver.find_element_by_id(channelName + "_tweet_4") assert False except selenium.common.exceptions.NoSuchElementException: assert True except AssertionError as e: pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close() assert False, str(e) except InvalidRequestError as e: pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close() assert False, "An error occurred while testing: {}".format(str(e)) pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close()
def create_a_publishing(post, chn, form): # called in publish_from_new_post() chan = str(chn.name) validate = pre_validate_post(chn, post) if validate == -1 or validate == 0: return validate title_post = form.get(chan + '_titlepost') if (form.get(chan + '_titlepost') is not None) else post.title descr_post = form.get(chan + '_descriptionpost') if form.get( chan + '_descriptionpost') is not None else post.description link_post = form.get(chan + '_linkurlpost') if form.get(chan + '_linkurlpost') is not None else post.link_url image_post = form.get(chan + '_imagepost') if form.get(chan + '_imagepost') is not None else post.image_url plugin = import_module(chn.module) if "saveExtraFields" in vars(plugin): misc_post = plugin.saveExtraFields(chan, form) # plugin will handle extra fields here if form.get(chan + 'datefrompost') is '': date_from = date.today() else: date_from = datetime_converter(form.get(chan + '_datefrompost')) if datetime_converter( form.get(chan + '_datefrompost')) is not None else post.date_from if form.get(chan + 'dateuntilpost') is '': date_until = date.today() + timedelta(days=7) else: date_until = datetime_converter(form.get(chan + '_dateuntilpost')) if datetime_converter( form.get(chan + '_dateuntilpost')) is not None else post.date_until if chn.module == 'superform.plugins.ICTV': logo = form.get(chan + '_logo') subtitle = form.get(chan + '_subtitle') duration = form.get(chan + '_duration') pub = Publishing(post_id=post.id, channel_id=chn.id, state=0, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, logo=logo, subtitle=subtitle, duration=duration) db.session.add(pub) db.session.commit() else: latest_version_publishing = db.session.query(Publishing).filter(Publishing.post_id == post.id, Publishing.channel_id == chn.id).order_by( Publishing.num_version.desc()).first() if latest_version_publishing is None: pub = Publishing(post_id=post.id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, misc=misc_post) db.session.add(pub) db.session.commit() user_comment = "" date_user_comment = str_converter_with_hour(datetime_now()) comm = Comment(publishing_id=pub.publishing_id, user_comment=user_comment, date_user_comment=date_user_comment) db.session.add(comm) db.session.commit() else: pub = Publishing(num_version=latest_version_publishing.num_version + 1, post_id=post.id, channel_id=chn.id, state=State.NOT_VALIDATED.value, title=title_post, description=descr_post, link_url=link_post, image_url=image_post, date_from=date_from, date_until=date_until, misc=misc_post) db.session.add(pub) db.session.commit() return pub
def setup_db(): global user_admin myself_user = db.session.query(User).get('myself') user_admin = myself_user.admin myself_user.admin = 1 id_channels = [0, -1, -2] id_posts = [0, -1, -2] channel = Channel(id=id_channels[0], name="Test_channel_1", module="superform.plugins.Twitter", config="{}") db.session.add(channel) channel = Channel(id=id_channels[1], name="Test_channel_2", module="superform.plugins.Twitter", config="{}") db.session.add(channel) channel = Channel(id=id_channels[2], name="Test_channel_3", module="superform.plugins.Twitter", config="{}") db.session.add(channel) authorization = Authorization(user_id="myself", channel_id=id_channels[0], permission=2) db.session.add(authorization) authorization = Authorization(user_id="myself", channel_id=id_channels[1], permission=2) db.session.add(authorization) authorization = Authorization(user_id="myself", channel_id=id_channels[2], permission=2) db.session.add(authorization) post = Post(id=id_posts[0], user_id="myself", title="first title #123456789123456789123456789title", description="This is a test, yes it really is. #123456789123456789123456789descr", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-08-08"), date_until=datetime_converter("2018-08-10")) db.session.add(post) post = Post(id=id_posts[1], user_id="myself", title="first title #123456789123456789123456789title ", description="This is a test, yes it really is. #123456789123456789123456789descr", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-10-08"), date_until=datetime_converter("2018-11-10")) db.session.add(post) post = Post(id=id_posts[2], user_id="myself", title="first title #98765410987654321876543223456title notvisible", description="This is a test, yes it really is. #98765410987654321876543223456title notvisible", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-10-08"), date_until=datetime_converter("2018-11-10")) db.session.add(post) publishing = Publishing(post_id=id_posts[0], channel_id=id_channels[0], state=1, title="first title #123456789123456789123456789title published", description="This is a test, yes it really is. #123456789123456789123456789descr published", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-08-08"), date_until=datetime_converter("2018-08-10"), extra="{}") db.session.add(publishing) publishing = Publishing(post_id=id_posts[0], channel_id=id_channels[1], state=0, title="first title #123456789123456789123456789title waitingforapproval", description="This is a test, yes it really is. #123456789123456789123456789descr waitingforapproval", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-11-11"), date_until=datetime_converter("2018-11-12"), extra="{}") db.session.add(publishing) publishing = Publishing(post_id=id_posts[0], channel_id=id_channels[2], state=2, title="first title #123456789123456789123456789title archived", description="This is a test, yes it really is. #123456789123456789123456789descr archived", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-12-11"), date_until=datetime_converter("2018-12-12"), extra="{}") db.session.add(publishing) try: db.session.commit() except Exception as e: print(str(e)) db.session.rollback() return id_channels, id_posts
def test_basic_warning2(client): id_channel, id_post = pytest.helpers.plugin.setup_db( channelName, pluginName) driver = webdriver.Firefox() try: driver.get('http://localhost:5000/') wait = WebDriverWait(driver, 10) driver.find_element_by_link_text("Login").click() driver.find_element_by_name("j_username").click() driver.find_element_by_name("j_username").clear() driver.find_element_by_name("j_username").send_keys("myself") driver.find_element_by_name("j_password").click() driver.find_element_by_name("j_password").clear() driver.find_element_by_name("j_password").send_keys("myself") driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='Password:'******'channel name'])[1]/following::button[1]" ).click() wait = WebDriverWait(driver, 10) wait.until(EC.element_to_be_clickable((By.LINK_TEXT, 'New post'))) driver.find_element_by_link_text("New post").click() driver.find_element_by_id("chan_option_" + str(id_channel)).click() driver.find_element_by_id("titlepost").click() driver.find_element_by_id("titlepost").clear() driver.find_element_by_id("titlepost").send_keys("Test") driver.find_element_by_id("descriptionpost").click() driver.find_element_by_id("descriptionpost").clear() driver.find_element_by_id("descriptionpost").send_keys("Frontend") driver.find_element_by_id("linkurlpost").click() driver.find_element_by_id("linkurlpost").clear() driver.find_element_by_id("linkurlpost").send_keys( "http://localhost:5000/new") driver.find_element_by_id("datefrompost").click() driver.find_element_by_id("datefrompost").clear() driver.find_element_by_id("datefrompost").send_keys("2020-11-21") driver.find_element_by_id("dateuntilpost").click() driver.find_element_by_id("dateuntilpost").clear() driver.find_element_by_id("dateuntilpost").send_keys("2021-01-29") driver.find_element_by_link_text(channelName).click() extra = {} pub = Publishing( post_id=id_post, channel_id=id_channel, state=0, title=driver.find_element_by_id( channelName + "_titlepost").get_attribute("value"), description=driver.find_element_by_id( channelName + "_descriptionpost").get_attribute("value"), link_url=driver.find_element_by_id( channelName + "_linkurlpost").get_attribute("value"), image_url="pas", date_from=datetime_converter("2050-07-01"), date_until=datetime_converter("2050-07-01"), extra=json.dumps(extra)) db.session.add(pub) db.session.commit() driver.get('http://localhost:5000/') # wait.until(EC.element_to_be_clickable((By.ID, "moderate_" + str(id_channel)))) driver.find_element_by_id("moderate_" + str(id_post)).click() driver.find_element_by_id("pub-button").click() assert driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='Moderate this publication'])[1]/following::div[1]" ).text == "Warning!: Channel not found, please review your configuration" except AssertionError as e: pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close() assert False, str(e) except InvalidRequestError as e: pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close() assert False, "An error occurred while testing: {}".format(str(e)) pytest.helpers.plugin.teardown_db(id_channel, id_post) driver.close()
def test_basic_publish(client, channelName, pluginName, configuration, extra): id_channel, id_post = setup_db(channelName, pluginName) driver = webdriver.Firefox() try: driver.get('http://localhost:5000/') wait = WebDriverWait(driver, 10) driver.find_element_by_link_text("Login").click() driver.find_element_by_name("j_username").click() driver.find_element_by_name("j_username").clear() driver.find_element_by_name("j_username").send_keys("myself") driver.find_element_by_name("j_password").click() driver.find_element_by_name("j_password").clear() driver.find_element_by_name("j_password").send_keys("myself") driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='Password:'******'http://localhost:5000/') wait = WebDriverWait(driver, 10) wait.until(EC.element_to_be_clickable((By.LINK_TEXT, "Channels"))) driver.find_element_by_link_text("Channels").click() driver.find_element_by_link_text("Configure").click() for key in configuration: driver.find_element_by_id(key).click() driver.find_element_by_id(key).clear() driver.find_element_by_id(key).send_keys(configuration[key]) driver.find_element_by_xpath( "(.//*[normalize-space(text()) and normalize-space(.)='" + list(configuration.keys())[-1] + "'])[1]/following::button[1]").click() wait = WebDriverWait(driver, 10) wait.until(EC.element_to_be_clickable((By.LINK_TEXT, 'New post'))) driver.find_element_by_link_text("New post").click() driver.find_element_by_id("chan_option_" + str(id_channel)).click() driver.find_element_by_id("titlepost").click() driver.find_element_by_id("titlepost").clear() driver.find_element_by_id("titlepost").send_keys("Test") driver.find_element_by_id("descriptionpost").click() driver.find_element_by_id("descriptionpost").clear() driver.find_element_by_id("descriptionpost").send_keys("Frontend") driver.find_element_by_id("linkurlpost").click() driver.find_element_by_id("linkurlpost").clear() driver.find_element_by_id("linkurlpost").send_keys( "http://localhost:5000/new") driver.find_element_by_id("datefrompost").click() driver.find_element_by_id("datefrompost").clear() driver.find_element_by_id("datefrompost").send_keys("2020-11-21") driver.find_element_by_id("dateuntilpost").click() driver.find_element_by_id("dateuntilpost").clear() driver.find_element_by_id("dateuntilpost").send_keys("2021-01-29") driver.find_element_by_link_text(channelName).click() pub = Publishing( post_id=id_post, channel_id=id_channel, state=0, title=driver.find_element_by_id( channelName + "_titlepost").get_attribute("value"), description=driver.find_element_by_id( channelName + "_descriptionpost").get_attribute("value"), link_url=driver.find_element_by_id( channelName + "_linkurlpost").get_attribute("value"), image_url="pas", date_from=datetime_converter("2050-07-01"), date_until=datetime_converter("2050-07-01"), extra=json.dumps(extra)) db.session.add(pub) db.session.commit() driver.get('http://localhost:5000/') # wait.until(EC.element_to_be_clickable((By.ID, "moderate_" + str(id_channel)))) driver.find_element_by_id("moderate_" + str(id_post)).click() driver.find_element_by_id("pub-button").click() assert driver.title == 'Index - Superform', driver.title except AssertionError as e: teardown_db(id_channel, id_post) driver.close() assert False, str(e) except InvalidRequestError as e: teardown_db(id_channel, id_post) driver.close() assert False, "An error occurred while testing: {}".format(str(e)) teardown_db(id_channel, id_post) driver.close()
def populate_db(): User.query.delete() user = User(id="michouchou", email="*****@*****.**", name="t", first_name="est", admin=False) db.session.add(user) user = User(id="googleplusmoderator", email="*****@*****.**", name="Press F", first_name="To pay respect", admin=False) db.session.add(user) user = User(id="mr_inutile69", email="*****@*****.**", name="MR", first_name="PS", admin=False) db.session.add(user) user = User(id="channelwriter", email="*****@*****.**", name="Channel", first_name="von LECRIVAIN", admin=False) db.session.add(user) user = User(id="channelmoder", email="*****@*****.**", name="Channel", first_name="van Moderate", admin=False) db.session.add(user) user = User(id="admin", email="*****@*****.**", name="Admin", first_name="van Ze Broek", admin=True) db.session.add(user) Channel.query.delete() channel = Channel(id=1, name="Twitter", module="superform.plugins.Twitter", config="{}") db.session.add(channel) channel = Channel(id=2, name="GPlus", module="superform.plugins.Gplus", config="{}") db.session.add(channel) channel = Channel(id=3, name="RSS", module="superform.plugins.RSS", config="{}") db.session.add(channel) channel = Channel(id=4, name="GMoins", module="superform.plugins.Gmoins", config="{}") db.session.add(channel) Authorization.query.delete() authorization = Authorization(user_id="michouchou", channel_id=1, permission=1) db.session.add(authorization) authorization = Authorization(user_id="admin", channel_id=1, permission=2) db.session.add(authorization) authorization = Authorization(user_id="admin", channel_id=2, permission=2) db.session.add(authorization) authorization = Authorization(user_id="admin", channel_id=3, permission=2) db.session.add(authorization) authorization = Authorization(user_id="admin", channel_id=4, permission=2) db.session.add(authorization) authorization = Authorization(user_id="googleplusmoderator", channel_id=2, permission=2) db.session.add(authorization) authorization = Authorization(user_id="channelwriter", channel_id=4, permission=1) db.session.add(authorization) authorization = Authorization(user_id="channelmoder", channel_id=1, permission=2) db.session.add(authorization) authorization = Authorization(user_id="channelmoder", channel_id=3, permission=1) db.session.add(authorization) Post.query.delete() post = Post( id=1, user_id="channelmoder", title="first title", description= "That know ask case sex ham dear her spot. Weddings followed the all marianne nor whatever settling. Perhaps six prudent several her had offence. Did had way law dinner square tastes. Recommend concealed yet her procuring see consulted depending. Adieus hunted end plenty are his she afraid. Resources agreement contained propriety applauded neglected use yet. ", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-07-01"), date_until=datetime_converter("2018-07-01")) db.session.add(post) post = Post( id=2, user_id="michouchou", title="second title", description= "first title Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. If we landlord stanhill mr whatever pleasure supplied concerns so. Exquisite by it admitting cordially september newspaper an. Acceptance middletons am it favourable.", link_url="http://twitter.com/", image_url="", date_from=datetime_converter("2018-11-13"), date_until=datetime_converter("2018-11-14")) db.session.add(post) post = Post( id=3, user_id="michouchou", title="third title", description= "Man request adapted spirits set pressed. Up to denoting subjects sensible feelings it indulged directly. We dwelling elegance do shutters appetite yourself diverted. Our next drew much you with rank. Tore many held age hold rose than our. She literature sentiments any contrasted. Set aware joy sense young now tears china shy. ", link_url="http://google.com/", image_url="de", date_from=datetime_converter("2018-11-15"), date_until=datetime_converter("2018-11-16")) db.session.add(post) post = Post(id=4, user_id="channelmoder", title="fourth nottitle", description="Man request adapted spirits set pressed. ", link_url="http://google.com/", image_url="", date_from=datetime_converter("2018-11-10"), date_until=datetime_converter("2018-11-17")) db.session.add(post) post = Post( id=5, user_id="michouchou", title="first title", description= "Not him old music think his found enjoy merry. Listening acuteness dependent at or an. Apartments thoroughly unsatiable terminated sex how themselves. She are ten hours wrong walls stand early. Domestic perceive on an ladyship extended received do. Why jennings our whatever his learning gay perceive.", link_url="http://youtube.com/", image_url="recherche", date_from=datetime_converter("2018-11-18"), date_until=datetime_converter("2018-11-19")) db.session.add(post) post = Post( id=7, user_id="channelmoder", title="lorem ipsum", description= "Add you viewing ten equally believe put. Separate families my on drawings do oh offended strictly elegance. Perceive jointure be mistress by jennings properly. An admiration at he discovered difficulty continuing. We in building removing possible suitable friendly on. ", link_url="http://instagram.com/", image_url="{}", date_from=datetime_converter("2018-11-20"), date_until=datetime_converter("2018-11-21")) db.session.add(post) post = Post(id=8, user_id="channelmoder", title="frè§iyu title", description="", link_url="", image_url="", date_from=datetime_converter("2018-11-22"), date_until=datetime_converter("2018-11-23")) db.session.add(post) post = Post( id=9, user_id="channelwriter", title="him men instrument saw", description= "It prepare is ye nothing blushes up brought. Or as gravity pasture limited evening on. Wicket around beauty say she. Frankness resembled say not new smallness you discovery. Noisier ferrars yet shyness weather ten colonel. Too him himself engaged husband pursuit musical.", link_url="http://linkedin.com/", image_url="http://wordpress.com/", date_from=datetime_converter("2018-11-24"), date_until=datetime_converter("2018-11-25")) db.session.add(post) post = Post(id=10, user_id="channelwriter", title="men instrument", description="", link_url="", image_url="", date_from=datetime_converter("2018-11-26"), date_until=datetime_converter("2018-11-27")) db.session.add(post) post = Post( id=11, user_id="channelwriter", title="", description= "Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. ", link_url="http://wordpress.com/", image_url="sur", date_from=datetime_converter("2018-11-28"), date_until=datetime_converter("2018-11-29")) db.session.add(post) Publishing.query.delete() publishing = Publishing( post_id=1, channel_id=1, state=0, title="first title", description= "That know ask case sex ham dear her spot. Weddings followed the all marianne nor whatever settling. Perhaps six prudent several her had offence. Did had way law dinner square tastes. Recommend concealed yet her procuring see consulted depending. Adieus hunted end plenty are his she afraid. Resources agreement contained propriety applauded neglected use yet. ", link_url="http://facebook.com/", image_url="pas", date_from=datetime_converter("2018-11-11"), date_until=datetime_converter("2018-11-12"), extra="{}") db.session.add(publishing) publishing = Publishing( post_id=2, channel_id=1, state=1, title="second title", description= "first title Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. If we landlord stanhill mr whatever pleasure supplied concerns so. Exquisite by it admitting cordially september newspaper an. Acceptance middletons am it favourable.", link_url="http://twitter.com/", image_url="", date_from=datetime_converter("2018-11-13"), date_until=datetime_converter("2018-11-14"), extra="{ce champs}") db.session.add(publishing) publishing = Publishing( post_id=3, channel_id=1, state=2, title="third title", description= "Man request adapted spirits set pressed. Up to denoting subjects sensible feelings it indulged directly. We dwelling elegance do shutters appetite yourself diverted. Our next drew much you with rank. Tore many held age hold rose than our. She literature sentiments any contrasted. Set aware joy sense young now tears china shy. ", link_url="http://google.com/", image_url="de", date_from=datetime_converter("2018-11-15"), date_until=datetime_converter("2018-11-16"), extra='{"est sans"}') db.session.add(publishing) publishing = Publishing( post_id=4, channel_id=1, state=0, title="fourth nottitle", description="Man request adapted spirits set pressed. ", link_url="http://google.com/", image_url="", date_from=datetime_converter("2018-11-10"), date_until=datetime_converter("2018-11-17"), extra="{'importance':mais}") db.session.add(publishing) publishing = Publishing( post_id=5, channel_id=1, state=1, title="first title", description= "Not him old music think his found enjoy merry. Listening acuteness dependent at or an. Apartments thoroughly unsatiable terminated sex how themselves. She are ten hours wrong walls stand early. Domestic perceive on an ladyship extended received do. Why jennings our whatever his learning gay perceive.", link_url="http://youtube.com/", image_url="recherche", date_from=datetime_converter("2018-11-18"), date_until=datetime_converter("2018-11-19"), extra="") db.session.add(publishing) publishing = Publishing( post_id=1, channel_id=3, state=0, title="lorem ipsum", description= "Add you viewing ten equally believe put. Separate families my on drawings do oh offended strictly elegance. Perceive jointure be mistress by jennings properly. An admiration at he discovered difficulty continuing. We in building removing possible suitable friendly on. ", link_url="http://instagram.com/", image_url="{}", date_from=datetime_converter("2018-11-11"), date_until=datetime_converter("2018-11-12"), extra="verifions") db.session.add(publishing) publishing = Publishing(post_id=7, channel_id=3, state=0, title="", description="", link_url="", image_url="", date_from=datetime_converter("2018-11-20"), date_until=datetime_converter("2018-11-21"), extra="{}") db.session.add(publishing) publishing = Publishing( post_id=8, channel_id=3, state=0, title="him men instrument saw", description= "It prepare is ye nothing blushes up brought. Or as gravity pasture limited evening on. Wicket around beauty say she. Frankness resembled say not new smallness you discovery. Noisier ferrars yet shyness weather ten colonel. Too him himself engaged husband pursuit musical.", link_url="http://linkedin.com/", image_url="http://wordpress.com/", date_from=datetime_converter("2018-11-22"), date_until=datetime_converter("2018-11-23"), extra="{}") db.session.add(publishing) publishing = Publishing(post_id=4, channel_id=3, state=2, title="men instrument", description="", link_url="", image_url="", date_from=datetime_converter("2018-11-10"), date_until=datetime_converter("2018-11-17"), extra="que ça n'as pas") db.session.add(publishing) publishing = Publishing( post_id=9, channel_id=4, state=1, title="", description= "Him rendered may attended concerns jennings reserved now. Sympathize did now preference unpleasing mrs few. Mrs for hour game room want are fond dare. For detract charmed add talking age. Shy resolution instrument unreserved man few. She did open find pain some out. ", link_url="http://wordpress.com/", image_url="sur", date_from=datetime_converter("2018-11-24"), date_until=datetime_converter("2018-11-25"), extra="[]") db.session.add(publishing) publishing = Publishing( post_id=10, channel_id=4, state=1, title="explained middleton am", description= "Entire any had depend and figure winter. Change stairs and men likely wisdom new happen piqued six. Now taken him timed sex world get. Enjoyed married an feeling delight pursuit as offered. As admire roused length likely played pretty to no. Means had joy miles her merry solid order. ", link_url="http://linkedin.com/", image_url="les images", date_from=datetime_converter("2018-11-26"), date_until=datetime_converter("2018-11-27"), extra="") db.session.add(publishing) publishing = Publishing( post_id=11, channel_id=4, state=2, title="first title", description= "Perhaps far exposed age effects. Now distrusts you her delivered applauded affection out sincerity. As tolerably recommend shameless unfeeling he objection consisted. She although cheerful perceive screened throwing met not eat distance.", link_url="http://youtube.com/", image_url="h", date_from=datetime_converter("2018-11-28"), date_until=datetime_converter("2018-11-29"), extra="'d'influence'") db.session.add(publishing)