from django.contrib.gis.geos import Point
from data_collection.management.commands import BaseXpressDemocracyClubCsvImporter


class Command(BaseXpressDemocracyClubCsvImporter):
    council_id = "E06000044"
    addresses_name = "local.2018-05-03/Version 1/Democracy_Club__03May2018.tsv"
    stations_name = "local.2018-05-03/Version 1/Democracy_Club__03May2018.tsv"
    elections = ["local.2018-05-03"]
    csv_delimiter = "\t"

    def address_record_to_dict(self, record):

        if record.addressline6 == "PO1 5BZ":
            return None

        return super().address_record_to_dict(record)

    def station_record_to_dict(self, record):
        rec = super().station_record_to_dict(record)

        if rec["internal_council_id"] == "3270":
            rec["location"] = Point(-1.059545, 50.7866578, srid=4326)

        return rec

from django.contrib.gis.geos import Point
from data_collection.management.commands import BaseXpressDemocracyClubCsvImporter


class Command(BaseXpressDemocracyClubCsvImporter):
    council_id = "E06000044"
    addresses_name = (
        "local.2019-05-02/Version 1/Democracy_Club__02May2019Portsmouth.tsv"
    )
    stations_name = "local.2019-05-02/Version 1/Democracy_Club__02May2019Portsmouth.tsv"
    elections = ["local.2019-05-02"]
    csv_delimiter = "\t"

    def address_record_to_dict(self, record):
        rec = super().address_record_to_dict(record)

        if record.addressline6 == "PO4 099":
            rec["postcode"] = "PO4 0PL"

        if record.property_urn.strip().lstrip("0") in [
            "1775122942",
            "1775122943",
            "1775122944",
        ]:
            rec["postcode"] = "PO5 2BZ"

        return rec

    def station_record_to_dict(self, record):
        rec = super().station_record_to_dict(record)

        if rec["internal_council_id"] == "3596":
            rec["location"] = Point(-1.059545, 50.7866578, srid=4326)

        return rec

Add import script for Portsmouth
Add import script for Portsmouth

Closes #1502
