def home(cid = None, item_id = None):
#Check input: Category ID
if cid == None:
category_id = Category.get_root().id
else:
category_id = cid
#Get one that is specified
categories = [] + [Category.get_by_id(category_id)]
#Get children
if len(categories) == 1:
children = Category.get_children(category_id, count_items = True)
if len(children) == 0: #If no children, then get parent of it
parent_id = categories[0].parent
categories = [] + [Category.get_by_id(parent_id)]
#get children of the parent
children = Category.get_children(parent_id, count_items = True)
if len(children) > 0:
categories += children
categories[0].parent_flag = True
#Assign selected_flag
for c in categories:
if c.id == int(category_id):
c.selected_flag = True
else:
c.selected_flag = False
#Get item or items
item = None
items = []
if item_id == None:
items = Item.get_by_category(category_id)
else:
item = Item.get_by_id(item_id)
if isinstance(item, Item) and item.category_id != category_id:
item = None
return render_template('home.html', title = 'Catalog Excercise',\
categories = categories,\
items = items,\
item = item
)
def catalogXML():
"""
####Returns####
+ genres: XML object of all genres and books
"""
root = ET.Element('genres')
return app.response_class(
ET.tostring(
Category.getCatalogXML(session, root),
encoding='us-ascii',
method='xml'),
mimetype='application/xml')
def categoryXML(category_id):
"""
####Args####
+ category_id: the id of the category of the book
####Returns####
+ genre: XML object of the genre
"""
category = session.query(Category).filter_by(id=category_id).one()
root = ET.Element('genre')
return app.response_class(
ET.tostring(
Category.getCategoryXML(session, category.id, root),
encoding='us-ascii',
method='xml'),
mimetype='application/xml')
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Category, Item, User
engine = create_engine('sqlite:///itemcatalogwithusers.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
User1 = User(name='Default', email='Default')
session.add(User1)
session.commit()
category1 = Category(name='Soccer')
session.add(category1)
session.commit()
item1 = Item(name='Soccer Cleats', category=category1, user_id=1)
session.add(item1)
session.commit()
item2 = Item(name='Jersey', category=category1, user_id=1)
session.add(item2)
session.commit()
item3 = Item(name='Shin Guards', category=category1, user_id=1)
session.add(item3)
session.commit()
category2 = Category(name='Baseball')
'Snowboard':'Boards where both feet are secured to the same board and are wider than skis,',
'Boots':'Snowboard boots are mostly considered soft boots, though alpine snowboarding uses a harder boot similar to a ski boot.',
'Bindings':'Bindings are separate components from the snowboard deck and are very important parts of the total snowboard interface.'
}
#Hockey Items
# Retreived from: https://en.wikipedia.org/wiki/Ice_hockey_equipment
hockey_items = {
'Helmet':'A helmet with strap, and optionally a face cage or visor, is required of all ice hockey players.',
'Neck guard':'For "skaters", a neck guard typically consists of a series of nylon or ABS plates for puncture resistance.',
'Shoulder pads':'Hockey shoulder pads are typically composed of a passed vest with front and back panels.'
}
#Adding Categories and items to DB
for cat in categories:
category_name = Category(name=cat)
session.add(category_name)
session.commit()
if cat == "Soccer":
for soccerItem in soccer_items:
item = Items(name=soccerItem, description=soccer_items[soccerItem], category = category_name)
session.add(item)
session.commit()
elif cat == "Basketball":
for basketballItem in basketball_items:
item = Items(name=basketballItem, description=basketball_items[basketballItem], category = category_name)
session.add(item)
session.commit()
elif cat == "Baseball":
for baseballItem in baseball_items:
item = Items(name=baseballItem, description=baseball_items[baseballItem], category = category_name)
import csv
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Class, Category
# Connect to Database and create database session
engine = create_engine('sqlite:///catalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Add sample data to database
with open('sample_data.csv', 'rb') as csvfile:
csv_reader = csv.reader(csvfile,
delimiter=',',
quotechar='"',
skipinitialspace=True)
for row in csv_reader:
category = session.query(Category).filter_by(title=row[0]).first()
if not category:
category = Category(title=row[0])
session.add(category)
session.flush() # so that category.id returns value before commit
session.add(
Class(category_id=category.id, title=row[1], description=row[2]))
session.commit()
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create dummy user
User1 = User(name="Robo Barista", email="*****@*****.**",
picture=('https://pbs.twimg.com/profile_images/2671170543/'
'18debd694829ed78203a5a36dd364160_400x400.png'))
session.add(User1)
session.commit()
# Questions in the category of History
category1 = Category(name="History")
session.add(category1)
session.commit()
item1 = Item(user_id=1, air_date="2004-12-31",
question=("For the last 8 years of his life, Galileo was under"
" house arrest for espousing this man\'s theory"),
value="$200", answer="Copernicus", game_round="Jeopardy!",
show_number="4680", category=category1)
session.add(item1)
session.commit()
item2 = Item(user_id=1, air_date="1996-12-06",
question=("Historians refer to the Golden Age as the time during"
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create dummy user
User1 = User(name="omrkhoder",
email="*****@*****.**",
picture='https://upload.wikimedia.org/wikipedia/ \
commons/thumb/1/12/User_icon_2.svg/220px-User_icon_2.svg.png')
session.add(User1)
session.commit()
'''
#### SANDWICHES ####
'''
category1 = Category(user_id=1, name="SANDWICHES")
session.add(category1)
session.commit()
Item1 = Item(user_id=1,
name="Smoked Turkey",
description="Smoked turkey,lettuce,mayonnise,mustard "
"and cheddar cheese",
price="$20",
category=category1)
session.add(Item1)
session.commit()
Item2 = Item(user_id=1,
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Category Soccer and Items
catSoccer = Category(name="Soccer")
session.add(catSoccer)
session.commit()
catSoccerItem1 = Item(name="Socks",
description="""
The main job of socks is to support the shin guards. Staying in place is the
most important element of any good-fitting sock. They should neither slip
down, nor impede circulation. You generally get what you pair for, so buy the
best pair your budget can afford.
""",
category=catSoccer)
session.add(catSoccerItem1)
session.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Category, Item, User
engine = create_engine('sqlite:///categoryitemwithusers.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
User1 = User(name="Priyanka Nalawade", email="*****@*****.**")
session.add(User1)
session.commit
session.query(User).all()
myfirstcategory = Category(user_id=1, name="Cat1")
session.add(myfirstcategory)
session.commit()
session.query(Category).all()
mysecondcategory = Category(user_id=1, name="Cat2")
session.add(mysecondcategory)
session.commit()
session.query(Category).all()
mythirdcategory = Category(user_id=1, name="Cat3")
session.add(mythirdcategory)
session.commit()
session.query(Category).all()
myfourthcategory = Category(user_id=1, name="Cat4")
session.add(myfourthcategory)
session.commit()
session.query(Category).all()
firstcatfirstitem = Item(user_id=1,
title="firstcatfirstitem",
description="this is firstcatfirstitem ",
category=myfirstcategory)
from database_setup import Base, Item, Category
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
engine=create_engine('sqlite:///mathru.db', connect_args={'check_same_thread':False})
#Bind the above engine to the session
Session=sessionmaker(bind=engine)
#Create a session object
session=Session()
#Items for videos
category1=Category(name="Programs")
session.add(category1)
session.commit()
item1=Item(name="Journey", description="", category=category1)
session.add(item1)
session.commit()
item2=Item(name="Ad-Campaign", description="", category=category1)
session.add(item2)
session.commit()
#Items for Print Media
category2=Category(name="Print Media")
session.add(category2)
session.commit()
item1=Item(name="Magzine", description="", category=category2)
engine = create_engine("sqlite:///tolearn.db")
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# CREATE data
# user
#email = "YOUR GOOGLEMAIL ADDRESS HERE"
#name = "YOUR GOOGLE NAME HERE"
me = User(name=name, email=email)
session.add(me)
session.flush()
# category for user
me = session.query(User).filter_by(name=name).one()
js = Category(user_id=me.id, name="JavaScript")
kotlin = Category(user_id=me.id, name="Kotlin")
session.add(kotlin)
session.add(js)
session.flush()
# item for category
nodejs = LearningItem(
category_id=js.id,
name="Introduction to Node.js",
description="Learn the basics of node by completing the blog series")
angularjs = LearningItem(category_id=js.id,
name="Introduction to AngularJS",
description="Get started with AngularJS")
kotlinbasics = LearningItem(category_id=kotlin.id,
name="Kotlin Basics",
description="Learn the basics of Kotlin")
user1 = User(id="none-1",
name="Matt Mohan",
email="*****@*****.**",
profile_pic="")
session.add(user1)
session.commit()
user2 = User(id="none-2",
name="Stella Sparks",
email="*****@*****.**",
profile_pic="")
session.add(user2)
session.commit()
# Create Categories
category1 = Category(name="Baby Clothing", user_id=user1.id)
session.add(category1)
session.commit()
category2 = Category(name="Diapers", user_id=user1.id)
session.add(category2)
session.commit()
category3 = Category(name="Toys", user_id=user2.id)
session.add(category3)
session.commit()
category4 = Category(name="Feeding", user_id=user2.id)
session.add(category4)
session.commit()
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
User1 = User(
name="Robo Barista",
email="*****@*****.**",
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png',
auto_signin=False)
session.add(User1)
session.commit()
category1 = Category(name="Hockey", user=User1, user_id=User1.id)
session.add(category1)
session.commit()
item1 = Item(name="Stick",
description=lorem_ipsum,
category=category1,
category_id=category1.id,
user=User1,
user_id=User1.id)
session.add(item1)
session.commit()
item2 = Item(name="Skates",
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create dummy user
User1 = User(name="Shiva", email="*****@*****.**", picture='./shiva.jpg')
session.add(User1)
session.commit()
# Items for Bikes
Category1 = Category(user_id=1, name="Bikes")
session.add(Category1)
session.commit()
item1 = Item(user_id=1,
name="Apache RTR",
description="One of the best two wheelers in its class!",
capacity="2",
fuelType="Petrol",
mileage="45 kmpl",
maxSpeed="148",
price="1240$",
category=Category1)
session.add(item1)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Category, Base, Item
engine = create_engine('sqlite:///categoryitems.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
soccer = Category(name='Soccer')
session.add(soccer)
session.commit()
baseball = Category(name='Baseball')
session.add(baseball)
session.commit()
hockey = Category(name='Hockey')
session.add(hockey)
session.commit()
snowboarding = Category(name='Snowboarding')
session.add(snowboarding)
session.commit()
frisbee = Category(name='Frisbee')
session.add(frisbee)
session.commit()
# session.rollback() session = DBSession() # Create dummy user user1 = User(name="User1", email="*****@*****.**") session.add(user1) session.commit() user2 = User(name="User2", email="*****@*****.**") session.add(user2) session.commit() # Create Categories category1 = Category(name="Drama", user_id=1) session.add(category1) session.commit() category2 = Category(name="Comedy", user_id=1) session.add(category2) session.commit() category3 = Category(name="Horror", user_id=1) session.add(category3) session.commit() category4 = Category(name="Action", user_id=1) session.add(category4) session.commit()
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import User, Category, Item, Base
# connect to the database
engine = create_engine('sqlite:///catagories.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
catagories = ("Soccer", "Basketball", "Baseball", "Frisbee",
"Snowboarding", "Rock Climbing", "Foosball", "Skating", "Hockey")
# add catagories to the database
for category in catagories:
c = Category(name=category)
session.add(c)
session.commit()
print "added catagories"
from sqlalchemy import create_engine, asc
from sqlalchemy.orm import sessionmaker
import random
import string
db_engine = create_engine('sqlite:///ItemCatalog.db')
db_session_binding = sessionmaker(bind=db_engine)
db_session = db_session_binding()
admin = User(name='Admin', email='*****@*****.**')
tester = User(name='Tester', email='*****@*****.**')
db_session.add(admin)
db_session.add(tester)
db_session.commit()
db_session.add(Category(name='Soccer', user=admin))
db_session.add(Category(name='Basketball', user=tester))
db_session.add(Category(name='Baseball', user=admin))
db_session.add(Category(name='Frisbee', user=tester))
db_session.add(Category(name='Snowboarding', user=admin))
db_session.add(Category(name='Rock Climbing', user=tester))
db_session.add(Category(name='Foosball', user=admin))
db_session.add(Category(name='Skating', user=tester))
db_session.add(Category(name='Hockey', user=admin))
db_session.commit()
db_session.add(Item(user=admin, description='-', name='Stick',
category=db_session.query(Category).
filter_by(name='Hockey').first()))
db_session.add(Item(user=tester, description='-', name='Goggles',
category=db_session.query(Category).
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
User2 = User(
name="John Smith",
email="*****@*****.**",
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User2)
session.commit()
# Menu for UrbanBurger
category1 = Category(user_id=1, name="Inkjet Printers")
session.add(category1)
session.commit()
CatItem2 = CatItem(
user_id=1,
name="HP Deskjet 3788",
description="All in one A4 4800 dpi usb wi-fi color inkjet",
price="$67.50",
#course="Entree",
category=category1)
session.add(CatItem2)
session.commit()
from sqlalchemy.orm import sessionmaker from database_setup import Base, Category, User from database_setup import engine Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) session = DBSession() # Seed database with categories action = Category(name="Action") session.add(action) session.commit() comedy = Category(name="Comedy") session.add(comedy) session.commit() horror = Category(name="Horror") session.add(horror) session.commit() sci_fi = Category(name="Science Fiction") session.add(sci_fi) session.commit() adventure = Category(name="Adventure") session.add(adventure) session.commit() drama = Category(name="Drama") session.add(drama)
# Connect the engine to a session
Session = sessionmaker(bind=engine)
# Setting up a Session object
session = Session()
user1 = User(
name='Abdulrahman',
email='*****@*****.**',
)
session.add(user1)
session.commit()
category3 = Category(name='test category3', user=user1)
session.add(category3)
session.commit()
item3 = Item(name='Item 3 test',
description='It is an test item. to test the app',
category=category3,
user=user1)
session.add(item3)
session.commit()
category4 = Category(name='test category4', user=user1)
session.add(category4)
# Bind the engine to the metadata of the Base class so that the # declaratives can be accessed through a DBSession instance Base.metadata.bind = engine DBSession = sessionmaker(bind=engine) # A DBSession() instance establishes all conversations with the database # and represents a "staging zone" for all the objects loaded into the # database session object. Any change made against the objects in the # session won't be persisted into the database until you call # session.commit(). If you're not happy about the changes, you can # revert all of them back to the last commit by calling # session.rollback() session = DBSession() # add categories in database category1 = Category(name="Football") session.add(category1) session.commit() category2 = Category(name="Basketball") session.add(category2) session.commit() category3 = Category(name="Tennis") session.add(category3) session.commit() category4 = Category(name="Swimming") session.add(category4) session.commit()
user1 = User(first_name="Deep",
last_name="Agar",
username="******",
hash_password=hashedPass1)
session.add(user1)
session.commit()
user2 = User(first_name="Priya",
last_name="Agar",
username="******",
hash_password=hashedPass1)
session.add(user2)
session.commit()
category1 = Category(title="Soccer")
session.add(category1)
session.commit()
item1 = Item(title="Stick",
description="New Description",
categoryId=category1.id,
userId=user1.id)
session.add(item1)
session.commit()
item2 = Item(title="Goggles",
description="New Description",
categoryId=category1.id,
userId=user1.id)
session.add(item2)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Category, Base, Item
import datetime
engine = create_engine('sqlite:///catalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# insert category and items for Soccer
var_category = Category(category_name="Soccer")
session.add(var_category)
session.commit()
var_item = Item(
item_name="Shin guards",
description=
"A shin guard is a piece of equipment worn on the front of a player's shin to protect them from injury.",
create_ts=datetime.datetime.now(),
category=var_category)
session.add(var_item)
session.commit()
var_item = Item(
item_name="Jersey",
description="A loose shirt worn by a member of team as part of a uniform",
create_ts=datetime.datetime.now(),
category=var_category)
session.add(var_item)
session.commit()
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
"""
A DBSession() instance establishes all conversations with the database
and represents a 'staging zone' for all the objects loaded into the
database session object. Any change made against the objects in the
session won't be persisted into the database until you call
session.commit(). If you're not happy about the changes, you can
revert all of them back to the last commit by calling session.rollback()
"""
session = DBSession()
# ---------------- Creating dummy Categories
print('Created dummy Categories')
Category1 = Category(name='Cat1', description='Cat1 description')
Category2 = Category(name='Cat2', description='Cat2 description')
Category3 = Category(name='Cat3', description='Cat3 description')
print('Adding dummy categories...')
session.add(Category1)
session.add(Category2)
session.add(Category3)
# session.commit()
print('Categories stored in DB')
# ---------------- Creating dummy Items
print('Creating dummy items...')
Item1 = Item(name='Item1', description='Item1 description', price='111')
Item2 = Item(name='Item2', description='Item2 description', price='222')
session.execute('''DELETE FROM user''')
session.commit()
session.close()
# Create dummy user
User1 = User(name="Mohammed Devops",
email="*****@*****.**",
picture='300x300.png')
session.add(User1)
session.commit()
# Read JSON File of Data, to edit raw_data, edit them in raw_data folder
with open('categories.json') as f:
category_data = json.load(f)
for category in category_data:
session.add(Category(name=category['name']))
session.commit()
print("Loaded Item Catalog Data into DB")
print("Categories Added: %s" % session.query(Category).count())
with open('items.json') as f1:
item_data = json.load(f1)
for item in item_data:
# Grab the category record that the item is attached to each item
category = session.query(Category) \
.filter_by(name=item['category']).one()
session.add(Item(name=item['name'],
description=item['description'],
category=category,
user=User1))
session.commit()
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create dummy user
User1 = User(
name="Robo Barista",
email="*****@*****.**",
picture=
'https://pbs.twimg.com/profile_images/2671170543/18debd694829ed78203a5a36dd364160_400x400.png'
)
session.add(User1)
session.commit()
# Ski
category1 = Category(user_id=1, name="Ski")
session.add(category1)
session.commit()
item2 = Item(user_id=1,
name="Helmet",
description="Head protection for skiers",
category=category1)
session.add(item2)
session.commit()
item1 = Item(user_id=1,
name="Skis",
description="Very good skis to ski",
# session.commit(). If you're not happy about the changes, you can # revert all of them back to the last commit by calling # session.rollback() session = DBSession() #User user1 = User(name="Olivia Gmail",email="*****@*****.**") session.add(user1) session.commit() user2 = User(name="Olivia Facebook",email="*****@*****.**") session.add(user2) session.commit() #Category category1 = Category(name="Soccer") session.add(category1) session.commit() category2 = Category(name="Basketball") session.add(category1) session.commit() category3 = Category(name="Snowboarding") session.add(category1) session.commit() dateTimeNow = datetime.datetime.now() #Menu for UrbanBurger item1 = Item(name = "Soccer Ball", description="an inflated ball used in playing soccer",
engine = create_engine('sqlite:///itemcatalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
# Create dummy user
User1 = User(name="Arch user", email="*****@*****.**",
picture='')
session.add(User1)
session.commit()
print "added one user!"
# Menu for UrbanBurger
category1 = Category(user_id=1, name="Soccer")
session.add(category1)
category2 = Category(user_id=1, name="Basketball")
session.add(category2)
category3 = Category(user_id=1, name="Baseball")
session.add(category3)
category4 = Category(user_id=1, name="Frisbee")
session.add(category4)
category5 = Category(user_id=1, name="Snowboarding")
session.add(category5)
category6 = Category(user_id=1, name="Rock Climbing")
session.add(category6)
category7 = Category(user_id=1, name="Skating")
session.add(category7)
category8 = Category(user_id=1, name="Hockey")
session.add(category8)
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import User, Base, Item, Category
engine = create_engine('sqlite:///itemcatalog.db')
# Bind the engine to the metadata of the Base class so that the
# declaratives can be accessed through a DBSession instance
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
category1 = Category(category_name="Art")
session.add(category1)
session.commit()
category2 = Category(category_name="Electronics")
session.add(category2)
session.commit()
category3 = Category(category_name="Fashion")
session.add(category3)
session.commit()
category4 = Category(category_name="Music")
session.add(category4)
session.commit()
category5 = Category(category_name="Home")
# A DBSession() instance establishes all conversations with the database
# and represents a "staging zone" for all the objects loaded into the
# database session object. Any change made against the objects in the
# session won't be persisted into the database until you call
# session.commit(). If you're not happy about the changes, you can
# revert all of them back to the last commit by calling
# session.rollback()
session = DBSession()
# Create user
User1 = User(name="latifa", email="*****@*****.**")
session.add(User1)
session.commit()
# Item for Action movies
category1 = Category(user_id=1, name="Action")
session.add(category1)
session.commit()
Item1 = Item(
user_id=1,
title="Mission Impossible Fallout",
description=
"Ethan Hunt and his IMF team along with some familiar allies race against time after a mission gone wrong", # noqa
category=category1)
session.add(Item1)
session.commit()
Item2 = Item(
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
from database_setup import Base, Category
engine = create_engine('sqlite:///catalog.db')
Base.metadata.bind = engine
DBSession = sessionmaker(bind=engine)
session = DBSession()
categories = [
'Hand Tools', 'Power Tools', 'Electrical', 'Plumbing', 'Lumber', 'Safety'
]
for c in categories:
new_category = Category(name=c)
session.add(new_category)
session.commit()
print "Categories added"
