"""add_other_in_user_generated_columns

Revision ID: f924744476d3
Revises: 9ba06b599b77
Create Date: 2020-10-06 14:01:49.605016

"""

# revision identifiers, used by Alembic.
revision = 'f924744476d3'
down_revision = '9ba06b599b77'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():

    # Add columns in a single statement to rewrite table only once.
    op.execute('''
      alter table in_user
      add column full_name text generated always as (page_data->'entry_data'->'ProfilePage'->0->'user'->>'full_name') stored,
      add column biography text generated always as (page_data->'entry_data'->'ProfilePage'->0->'user'->>'biography') stored,
      add column external_url text generated always as (page_data->'entry_data'->'ProfilePage'->0->'user'->>'external_url') stored;
    ''')

def downgrade():
    op.drop_column('in_user', 'full_name')
    op.drop_column('in_user', 'biography')
    op.drop_column('in_user', 'external_url')