def importProductsFromBD():
dbUtils = DbUtils()
productsBD = dbUtils.selectProducts()
#while(product):
for product in productsBD:
products.append(Product(product[0],product[1],product[2],product[3],product[4]))
print(product)
print(products)
return 0
def addhistorical():
if not request.json:
abort(400)
distanceData = json.dumps(request.json)
distanceObject = json.loads(distanceData, object_hook=JSONObject)
dbUtils = DbUtils()
dbUtils.addDistance(distanceObject.length, distanceObject.width)
def getbounds():
# Init my variables that i am going to be using
dbUtils = DbUtils()
top = ""
right = ""
bottom = ""
left = ""
edges = []
# Get my bounds from the server
boundData = dbUtils.getBounds()
# parse my boundData and set each row to a longitute and latitude in a list of dictionaries.
for r in boundData:
# get longitude out
tempStrings = str(r).split()
tempStrings[0] = tempStrings[0][8:]
# get latitude out
index = tempStrings[1].find(")")
tempStrings[1] = tempStrings[1][0:index]
# add that to a dictionary
a = {"lon": tempStrings[0], "lat": tempStrings[1]}
# add the dictionary to a list
edges.append(a)
# Check the latitudes for a top and bottom
if float(edges[0]["lat"]) > float(edges[1]["lat"]):
top = edges[0]["lat"]
bottom = edges[1]["lat"]
else:
top = edges[1]["lat"]
bottom = edges[0]["lat"]
# Check longitude for a left and right
if float(edges[0]["lon"]) < float(edges[1]["lon"]):
left = edges[0]["lon"]
right = edges[1]["lon"]
else:
right = edges[0]["lon"]
left = edges[1]["lon"]
# Create my json dictionary
bounds = {"top": top, "bottom": bottom, "left": left, "right": right}
# return the json to the user
return jsonify(bounds)
def getimg(img_name):
from DbUtils import DbUtils
img = []
dbUtils = DbUtils()
imgData = dbUtils.getPNG(img_name)
# Parse the info and return it
for r in imgData:
a = {
"img_name": r[0],
"img": r[1],
"img_size": r[2],
"bot_left_corner": r[3],
"rotation": r[4],
}
img.append(a)
return jsonify(img)
def addimg():
if not request.json:
abort(400)
imgData = json.dumps(request.json)
imgObject = json.loads(imgData, object_hook=JSONObject)
dbUtils = DbUtils()
dbUtils.addNewPNG(
imgObject.img_name,
list(imgObject.img),
imgObject.img_size,
imgObject.corner,
imgObject.img_rotation,
)
return jsonify({"Result": "Inserted"}), 201
def logar():
print(request.form)
print(request.form['password'])
print(request.form['email'])
password = request.form['password']
email = request.form['email']
dbUtils = DbUtils()
res = dbUtils.selectUsers(email,password)
if(res):
print(res)
userReturn = None
for user in res:
userReturn = user
print(user)
if(userReturn == None):
return "<h1>Usuário ou senha incorretos</h1>"
else:
return "<h1>Erro ao logar</h1>"
return "<h1> Bem vindo " + userReturn[1] + "</h1>"
def exportProductstoBD():
products.append(Product(0,"IphoneX","5999.99","IphoneX text","iphoneX.jpg"))
products.append(Product(1,"Galaxy S10+","3999.99","Galaxy S10+ text","Galaxy_S10+.jpg"))
products.append(Product(2,"Huawei P30 Pro","3500.00","Huawei P30 Pro Text","Huawei_P30.jpg"))
products.append(Product(3,"Moto G8 Plus","1999.99","Moto G8 text","MotoG8.jpg"))
products.append(Product(4,"Xiaomi Mi9", "2299.99", "Xiaomi Mi9", "XiaomiMi9.jpg"))
products.append(Product(5,"Alcatel Pixi 4","186.90","Alcatel Pixi 4 text","AlcatelPixi4.jpg"))
dbUtils = DbUtils()
dbUtils.createTableProducts() #Table products
for product in products:
dbUtils.addNewProduct(product.name, product.price, product.text, product.urlImage)
def cadastrar():
#global users
print(request.form)
#user_data = request.get_json(force=True)
#print(user_data)
print(request.form['name'])
print(request.form['password'])
print(request.form['email'])
newUser = User(request.form['name'],request.form['password'],request.form['email'])
users.append(newUser)
dbUtils = DbUtils()
dbUtils.createTableUsers()
#for user in users:
dbUtils.addNewUser(newUser.name, newUser.password, newUser.email)
return "<h1>CADASTRADO</h1>"
from DbUtils import DbUtils
import re
import sys
db = DbUtils()
tweets = db.fetchall(sys.argv[3], ("text", ), sort="id DESC")
tweets = [re.sub(r'http(s?).* ?', '', x[0]).strip().lower() for x in tweets]
tweets = list(set(tweets))
with open("resources/stopwords.txt", "rb") as f:
stopwords = f.read().splitlines()
with open("resources/" + sys.argv[2], "w") as f:
f.write("i,j,x\r\n")
for i in range(len(tweets)):
for j in range(len(words)):
cont = tweets[i].count(words[j])
if cont > 0:
f.write(
str(i + 1) + "," + str(j + 1) + "," + str(cont) + "\r\n")
parser.add_argument('-result-type', dest="result_type", default="mixed", help="Result type")
parser.add_argument('-max-id', dest="max_id", default=None, help="Maximum Id from which to start searching")
parser.add_argument('-until', dest="until", default=None, help="Last date")
parser.add_argument('-lang', dest="lang", default=None, help="Language")
parser.add_argument('-table', dest="table", default="tweets", help="DB Table")
args = parser.parse_args()
q = args.q
n = args.n
result_type = args.result_type
max_id = args.max_id
until = args.until
lang = args.lang
table = args.table
twitter = TwitterUtils()
db = DbUtils()
next_results = {"q": q, "count": 100}
if result_type is not None:
next_results["result_type"] = result_type
if max_id is not None:
next_results["max_id"] = max_id
if until is not None:
next_results["until"] = until
if lang is not None:
next_results["lang"] = lang
db.cursor = db.conn.cursor()
try:
for i in range(0, n):
print("Request: %d" % (i+1,))
result = twitter.search(**next_results)
from DbUtils import DbUtils
import re
import sys
db = DbUtils()
tweets = db.fetchall(sys.argv[3], ("text",), sort="id DESC")
tweets = [re.sub(r'http(s?).* ?', '', x[0]).strip().lower() for x in tweets]
tweets = list(set(tweets))
with open("resources/stopwords.txt","rb") as f:
stopwords = f.read().splitlines()
with open("resources/" + sys.argv[2], "w") as f:
f.write("i,j,x\r\n")
for i in range(len(tweets)):
for j in range(len(words)):
cont = tweets[i].count(words[j])
if cont > 0:
f.write(str(i+1) + "," + str(j+1) + "," + str(cont) + "\r\n")
default=None,
help="Maximum Id from which to start searching")
parser.add_argument('-until', dest="until", default=None, help="Last date")
parser.add_argument('-lang', dest="lang", default=None, help="Language")
parser.add_argument('-table', dest="table", default="tweets", help="DB Table")
args = parser.parse_args()
q = args.q
n = args.n
result_type = args.result_type
max_id = args.max_id
until = args.until
lang = args.lang
table = args.table
twitter = TwitterUtils()
db = DbUtils()
next_results = {"q": q, "count": 100}
if result_type is not None:
next_results["result_type"] = result_type
if max_id is not None:
next_results["max_id"] = max_id
if until is not None:
next_results["until"] = until
if lang is not None:
next_results["lang"] = lang
db.cursor = db.conn.cursor()
try:
for i in range(0, n):
print("Request: %d" % (i + 1, ))
result = twitter.search(**next_results)
