def newUser():
fname = request.form['stu-fname']
lname = request.form['stu-lname']
email = request.form['stu-email']
phone = request.form['stu-phone']
psw = request.form['stu-psw']
age = request.form['stu-age']
skills = request.form['stu-skills']
try:
user = firebase.auth().create_user_with_email_and_password(email, psw)
print("auth success")
except:
print('error with create user', email, psw)
return redirect('')
uid = user['localId']
db = firebase.database()
newData = {
"fname": fname,
"lname": lname,
"email": email,
"phone": phone,
"psw": psw,
"age": age,
"skills": skills,
"jobList": None
}
print(newData)
db.child("userdb").child(uid).set(newData)
print("created")
if 'user' not in session:
session['user'] = uid
return redirect(url_for('user_profile'))
def newCompany():
cname = request.form['cmp-cname']
email = request.form['cmp-email']
phone = request.form['cmp-phone']
psw = request.form['cmp-psw']
industry = request.form['cmp-industry']
try:
user = firebase.auth().create_user_with_email_and_password(email, psw)
except:
print('error with create user')
return redirect('')
uid = user['localId']
db = firebase.database()
newData = {
"cname": cname,
"email": email,
"phone": phone,
"psw": psw,
"industry": industry,
"jobList": None
}
db.child("companydb").child(uid).set(newData)
if 'user' not in session:
session['user'] = uid
return redirect(url_for('employer_profile'))
def discardLast():
""" Discards the last search storing its status """
last = getCurrentSearch()
if last:
new_key_name = datetime.now().strftime("%y%m%d_%H%M%S")
db.child("searchs/old/" + new_key_name).set(last)
db.child("searchs/current").delete()
def main(detect_pots, update_time):
thermal = ThermalMeasure()
stove = Stove()
pot_detector = PotDetector()
burner_on = BurnerOn()
while (True):
for burner in [
stove.upper_left, stove.lower_left, stove.lower_right,
stove.upper_right
]:
db.child("burners").child(burner.name).set(vars(burner))
image_path = capture()
with open(image_path, mode="rb") as frame:
if (detect_pots == True):
pot_detector.update(frame, stove)
thermal.update(stove)
burner_on.update(stove)
if (update_time != None):
iteration_time = args.update_time
else:
iteration_time = ITERATION_TIME
time.sleep(iteration_time)
def modificarOferta():
add_oferta = forms.AgregarOferta(request.form)
if request.method == 'POST':
db.child(add_oferta.nombre.data).update(
{'HOferta': add_oferta.oferta.data})
return render_template("gestion-oferta.html")
return render_template("modificar-oferta.html", form=add_oferta)
def actualizar(id, cantidad):
#Ingresa los datos del formulario en la variable data
cantidad1 = float(db.child(id).child("DCantidad").get().val())
cantidad2 = float(cantidad)
nuevacantidad = cantidad1 - cantidad2
#Inserta en la Base de Datos
db.child(id).update({"DCantidad": str(nuevacantidad)})
def salida(id):
productos = db.get()
add_product = forms.AgregarProducto(request.form)
#Ingresa los datos del formulario en la variable data
if request.method == 'POST':
cantidad1 = float(db.child(id).child("DCantidad").get().val())
cantidad2 = float(add_product.cantidad.data)
nuevacantidad = cantidad1 - cantidad2
data = {
'ANombre': add_product.nombre.data,
'BCodigo': add_product.codigo.data,
'CPrecio': add_product.precio.data,
'DCantidad': str(nuevacantidad),
'EDia': add_product.dia_vencimiento.data,
'FMes': add_product.mes_vencimiento.data,
'GAño': add_product.ano_vencimiento.data,
}
#Inserta en la Base de Datos
db.child(add_product.nombre.data).set(data)
return redirect(url_for('gestionProductos'))
return render_template("control-entrada.html",
form=add_product,
id=id,
db=db,
data=productos)
def tofb():
df1 = crawling()
df2 = final_dreams()
df3 = browser2()
df4 = data2
mid = pd.concat([df1, df2, df3, df4])
mid_df = mid.reset_index(drop=True)
mid_df['title'] = mid_df['title'].str.strip()
fin_df = mid_df.drop_duplicates(['title'], keep='first')
fin = fin_df.reset_index(drop=True)
postdata = fin.to_dict(orient="index")
config = {
"apiKey": "AIzaSyDIo8bt7OrCX6KYaxplvUauQdaehcjUo_0",
"authDomain": "activity-crawling.firebaseapp.com",
"databaseURL": "https://activity-crawling-default-rtdb.firebaseio.com",
"projectId": "activity-crawling",
"storageBucket": "activity-crawling.appspot.com",
"messagingSenderId": "608978503357",
"appId": "1:608978503357:web:374a269b8fa1a64888d9d4"
}
firebase = pyrebase.initialize_app(config)
db = firebase.database()
db.child().update(postdata)
def initial_info(firebase, email, salary, total_tax, take_home_monthly,
prov_code):
# replace '.' with dot, so firebase doesnt throw error
email = email.replace(".", 'dot')
db = firebase.database()
data = {
"Salary": float(salary),
"Prov_code": prov_code,
"Total_Tax": float(total_tax),
"Take_home_income": take_home_monthly,
"Expenses": {
"Rent": PrelimInfo.expenses['rent'],
"Internet": PrelimInfo.expenses['internet'],
"Phone": PrelimInfo.expenses['phone'],
"Groceries": PrelimInfo.expenses['groceries'],
"Commute": PrelimInfo.expenses['commute'],
"Utility": PrelimInfo.expenses['utility'],
"Entertainment": PrelimInfo.expenses['entertainment'],
"Hobbies": PrelimInfo.expenses['hobbies']
}
}
db.child("Users").child(email).child("Financial Profile").set(data)
return
def add_santri(key_wali):
data = request.json
uid_santri = uuid.uuid4().hex
data_santri = {
"id_santri":uid_santri,
"id_wali":key_wali,
"no_induk":data["no_induk"],
'nama_lengkap' : data['nama_lengkap'],
"jenis_kelamin" : data['jenis_kelamin'],
"alamat" : data['alamat'],
"tgl_lahir" : data['tgl_lahir'],
"url_photo" : data['url_photo'],
"email" : data['email'],
"telp" : data['telp'],
"password" : data['password'],
"rayon" : data['rayon'],
"kelas" : data['kelas'],
"kamar" : data['kamar']
}
db.child("santri").child(uid_santri).set(data_santri)
return "Behasil di add"
def agregarElemento():
add_product = forms.AgregarProducto(request.form)
if request.method == 'POST':
db.child("Compra").update(
{add_product.nombre.data: add_product.cantidad.data})
return render_template("menu-venta.html",
form=add_product,
db=db.child("Compra").get(),
dab=db)
return render_template("menu-venta.html", form=add_product)
def member_practice():
if not flask.request.is_json:
return flask.abort(400)
data = flask.request.json
discord_data = refresh_discord_token_and_get_user_data()
if not discord_data:
return forbidden()
discord_id = discord_data["id"]
discord_username = discord_data["username"]
if "avatar" in discord_data:
discord_avatar = "https://cdn.discordapp.com/avatars/{}/{}".format(
discord_id, discord_data["avatar"])
else:
discord_avatar = None
player_name = data.get("player", None)
if not player_name:
player_name = discord_username
practice_races = [
race for race in RACES if race in data.get("practiceRaces", [])
]
timezone = data.get("timezone", None)
week_time_ranges = {}
for day in DAYS_OF_THE_WEEK:
key = "timeRanges" + day
if key not in data:
week_time_ranges[key] = []
week_time_ranges[key] = [{
**({
"from": timeRange["from"]
} if "from" in timeRange else {}),
**({
"to": timeRange["to"]
} if "to" in timeRange else {}),
} for timeRange in data[key]]
update = {
"practiceRaces": practice_races,
**({
"timezone": timezone
} if timezone else {}),
"player": player_name,
**({
"avatar": discord_avatar
} if discord_avatar else {}),
**week_time_ranges,
}
db = firebase_admin.db.reference()
db.child("members").child(discord_id).child("practice").update(update)
return {}
def Get_rating(xp1content):
users = db.child("players").child(xp1content).get()
xmu = db.child("players").child(xp1content).child('mu').get()
xsigma = db.child("players").child(xp1content).child('sigma').get()
x = users.val()
sigma = xsigma.val()
mu = xmu.val()
d,y = float(mu),float(sigma)
r1 = Rating(d,y)
return r1
def basic():
if request.method == 'POST':
if request.form['submit'] == 'add':
name = request.form['name']
todo = db.child("Events Table").get()
to = todo.val()
return render_template('index.html', t=to.values())
elif request.form['submit'] == 'delete':
db.child("todo").remove()
return render_template('index.html')
return render_template('index.html')
def update_customer(db, name):
#finds the customer and returns parent and child in tuple
customer = find_customer(db, name)
changing = True
while changing == True:
change = str.replace(input("What would you like to change?: "), " ",
"_")
avalue = input("To what value?")
db.child("Customer").child(customer[0]).update({change: avalue})
if input("Anymore changes on this Customer(y/n)? ") == "Y":
changing = True
else:
changing = False
def getlen():
try:
global posts_len
company = db.child(news_names).get()
posts_len = len(company)
if posts_len >= 200:
db.child(news_names).delete()
posts_len = 0
os.remove(save_news)
f = open(save_news, "w")
f.close()
except Exception as er:
errlog(er, "글 수 가져오기 에러")
pass
def edit(id):
if request.method == "POST":
title = request.form["title"]
content = request.form["content"]
post = {"title": title, "content": content, "author": session["email"]}
#update the post
db.child("Posts").child(id).update(post)
return redirect("/post/" + id)
orderedDict = db.child("Posts").order_by_key().equal_to(id).limit_to_first(
1).get()
return render_template("edit.html", data=orderedDict)
def home():
if request.method == 'POST':
email = request.form['signInEmail']
password = request.form['signInPassword']
global client
global NICK
users = db.child("users").get()
if users.val() != "none":
for user in users.each():
userList.append(user.val())
for user in userList:
newUser = user.get("username")
newUserMail = user.get("email")
if newUserMail == email:
NICK = newUser
client = Client(NICK)
print(NICK)
try:
auth.sign_in_with_email_and_password(email, password)
# user_id = auth.get_account_info(user['idToken'])
# session['usr'] = user_id
# print(session['usr'])
return render_template("chat.html")
except:
unseccessful = "please check your e-mail or password"
return render_template("index.html", unmessage=unseccessful)
return render_template("index.html")
def add_user_to_db(firebase, email, name):
# replace '.' with dot, so firebase doesnt throw error
replace = "dot"
#email = replace.join(email.rsplit('.', 1))
email = email.replace(".", 'dot')
db = firebase.database()
data = {"Name": name, "Phone": '123-456-7890'}
# add User to the data base under 'Users'
db.child("Users").child(email).set(data)
#print("Returning from ")
return
def index():
allposts = db.child("Posts").get()
#print(allposts.val(), file=sys.stderr)
if allposts.val() == None:
#print(posts, file=sys.stderr)
return render_template("index.html")
else:
return render_template("index.html", posts=allposts)
def validarcodigo(x):
producto = db.get()
for item in producto:
if (db.child(item.key()).child("BCodigo").get()).val() == x:
x = x + 1
print(x)
return validarcodigo(x)
return x
def agregarProducto():
#Guarda los datos ingresados en el formulario
add_product = forms.AgregarProducto(request.form)
#Ingresa los datos del formulario en la variable data
if request.method == 'POST':
data = {
'ANombre': add_product.nombre.data,
'BCodigo': validarcodigo(add_product.codigo.data),
'CPrecio': add_product.precio.data,
'DCantidad': add_product.cantidad.data,
'EDia': add_product.dia_vencimiento.data,
'FMes': add_product.mes_vencimiento.data,
'GAño': add_product.ano_vencimiento.data,
}
#Inserta en la Base de Datos
db.child(add_product.nombre.data).set(data)
return render_template("agregar-producto.html", form=add_product)
return render_template("agregar-producto.html", form=add_product)
def connect_firebase_pyrebase():
# add a way to encrypt those, I'm a starter myself and don't know how
username = "******"
password = "******"
firebase = pyrebase.initialize_app(configfb)
auth = firebase.auth()
user = auth.sign_in_with_email_and_password(username, password)
#user['idToken']
# At pyrebase's git the author said the token expires every 1 hour, so it's needed to refresh it
user = auth.refresh(user['refreshToken'])
#set database
db = firebase.database()
values = db.child('SensorDataSet').get()
data = pd.DataFrame(values.val())
#print (dataX[0:6].T)
npdata = np.array(data.values).T
print(npdata.shape)
print(npdata[0:5, :])
# new_dataX = []
# for i in range(0, npdataX.shape[0] , timestep_size):
# if i+timestep_size < npdataX.shape[0]-1 :
# new_dataX.append(npdataX[i:i+timestep_size, :].flatten())
# new_dataX = np.array(new_dataX)
# # dataNum = new_dataX.shape[0]
# # new_dataY = npdataY[0:dataNum,:]
# dataNum = npdataY.shape[0]
# new_dataY = npdataY
# new_dataX = new_dataX[0:dataNum,:]
# print (new_dataX.shape)
# print (new_dataY.shape)
# raw_data = np.hstack((new_dataY, new_dataX))
# print (raw_data.shape)
# print (raw_data[0:5,:])
# trainNum = int(dataNum*train_p)
# trainX = new_dataX[0:trainNum,:]
# trainY = new_dataY[0:trainNum,:]
# testX = new_dataX[trainNum:dataNum,:]
# testY = new_dataY[trainNum:dataNum,:]
# print (trainX.shape)
# print (trainY.shape)
# print (testX.shape)
# print (testY.shape)
return npdata
def create():
if request.method == "POST":
#get the request data
title = request.form["title"]
content = request.form["content"]
post = {"title": title, "content": content, "author": session["email"]}
try:
#print(title, content, file=sys.stderr)
#push the post object to the database
db.child("Posts").push(post)
return redirect("/")
except:
return render_template("create.html",
message="Something wrong happened")
return render_template("create.html")
def add_customer(db, fname, lname, address, city, state, zip_code,
phone_number, status):
# Get last customer name
last_cust = db.child("Customer").order_by_key().limit_to_last(1).get()
last_key = last_cust.keys()
s = "%s" % last_key
new_index = "customer" + str(int(s.split("customer")[1].split("'")[0]) + 1)
#Adds a new customer
db.child("Customer").update({
new_index: {
"First_Name": fname,
"Last_Name": lname,
"Street_Address": address,
"City": city,
"State": state,
"Zip_Code": zip_code,
"Phone_Number": phone_number,
"Status": status,
}
})
def update_firebase():
print(ser.readline())
ser.flushInput()
lines = ser.readline().strip()
values = lines.decode('ascii').split(',')
if len(values) == 5:
water_level, humidity, temperature, lux, water_temp = [
float(s) for s in values
]
print(ser)
data = {
"humidity": humidity,
"temperature": temperature,
"water level": water_level,
"lux": lux,
"water temp": water_temp
}
db.child("sensor").update(data)
settings = db.child("settings").get()
for setting in settings.each():
ser.write(json.dumps(settings.val()).encode())
def signup():
if request.method == 'POST':
email = request.form['signUpEmail']
password = request.form['signUpPassword']
username = request.form['signUpUsername']
global client
global NICK
users = db.child("users").get()
if users.val() != "none":
for user in users.each():
userList.append(user.val())
unseccessful = "Username has already taken"
forgot_message = "E-mail has already taken"
for user in userList:
newUser = user.get("username")
newUserMail = user.get("email")
if newUserMail == email:
return render_template("signup.html",
forgot_message=forgot_message)
if newUser == username:
return render_template("signup.html",
unmessage=unseccessful)
NICK = username
client = Client(NICK)
print(NICK)
db.child("users").push({"email": email, "username": username})
try:
auth.create_user_with_email_and_password(email, password)
except:
unseccessful = "Make sure you enter it completely"
if username == "" or email == "" or password == "":
return render_template("signup.html", unmessage=unseccessful)
return render_template("chat.html")
return render_template("signup.html")
def getJourney(profil):
weight = 0
if (profil == "Strong"):
weight = 2000
elif (profil == "Skinny"):
weight = 500
elif (profil == "Medium"):
weight = 1000
req = flask.request.json
orders = []
for current in ORDERS.val().items():
orders.append(current)
# get best order list
order_list = defineBestCombinaison(orders, weight)
# get ordered products of current orders
products_keys = getProducts(order_list)
products_content = []
for current in products_keys:
products_content.append(
dict(db.child('products').child(current).get(0).val()))
sorted(products_content, key=itemgetter('place'))
journeys_tmp = db.child('journeys').get()
count_id = 0
for i in journeys_tmp.val().items():
count_id = count_id + 1
# create and push journey
journey = {
"orders": [item[0] for item in order_list],
"ordered_products": products_content,
"done": 0,
"id": count_id + 1
}
db.child('journeys').push(journey)
print(journey)
return jsonify(journey)
def editar(id):
productos = db.get()
add_product = forms.AgregarProducto(request.form)
#Ingresa los datos del formulario en la variable data
if request.method == 'POST':
data = {
'ANombre': add_product.nombre.data,
'BCodigo': validarcodigo(add_product.codigo.data),
'CPrecio': add_product.precio.data,
'DCantidad': add_product.cantidad.data,
'EDia': add_product.dia_vencimiento.data,
'FMes': add_product.mes_vencimiento.data,
'GAño': add_product.ano_vencimiento.data,
}
#Inserta en la Base de Datos
db.child(add_product.nombre.data).set(data)
return redirect(url_for('gestionProductos'))
return render_template("editar-producto.html",
form=add_product,
id=id,
db=db,
data=productos)
def newListing():
title = request.form['jl-title']
totalHours = request.form['jl-totalHours']
wage = request.form['jl-wage']
startDate = request.form['jl-startDate']
shift = request.form['jl-shifts']
description = request.form['jl-description']
companyId = session['user']
db = firebase.database()
newData = {
"companyId": companyId,
"title": title,
"wage": wage,
"totalHours": totalHours,
"startDate": startDate,
"shift": shift,
"description": description,
"taken": 0
}
newId = db.child("jobsdb").push(newData)
db.child("companydb").child(companyId).child('jobList').push(newId)
return redirect(url_for('employer_profile'))
