import cherrypy
import sqlite3
import json
from lib import uuid
from lib import database

@cherrypy.expose
class Button(object):
    STATUS_INVENTORY = 0
    STATUS_ACTIVE = 1
    STATUS_INACTIVE = 2 
    STATUS_SUSPENDED = 3
    STATUS_DEAD = 4

    def __init__(self):
        self.id = None
        self.status = 0

    def GET(self, id):
        if not uuid.validate(id):
            return cherrypy.HTTPError(404)

        db = database.connect()
        db.execute("SELECT id,status FROM buttons WHERE id = ?" , (str(id),))
        return db.fetchone()
#        return json.dumps({
#            'id': self.id,
#            'status': self.status
#        })

    def POST(self):
        return 'POST BIUTTON'

    def PUT(self, id):
        if uuid.validate(id):
            return self.GET(id)

        raise cherrypy.HTTPError(400, 'Invalid UUID')

    def DELETE(self):
        return 'DELETE BUTTON'