Beispiel #1
0
def db_start():
    app.app_context().push()
    db.create_all()
    config = configparser.ConfigParser()
    config.read('config.ini')

    engine = create_engine(config['DB']['SQLALCHEMY_DATABASE_URI'],
                           convert_unicode=True)
    if not database_exists(engine.url):
        create_database(engine.url)
    db.create_all()
    db.session.commit()
Beispiel #2
0
def init_admin():
    user = User()
    user.username = "******"
    user.password = generate_password_hash('admin', method='sha256')
    user.email = '*****@*****.**'
    user.admin = True
    user.poweruser = True
    try:
        sa.orm.configure_mappers()
        app.app_context().push()
        db.session.add(user)
        db.session.commit()
    except IntegrityError as e:
        print('W bazie istnieje już użytkownik o nazwie: ' + user.username)
Beispiel #3
0
def session(app, db, request):
    """
    Returns function-scoped session.
    """
    with app.app_context():
        conn = _db.engine.connect()
        txn = conn.begin()

        options = dict(bind=conn, binds={})
        sess = _db.create_scoped_session(options=options)

        # establish  a SAVEPOINT just before beginning the test
        # (http://docs.sqlalchemy.org/en/latest/orm/session_transaction.html#using-savepoint)
        sess.begin_nested()

        @event.listens_for(sess(), "after_transaction_end")
        def restart_savepoint(sess2, trans):
            # Detecting whether this is indeed the nested transaction of the test
            if trans.nested and not trans._parent.nested:
                # The test should have normally called session.commit(),
                # but to be safe we explicitly expire the session
                sess2.expire_all()
                sess.begin_nested()

        _db.session = sess
        yield sess

        # Cleanup
        sess.remove()
        # This instruction rollsback any commit that were executed in the tests.
        txn.rollback()
        conn.close()
Beispiel #4
0
def send_mail(sender, recipients, theme, body, html):
    message_to_send = Message(theme, sender=sender, recipients=[recipients])
    message_to_send.body = body
    message_to_send.html = html

    with app.app_context():
        mail.send(message_to_send)
Beispiel #5
0
def price_alert(listing):
    # get trackers
    trackers = db.session.query(Tracker).all()
    for tracker in trackers:
        # if listing is tracked by tracker
        tracked_words = set(tracker.search.lower().split(" "))
        if set(listing.name.lower().split(" ")).intersection(
                tracked_words) == tracked_words:
            print("this is tracked:", listing.name)
            # if listing price triggers price alert
            if listing.price <= tracker.alert_price or listing.price <= tracker.ave_price * tracker.alert_percentage:
                # generate and send price alert email
                with app.app_context():
                    html_template = render_template(
                        "price_alert_email_template.html",
                        listing=listing,
                        tracker=tracker)
                to_email = str(tracker.user_email)
                send_alert(to_email, html_template)
                print("Data alert: ", listing.link)
                # update tracker ave_price and tracked items
                tracker.tracked_items = int(tracker.tracked_items) + 1
                tracker.ave_price = (tracker.ave_price +
                                     listing.price) / tracker.tracked_items
                db.session.commit()
Beispiel #6
0
def db(app, request):
    """
    Returns session-wide initialised database.
    """
    _db.init_app(app)
    with app.app_context():
        _db.drop_all()
        _db.create_all()
Beispiel #7
0
def add_supp():
    app.app_context().push()
    db.create_all()
    """    suppliers_id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(80), nullable=False)
    nip = db.Column(db.String(30), nullable=False)
    adress = db.Column(db.String(80), nullable=False)
    discount = db.Column(db.Float, default=0)
    """
    supplier1 = Suppliers(name='Engine Company 2',
                          nip='35223425525',
                          address="Engine town",
                          discount=10.15)
    sa.orm.configure_mappers()
    app.app_context().push()

    db.create_all()
    db.session.add(supplier1)
    db.session.commit()
def sendmail(notification):
    message = Message(
        subject=_('You have a notification from Better Translator'),
        body=notification.payload,
        sender=(_('app-title'), '*****@*****.**'),
        recipients=[notification.user.email]
    )

    with app.app_context():
        mail.send(message)

        db.session.delete(notification)
Beispiel #9
0
def db_start():
    db.init_app(app.app_context())
    config = configparser.ConfigParser()
    config.read('config.ini')

    # engine = create_engine('postgresql://*****:*****@localhost/stock_manager', convert_unicode=True)
    engine = create_engine(config['DB']['SQLALCHEMY_DATABASE_URI'],
                           convert_unicode=True)
    if not database_exists(engine.url):
        create_database(engine.url)
    db.create_all()
    db.session.commit()
Beispiel #10
0
def generate_notification():
    user_id = request.json['user_id']

    with app.app_context():
        msg = Message(
            subject="[Urgent] Get yourself tested for COVID-19 and quarantine.",
            sender=app.config.get("MAIL_USERNAME"),
            recipients=[user_id],  # replace with your email for testing
            body=
            "Hello, \r\nGreetings for the day. \r\nYou were in proximity of a person in the last 14 days who is currently infected from COVID-19. We highly recommend you to get yourself tested as soon as possible and quarantine yourself to prevent the spread of virus.\r\nStay Home, Stay Safe. \r\nBest Regards,\r\nPandemic Response Team "
        )
    mail.send(msg)
    return {"message": "success"}, 200
Beispiel #11
0
def say_hello():
    with app.app_context():
        app.logger.debug("adding to the log")
    test_dict["value"] += 33
    return 'hello world ' + str(test_dict["value"])
Beispiel #12
0
    for opportunity in opportunities:
        html += f"<a href='{baseurl}/opportunities/{opportunity.opportunityID}'>{opportunity.title}</a><br>"

    html += "<br>--<br>Caerus</body></html>"

    return html


# https://support.google.com/mail/answer/7126229?p=BadCredentials&visit_id=637267656946578056-6078978&rd=2#cantsignin
# https://www.digitalocean.com/community/tutorials/how-to-use-cron-to-automate-tasks-ubuntu-1804
# https://realpython.com/python-send-email/

if __name__ == "__main__":
    db.init_app(app)
    with app.app_context():
        db.create_all()
        info = getPreferredOpportunitiesForAllUsers()
        notifier = Notifier(user, pwd)
        for email in info.keys():
            prefs = getAllPreferences(info[email]['id'])
            opps = info[email]['opportunities']
            if len(opps) > 0:
                html = constructBody(opps, prefs)

                time = datetime.datetime.now()
                notifier.sendmail(
                    [email],
                    f"Caerus Weekly Update -- {time.date().isoformat()}", html)
                print(
                    f"Notification email sent to {email} -- {time.isoformat()}"
@babel.localeselector
def get_locale():
    return 'ko'

def sendmail(notification):
    message = Message(
        subject=_('You have a notification from Better Translator'),
        body=notification.payload,
        sender=(_('app-title'), '*****@*****.**'),
        recipients=[notification.user.email]
    )

    with app.app_context():
        mail.send(message)

        db.session.delete(notification)


def main():
    for notification in NotificationQueue.query.all():
        sendmail(notification)

    db.session.commit()


if __name__ == '__main__':
    #main()

    with app.app_context():
        print _('app-title')
Beispiel #14
0
def send_async_email(app, msg):
    with app.app_context():
        mail.send(msg)
from invoices.models import Products


def search_engine(query):
    product_list = {"Products":[]}
    if query:
        search_results = Products.query.order_by(Products.products_id)
        search_results = search(search_results, query)

    else:
        search_results = Products.query.order_by(Products.products_id)

    for r in search_results:
        product_name = str(r)
        product_list["Products"].append({"name": product_name[1:-1], "columns": [
            r.products_id,
            r.name,
            r.group,
            r.stock_quantity,
            r.price,
            r.supplier_id
        ]})

    return product_list


if __name__ == '__main__':
    from __init__ import app
    app.app_context().push()
    db.create_all()
    search_engine(query)
Beispiel #16
0
import csv
import datetime
from __init__ import app
from config import Config
from models import *

with app.app_context(), open('meetup_events.csv', 'r') as data:
    events_csv = csv.reader(data)
    events = list(events_csv)
    for row in events[1:]:
        loc = db.session.query(Location).filter(
            Location.code == row[6]).first()
        date = datetime.datetime.strptime(row[2] + row[3], '%d.%m.%Y%H:%M')
        event = Event(
            title=row[0],
            description=row[1],
            datetime=date,
            category=row[4],
            type=row[5],
            location=loc,
            address=row[7],
            seats=row[8],
        )
        db.session.add(event)
    db.session.commit()