コード例 #1
0
ファイル: entities.py プロジェクト: flavioafa/places.br
class LegacyMunicipality(LegacyEntity):
    '''
    Legacy entity for municipalities.
    '''
    __table__ = Table(
        _('municipalities'),
        LegacyEntity.metadata,
        Column(_('id'),
               Integer,
               nullable=False,
               primary_key=True),
        Column(_('state_id'),
               SmallInteger,
               ForeignKey(_('states.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('name'),
               String(64),
               nullable=False,
               index=True)
    )

    # Columns mapping
    __columns__ = {
        _('id'): 'municipality_id',
        _('state_id'): 'state_id',
        _('name'): 'municipality_name',
    }
コード例 #2
0
ファイル: entities.py プロジェクト: flavioafa/places.br
class Mesoregion(Entity):
    '''
    Entity for mesoregions.
    '''
    __table__ = Table(
        _('mesoregions'),
        Entity.metadata,
        Column(_('id'),
               SmallInteger,
               nullable=False,
               primary_key=True),
        Column(_('state_id'),
               SmallInteger,
               ForeignKey(_('states.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('name'),
               String(64),
               nullable=False,
               index=True)
    )

    # Columns mapping
    __columns__ = {
        _('id'): 'mesoregion_id',
        _('state_id'): 'state_id',
        _('name'): 'mesoregion_name',
    }
コード例 #3
0
    def renderDatasetRecords(self):
        '''
        Renders the dataset records counts.

        Returns:
            str: The dataset records counts
        '''
        headers = ['Table', 'Records']
        alignment = ['>', '>']
        datasets = DatasetUtils.getDatasetsByLocale(self._locale)
        data = [[
            Markdown.code(_(entity.table)),
            '{:,d}'.format(len(datasets[self._dataset.year][_(entity.table)]))
        ] for entity in Entities
                if _(entity.table) in datasets[self._dataset.year]]

        return Markdown.table([headers] + data, alignment)
コード例 #4
0
    def renderDatasetRecords(self):
        """
        Renders the dataset records counts.

        Returns:
            str: The dataset records counts
        """
        headers = ["Table", "Records"]
        alignment = [">", ">"]
        datasets = DatasetUtils.getDatasetsByLocale(self._locale)
        data = [
            [Markdown.code(_(entity.table)), "{:,d}".format(len(datasets[self._dataset.year][_(entity.table)]))]
            for entity in Entities
            if _(entity.table) in datasets[self._dataset.year]
        ]

        return Markdown.table([headers] + data, alignment)
コード例 #5
0
ファイル: entities.py プロジェクト: flavioafa/places.br
    def __init__(self, name, **rules):
        '''
        Constructor.

        Arguments:
            name (str): The column name
            rules (dict): The column rules
        '''
        self.name = name
        self.localized_name = _(name)
        self.rules = rules
コード例 #6
0
    def renderDatasetRecords(self):
        """
        Renders the available dataset records counts.

        Returns:
            str: The available dataset records counts
        """
        headers = ["Dataset"] + [Markdown.code(entity.table) for entity in Entities]
        alignment = [">"] * 7
        datasets = DatasetUtils.getDatasetsByLocale("pt")
        data = [
            [Markdown.bold(dataset)]
            + [
                "{:,d}".format(len(datasets[dataset][_(entity.table)])) if _(entity.table) in datasets[dataset] else "-"
                for entity in Entities
            ]
            for dataset in datasets
        ]

        return Markdown.table([headers] + data, alignment)
コード例 #7
0
    def renderDatasetRecords(self):
        '''
        Renders the available dataset records counts.

        Returns:
            str: The available dataset records counts
        '''
        headers = ['Dataset'
                   ] + [Markdown.code(entity.table) for entity in Entities]
        alignment = ['>'] * 7
        datasets = DatasetUtils.getDatasetsByLocale('pt')
        data = [
            [Markdown.bold(dataset)] + [
                '{:,d}'.format(len(datasets[dataset][_(entity.table)])) \
                    if _(entity.table) in datasets[dataset] else '-'
                for entity in Entities
            ]
            for dataset in datasets
        ]

        return Markdown.table([headers] + data, alignment)
コード例 #8
0
ファイル: entities.py プロジェクト: flavioafa/places.br
class State(Entity):
    '''
    Entity for states.
    '''
    __table__ = Table(
        _('states'),
        Entity.metadata,
        Column(_('id'),
               SmallInteger,
               nullable=False,
               primary_key=True),
        Column(_('name'),
               String(32),
               nullable=False,
               index=True)
    )

    # Columns mapping
    __columns__ = {
        _('id'): 'state_id',
        _('name'): 'state_name',
    }
コード例 #9
0
ファイル: entities.py プロジェクト: flavioafa/places.br
class Subdistrict(Entity):
    '''
    Entity for subdistricts.
    '''
    __table__ = Table(
        _('subdistricts'),
        Entity.metadata,
        Column(_('id'),
               BigInteger,
               nullable=False,
               primary_key=True),
        Column(_('district_id'),
               Integer,
               ForeignKey(_('districts.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('municipality_id'),
               Integer,
               ForeignKey(_('municipalities.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('microregion_id'),
               Integer,
               ForeignKey(_('microregions.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('mesoregion_id'),
               SmallInteger,
               ForeignKey(_('mesoregions.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('state_id'),
               SmallInteger,
               ForeignKey(_('states.id'), use_alter=True),
               nullable=False,
               index=True),
        Column(_('name'),
               String(64),
               nullable=False,
               index=True)
    )

    # Columns mapping
    __columns__ = {
        _('id'): 'subdistrict_id',
        _('district_id'): 'district_id',
        _('municipality_id'): 'municipality_id',
        _('microregion_id'): 'microregion_id',
        _('mesoregion_id'): 'mesoregion_id',
        _('state_id'): 'state_id',
        _('name'): 'subdistrict_name',
    }