dataimport/test/data-massimport/schema.py
author Julien Cristau <julien.cristau@logilab.fr>
Mon, 14 Dec 2015 14:55:10 +0100
changeset 10987 a945fe89b33f
permissions -rw-r--r--
[dataimport] add tests for SQLGenObjectStore (closes #9177565) Stolen from the massive import store, with the irrelevant bits removed. Remove redundant tests from test_pgstore.py.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
10987
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     1
# copyright 2011 LOGILAB S.A. (Paris, FRANCE), all rights reserved.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     2
# contact http://www.logilab.fr -- mailto:contact@logilab.fr
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     3
#
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     4
# This program is free software: you can redistribute it and/or modify it under
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     5
# the terms of the GNU Lesser General Public License as published by the Free
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     6
# Software Foundation, either version 2.1 of the License, or (at your option)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     7
# any later version.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     8
#
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
     9
# This program is distributed in the hope that it will be useful, but WITHOUT
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    10
# ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    11
# FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    12
# details.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    13
#
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    14
# You should have received a copy of the GNU Lesser General Public License along
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    15
# with this program. If not, see <http://www.gnu.org/licenses/>.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    16
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    17
"""cubicweb-geonames schema"""
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    18
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    19
from yams.buildobjs import (EntityType, RelationDefinition, SubjectRelation,
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    20
			    String, Int, BigInt, Float, Date)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    21
from cubicweb.schemas.base import ExternalUri
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    22
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    23
"""
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    24
See geonames readme.txt for more details.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    25
"""
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    26
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    27
class TestLocation(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    28
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    29
    Entity type for location of Geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    30
    See cities1000.zip, cities5000.zip, cities15000.zip and allCountries.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    31
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    32
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    33
    geonameid = Int(required=True, unique=True, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    34
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    35
class Location(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    36
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    37
    Entity type for location of Geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    38
    See cities1000.zip, cities5000.zip, cities15000.zip and allCountries.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    39
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    40
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    41
    geonameid = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    42
    asciiname = String(maxsize=200, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    43
    alternatenames = String(fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    44
    names = SubjectRelation('LocationName', cardinality='**')
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    45
    latitude = Float(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    46
    longitude = Float(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    47
    feature_class = String(maxsize=1, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    48
    feature_code = SubjectRelation('FeatureCode', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    49
    country = SubjectRelation('Country', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    50
    alternate_country_code = String(maxsize=60)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    51
    main_administrative_region = SubjectRelation('AdministrativeRegion', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    52
    second_administrative_region = SubjectRelation('AdministrativeRegion', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    53
    admin_code_1 = String(maxsize=124)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    54
    admin_code_2 = String(maxsize=124)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    55
    admin_code_3 = String(maxsize=20)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    56
    admin_code_4 = String(maxsize=20)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    57
    population = BigInt(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    58
    elevation = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    59
    gtopo30 = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    60
    timezone = SubjectRelation('TimeZone', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    61
    geonames_date = Date()
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    62
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    63
class LocationName(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    64
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    65
    Name of a Location
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    66
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    67
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    68
    language = SubjectRelation('Language', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    69
    alternatenamesid = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    70
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    71
class FeatureCode(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    72
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    73
    Entity type for feature codes of Geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    74
    See featureCodes_en.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    75
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    76
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    77
    main_code = String(maxsize=1, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    78
    code = String(maxsize=12)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    79
    description = String(maxsize=1024, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    80
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    81
class AdministrativeRegion(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    82
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    83
    Entity type for administrative regions of Geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    84
    See admin1CodesASCII.txt and admin2Codes.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    85
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    86
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    87
    code = String(maxsize=64, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    88
    country = SubjectRelation('Country', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    89
    geonameid = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    90
    asciiname = String(maxsize=200, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    91
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    92
class Language(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    93
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    94
    Entity type for languages of Geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    95
    See admin1CodesASCII.txt and admin2Codes.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    96
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    97
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    98
    iso_639_3 = String(maxsize=3, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
    99
    iso_639_2 = String(maxsize=64, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   100
    iso_639_1 = String(maxsize=3, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   101
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   102
class Continent(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   103
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   104
    Entity type for continents of geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   105
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   106
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   107
    code = String(maxsize=2, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   108
    geonameid = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   109
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   110
class Country(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   111
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   112
    Entity type for countries of geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   113
    See countryInfo.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   114
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   115
    name = String(maxsize=1024, indexed=True, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   116
    code = String(maxsize=2, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   117
    code3 = String(maxsize=3, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   118
    codenum = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   119
    fips = String(maxsize=2)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   120
    capital = String(maxsize=1024, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   121
    area = Float(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   122
    population = BigInt(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   123
    continent_code = String(maxsize=3)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   124
    continent = SubjectRelation('Continent', cardinality='?*', inlined=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   125
    tld = String(maxsize=64)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   126
    currency = String(maxsize=1024, fulltextindexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   127
    currency_code = String(maxsize=64)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   128
    geonameid = Int(indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   129
    phone = String(maxsize=64)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   130
    postal_code = String(maxsize=200)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   131
    postal_code_regex = String(maxsize=200)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   132
    languages_code = String(maxsize=200)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   133
    neighbours_code = String(maxsize=200)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   134
    equivalent_fips = String(maxsize=2)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   135
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   136
class TimeZone(EntityType):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   137
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   138
    Entity type for timezone of geonames.
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   139
    See timeZones.txt
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   140
    """
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   141
    code = String(maxsize=1024, indexed=True)
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   142
    gmt = Float()
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   143
    dst = Float()
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   144
    raw_offset = Float()
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   145
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   146
class used_language(RelationDefinition):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   147
    subject = 'Country'
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   148
    object = 'Language'
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   149
    cardinality = '**'
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   150
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   151
class neighbour_of(RelationDefinition):
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   152
    subject = 'Country'
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   153
    object = 'Country'
a945fe89b33f [dataimport] add tests for SQLGenObjectStore (closes #9177565)
Julien Cristau <julien.cristau@logilab.fr>
parents:
diff changeset
   154
    cardinality = '**'