def create_db_and_tables():
isSucc = create_db.create_db()
if (isSucc):
create_table.create_table()
"-r",
"requirements.txt"]).wait()
if not isfile("config.py"):
Popen(["cp",
"config.py.example",
"config.py"]).wait()
__file__ = join(".env", "bin", "activate_this.py")
with open(join(".env", "bin", "activate_this.py"), "r") as f:
exec(f.read())
import bcrypt
if not isfile("db/Issues.db"):
create_db()
Popen(["mv",
"Issues.db",
"db/Issues.db"]).wait()
print("")
print("Crie um usuário administrador")
print("Usuário:")
usuario = input()
print("Senha:")
senha = getpass("")
print("E-mail:")
email = input()
print("Nome:")
nome = input()
def wrapper(function):
if function == "download":
from ftp import download_files
download_files.download_files(config.start_year, config.end_year,
config.cwd)
elif function == "extract":
from ftp import extract_files
extract_files.extract_files(config.start_year, config.end_year,
config.cwd)
elif function == "createdb":
from db import create_db
create_db.create_db(config.start_year, config.end_year, config.cwd,
config.db_name, config.db_user, config.db_password,
config.db_host, config.db_port)
elif function == "populatedb":
conn_settings = {
'db_password': config.db_password,
'db_user': config.db_user,
'db_host': config.db_host,
'db_port': config.db_port,
'db_name': config.db_name,
'start_year': config.start_year,
'end_year': config.end_year
}
from db.connect import Connection
connections = Connection(conn_settings)
from db import populate_database
threads = {}
for year in range(config.start_year, config.end_year, 2):
threads[year] = populate_database.threadedPopulate(
year, year, config.cwd, connections)
for thread in sorted(threads):
print "Starting: %s population" % threads[thread].name
threads[thread].start()
time.sleep(1)
while True:
for thread in sorted(threads):
if all(None == x for x in threads.values()):
print "Complete"
return
elif threads[thread] == None:
continue
elif threads[thread].complete:
print "Thread: %s is complete" % threads[thread].name
threads[thread].join()
print "Thread: %s is joined" % threads[thread].name
threads[thread] = None
else:
time.sleep(1)
continue
elif function == "createuser":
print "Will now create new user in PostgresSQL"
print "At the prompt, enter the password for the new user, as set in config.py"
os.system("""createuser --createdb --encrypted --pwprompt --no-superuser --no-createrole --host=%s --port=%s --username=postgres --password %s""" % \
(config.db_host, config.db_port, config.db_user))
elif function == "creategeo":
from geo import geodatadb
print "Creating zipcode database and dumping json to database"
geodatadb.gengeodb(config.cwd, config.db_name, config.db_user,
config.db_password, config.db_host, config.db_port)
elif function == "clean_uninstall":
pass
else:
print "Invalid function: %s" % function
from flask import render_template
from build_user_matrix import get_user_data
from db.create_db import create_db
from db.table_config import DATA_FILE_PATHS, TABLE_DESC
from user_recommender import build_recommender
app = connexion.App(__name__, specification_dir="./")
app.add_api("swagger.yml")
db_conn = sqlite3.connect('db/ps.sqlite')
users = get_user_data(db_conn)
build_recommender(users)
@app.route("/")
def home():
return render_template("home.html")
if __name__ == '__main__':
db_conn = create_db('db/ps.sqlite',
file_paths=DATA_FILE_PATHS,
table_desc=TABLE_DESC)
users = get_user_data(db_conn)
build_recommender(users)
port = int(os.environ.get('PORT', 5000))
app.run(host='0.0.0.0', port=port, debug=True)
from flask import Flask from db import create_db create_db.create_db() app = Flask(__name__) from fastfood.views import orders, auth, api app.register_blueprint(api, url_prefix='/api/v1')