mvidalgarcia

def adjust_url(url):
    """
    Add 'http://' protocol to url string
    :param url: Input url
    :return: Proper formatted url
    """
    if url[:4] != 'http':
        url = 'http://' + url
    return url

mvidalgarcia

SET search_path = event_paper_reviewing, pg_catalog;

CREATE SEQUENCE paper_review_questions_id_seq
	START WITH 1
	INCREMENT BY 1
	NO MAXVALUE
	NO MINVALUE
	CACHE 1;

CREATE SEQUENCE paper_review_ratings_id_seq

mvidalgarcia

from sqlalchemy.orm.attributes import flag_modified
import uuid

lst = []

for reg_item in RegistrationFormItem.find(input_type='accommodation', is_deleted=False):
    choice_id = unicode(uuid.uuid4())
    needs_caption = False

    for rffd in RegistrationFormFieldData.find(field_id=reg_item.id):

mvidalgarcia

# ConfigMaps

spec:
  containers:
  - env:
    volumeMounts:
    - mountPath: /cephalopod/settings
      name: settings-volume
  
  # ...

mvidalgarcia

from timeit import default_timer as timer

from flask import Flask
from flask_sqlalchemy import SQLAlchemy
from sqlalchemy.orm import joinedload

app = Flask(__name__)
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = False
app.config['SQLALCHEMY_DATABASE_URI'] = 'postgresql:///test'
db = SQLAlchemy(app)

mvidalgarcia

#!/usr/bin/python

# This work is licensed under the Creative Commons Attribution 3.0 United 
# States License. To view a copy of this license, visit 
# http://creativecommons.org/licenses/by/3.0/us/ or send a letter to Creative
# Commons, 171 Second Street, Suite 300, San Francisco, California, 94105, USA.

# from http://oranlooney.com/make-css-sprites-python-image-library/ 
# Orignial Author Oran Looney <olooney@gmail.com>

mvidalgarcia

WITH reserv_data AS (
    SELECT nextval('roombooking.reservation_links_id_seq') AS new_link_id, id AS reserv_id, event_id
    FROM roombooking.reservations
    WHERE event_id IS NOT NULL
    -- LIMIT 2
), link_ids_data AS (
    INSERT INTO roombooking.reservation_links (id, event_id, linked_event_id, link_type)
    SELECT new_link_id, event_id, event_id, 2 -- LinkType.event
    FROM reserv_data
    RETURNING id AS link_id

mvidalgarcia

-- upgrade

WITH reserv_data AS (
    SELECT nextval('roombooking.reservation_links_id_seq') AS new_link_id, id AS reserv_id, event_id
    FROM roombooking.reservations
    WHERE event_id IS NOT NULL
    -- LIMIT 2
), link_ids_data AS (
    INSERT INTO roombooking.reservation_links (id, event_id, linked_event_id, link_type)
    SELECT new_link_id, event_id, event_id, 2 -- LinkType.event

mvidalgarcia

def upgrade():
    op.create_table(
        'reservation_links',
        sa.Column('id', sa.Integer(), nullable=False),
        sa.Column('event_id', sa.Integer(), nullable=True, index=True),
        sa.Column('linked_event_id', sa.Integer(), nullable=True, index=True),
        sa.Column('contribution_id', sa.Integer(), nullable=True, index=True),
        sa.Column('session_block_id', sa.Integer(), nullable=True, index=True),
        sa.Column('link_type',
                  PyIntEnum(LinkType, exclude_values={LinkType.category, LinkType.subcontribution, LinkType.session}),

mvidalgarcia

db.session.add(RoomAttribute(name="long-term", title="Long term", is_hidden=True))

ra = RoomAttribute.query.filter_by(name='long-term').one() # Burotel
for r in Room.query.order_by(Room.id.asc()).limit(100):
    RoomAttributeAssociation(room=r, attribute=ra, value='true')
    
db.session.commit()