def tweet_comment_create(form):
tweet_text = Tweet_comment(tweet_text=form['tweet'])
session.add(tweet_text)
session.commit()
return tweet_text
def create_google_user():
stripe_id = request.get_cookie('stripe_id',
secret=models.app_setting.SECRET_KEY)
user = User(stripe_id=stripe_id, pro_img='./static/img/ninwanko.png')
session.add(user)
session.commit()
return user
def create_instagram_user(form):
stripe_id = request.get_cookie('stripe_id',
secret=models.app_setting.SECRET_KEY)
user = User(stripe_id=stripe_id,
name=form['full_name'],
pro_img='./static/img/ninwanko.png')
session.add(user)
session.commit()
return user
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 create_user(form):
stripe_id = request.get_cookie('stripe_id',
secret=models.app_setting.SECRET_KEY)
user = User(stripe_id=stripe_id,
name=form.getunicode('name'),
email=form.getunicode('email'),
password=_encrypt_password(form.getunicode('password')),
pro_img='./static/img/hi.png')
session.add(user)
session.commit()
return user
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 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 follow_table(form):
from_id = request.get_cookie('user_id',
secret=models.app_setting.SECRET_KEY)
follow_id = 1
follow_user = session.query(Follow.follow_id).filter(
Follow.to_user_id == form, Follow.from_user_id == from_id).all()
if follow_id == 1:
follow = Follow(from_user_id=from_id,
to_user_id=form,
follow_id=follow_id)
session.add(follow)
session.commit()
return redirect('/follower')
else:
return redirect('/follower')
def create_socials(user, data, provider):
if provider == 'facebook':
social = Social(
user_id=user.id,
provider=provider,
provider_id=data['id'],
)
elif provider == 'google':
social = Social(user_id=user.id, provider=provider, provider_id=data)
elif provider == 'twitter':
social = Social(user_id=user.id,
provider=provider,
provider_id=data['user_id'])
elif provider == 'instagram':
social = Social(user_id=user.id,
provider=provider,
provider_id=data['id'])
session.add(social)
session.commit()
def img_table(form):
tweet = 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)
if request.POST.getunicode('img') != '':
img = Img(img_url=request.POST.getunicode('img'),
tweet_id=tweet,
user_id=data)
img_file = img.img_url
if img_file and allowed_file(img_file.filename):
filename = img_file.filename
path = UPLOAD_FOLDER + filename
try:
img_file.save(os.path.join(UPLOAD_FOLDER, filename))
img.img_url = path
session.add(img)
session.commit()
return img
except OSError:
os.remove(path)
img_file.save(os.path.join(UPLOAD_FOLDER, filename))
img.img_url = path
session.add(img)
session.commit()
return img
else:
img = Img(img_url=None, tweet_id=tweet, user_id=data)
session.add(img)
session.commit()
print(img)
print(img.img_url)
return img
def set_stripe_id(stripe_id, email):
user = User(stripe_id=stripe_id, email=email)
session.add(user)
session.commit()
