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"