Revision 29148653 snf-pithos-backend/pithos/backends/lib/sqlalchemy/alembic/versions/27381099d477_alter_public_add_col.py

b/snf-pithos-backend/pithos/backends/lib/sqlalchemy/alembic/versions/27381099d477_alter_public_add_col.py
16 16 
from pithos.backends.modular import ULTIMATE_ANSWER
17 17 
from pithos.api.short_url import encode_url
18 18 

  		





  
  19
  
    

  		





  19
  20
  
    
def upgrade():


  		





  20
  21
  
    
    op.add_column('public', sa.Column('url', sa.String(2048)))


  		





  21
  22
  
    
    op.create_unique_constraint('idx_public_url', 'public', ['url'])


  		





  ......




  31
  32
  
    
    s = sa.select([p.c.public_id])


  		





  32
  33
  
    
    rows = conn.execute(s).fetchall()


  		





  33
  34
  
    
    for r in rows:


  		





  34
  
  
    
        s = p.update().values(url=get_url(r[0])).where(p.c.public_id==r[0])


  		





  
  35
  
    
        s = p.update().values(url=get_url(r[0])).where(p.c.public_id == r[0])


  		





  35
  36
  
    
        op.execute(s)


  		





  36
  37
  
    

  		





  
  38
  
    

  		





  37
  39
  
    
def downgrade():


  		





  38
  40
  
    
    op.drop_constraint('idx_public_url', 'public')


  		





  39
  41
  
    
    op.drop_column('public', 'url')


  		












Also available in:
  Unified diff