Webhook server messanger

def webhook(request): if request.method == 'POST': data = request.json print(data) return jsonify(data)

Form with three imput one mai password Andy submit

<form action="https://www.w3schools.com/action_page.php"> <label for="fname">First name:</label><br> <input type="text" id="fname" name="fname" value="John"><br> <label for="lname">Last name:</label><br> <input type="text" id="lname" name="lname" value="Doe"><br><br> <input type="submit" value="Submit"> </form>

Find patient with many diseases not paid

select p.name, count(d.id) as num_diseases, sum(b.paid) as total_paid, sum(b.amount) as total_amount from patients p, diseases d, bills b where p.id=d.patient_id and d.id=b.disease_id group by p.name having total_paid!=total_amount;

class AliasPluginModel(CMSPlugin): cmsplugin_ptr = models.OneToOneField( CMSPlugin, on_delete=models.CASCADE, related_name='cms_aliasplugin', parent_link=True, ) plugin = models.ForeignKey( CMSPlugin, on_delete=models.CASCADE, editable=False, related_name='alias_reference', null=True, ) alias_placeholder = models.ForeignKey( Placeholder, on_delete=models.CASCADE, editable=False, related_name='alias_placeholder', null=True, ) class Meta: app_label = 'cms

The AliasPluginModel is a subclass of CMSPlugin and it has a one-to-one relation with CMSPlugin. It also has a foreign key relation with CMSPlugin and a foreign key relation with Placeholder.

Read Excel file data Andy insert that data in SQL database

import pandas as pd def read_excel_file(file_name): try: df = pd.read_excel(file_name) return df except Exception as e: print(e) df = read_excel_file('file.xlsx')

Trad Google mail Andy sabe it ton Google sheet

def sendToGSheet(subject, content): import gspread from oauth2client.service_account import ServiceAccountCredentials scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive'] credentials = ServiceAccountCredentials.from_json_keyfile_name('/content/gspread-275812-baf8a05c34ab.json', scope) gc = gspread.authorize(credentials) wks = gc.open("GoogleMail").sheet1 wks.append_row([subject, content])

Webhook messanger

def webhook_messenger(name, message): return "You have a new message from {}. {}".format(name, message) webhook_messenger("John", "Hello")

Webhook server for Facebook messanger

import json from flask import Flask, request from pymessenger.bot import Bot app = Flask(__name__) ACCESS_TOKEN = 'ACCESS_TOKEN' VERIFY_TOKEN = 'VERIFY_TOKEN' bot = Bot(ACCESS_TOKEN) def verify_fb_token(token_sent): #take token sent by facebook and verify it matches the verify token you sent #if they match, allow the request, else return an error if token_sent == VERIFY_TOKEN: return request.args.get("hub.challenge") return 'Invalid verification token' #chooses a random message to send to the user def get_message(): sample_responses = ["You are stunning!", "We're proud of you.", "Keep on being you!", "We're greatful to know you :)"] # return selected item to the user return random.choice(sample_responses) #uses PyMessenger to send response to user def send_message(recipient_id

Convert excel sheet to dsl database

def convert(filename): return make_db(read_excel(filename))

class AliasPluginModel(CMSPlugin): cmsplugin_ptr = models.OneToOneField( CMSPlugin, on_delete=models.CASCADE, related_name='cms_aliasplugin', parent_link=True, ) plugin = models.ForeignKey( CMSPlugin, on_delete=models.CASCADE, editable=False, related_name='alias_reference', null=True, ) alias_placeholder = models.ForeignKey( Placeholder, on_delete=models.CASCADE, editable=False, related_name='alias_placeholder', null=True, ) class Meta: app_label = 'cms