Exemple #1
0
import os
from flask import Flask
from flask_pymongo import pymongo

client = pymongo.MongoClient(os.environ["MONGO_CLIENT"])
db = client.get_database('flask_mongodb_atlas')
Exemple #2
0
from flask import Flask, render_template, redirect
from flask_pymongo import pymongo
import news_scrap

app = Flask(__name__)

# Use flask_pymongo to set up mongo connection
#app.config["MONGO_URI"] = "mongodb://*****:*****@ds141613.mlab.com:41613/project_housing_price"
# connection = MongoClient(url)
# db = connection['Housing_project']

connection = pymongo.MongoClient('ds141613.mlab.com', 41613)
db = connection['project_housing_price']
db.authenticate('test2', 'test123')


@app.route("/")
def index():
    news_scrap = db.Housing_project.find_one()
    return render_template("index.html", news_scrap=news_scrap)
    # try:
    #     Housing_project = db.Housing_project.find_one()
    #     return render_template("index.html", Housing_project=Housing_project)
    # except:
    #     return redirect("/", code=302)


@app.route("/scrap")
Exemple #3
0
from flask import Flask, render_template, request, json, redirect, jsonify, session
from flask_pymongo import pymongo
from bson import json_util
import database.queries as queries
import os
import bcrypt

app = Flask(__name__)
client = pymongo.MongoClient(
    "mongodb://*****:*****@45.55.198.145/interceptDB")
db = client.interceptDB
'''Load organizations that are relevant based on survey results'''


@app.route('/showSurveyResults')
def show_survey_results():
    surveyID = request.args.get('id', default='*', type=str)
    orgs = queries.find_orgs_by_matching_tags(surveyID)
    relevant_orgs = queries.find_orgs_with_one_service(orgs, surveyID)
    return json_util.dumps(relevant_orgs, default=json_util.default)


'''Updates the user password'''


@app.route('/password', methods=['POST'])
def create_password():
    surveyID = request.args.get('id', default='*', type=str)
    password = request.args.get('password', default='*', type=str)
    enc_pass = password.encode('utf-8')
    queries.update_password_by_id(surveyID,
from googleplaces import GooglePlaces, ranking, types, lang
import requests
import json

from flask_pymongo import pymongo

client = pymongo.MongoClient(
    "mongodb+srv://aliu:[email protected]/test?retryWrites=true&w=majority"
)
db = client.inline

# Use your own API key for making api request calls
API_KEY = 'AIzaSyBHGtFlzUzLX4251KTO3IBfen2no0Jllic'
# Initialising the GooglePlaces constructor
google_places = GooglePlaces(API_KEY)

# coordinates = {'lat': 36.4089, 'lng': -78.3178}
testLat = 33.25289
testLng = 56.8178
# start at 10000, then increment by like 1000 until you get some hospitals
searchRadius = 50000
# searchRadius = 50000

# efficiency can be improved
# To make this more efficient: cache the data points
hospitals = db.HospitalCost.find()
hospitalNames = []
for hospital in hospitals:
    hospitalNames.append(hospital['HospitalName'].lower())
# print(hospitals)
# print(hospitalNames)
Exemple #5
0
import os
import ssl
from flask import Flask, render_template, request, redirect
from flask_pymongo import pymongo
from gen_slug import base62_slug
from dotenv import load_dotenv
load_dotenv()

app = Flask(__name__, template_folder='templates', static_folder='static')

client = pymongo.MongoClient(
    f"mongodb://{os.getenv('MONGO_DB_USER')}:{os.getenv('MONGO_DB_PASSWORD')}@"
    f"{os.getenv('CLUSTER_NAME')}.mongodb.net/urls-redirects?retryWrites=true&w=majority",
    ssl_cert_reqs=ssl.CERT_NONE)

db = client["urls-redirects"]


@app.route('/', methods=['GET', 'POST'])
def index():
    if request.method == 'POST':
        url = request.form['init-url']

        counter_db = client["counter"]["counter"]
        counter_num = counter_db.find_one()["counter"]

        slug = base62_slug(counter_num)

        counter_db.update_one({"counter": counter_num},
                              {"$set": {
                                  "counter": counter_num + 1
Exemple #6
0
from flask import Flask, render_template, jsonify, redirect
from flask_pymongo import pymongo
import scrape_mars

app = Flask(__name__)

# setup mongo connection
conn = "mongodb://*****:*****@app.route("/")
def index():
    mars_data_values = list(db.collection.find())
    #mars_data_values = mars_data_values[0]
    return render_template("index.html", mars_data_values=mars_data_values)


@app.route("/scrape")
def scraper():
    mars_dict = scrape_mars.scrape()
    #db.mars_data.update({}, mars_dict, upsert=True)
    db.collection.delete_many({})
Exemple #7
0
from flask import Flask, redirect, url_for
from flask_pymongo import pymongo
from bson.json_util import dumps
from bson.objectid import ObjectId
from flask import jsonify, request, make_response
from flask import render_template
import os
import queryInterpreter
app = Flask(__name__)

client = pymongo.MongoClient(
    "mongodb+srv://dbUser242:[email protected]/myFirstDatabase?retryWrites=true&w=majority"
)
db = client.get_database('goodreads')
user_collection = pymongo.collection.Collection(db, 'goodreads_info')


@app.route('/book', methods=['POST'])
def post_book():
    _json = request.json
    _title = _json['title']
    _book_url = _json['book_url']
    _author_url = _json['author_url']
    _author = _json['author']
    _rating = _json['rating']
    _rating_count = _json['rating_count']
    _review_count = _json['review_count']
    _image_url = _json['image_url']

    if _title and _book_url and _author_url and _author and _rating and _rating_count and _review_count and _image_url and request.method == 'POST':
        id = db.goodreads_info.insert_one({
Exemple #8
0
from flask import Flask, render_template, request, redirect
from config import Config as SETTING
from flask_pymongo import pymongo
# import sqlite3

app = Flask(__name__)

# database Settings
myclient = pymongo.MongoClient(SETTING.MONGO_LINK)
EmergencySaveDatabase = myclient[SETTING.DATABASE_NAME]
EmergencySaveCollection = EmergencySaveDatabase[SETTING.DATABASE_COLLECTION]


@app.route('/')
def index():
    return render_template('index.html')


@app.route('/detect', methods=['GET'])
def detect():
    if request.method == 'GET':
        endport = request.args.get("endport")
        return redirect(endport)


@app.route('/<string:PersonalPage>', methods=['GET', 'POST'])
def PersonalPage(PersonalPage):
    if request.method == 'GET':
        # check that page is available or not
        userCheck = EmergencySaveCollection.count_documents(
            {"endport": PersonalPage})
Exemple #9
0
from flask_pymongo import pymongo
from flask import Flask
import urllib.parse

# database
client = pymongo.MongoClient(
    "mongodb+srv://xoro:" + urllib.parse.quote("p@ssvv0rd") +
    "@cluster0.rphug.mongodb.net/Portfolio?retryWrites=true&w=majority")
db = pymongo.database.Database(client, 'Twittrer')
col = pymongo.collection.Collection(db, 'users')
 def initialize():
     client = pymongo.MongoClient(Database.URI)
     Database.DATABASE = client[conf.database_name]
Exemple #11
0
from bson.json_util import dumps #To get final Data Store

#---------------------------------------------------------------------------------------------------

#---------------------------------------------------------------------------------------------------
# MAIN VARIABLES
# These are the main variables that will be used throughout the program
# These first two are for sessions
SESSION_PRE = "data_"
SESSION_POST = "_store"
app = Flask(__name__) # To initialise the app
app.secret_key = '?A7_`a?^k=9+1k6Z@XX0vFpDasd"pQ' # Secret key provides security for sessions
CONNECTION_STRING = "mongodb+srv://charles:[email protected]/test_crd?retryWrites=true&w=majority" #Connect to Mongo DB
#CONNECTION_STRING = "mongodb://localhost:27018/test_crd" #Localhost connection string
#---------------------------------------------------------------------------------------------------
client = pymongo.MongoClient(CONNECTION_STRING) # Connect to Mongo DB

db = client['test_crd']['crd']
user_db = client['user_info']['users']

#---------------------------------------------------------------------------------------------------
# USER FUNCTIONS
# This section contains functions declared for use in the application
def validate_user(username):
    '''
        Function to return string with username for session
    '''
    return SESSION_PRE + str(username) + SESSION_POST

def db_size():
    '''
Exemple #12
0
# import necessary libraries
from flask import Flask, render_template, redirect
from flask_pymongo import pymongo
import scrape_mars

# create instance of Flask app
app = Flask(__name__)

# Create connection to Mongo
client = pymongo.MongoClient()
db = client.mars_db
collection = db.mars_data


# create route that renders index.html template and finds documents from mongo
@app.route("/")
def home():

    # Find data
    martian = list(db.collection.find())
    print(martian)

    # return template and data
    return render_template("index.html", martian=martian)


# Route that will trigger scrape functions
@app.route("/scrape")
def scrape():
    # db.collection.remove({})
    martian = scrape_mars.scrape()
from flask import Flask, render_template, redirect
import requests
from flask_pymongo import pymongo
import csv

app = Flask(__name__)

client = pymongo.MongoClient(
    "mongodb+srv://project_staff:[email protected]/test?retryWrites=true&w=majority"
)
db = client.test

db.tech_stocks.drop()

with open('All_Stocks.csv') as csv_file:
    data = csv.reader(csv_file, delimiter=',')
    for row in data:
        stocks = {
            "Stock Exchange": row[0],
            "Stock": row[1],
            "Stock Ticker": row[2],
            "Date": row[3],
            "Open": row[4],
            "High": row[5],
            "Low": row[6],
            "Close": row[7],
            "Adj Close": row[8],
            "Volume": row[9]
        }
        db.tech_stocks.insert_one(stocks)
Exemple #14
0
#################################################
# MongoDB and Flask Application
#################################################

from flask import Flask, render_template, redirect
from flask_pymongo import pymongo
from pymongo import MongoClient
import time
import scrape_mars

client = pymongo.MongoClient('mongodb://localhost:27017')
db = client.mars_db
collection = db.mars

#################################################
# Flask Setup
#################################################

app = Flask(__name__)

#################################################
# Use flask_pymongo to set up mongo connection
#################################################

# mongo = pymongo(app, uri="mongodb://loalhost:27017/mars_app")
# app.config["MONGO_URI"] = "mongodb://localhost:27017/mars_app"
# mongo = pymongo(app)


#################################################
# Flask Routes
Exemple #15
0
from flask_pymongo import pymongo
import os
from dotenv import load_dotenv
load_dotenv(override=True)
USER = os.getenv('DB_USER')
PASSWORD = os.getenv('DB_PASSWORD')
HOST = os.getenv('DB_HOST')
NAME = os.getenv('DB_NAME')
client = pymongo.MongoClient(
    f'mongodb+srv://{USER}:{PASSWORD}@{HOST}.mongodb.net/{NAME}?retryWrites=true'
)
c_users = client.users
Exemple #16
0
from flask_pymongo import pymongo
import os

DB_USER = os.getenv("DB_USER")
DB_PASSWORD = os.getenv("DB_PASSWORD")
DB_NAME = os.getenv("DB_NAME")

client = pymongo.MongoClient(
    f"mongodb+srv://{DB_USER}:{DB_PASSWORD}@db-test.p6fmb.mongodb.net/{DB_NAME}?retryWrites=true&w=majority"
)
db = client.chihuahua
from flask import Flask, render_template
from flask_bootstrap import Bootstrap
from flask_mail import Mail
from flask_moment import Moment
from flask_pymongo import pymongo, MongoClient
from config import config
from flask_login import LoginManager, UserMixin
from flask_caching import Cache
from .models import User

client = pymongo.MongoClient(
    "mongodb+srv://twre:[email protected]/test?retryWrites=true&w=majority"
)
mongo = client.twredb

login_manager = LoginManager()
login_manager.session_protection = 'strong'
login_manager.login_view = 'auth.login'


@login_manager.user_loader
def load_user(user_id):
    users = mongo.db.Users
    user_json = users.find_one({'_id': 'Int32(user_id)'})
    return User(user_json)


bootstrap = Bootstrap()
mail = Mail()
moment = Moment()
cache = Cache(config={'CACHE_TYPE': 'simple'})
Exemple #18
0
import os
from dotenv import load_dotenv
from datetime import datetime
from flask_bcrypt import Bcrypt
from flask_jwt_extended import JWTManager
from flask_jwt_extended import create_access_token
import json

app = Flask(__name__)

load_dotenv()
bcrypt = Bcrypt(app)
app.secret_key = os.getenv("SESSION_KEY")
jwt = JWTManager(app)

client = pymongo.MongoClient(os.getenv("MONGO_CONNECTION"))
db = client.get_database('grocery')
users_Collection = pymongo.collection.Collection(db, 'users')


@app.route('/')
def index():
    return app.send_static_file('index.html')


@app.route('/signup', methods=['POST'])
def signup():
    firstName = request.get_json()['firstName']
    lastName = request.get_json()['lastName']
    email = request.get_json()['email']
    password = bcrypt.generate_password_hash(
Exemple #19
0
from flask import Flask, request, render_template
import json
from flask_pymongo import PyMongo, pymongo
from pymongo import MongoClient
import datetime
import matplotlib.pyplot as plt
import networkx as nx

pp = Flask(__name__)
#db connection
mongo = pymongo.MongoClient(
    "mongodb+srv://iimt:[email protected]/iimtnewsdb?retryWrites=true&w=majority"
)  #connect mongodb
db = mongo.iimtnewsdb  #iimtnewsdb is my database
col = db.cluster  #Here cluster is my collection

nc = col.find_one({"cluster_type": "all"})
#nc = col.find_one({"cluster_type":"month","date":"2021-03-01"})
#nc = col.find_one({"cluster_type":"month","date":"2021-02-01"})
#nc = col.find_one({"cluster_type":"day","date":"2014-03-11"})
G = nx.Graph()
number_of_cluster = nc["total_number_of_clusters"]
color_map = []
size_map = []

#add node
for i in range(number_of_cluster):
    if nc["clusters"][i][
            "total_number_of_articles"] > 20:  #not show cluster with little articles
        G.add_node("Cluster" + str(i + 1))
        color_map.append('red')
Exemple #20
0
 def initialize():
     client = pymongo.MongoClient(Database.URI)
     Database.DATABASE = client['beta_test_01']
Exemple #21
0
from flask import Flask
from flask_pymongo import pymongo
import app

CONNECTION_STRING = "mongodb+srv://SaumyaDB:[email protected]/<dbname>?retryWrites=true&w=majority"

client = pymongo.MongoClient(CONNECTION_STRING)
db = client.get_database('flask_mongodb_atlas')
user_collection = pymongo.collection.Collection(db, 'user_collection')
Exemple #22
0
    def default(self, o):
        if isinstance(o, ObjectId):
            return str(o)
        return json.JSONEncoder.default(self, o)

#################################################
# Flask Setup
#################################################
app = Flask(__name__)


# Mongo DB configuration
mg_usr = config('mg_usr')
mg_pwd = config('mg_pwd')

client = pymongo.MongoClient(f"mongodb+srv://{mg_usr}:{mg_pwd}@cluster0-xcn4s.mongodb.net/test?retryWrites=true&w=majority")
db = client['albums_db']
collection = db['album_collection']


#################################################
# Flask Routes
#################################################


@app.route("/",methods=['GET', 'POST'])
def welcome():
    return render_template("index.html")

# Source for song information
@app.route("/song/<song_id>")