def CreateCategory(self, request):
category = Category(name = request.name, user = self.GetUserId())
if category.isCategoryUnique() == False :
raise endpoints.BadRequestException("BUSINESS RULE: Duplicate Category already exists")
category.put()
return category.ConvertToResponse()
def index(self):
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render('home_admin.html',
report={
'users': users[0],
'categories': categories[0],
'products': products[0]
},
last_products=last_products)
def index(self):
#return self.render('home_admin.html', data={'username':'******'})
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render('home_admin.html', report={
'users': 0 if not users else users[0],
'categories': 0 if not categories else categories[0],
'products': 0 if not products else products[0]
}, last_products=last_products)
def __init__(self, parent=None):
super(MainWindow, self).__init__(parent)
self.mainwindow = Ui_MainWindow()
self.mainwindow.setupUi(self)
it1 = Category(title='it1')
it2 = Page('it2', 'This is it2\'s content')
it3 = Page('it3', 'This is it3\'s content')
it1.setChild(it1.rowCount(), it2)
it1.setChild(it1.rowCount(), it3)
model = QStandardItemModel()
model.appendRow(it1)
tv = self.mainwindow.treeView
tv.setModel(model)
tv.setRootIsDecorated(True)
tv.setSelectionMode(QAbstractItemView.SingleSelection)
tv.setSelectionBehavior(QAbstractItemView.SelectItems)
tv.clicked.connect(self.printData)
def index(self):
user_model = User()
category_model = Category()
product_model = Product()
users = user_model.get_total_users()
categories = category_model.get_total_categories()
products = product_model.get_total_products()
last_products = product_model.get_last_products()
return self.render(
"home_admin.html",
report={
"users": 0 if not users else users[0],
"categories": 0 if not categories else categories[0],
"products": 0 if not products else products[0]
},
last_products=last_products
)
def readDetail(self, response):
# loader = ItemLoader(item = TruyentranhItem(), response = response)
# loader.add_xpath('image_urls', '//div[@class="manga-cover"]/img/@src')
soup = BeautifulSoup(response.body, 'lxml')
book = response.meta['book']
p = soup.findAll('p', {'class': 'misc-infor'})
'''author'''
book.book_author = self.getText(p[1].find('a'))
'''category'''
book_category = []
listCates = p[2].findAll('a')
for cate in listCates:
category = Category()
category.category_name = cate.text.encode('utf-8',
'ignore').strip()
book_category.append(
self.dbCategory.addNewCategory(category, self.site))
# print book_category
'''description'''
div = soup.find('div', {'id': 'manga-summary'})
book.book_description = self.getText(div)
book.book_id = self.bookDBManager.addNewBook(book, self.site)
self.mapBookCategoryDBManager.addBookCategory(book, book_category)
'''download avatar'''
yield self.downloadImage(response)
'''chapter'''
listChapter = soup.findAll('span', {'class': 'chapter-name'})
order = len(listChapter)
for ele in listChapter:
chapter = Chapter()
chapter.chapter_book = book.book_id
chapter.chapter_name = self.getText(ele)
chapter.chapter_order = order
order -= 1
a = ele.find('a')
yield scrapy.Request(a.get('href').strip(),
callback=self.readContentChapter,
meta={'chapter': chapter})
"""debug"""
break
def MergeFromMessage(self, message):
if message.status is not None:
self.status = message.status
if message.category is not None:
self.category = Category.get_by_id(message.category).key
if message.title is not None:
self.title = message.title
if message.description is not None:
self.description = message.description
def get_foods(category_id):
cursor_wrapper = CursorWrapper()
sql = "SELECT food_id, food_name FROM foods WHERE category_id = {}".format(
category_id)
with cursor_wrapper as cursor:
cursor.execute(sql, commit=False)
# categories_tuple = cursor.fetchall()
categories = Category.from_rows(cursor.fetchall())
# categories = []
# for cat in categories_tuple:
# categorie = {'id': cat[0], 'name': cat[1]}
# categories.append(categorie)
return categories
def UpdateCategoryName(self, request):
result = CategoryResponse()
category = Category.get_by_id(request.id)
if category != None:
if category.last_updated <= request.client_copy_timestamp and category.user == self.GetUserId():
category.name = request.new_name
category.put()
result = category.ConvertToResponse()
else:
raise endpoints.NotFoundException("The item was updated on the outside")
else:
raise endpoints.NotFoundException('No category entity with the id "%s" exists.' % request.id)
return result
def GetCategoryList(self, request):
limit = 10
if request.limit is not None:
limit = request.limit
curs = None
if request.cursor is not None:
try:
curs = Cursor(urlsafe=request.cursor)
except BadValueError:
raise endpoints.BadRequestException('Invalid cursor %s.' % request.cursor)
if (curs is not None):
categories, next_curs, more = Category.query(Category.user == self.GetUserId()).fetch_page(limit, start_cursor=curs)
else:
categories, next_curs, more = Category.query(Category.user == self.GetUserId()).fetch_page(limit)
items = [entity.ConvertToResponse() for entity in categories]
if more:
return CategoryListResponse(category_list=items, cursor=next_curs.urlsafe(), has_more=more)
else:
return CategoryListResponse(category_list=items, has_more=more)
def DeleteUser(self, request):
'''API method to delete current user and all his data'''
categories = Category.query(Category.user == self.GetUserId()).fetch()
for category in categories:
category.key.delete()
tasks = Task.query(Task.user == self.GetUserId()).fetch()
for task in tasks:
task.key.delete()
user = User.query(User.username == endpoints.get_current_user().email()).get()
user.key.delete()
return message_types.VoidMessage()
def testAddRemovePages(self):
cat = Category('Test category')
pageOne = Page(cat, 'Page One Title', 'Page One Content')
pageTwo = Page(cat, 'Page Two Title', 'Page Two Content')
cat.add_page(pageOne)
cat.add_page(pageTwo)
self.assertEquals(len(cat.pages), 2, 'Pages len fail')
cat.remove_page(pageOne)
self.assertEquals(len(cat.pages), 1, 'Pages len fail')
cat.remove_page(pageTwo)
self.assertEquals(len(cat.pages), 0, 'Pages len fail')
def DeleteCategory(self, request):
result = CategoryResponse()
category = Category.get_by_id(request.id)
if category != None:
if Task.query(Task.category == category.key).get() == None:
if category.last_updated <= request.client_copy_timestamp and category.user == self.GetUserId():
category.key.delete()
result = category.ConvertToResponse()
else:
raise endpoints.NotFoundException("The item was updated on the outside")
else:
raise endpoints.NotFoundException("This item has child elements")
else:
raise endpoints.NotFoundException('No category entity with the id "%s" exists.' % request.id)
return result
def CreateDefaultCategories(self, userid):
for category in Settings.default_categories:
category = Category(name = category, user = userid)
category.put()
def CreateCategory(self, request):
category = Category(name = request.name, user = self.GetUserId())
category.put()
return category.ConvertToResponse()
def creationCategory(request):
label = request.form.get('label')
return Category.creationCategorie(label)
