Skip to content

Instantly share code, notes, and snippets.

View elseagle's full-sized avatar
:octocat:
Graphud

Sogo elseagle

:octocat:
Graphud
View GitHub Profile
from flask import Flask, request
import json, requests, apiai, threading, time
app = Flask(__name__)
datetime_dict = {}
PAT = 'EAAIEBfGH3bIBAN2xaZBy7dW7kAxvfCQSz7K6o3ejZAJDP8QCUQRTZCkKl1iTm74qAFxVP94FNb1O4YCaPPGIW827tw5lZBJJIn7MCv2KQOUvUlZAgXI3E6CeZBFsESz3bfS8Foq4ixha7myyeFbLtEkSbe8wSNGFJQtBpqIfWtFgZDZD'
VERIFICATION_TOKEN = "token_key"
CLIENT_ACCESS_TOKEN = "c9299dd0c1ef4173b3af4a02a6473311"
from flask import Flask, request
import json
import requests
from Quotes_Api import get_quotes
import sys
import os
try:
import apiai
from flask import Flask, request
import json
import requests
import sys
import os
import apiai
app = Flask(__name__)
#Page Access Token
'.*?@domain.com'
from flask import Flask, jsonify, request
app = Flask(__name__)
store =
{
"item": [
{
"name": 'Book',
"price": 99.99
import sqlite3
connection = sqlite3.connect('data.db')
cursor = connection.cursor()
create_table = "CREATE TABLE IF NOT EXISTS items (name text PRIMARY KEY, price real)"
cursor.execute(create_table)
connection.commit()
def find_by_name(name):
connection = sqlite3.connect('data.db')
cursor = connection.cursor()
query = "SELECT * FROM items WHERE name=?"
result = cursor.execute(query, (name,))
row = result.fetchone()
connection.close()
if row:
@app.route('/item/<string:name>')
def get(name):
item = find_by_name(name)
if item:
return item
return jsonify({'message': 'Item not found'}), 404
@app.route('/item')
def get():
connection = sqlite3.connect('data.db')
cursor = connection.cursor()
query = "SELECT * FROM items"
result = cursor.execute(query)
items = []
for row in result:
items.append({'name': row[0], 'price': row[1]})
def insert(item):
connection = sqlite3.connect('data.db')
cursor = connection.cursor()
query = "INSERT INTO {table} VALUES(?, ?)"
cursor.execute(query, (item['name'], item['price']))
connection.commit()
connection.close()