# -*- coding: utf-8 -*-
#
# Copyright(c) 2010 poweredsites.org
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may
# not use this file except in compliance with the License. You may obtain
# a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations
# under the License.

from poweredsites.libs.handler import StaffBaseHandler, AdminBaseHandler
from poweredsites.db.caches import clearup

class ClearCacheHandler(AdminBaseHandler):
    def get(self):
        clearup()
        self.write("Clearup cache OK")


class NewUsersHandler(AdminBaseHandler):
    def get(self):
        # New users list, temp
        users = self.db.query("select * from user order by id DESC limit 0, 200")
        count = self.db.query("select count(*) as c from user")
        if count:
            count = count.c
        else:
            count = 0
        self.render("admin/new_users.html", users=users, count=count)


sub_handlers = ["^admin.poweredsites.org$",
              [(r"/clearcache", ClearCacheHandler),
               (r"/newusers", NewUsersHandler),
               ]
            ]

@@ -1059,37 +1059,35 @@
 count = self.db.
-query
+get
 (%22select count(*

fix count use get