def feedbk_update():
db.create_all()
upd = Feedback.query.filter_by(user_id=request.json['user_id']).first()
upd.feedback = request.json['feedback']
db.session.commit()
return "Feedback updated"
def addr_read():
db.create_all()
# result = db.engine.execute("SELECT * from video")
jlist = []
result = Address.query.all()
print(result)
for i in result:
i.__dict__['_sa_instance_state']=str(i.__dict__['_sa_instance_state'])
jlist.append(i.__dict__)
return jsonify(jlist)
def pay_delete(id_):
db.create_all()
find_user = User.query.filter_by(user_id=int(id_)).first_or_404(description='record: not found')
# print(find_vid)
del_pay = Payment.query.filter_by(user_id=find_user.user_id).first_or_404(description='record: {} not found')
print(del_pay)
db.session.delete(del_pay)
db.session.commit()
return "payment deleted"
def addr_delete(id_):
db.create_all()
find_user = User.query.filter_by(user_id=int(id_)).first_or_404(description='record: not found')
del_addr = Address.query.filter_by(user_id=find_user.user_id).first_or_404(description='record: {} not found')
db.session.delete(del_addr)
db.session.commit()
return "address deleted"
def doc_delete(video_name):
db.create_all()
find_vid = Video.query.filter_by(video_name=str(video_name)).first_or_404(description='record: {} not found'.format(video_name))
print(find_vid)
del_doc = Document.query.filter_by(video_id=find_vid.id).first_or_404(description='record: {} not found'.format(video_name))
print(del_doc)
db.session.delete(del_doc)
db.session.commit()
return "document deleted"
def doc_read():
db.create_all()
# result = db.engine.execute("SELECT * from video")
jlist = []
result = Document.query.all()
for i in result:
i.__dict__['_sa_instance_state']=str(i.__dict__['_sa_instance_state'])
jlist.append(i.__dict__)
print(jlist[0])
return jsonify(jlist)
def user_delete(mailid):
db.create_all()
# delete from user table
d = User.query.filter_by(email=str(mailid)).first()
db.session.delete(d)
# delete from login table
ld = Login.query.filter_by(login_id=str(mailid)).first()
db.session.delete(ld)
db.session.commit()
return "user deleted from user and login table"
def reg_update(mailid):
if not request.json:
abort(404)
db.create_all()
user_update = User.query.filter_by(email=str(mailid)).first()
user_update.password = request.json['psd']
log_update = Login.query.filter_by(login_id=str(mailid)).first()
log_update.password = request.json['psd']
db.session.commit()
print(request.json)
return "password updated"
def doc_update():
db.create_all()
if not request.json:
abort(404)
find_vid = Video.query.filter_by(video_name=request.json['video_name']).first()
upd_doc = Document.query.filter_by(video_id=find_vid.id).first()
upd_doc.document_path_url = request.json['doc_path']
db.session.commit()
return "document updated"
def video():
values = []
if not request.json:
return make_response({"json":"NO"})#abort(404)
for i in request.json:
values.append(request.json[i])
db.create_all()
vid = Video(values[0],values[1], values[2], values[3])
db.session.add(vid)
db.session.commit()
return "Inserted into Video table and document table"
def pay_update():
db.create_all()
if not request.json:
abort(404)
find_user = User.query.filter_by(user_id=request.json['user_id']).first_or_404(description='record not found')
upd_pay = Payment.query.filter_by(user_id=find_user.user_id).first()
upd_pay.payment_amout = request.json['pay_amout']
upd_pay.status = request.json['status']
db.session.commit()
return "payment updated"
def vid_delete(v_id):
print(type(v_id))
db.create_all()
# find_doc = Document.query.filter_by()
de = Video.query.filter_by(id=v_id).first()
# delete related documents
docs = Document.query.filter_by(video_id=de.id).delete()
print(docs)
# db.session.delete(docs)
db.session.delete(de)
db.session.commit()
return "record deleted\n"
def vid_update():
db.create_all()
print(request.json)
upd = Video.query.filter_by(video_name=request.json['video_name']).first_or_404(description='record')
if not request.json:
abort(404)
print(type(request.json))
upd.video_name = request.json['video_name']
upd.video_url = request.json['video_url']
upd.description = request.json['description']
upd.category = request.json['category'] #request.json.get("category",upd.category)
db.session.commit()
return "sucess"
def vid_getFew(id):
db.create_all()
result = Video.query.filter_by(id=int(id)).all()
# query_parameter = dict(request.args)
# if 'id' in query_parameter :
# id=int(query_parameter.get('id'))
# result = Video.query.filter_by(id=id).all()
jlist = []
for i in result:
i.__dict__['_sa_instance_state']=str(i.__dict__['_sa_instance_state'])
jlist.append(i.__dict__)
# print(query_parameter)
return jsonify(jlist)
def feedbk_insert():
db.create_all()
if not request.json:
abort(404)
find_user = User.query.filter_by(user_id=request.json['user_id']).first_or_404(description="user not found")
# print(find_user)
if find_user:
new_feedback = Feedback(feedback=request.json['feedback'], user=find_user)
db.session.add(new_feedback)
else:
abort(404)
db.session.commit()
return "feedback inserted"
def doc_insert():
db.create_all()
if not request.json:
return make_response({"json":"NO"})#abort(404)
find_vid = Video.query.filter_by(video_name=request.json['video_name']).first_or_404(description='there is no data with {}'.format(request.json['video_name']))
if find_vid:
new_doc = Document(document_path_url=request.json['doc'], video_name=find_vid)
db.session.add(new_doc)
else:
abort(404)
db.session.commit()
return "document inserted"
def q():
db.create_all()
vname = 'jgas.mp4'
vurl = '.assests/video/jafids.mp4'
desc = 'jiogajsd nuaensf iuiew'
cat = 'funny'
vid = Video(vname, vurl, desc, cat)
db.session.add(vid)
doc = Document(document_path_url='j/sdg/asgasd/asg/jdsa.pdf',video_name=vid)
db.session.add(doc)
db.session.commit()
print(Document.query.all())
return "sucess"
def pay_insert():
db.create_all()
if not request.json:
return make_response({"json":"NO"})#abort(404)
find_user = User.query.filter_by(user_id=request.json['user_id']).first_or_404(description='there is no data with {}'.format(request.json['user_id']))
if find_user:
new_pay = Payment(txn_id=request.json['txn'], payment_amout=request.json['pay_amout'],status=request.json['status'], user=find_user)
db.session.add(new_pay)
else:
abort(404)
db.session.commit()
return "payment made successfully"
def addr_update():
db.create_all()
if not request.json:
abort(404)
find_user = User.query.filter_by(user_id=request.json['user_id']).first_or_404(description='record not found')
upd = Address.query.filter_by(user_id=find_user.user_id).first()
upd.addr_line1 = request.json['addr1']
upd.addr_line2 = request.json['addr2']
upd.country = request.json['country']
upd.state = request.json['state']
upd.city = request.json['city']
db.session.commit()
return "Address updated"
def regis():
values =[]
if not request.json:
abort(404)
for i in request.json:
values.append(request.json[i])
db.create_all()
new_user = User(name=values[0],password=values[1],contact=values[2],email=values[3],company=values[4],design=values[5],why=values[6],address=values[7])
log = Login(id=new_user.user_id, login_id=new_user.email, password=new_user.password)
db.session.add(new_user)
db.session.add(log)
db.session.commit()
return "value inserted in user and login tables"
def addr_insert():
db.create_all()
values=[]
if not request.json:
return make_response({"json":"NO"})#abort(404)
else:
for i in request.json:
values.append(request.json[i])
find_user = User.query.filter_by(user_id=values[0]).first_or_404(description='there is no data with {}'.format(values[0]))
if find_user:
add_addr = Address(addr_line1=values[1], addr_line2=values[2], country=values[3], state=values[4], city=values[5], user=find_user)
db.session.add(add_addr)
else:
abort(404)
db.session.commit()
return "Address inserted"
def reg_user_update(mailid):
db.create_all()
# update user table
upd = User.query.filter_by(email=str(mailid)).first()
upd.name = request.json['name']
upd.password = request.json['password']
upd.contact = request.json['contact']
upd.email = request.json['email']
upd.company = request.json['company']
upd.design = request.json['designation']
upd.why = request.json['why']
upd.address = request.json['address']
# update login table
lo = Login.query.filter_by(login_id=str(mailid)).first()
lo.login_id = request.json['email']
lo.password = request.json['password']
db.session.commit()
return "user updated"