def is_duplicate_name(name): user = session.query(User).filter(User.name == name).first() if user is None: return False else: return True
def insta_callback(): if request.GET.getunicode('code'): access_token = get_instagram_access_token( request.GET.getunicode('code')) data = check_instagram_access_token(access_token) if data: if check_socials(data, 'instagram'): social = session.query(User.name).join( Social, User.id == Social.user_id).filter( Social.provider == 'instagram', Social.provider_id == data['id']).first() if social is None: redirect('/mypage') else: redirect('/tweet') else: user = create_instagram_user(data) create_socials(user, data, 'instagram') login_user(user.id) # send_mail(data['email'], 'create') redirect('/tweet') else: # アクセストークンが不正なものだったらログイン画面にリダイレクトする redirect('/') else: redirect('/')
def delete_mail(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) mail = session.query(User.email).filter(User.id == user_id).all() return mail
def is_duplicate_email(email): user = session.query(User).filter(User.email == email).first() if user is None: return False else: return True
def delete_follower(form): delete = session.query(Follow).filter(Follow.to_user_id == form, Follow.follow_id == 1).delete() session.commit() return redirect('/follower')
def facebook_callback(): # try: # 予期せぬエラーがでたらログイン画面にリダイレクトする if request.GET.getunicode('code'): access_token = get_facebook_access_token( request.GET.getunicode('code')) data = check_facebook_access_tokn(access_token) if data['is_valid']: data = get_facebook_user_info(access_token, data['user_id']) if check_socials(data, 'facebook'): social = session.query(User.name).join( Social, User.id == Social.user_id).filter( Social.provider == 'facebook', Social.provider_id == data['id']).first() if social is None: redirect('/mypage') else: redirect('/tweet') else: user = create_facebook_user(data) create_socials(user, data, 'facebook') login_user(user.id) # send_mail(data['email'], 'create') redirect('/tweet') else: # アクセストークンが不正なものだったらログイン画面にリダイレクトする redirect('/') else: redirect('/')
def loggedin_account(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) account = session.query(User.id).filter(User.id == user_id).all() return account
def fab_check_view(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) check = session.query(Fab.tweet_id).filter(Fab.user_id == user_id, Fab.fab_id == 1).all() return check
def tweet_table(form): content = session.query(Tweet_comment.id).filter( Tweet_comment.tweet_text == form['tweet']).order_by( desc(Tweet_comment.id)).first() data = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) img_db = session.query(Img).join( Tweet_comment, Tweet_comment.id == Img.tweet_id).filter( Tweet_comment.tweet_text == form['tweet'], Img.user_id == data).order_by(desc(Img.id)).first() tweet = Tweet(tweet_id=content, user_id=data, img_id=img_db.id) session.add(tweet) session.commit() return tweet
def get_current_user(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) if user_id: return session.query(User).get(user_id) else: return None
def remake_password_check(mail, form, stripe_id): password_check = session.query(User.password).filter( User.email == mail, User.stripe_id == stripe_id).all() if password_check is None: remake = User(password=_encrypt_password(form.getunicode('password2'))) session.add(remake) session.commit() else: remake = session.query(User).filter( User.email == mail, User.stripe_id == stripe_id).first() print(remake) remake.password = _encrypt_password(form.getunicode('password2')) session.commit()
def my_tweet_img(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) profile = session.query(User.pro_img).filter(User.id == user_id).all() return profile
def follow_id_view(): cookie_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) follow_view = session.query(Follow.to_user_id).filter( Follow.from_user_id == cookie_id, Follow.follow_id == 1).all() return follow_view
def user_email_first(): stripe_id = request.get_cookie('stripe_id', secret=models.app_setting.SECRET_KEY) email = session.query(User.email).filter(User.stripe_id == stripe_id).all() email = email[0][0] return email
def check_email_stripe_id(form): user = session.query( User.stripe_id).filter(User.email == form.getunicode('email')).all() if user is None: return False else: return user
def check_account_payafter(email, stripe_id): user = session.query(User).filter(User.email == email, User.stripe_id == stripe_id).all() if user is None: return False else: return True
def delete_account(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) user_account_delete = session.query(User).filter( User.id == user_id).delete() session.commit() return user_account_delete
def comment(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) profile = session.query(User.id, User.name, User.email, User.pro_img, User.comment).filter(User.id == user_id).all() return profile
def get_current_stripe_id_check(): stripe_id = request.get_cookie('stripe_id', secret=models.app_setting.SECRET_KEY) user = session.query(User).filter(User.stripe_id == stripe_id).all() if user: return True else: return None
def remake_password_email(form): user = session.query( User.email).filter(User.email == form.getunicode('email')).all() if user == []: return False else: user = user[0][0] return user
def users_tweet(form): user_tweet = session.query( Tweet.created_at, Tweet_comment.tweet_text, Tweet.tweet_id, User.id, User.name, Img.img_url, User.pro_img, Tweet.id).join(User, User.id == Tweet.user_id).join( Tweet_comment, Tweet_comment.id == Tweet.tweet_id).join( Img, Img.id == Tweet.img_id).filter(Tweet.user_id == form).all() return user_tweet
def my_tweet_edit(form): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) tweet_edit = session.query(Tweet_comment.tweet_text).join( Tweet, Tweet.tweet_id == Tweet_comment.id).filter( Tweet.user_id == user_id, Tweet_comment.id == form).all() return tweet_edit
def follower_view(): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) follower = session.query( Follow.to_user_id, User.name, User.comment, User.pro_img).join(User, User.id == Follow.to_user_id).filter( Follow.from_user_id == user_id, Follow.to_user_id == User.id, Follow.to_user_id != user_id, Follow.follow_id == 1).all() return follower
def my_tweet_edit_input(form): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) tweet_edit = session.query(Tweet_comment.id).join( Tweet, Tweet.tweet_id == Tweet_comment.id).filter( Tweet.user_id == user_id, Tweet_comment.id == form).all() if tweet_edit != form: redirect('/mypage') tweet_edit = session.query(Tweet_comment).join( Tweet, Tweet.tweet_id == Tweet_comment.id).filter( Tweet.user_id == user_id, Tweet_comment.id == form).first() tweet_edit.tweet_text = request.POST.getunicode('tweet') print(tweet_edit.tweet_text) session.commit() return tweet_edit
def authenticate(form): auth_user = session.query(User).filter( User.email == form.getunicode('email'), User.password == _encrypt_password( form.getunicode('password'))).first() if auth_user is not None: login_user(auth_user.id) return True else: return False
def delete_check(form): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) check = session.query(User).filter( User.email == form.getunicode('email')).all() if check is not None: return True else: return False
def my_comment(form): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) profile_edit = session.query(User).filter(User.id == user_id).first() profile_edit.name = form['user_name'] profile_edit.comment = form['user_intro'] session.commit() return profile_edit
def fab_table(form): user_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) fab_view = session.query(Fab.fab_id).filter(Fab.user_id == user_id, Fab.tweet_id == form).all() if fab_view == 1: return redirect('/fab') else: fab = Fab(user_id=user_id, tweet_id=form, fab_id=1) session.add(fab) session.commit() return redirect('/fab')
def check_socials(data, provider): if provider == 'facebook': social = session.query(Social).filter( Social.provider == 'facebook', Social.provider_id == data['id']).first() elif provider == 'twitter': social = session.query(Social).filter( Social.provider == 'twitter', Social.provider_id == data['user_id']).first() elif provider == 'instagram': social = session.query(Social).filter( Social.provider == 'instagram', Social.provider_id == data['id']).first() else: social = session.query(Social).filter( Social.provider == 'google', Social.provider_id == data).first() if social is None: return False else: login_user(social.user_id) return True
def tweet_view(): cookie_id = request.get_cookie('user_id', secret=models.app_setting.SECRET_KEY) tweet_view = session.query( Tweet.created_at, Tweet_comment.tweet_text, Tweet_comment.id, User.id, User.name, Img.img_url, User.pro_img, Tweet.tweet_id, Tweet.id).join(User, User.id == Tweet.user_id).join( Tweet_comment, Tweet_comment.id == Tweet.tweet_id).join( Img, Img.id == Tweet.img_id).filter( Tweet.user_id != cookie_id).all() return tweet_view