def get_all_categories():
# Open a connection to the database
with sqlite3.connect("./rare.db") as conn:
# Just use these. It's a Black Box.
conn.row_factory = sqlite3.Row
db_cursor = conn.cursor()
# Write the SQL query to get the information you want
db_cursor.execute("""
SELECT
c.id,
c.label
FROM categories c
""")
# Initialize an empty list to hold all animal representations
categories = []
# Convert rows of data into a Python list
dataset = db_cursor.fetchall()
# Iterate list of data returned from database
for row in dataset:
category = Categories(row['id'], row['label'])
categories.append(category.__dict__)
# Use `json` package to properly serialize list as JSON
return json.dumps(categories)
def setUp(self):
"""Defining setUp() method that runs prior to each test."""
self.newCat = Categories()
self.newCat.category_register("category", "*****@*****.**")
self.newCat.category_edit("category", "category_one",
"*****@*****.**")
app.config['TESTING'] = True
self.test_app = app.test_client()
def setUp(self):
"""Defining setUp() method that runs prior to each test."""
self.newRecipe = Recipe()
self.newCategory = Categories()
self.recipe_register = self.newRecipe.recipe_register(
"category", "recipe", "*****@*****.**", "recipe_ingredients",
"recipe_methods")
self.newCategory.category_register("category_one", "*****@*****.**")
app.config['TESTING'] = True
self.test_app = app.test_client()
def __init__(self):
self.connection_manager = ConnectionManager()
self.database = Database()
self.records = Records()
self.categories = Categories()
self.products = Products()
self.substitutes = Substitutes()
self.abandon = Abandon()
self.menu = Menu()
self.register = Register()
self.research = Research()
self.tests = Tests()
self.initialize_database()
def post(self):
if self.user:
name = self.request.get('category_name')
feature = self.request.get("c_feature")
if name:
c = Categories(parent = categories_key(),
name = name,
user = self.user)
if (feature and feature == 'true'):
c.feature = True
c.put()
self.redirect('/main')
else:
self.render('errorpage.html', error = "No Category Given")
else:
self.redirect('/login')
def add_expense(raw_message: str) -> Expense:
parsed_message = _parse_message(raw_message)
category = Categories().get_category(parsed_message.category_text)
with connect() as conn, conn.cursor() as cur:
cur.execute(
"""
INSERT INTO expense(amount, created, category_codename, raw_text)
VALUES (%s, NOW(), %s, %s)
""",
(
parsed_message.amount,
category.codename,
parsed_message.category_text,
),
)
return Expense(
id=None, amount=parsed_message.amount, category_name=category.name
)
def post(self, project_id):
if not self.user:
self.redirect('/login')
key = ndb.Key('Projects', int(project_id), parent=post_key())
p = key.get()
title = self.request.get("title")
link = self.request.get("link")
description = self.request.get("description")
programming_language = self.request.get("programming_language")
category = self.request.get("name_category")
add_category = self.request.get("add_category")
feature = self.request.get("p_feature")
error = "NEEDS A TITLE!"
if (p and p.user.name == self.user.name):
if (title):
p.title = title
if (link):
p.link = link
else:
p.link = '[None]'
if (description):
p.description = description
else:
p.description = '[None]'
if (programming_language):
p.programming_language = programming_language
if (category):
p.category_name = category
if (add_category):
c = Categories(name=add_category, user=self.user)
c.put()
if (feature and feature == "true"):
p.feature = True
else:
p.feature = False
p.put()
self.redirect('/main')
else:
self.render('editproject.html', project=p, error=error)
else:
self.redirect('/login')
def create_category(self):
if web.ctx.method == "GET":
category_list = Categories.select().where(Categories.status == 0)
self.private_data["category_list"] = category_list
return self.display("admin/create_category")
else:
inputs = self.get_input()
name = inputs.get('name')
desc = inputs.get('desc')
parent_id = inputs.get("parent_id")
try:
category = Categories(name=name,
description=desc,
parent_id=parent_id)
category.save()
self.private_data["create_success"] = True
return web.seeother(self.make_url('category_list'))
except Exception as e:
log.error('create category failed %s' % traceback.format_exc())
log.error('input params %s' % inputs)
self.private_data["create_success"] = False
return self.display("admin/create_category")
def post(self):
title = self.request.get("title")
link = self.request.get("link")
description = self.request.get("description")
programming_language = self.request.get("programming_language")
category = self.request.get("name_category")
add_category = self.request.get("add_category")
feature = self.request.get("p_feature")
error = "Need Title, Link, and Description!"
if self.user:
if (title):
p = Projects(parent=post_key(),
title=title,
link='[None]',
description='[None]',
user=self.user)
if (link):
p.link = link
if (description):
p.description = description
if (programming_language):
p.programming_language = programming_language
if (category):
p.category_name = category
if (add_category):
c = Categories(name=add_category, user=self.user)
c.put()
if (feature and feature == "true"):
p.feature = True
else:
p.feature = False
p.put()
self.redirect('/main')
else:
self.redirect('/main')
else:
self.redirect('/login')
'instruction': i[4],
'time_id': i[5],
'history': i[6],
'advice': i[7]
})
session3.add(record)
data3 = Load_Data_3("csv/1time.csv")
for i in data3:
record = Time(**{'id': i[0], 'minutes': i[1]})
session3.add(record)
data4 = Load_Data_1("csv/1categories.csv")
for i in data4:
record = Categories(**{'id': i[0], 'category_name': i[1]})
session3.add(record)
data5 = Load_Data_1("csv/1cuisine.csv")
for i in data5:
record = Cuisine(**{'id': i[0], 'cuisine_name': i[1]})
session3.add(record)
data6 = Load_Data_1("csv/1menu.csv")
for i in data6:
record = Menu(**{'id': i[0], 'menu_name': i[1]})
session3.add(record)
data7 = Load_Data_3("csv/1recipe_has_ingredients.csv")
for i in data7:
record = Recipe_has_ingredients(**{
"""The vierws.py file deals with the logic used by the classes"""
import os
from flask import render_template, request, session, g, Flask
from models.user import Users
from models.recipe import Recipe
from models.categories import Categories
app = Flask(__name__)
from app import app
app.secret_key = os.urandom(24) # needed to keep the client sessions secure
new_user = Users() # instance of class Users
new_cat = Categories() # instance of class Category
new_recipe = Recipe() # instance of class Recipe
@app.route('/')
def index():
""" Redirects to the index page """
return render_template('index.html')
@app.route('/register', methods=['GET', 'POST'])
def register():
"""Handles the view for user registration, it then fetches
the return messages in the register methods and returns appropriate
messages to the user through the templates"""
if request.method == "POST":
# gets the email, password, password and confirm password from the
# registration.html template
