Skip to content

oarepo_oaipmh_harvester.alembic.1791708839_oai_harvest_records_utc_datetimes

oarepo_oaipmh_harvester.alembic.1791708839_oai_harvest_records_utc_datetimes

Store oai harvest record datestamp and harvested_at as timezone aware (UTC) timestamps.

upgrade() -> None

Upgrade database.

Source code in oarepo_oaipmh_harvester/alembic/1791708839_oai_harvest_records_utc_datetimes.py 
20
21
22
23
24
25
26
27
28
29
30
31
def upgrade() -> None:
    """Upgrade database."""
    for column in COLUMNS:
        # existing naive values are UTC
        op.alter_column(
            "oai_harvest_records",
            column,
            type_=sa.DateTime(timezone=True),
            existing_type=sa.DateTime(),
            existing_nullable=False,
            postgresql_using=f"{column} AT TIME ZONE 'UTC'",
        )

downgrade() -> None

Downgrade database.

Source code in oarepo_oaipmh_harvester/alembic/1791708839_oai_harvest_records_utc_datetimes.py 
34
35
36
37
38
39
40
41
42
43
44
def downgrade() -> None:
    """Downgrade database."""
    for column in COLUMNS:
        op.alter_column(
            "oai_harvest_records",
            column,
            type_=sa.DateTime(),
            existing_type=sa.DateTime(timezone=True),
            existing_nullable=False,
            postgresql_using=f"{column} AT TIME ZONE 'UTC'",
        )