Example #1
0
def remove_config():
    
    # get id from URL: /config?id=id_
    id_ = request.args.get('id', -1)

    # get confirmation for removal
    confirm = request.args.get('confirm', 0)

    # cast confirm as int
    try:
        confirm = int(confirm)
    except:
        confirm = 0

    if confirm > 0:

        # remove configuration
        HardwareConnections.query.filter_by(id=id_).delete()

        # commit change to database
        try:
            db_session.commit()
        except IntegrityError as e:
            db_session.rollback()
            print str(e)
        except SQLAlchemyError as e:
            db_session.rollback()
            print str(e)

    # redirect to configurations page
    return redirect(url_for('configurations'))
Example #2
0
File: init.py Project: lariat/lhcdb
lhc.caen_board_24_channel_48 = 'WC1'
lhc.caen_board_24_channel_49 = 'WC2'
lhc.caen_board_24_channel_50 = 'WC3'
lhc.caen_board_24_channel_51 = 'WC4'
lhc.caen_board_24_channel_52 = 'BEAMON'
lhc.caen_board_24_channel_53 = 'TOFUS'
lhc.caen_board_24_channel_54 = 'TOFDS'
lhc.caen_board_24_channel_55 = 'PUNCH'
lhc.caen_board_24_channel_56 = 'HALO'
lhc.caen_board_24_channel_57 = 'PULSER'
lhc.caen_board_24_channel_58 = 'COSMICON'
lhc.caen_board_24_channel_59 = 'COSMIC'
lhc.caen_board_24_channel_60 = 'PILEUP'
lhc.caen_board_24_channel_61 = 'MICHEL'
lhc.caen_board_24_channel_62 = 'LARSCINT'
lhc.caen_board_24_channel_63 = 'MURS'

db_session.add(lhc)

try:
    db_session.commit()
except IntegrityError as e:
    db_session.rollback()
    print str(e)
except SQLAlchemyError as e:
    db_session.rollback()
    print str(e)

db_session.remove()

Example #3
0
def submit_config():

    if request.method == 'POST':

        keys = []
        submission = request.form
        id_ = submission.get('id_', '')
        date_time = submission.get('date-time', '')

        if date_time == '':
            response = make_response(redirect(url_for('add_config')))
            return response

        date_time = datetime.strptime(date_time, '%m/%d/%Y %I:%M %p')

        for key, value in submission.iteritems():
            if value:
                keys.append(key)
                #print key, value

        result = HardwareConnections.query.get(id_)

        if not result:
            response = make_response(redirect(url_for('add_config')))
            return response

        lhc_dict = dict(result.__dict__)
        lhc_dict.pop('_sa_instance_state', None)
        lhc_dict.pop('id', None)
        lhc_dict.pop('date_time', None)
        lhc_dict.pop('date_time_added', None)
        lhc_dict.pop('date_time_updated', None)

        db_session.remove()

        for key in keys:
            lhc_dict[key] = submission.get(key)
            #print key, submission.get(key)

        keys.extend(lhc_dict.keys())
        keys = list(set(keys))

        lhc = HardwareConnections(
            date_time=date_time, date_time_added=datetime.now()
            )

        for key, value in lhc_dict.iteritems():
            if value == 'None':
                setattr(lhc, key, None)
            else:
                setattr(lhc, key, value)

        db_session.add(lhc)

        try:
            db_session.commit()
        except IntegrityError as e:
            db_session.rollback()
            print str(e)
        except SQLAlchemyError as e:
            db_session.rollback()
            print str(e)

        db_session.remove()

        response = make_response(redirect(url_for('configurations')))

        return response

    return 'Error!'