Ejemplo n.º 1
0
class PV_Controller:
    def __init__(self, db):
        self.db = db
        self.pv_hook = PV(db)
        self.point_hook = Point(db)
        self.participant_hook = Participant(db)

    ### New
    def get_new_pv(self):
        return template('pv/new',
                        title="New PV",
                        errors=dict(),
                        data=defaultdict(lambda: ''))

    get_new_pv.route = '/pv/new'
    get_new_pv.method = 'GET'

    def ajax_get_new_pv(self):
        return template('pv/new',
                        ajax=True,
                        title="New PV",
                        errors=dict(),
                        data=defaultdict(lambda: ''))

    ajax_get_new_pv.route = '/pv/ajax/new'
    ajax_get_new_pv.method = 'GET'

    def post_new_pv(self):
        fields = dict()
        fields['title'] = request.forms.title
        fields['date'] = request.forms.date
        fields['time'] = request.forms.time
        fields['location'] = request.forms.location
        fields['description'] = request.forms.description

        validation_result = self.pv_hook.create(fields)
        if isinstance(validation_result, dict):
            return template('pv/new',
                            title="New PV",
                            errors=validation_result,
                            data=request.forms)
        else:
            redirect('/')

    post_new_pv.route = '/pv/new'
    post_new_pv.method = 'POST'

    def ajax_post_new_pv(self):
        fields = dict()
        fields['title'] = request.forms.title
        fields['date'] = request.forms.date
        fields['time'] = request.forms.time
        fields['location'] = request.forms.location
        fields['description'] = request.forms.description

        validation_result = self.pv_hook.create(fields)
        if isinstance(validation_result, dict):
            return validation_result
        else:
            return {'id': validation_result}

    ajax_post_new_pv.route = '/pv/ajax/new'
    ajax_post_new_pv.method = 'POST'

    ### Edit
    def get_edit_pv(self, pv_id=None):
        data = self.pv_hook.retrieve_one(where={'id': pv_id})

        return template('pv/edit', title="New PV", data=data, errors=dict())

    get_edit_pv.route = '/pv/edit/<pv_id>'
    get_edit_pv.method = 'GET'

    def ajax_get_edit_pv(self):
        data = self.pv_hook.retrieve_one(where={'id': request.query.pv_id})

        return template('pv/edit',
                        ajax=True,
                        title="New PV",
                        data=data,
                        errors=dict())

    ajax_get_edit_pv.route = '/pv/ajax/edit'
    ajax_get_edit_pv.method = 'GET'

    def post_edit_pv(self):
        fields = dict()
        fields['id'] = request.forms.pv_id
        fields['title'] = request.forms.title
        fields['date'] = request.forms.date
        fields['time'] = request.forms.time
        fields['location'] = request.forms.location
        fields['description'] = request.forms.description

        validation_result = self.pv_hook.update(fields, {'id': fields['id']})

        if isinstance(validation_result, dict):
            return template('pv/edit', data=fields, errors=validation_result)
        else:
            redirect('/')

    post_edit_pv.route = '/pv/edit'
    post_edit_pv.method = 'POST'

    def ajax_post_edit_pv(self):
        fields = dict()
        fields['id'] = request.forms.pv_id
        fields['title'] = request.forms.title
        fields['date'] = request.forms.date
        fields['time'] = request.forms.time
        fields['location'] = request.forms.location
        fields['description'] = request.forms.description

        validation_result = self.pv_hook.update(fields, {'id': fields['id']})
        if isinstance(validation_result, dict):
            return validation_result
        else:
            return {'id': validation_result}

    ajax_post_edit_pv.route = '/pv/ajax/edit'
    ajax_post_edit_pv.method = 'POST'

    ### Delete
    def get_delete_pv(self, pv_id=None):
        if pv_id is None:
            redirect('/')
        else:
            return template('pv/delete', title="Delete PV", pv_id=pv_id)

    get_delete_pv.route = '/pv/delete/<pv_id>'
    get_delete_pv.method = 'GET'

    def ajax_get_delete_pv(self):
        pv_id = request.query.pv_id
        return template('pv/delete', ajax=True, title="Delete PV", pv_id=pv_id)

    ajax_get_delete_pv.route = '/pv/ajax/delete'
    ajax_get_delete_pv.method = 'GET'

    def post_delete_pv(self):
        pv_id = request.forms.pv_id
        if 'yes' not in request.forms or 'no' in request.forms or pv_id is None:
            redirect('/')
        else:
            if self.pv_hook.delete({'id': pv_id}):
                redirect('/')
            else:
                print('Error. Do something.')  # TODO

    post_delete_pv.route = '/pv/delete'
    post_delete_pv.method = 'POST'

    def ajax_post_delete_pv(self):
        pv_id = request.forms.pv_id
        print(pv_id)
        if pv_id is None:
            redirect('/')
        else:
            if self.pv_hook.delete({'id': pv_id}):
                redirect('/')
            else:
                print('Error. Do something.')  # TODO

    ajax_post_delete_pv.route = '/pv/ajax/delete'
    ajax_post_delete_pv.method = 'POST'

    ### Select
    def get_pv(self, pv_id=None):
        if pv_id is None:
            redirect('/')
        else:
            try:
                isinstance(int(pv_id), int)
            except ValueError:
                redirect('/')

            cookie_data = request.get_cookie('spvm', dict(), secret='secret')

            if not isinstance(cookie_data,
                              dict) and cookie_is_encoded(cookie_data):
                cookie_data = cookie_decode(cookie_data, 'key')

            cookie_data['pv_id'] = pv_id

            response.set_cookie('spvm',
                                cookie_encode(cookie_data, 'key'),
                                secret='secret',
                                path='/')

            pv_data = self.pv_hook.retrieve_one(where={'id': pv_id})

            points = self.point_hook.retrieve(where={
                'pv_id': pv_id,
                'parent_id': ''
            },
                                              order="rank ASC",
                                              recursion=3)

            participants = self.participant_hook.retrieve(
                where={'pv_id': pv_id})

            return template('main',
                            pv_id=pv_id,
                            pv_data=pv_data,
                            points=points,
                            participants=participants)

    get_pv.route = '/pv/<pv_id>'
    get_pv.method = 'GET'

    ### Unselect
    def close_pv(self):
        cookie_data = request.get_cookie('spvm', dict(), secret='secret')

        if not isinstance(cookie_data,
                          dict) and cookie_is_encoded(cookie_data):
            cookie_data = cookie_decode(cookie_data, 'key')

        cookie_data['pv_id'] = 0

        response.set_cookie('spvm',
                            cookie_encode(cookie_data, 'key'),
                            secret='secret',
                            path='/')

        redirect('/')

    close_pv.route = '/pv/close'
    close_pv.method = 'GET'

    ### Configure TODO
    def config_pv(self):
        redirect('/')

    config_pv.route = '/pv/config'
    config_pv.method = 'GET'
Ejemplo n.º 2
0
 def __init__(self, db):
     self.db = db
     self.pv_hook = PV(db)
     self.point_hook = Point(db)
     self.participant_hook = Participant(db)
Ejemplo n.º 3
0
	def __init__(self, db):
		self.db = db
		self.pv_hook = PV(db)
		self.point_hook = Point(db)
		self.participant_hook = Participant(db)
Ejemplo n.º 4
0
class PV_Controller:
	def __init__(self, db):
		self.db = db
		self.pv_hook = PV(db)
		self.point_hook = Point(db)
		self.participant_hook = Participant(db)

	### New
	def get_new_pv(self):
		return template('pv/new', title="New PV", errors=dict(), data=defaultdict(lambda:''))
	get_new_pv.route = '/pv/new'
	get_new_pv.method = 'GET'

	def ajax_get_new_pv(self):
		return template('pv/new', ajax=True, title="New PV", errors=dict(), data=defaultdict(lambda:''))
	ajax_get_new_pv.route = '/pv/ajax/new'
	ajax_get_new_pv.method = 'GET'

	def post_new_pv(self):
		fields = dict()
		fields['title'] = request.forms.title
		fields['date'] = request.forms.date
		fields['time'] = request.forms.time
		fields['location'] = request.forms.location
		fields['description'] = request.forms.description

		validation_result = self.pv_hook.create(fields)
		if isinstance(validation_result, dict):
			return template('pv/new', title="New PV", errors=validation_result, data=request.forms)
		else:
			redirect('/')
	post_new_pv.route = '/pv/new'
	post_new_pv.method = 'POST'

	def ajax_post_new_pv(self):
		fields = dict()
		fields['title'] = request.forms.title
		fields['date'] = request.forms.date
		fields['time'] = request.forms.time
		fields['location'] = request.forms.location
		fields['description'] = request.forms.description

		validation_result = self.pv_hook.create(fields)
		if isinstance(validation_result, dict):
			return validation_result
		else:
			return {'id': validation_result}
	ajax_post_new_pv.route = '/pv/ajax/new'
	ajax_post_new_pv.method = 'POST'

	### Edit
	def get_edit_pv(self, pv_id=None):
		data = self.pv_hook.retrieve_one(where={'id':pv_id})

		return template('pv/edit', title="New PV", data=data, errors=dict())
	get_edit_pv.route = '/pv/edit/<pv_id>'
	get_edit_pv.method = 'GET'

	def ajax_get_edit_pv(self):
		data = self.pv_hook.retrieve_one(where={'id':request.query.pv_id})

		return template('pv/edit', ajax=True, title="New PV", data=data, errors=dict())
	ajax_get_edit_pv.route = '/pv/ajax/edit'
	ajax_get_edit_pv.method = 'GET'

	def post_edit_pv(self):
		fields = dict()
		fields['id'] = request.forms.pv_id
		fields['title'] = request.forms.title
		fields['date'] = request.forms.date
		fields['time'] = request.forms.time
		fields['location'] = request.forms.location
		fields['description'] = request.forms.description

		validation_result = self.pv_hook.update(fields, {'id': fields['id']})

		if isinstance(validation_result, dict):
			return template('pv/edit', data=fields, errors=validation_result)
		else:
			redirect('/')
	post_edit_pv.route = '/pv/edit'
	post_edit_pv.method = 'POST'

	def ajax_post_edit_pv(self):
		fields = dict()
		fields['id'] = request.forms.pv_id
		fields['title'] = request.forms.title
		fields['date'] = request.forms.date
		fields['time'] = request.forms.time
		fields['location'] = request.forms.location
		fields['description'] = request.forms.description

		validation_result = self.pv_hook.update(fields, {'id': fields['id']})
		if isinstance(validation_result, dict):
			return validation_result
		else:
			return {'id': validation_result}
	ajax_post_edit_pv.route = '/pv/ajax/edit'
	ajax_post_edit_pv.method = 'POST'

	### Delete
	def get_delete_pv(self, pv_id=None):
		if pv_id is None:
			redirect('/')
		else:
			return template('pv/delete', title="Delete PV", pv_id=pv_id)
	get_delete_pv.route = '/pv/delete/<pv_id>'
	get_delete_pv.method = 'GET'

	def ajax_get_delete_pv(self):
		pv_id = request.query.pv_id
		return template('pv/delete', ajax=True, title="Delete PV", pv_id=pv_id)
	ajax_get_delete_pv.route = '/pv/ajax/delete'
	ajax_get_delete_pv.method = 'GET'

	def post_delete_pv(self):
		pv_id = request.forms.pv_id
		if 'yes' not in request.forms or 'no' in request.forms or pv_id is None:
			redirect('/')
		else:
			if self.pv_hook.delete({'id':pv_id}):
				redirect('/')
			else:
				print('Error. Do something.') # TODO
	post_delete_pv.route = '/pv/delete'
	post_delete_pv.method = 'POST'

	def ajax_post_delete_pv(self):
		pv_id = request.forms.pv_id
		print(pv_id)
		if pv_id is None:
			redirect('/')
		else:
			if self.pv_hook.delete({'id':pv_id}):
				redirect('/')
			else:
				print('Error. Do something.') # TODO
	ajax_post_delete_pv.route = '/pv/ajax/delete'
	ajax_post_delete_pv.method = 'POST'

	### Select
	def get_pv(self, pv_id=None):
		if pv_id is None:
			redirect('/')
		else:
			try:
				isinstance(int(pv_id), int)
			except ValueError:
				redirect('/')

			cookie_data = request.get_cookie('spvm', dict(), secret='secret')

			if not isinstance(cookie_data, dict) and cookie_is_encoded(cookie_data):
				cookie_data = cookie_decode(cookie_data, 'key')

			cookie_data['pv_id'] = pv_id

			response.set_cookie('spvm', cookie_encode(cookie_data, 'key'), secret='secret', path='/')

			pv_data = self.pv_hook.retrieve_one(where={'id':pv_id})

			points = self.point_hook.retrieve(where={'pv_id':pv_id, 'parent_id':''}, order="rank ASC", recursion=3)

			participants = self.participant_hook.retrieve(where={'pv_id':pv_id})

			return template('main', pv_id=pv_id, pv_data=pv_data, points=points, participants=participants)
	get_pv.route = '/pv/<pv_id>'
	get_pv.method = 'GET'

	### Unselect
	def close_pv(self):
		cookie_data = request.get_cookie('spvm', dict(), secret='secret')

		if not isinstance(cookie_data, dict) and cookie_is_encoded(cookie_data):
			cookie_data = cookie_decode(cookie_data, 'key')

		cookie_data['pv_id'] = 0

		response.set_cookie('spvm', cookie_encode(cookie_data, 'key'), secret='secret', path='/')

		redirect('/')
	close_pv.route = '/pv/close'
	close_pv.method = 'GET'

	### Configure TODO
	def config_pv(self):
		redirect('/')
	config_pv.route = '/pv/config'
	config_pv.method = 'GET'
Ejemplo n.º 5
0
(options, args) = parser.parse_args()

# Loading database
try:
    db_module = __import__('database.' + options.db_module,
                           fromlist=['database'])
except ImportError:
    print('DB Error.')
    exit(1)

# Connecting to database
db_hook = db_module.DBModule(options.database, options.username,
                             options.password)

# Loading models
pv_hook = PV(db_hook)
point_hook = Point(db_hook)
proposition_hook = Proposition(db_hook)
participant_hook = Participant(db_hook)

# Building tables
pv_hook.create_table()
point_hook.create_table()
proposition_hook.create_table()
participant_hook.create_table()


def setup_routes(obj):
    for kw in dir(obj):
        attr = getattr(obj, kw)
        if hasattr(attr, 'route'):
Ejemplo n.º 6
0
	def __init__(self, db):
		self.service_hook = PV(db)

		self.service_name = "pvs"

		super(PV_Service, self).__init__()
Ejemplo n.º 7
0
parser.add_option("-p", "--password", action="store", type="string", dest="password")

(options, args) = parser.parse_args()

# Loading database
try:
	db_module = __import__('database.' + options.db_module, fromlist=['database'])
except ImportError:
	print('DB Error.')
	exit(1)

# Connecting to database
db_hook = db_module.DBModule(options.database, options.username, options.password)

# Loading models
pv_hook = PV(db_hook)
point_hook = Point(db_hook)
proposition_hook = Proposition(db_hook)
participant_hook = Participant(db_hook)

# Building tables
pv_hook.create_table()
point_hook.create_table()
proposition_hook.create_table()
participant_hook.create_table()

def setup_routes(obj):
	for kw in dir(obj):
		attr = getattr(obj, kw)
		if hasattr(attr, 'route'):
			if hasattr(attr, 'method'):