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
