[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[Git][snapshot-team/snapshot][master] set stat_result.size to bigint. closes: #913940



Title: GitLab

Peter Palfrader pushed to branch master at snapshot / snapshot

Commits:

1 changed file:

Changes:

  • db/upgrade_21.py
    1
    +#!/usr/bin/python
    
    2
    +#
    
    3
    +# Copyright (c) 2018 Peter Palfrader
    
    4
    +#
    
    5
    +# Permission is hereby granted, free of charge, to any person obtaining a copy
    
    6
    +# of this software and associated documentation files (the "Software"), to deal
    
    7
    +# in the Software without restriction, including without limitation the rights
    
    8
    +# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
    
    9
    +# copies of the Software, and to permit persons to whom the Software is
    
    10
    +# furnished to do so, subject to the following conditions:
    
    11
    +#
    
    12
    +# The above copyright notice and this permission notice shall be included in
    
    13
    +# all copies or substantial portions of the Software.
    
    14
    +#
    
    15
    +# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
    
    16
    +# IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
    
    17
    +# FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
    
    18
    +# AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
    
    19
    +# LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
    
    20
    +# OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
    
    21
    +# SOFTWARE.
    
    22
    +
    
    23
    +def upgrade(db):
    
    24
    +    """We have now files >= 2gb in the archive: adapt stat_result also."""
    
    25
    +    db.execute("""
    
    26
    +        ALTER TYPE stat_result ALTER ATTRIBUTE size TYPE BIGINT;
    
    27
    +        """)
    
    28
    +
    
    29
    +    db.execute("UPDATE config SET value='21' WHERE name='db_revision' AND value='20'")
    
    30
    +
    
    31
    +# vim:set et:
    
    32
    +# vim:set ts=4:
    
    33
    +# vim:set shiftwidth=4:


  • Reply to: