예제 #1
0
def all_tweets():
    """
    This method handles All Tweets View.
    :return: If "GET" rendering template "all_tweets",
            If "POST" adding new Tweet to db and redirecting back to all_tweets.
    """

    if not session['logged_in']:
        return redirect(url_for('login'))

    if request.method == "GET":
        cnx = connect_db()
        tweets = Tweet.load_all_tweets(cnx.cursor())
        return render_template('all_tweets.html', tweets=tweets)

    elif request.method == "POST":
        tweet = Tweet()
        tweet.user_id = session['user_id']
        tweet.text = request.form['new_tweet']
        tweet.creation_date = datetime.now()

        cnx = connect_db()
        tweet.add_tweet(cnx.cursor())
        cnx.commit()

        return redirect(url_for('all_tweets'))
예제 #2
0
def testCreateTweet():
    new_tweet = Tweet()
    new_tweet.text = 'gollsdfsdfsdfsfdsdfum'
    new_tweet.creation_date = datetime.now()
    print(new_tweet.id)

    try:
        cnx = connect(user=user,
                      password=password,
                      host=host,
                      database=database)
        print("Connected...")
        cursor = cnx.cursor()

        new_tweet.add_edit_tweet(cursor)

        cnx.commit()
        cursor.close()
        cnx.close()
        print('Disconnected...')

    except ProgrammingError:
        print("Not connected...")