示例#1
0
class Picture(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    orga = db.Column(db.Integer)
    name = db.Column(db.String(80))
    filename = db.Column(db.String(255))
    radiotext = db.Column(db.String(255))
    radiolink = db.Column(db.String(255))
    image_url_prefix = db.Column(db.String(255))

    channels = db.relationship('Channel',
                               backref='default_picture',
                               lazy='dynamic')

    def __init__(self, orga):
        self.orga = orga

    def __repr__(self):
        return '<Picture %r[%s]>' % (self.name, self.orga)

    @property
    def clean_filename(self):
        if not self.filename:
            return ''

        return self.filename.split('/')[-1]

    @property
    def public_url(self):
        return "%s%s" % (self.image_url_prefix, self.filename)

    @property
    def json(self):
        return to_json(self, self.__class__, ['clean_filename', 'public_url'])
示例#2
0
class Users(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(255), nullable=False, unique=True)
    name = db.Column(db.String(50), nullable=False)
    profile_pic = db.Column(db.String(), nullable=False)
    owned_recipes = db.relationship('Recipe', backref='user', lazy=True)
    shared_recipes = db.Column(db.PickleType)
    saved_recipes = db.Column(db.PickleType)
    shopping_list = db.Column(db.PickleType)
示例#3
0
class GenericServiceFollowingEntry(db.Model):
    """A generic entry for service following"""
    """If channel id is set, object is linked to a channel, otherwise station_id and channel_uri must be set, linking to a station"""

    id = db.Column(db.Integer, primary_key=True)

    active = db.Column(db.Boolean)
    cost = db.Column(db.Integer)
    offset = db.Column(db.Integer)
    mime_type = db.Column(db.String(255))
    bitrate = db.Column(db.Integer)

    channel_id = db.Column(db.Integer,
                           db.ForeignKey('channel.id'),
                           nullable=True)

    station_id = db.Column(db.Integer,
                           db.ForeignKey('station.id'),
                           nullable=True)
    channel_uri = db.Column(db.String(255), nullable=True)

    @property
    def channel_name(self):
        """The name of the channel, if linked to a channel"""
        if self.channel:
            return self.channel.name
        return ''

    @property
    def channel_type(self):
        """The type of the channel, if linked to a channel"""
        if self.channel:
            return self.channel.type_id
        return ''

    @property
    def uri(self):
        """The uri to use"""
        if self.channel:
            return self.channel.epg_uri
        else:
            return self.channel_uri

    @property
    def type(self):
        if self.channel:
            return 'channel'
        else:
            return 'ip'

    @property
    def json(self):
        return to_json(self, self.__class__,
                       ['channel_name', 'uri', 'type', 'channel_type'])
示例#4
0
class CountryCode(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))
    iso = db.Column(db.String(2), index=True)
    cc = db.Column(db.String(3))
    __tablename__ = "country_code"

    def __repr__(self):
        return '<Cc %r>' % self.name

    @property
    def json(self):
        return to_json(self, self.__class__)
示例#5
0
class Recipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(150), nullable=False)
    description = db.Column(db.String())
    images = db.Column(db.PickleType, nullable=False)
    user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False)
    difficulty = db.Column(db.String(50),
                           db.ForeignKey('levels.difficulty'),
                           nullable=False)
    ingredients = db.Column(db.PickleType, nullable=False)
    tags = db.relationship('Tag', secondary=tags, back_populates='recipes')
    instructions = db.Column(db.PickleType, nullable=False)
    ready_in_minutes = db.Column(db.Integer, nullable=False)
    servings = db.Column(db.Integer, nullable=False)
示例#6
0
class Ecc(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255))
    iso = db.Column(db.String(2), index=True)
    pi = db.Column(db.String(2))
    ecc = db.Column(db.String(3))
    __table_args__ = (db.Index('ix_ecc_pi_ecc', "pi", "ecc"), )

    def __repr__(self):
        return '<Ecc %r>' % self.name

    @property
    def json(self):
        return to_json(self, self.__class__)
示例#7
0
class Clients(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(500))
    orga = db.Column(db.Integer)
    identifier = db.Column(db.String(128))
    email = db.Column(db.String(255))

    def __eq__(self, other):
        return other is not None and self.id == other.id

    def __hash__(self):
        return self.id

    @property
    def json(self):
        return to_json(self, self.__class__)
示例#8
0
class Recipe(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    title = db.Column(db.String(150), nullable=False)
    description = db.Column(db.String())
    number_of_forks = db.Column(db.Integer)
    forked_from_recipe = db.Column(db.Integer)
    images = db.Column(db.PickleType, nullable=False)
    user_submitted_images = db.Column(db.PickleType)
    videos = db.Column(db.PickleType)
    user_id = db.Column(db.Integer, db.ForeignKey("users.id"), nullable=False)
    difficulty = db.Column(db.String(50),
                           db.ForeignKey("levels.difficulty"),
                           nullable=False)
    ingredients = db.Column(db.PickleType, nullable=False)
    tags = db.relationship("Tag", secondary=tags, back_populates="recipes")
    instructions = db.Column(db.PickleType, nullable=False)
    ready_in_minutes = db.Column(db.Integer, nullable=False)
    servings = db.Column(db.Integer, nullable=False)
    ratings = db.relationship("Rating", backref="recipe", lazy=True)
示例#9
0
class Show(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    orga = db.Column(db.Integer)
    medium_name = db.Column(db.String(255))
    long_name = db.Column(db.String(255))
    description = db.Column(db.String(255))
    color = db.Column(db.String(7))

    station_id = db.Column(db.Integer, db.ForeignKey('station.id'))

    schedules = db.relationship('Schedule', backref='show', lazy='dynamic')

    def __init__(self, orga):
        self.orga = orga

    def __repr__(self):
        return '<Show %r[%s]>' % (self.medium_name, self.orga)

    @property
    def json(self):
        return to_json(self, self.__class__, [])
示例#10
0
class LogEntry(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    topic = db.Column(db.String(255), index=True)
    body = db.Column(db.Text())
    headers = db.Column(db.Text())
    reception_timestamp = db.Column(db.Integer(), index=True)

    @property
    def reception_date(self):
        return datetime.datetime.fromtimestamp(self.reception_timestamp)

    @property
    def json(self):
        return to_json(self, self.__class__, ['reception_date'])
示例#11
0
class Tag(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255), unique=True)
    recipes = db.relationship("Recipe", secondary=tags, back_populates="tags")
示例#12
0
class Levels(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    difficulty = db.Column(db.String(50), unique=True)
    recipes = db.relationship("Recipe", backref="levels", lazy=True)
示例#13
0
class LogoImage(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    orga = db.Column(db.Integer)
    codops = db.Column(db.String(255))

    name = db.Column(db.String(255))
    filename = db.Column(db.String(255))

    url32x32 = db.Column(db.String(255))
    url112x32 = db.Column(db.String(255))
    url128x128 = db.Column(db.String(255))
    url320x240 = db.Column(db.String(255))
    url600x600 = db.Column(db.String(255))

    service_provider_id = db.Column(db.Integer,
                                    db.ForeignKey('service_provider.id'))
    service_provider = db.relationship("ServiceProvider",
                                       backref='logo_images',
                                       uselist=False,
                                       foreign_keys=[service_provider_id])

    stations = db.relationship('Station',
                               backref='epg_picture',
                               lazy='dynamic')

    def __init__(self, orga):
        self.orga = orga

    def __repr__(self):
        return '<LogoImage %r[%s]>' % (self.filename, self.orga)

    @property
    def clean_filename(self):
        if not self.filename:
            return ''

        return self.filename.split('/')[-1]

    @property
    def public_url(self):
        if self.service_provider:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.filename)
        else:
            return None

    @property
    def public_32x32_url(self):
        if self.url32x32:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.url32x32)
        else:
            return self.public_url

    @property
    def public_112x32_url(self):
        if self.url112x32:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.url112x32)
        else:
            return self.public_url

    @property
    def public_128x128_url(self):
        if self.url128x128:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.url128x128)
        else:
            return self.public_url

    @property
    def public_320x240_url(self):
        if self.url320x240:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.url320x240)
        else:
            return self.public_url

    @property
    def public_600x600_url(self):
        if self.url600x600:
            return "%s%s" % (self.service_provider.image_url_prefix,
                             self.url600x600)
        else:
            return self.public_url

    @property
    def json(self):
        return to_json(self, self.__class__, [
            'clean_filename', 'public_url', 'public_32x32_url',
            'public_112x32_url', 'public_128x128_url', 'public_320x240_url',
            'public_600x600_url'
        ])
示例#14
0
class Channel(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    station_id = db.Column(db.Integer, db.ForeignKey('station.id'))
    name = db.Column(db.String(255))

    TYPE_ID_CHOICES = [
        ('fm', 'VHF/FM', ['ecc_id', 'pi', 'frequency']),
        ('dab', 'DAB',
         ['ecc_id', 'eid', 'sid', 'scids', 'appty_uatype', 'pa', 'mime_type']),
        ('drm', 'DRM', ['sid']), ('amss', 'AMSS', ['sid']),
        ('hd', 'HD Radio', ['cc', 'tx']),
        ('id', 'IP',
         ['fqdn', 'serviceIdentifier', 'stream_url', 'mime_type', 'bitrate'])
    ]
    TO_IGNORE_IN_DNS = ['stream_url', 'mime_type', 'bitrate']

    type_id = db.Column(db.String(5), index=True)

    ecc_id = db.Column(db.Integer, db.ForeignKey('ecc.id'))

    pi = db.Column(db.String(4))
    frequency = db.Column(db.String(5))

    eid = db.Column(db.String(4))
    sid = db.Column(db.String(8))
    scids = db.Column(db.String(3))

    appty_uatype = db.Column(db.String(6))
    pa = db.Column(db.Integer)

    stream_url = db.Column(db.String(255))
    bitrate = db.Column(db.Integer)
    mime_type = db.Column(db.String(64))

    tx = db.Column(db.String(5))
    cc = db.Column(db.String(3))

    fqdn = db.Column(db.String(255))
    serviceIdentifier = db.Column(db.String(16))

    fk_client = db.Column(
        db.Integer,
        db.ForeignKey('clients.id',
                      use_alter=True,
                      name='channel_clients_id_fk'))
    client = db.relationship("Clients", foreign_keys=[fk_client])

    default_picture_id = db.Column(db.Integer, db.ForeignKey('picture.id'))

    servicefollowingentries = db.relationship('GenericServiceFollowingEntry',
                                              backref='channel',
                                              lazy='dynamic')

    def __repr__(self):
        return '<Channel %r[%s]>' % (self.name, self.station.__repr__)

    def updateservicefollowingentry(self):
        """Updates the existing service following entry linked to the channel if one"""
        entries = self.servicefollowingentries.all()
        for entry in entries:
            if self.type_id == 'dab' and not self.mime_type:
                entry.mime_type = 'audio/mpeg'
            else:
                entry.mime_type = self.mime_type
            if self.type_id == 'id' and not self.mime_type:
                entry.mime_type = 'audio/mpeg'
            else:
                entry.mime_type = self.mime_type
            if self.type_id == 'id' and not self.bitrate:
                entry.bitrate = 128
            else:
                entry.bitrate = self.bitrate

        db.session.commit()

    @property
    def servicefollowingentry(self):
        """Return (or create) the associated service following entry"""

        # Find in exisiting objects
        entries = self.servicefollowingentries.all()
        if len(entries) > 0:
            return entries[0]

        # Create a new one

        object = GenericServiceFollowingEntry()
        object.channel_id = self.id
        object.active = True
        object.cost = 100
        object.offset = 0

        # Mime Type and default values
        if self.type_id == 'id':
            object.cost = 100
            object.offset = 2000
            if not self.mime_type:
                object.mime_type = 'audio/mpeg'
            else:
                object.mime_type = self.mime_type
            if not self.bitrate:
                object.bitrate = 128
            else:
                object.bitrate = self.bitrate
        if self.type_id == 'fm':
            object.cost = 50
        if self.type_id == 'dab':
            object.cost = 20
            if not self.mime_type:
                object.mime_type = 'audio/mpeg'
            else:
                object.mime_type = self.mime_type

        db.session.add(object)
        db.session.commit()

        return object

    @property
    def service_identifier(self):
        ecc = Ecc.query.filter_by(id=self.ecc_id).first()
        gcc = ecc.pi + ecc.ecc
        if self.type_id == "fm":
            return "fm/{}/{}/{}".format(gcc, self.pi, self.frequency)
        elif self.type_id == "dab":
            return "dab/{}/{}/{}/{}".format(gcc, self.eid, self.sid,
                                            self.scids)

    @property
    def topic(self):
        return self.topic_no_slash + '/'

    @property
    def topic_no_slash(self):
        return '/topic/' + '/'.join(self.dns_entry.split('.')[::-1])

    def generate_dns_entry(self, return_iso):
        val = self.type_id
        for (t, _, props) in Channel.TYPE_ID_CHOICES:
            if t == self.type_id:
                for v in props:
                    if getattr(self, v) is not None:
                        value = str(getattr(self, v)).lower()

                        if v == 'ecc_id':  # Special case
                            cc_obj = Ecc.query.filter_by(id=value).first()
                            if return_iso:
                                value = (cc_obj.iso).lower()
                            else:
                                value = (cc_obj.pi + cc_obj.ecc).lower()

                        if v not in Channel.TO_IGNORE_IN_DNS:  # Ignore certain values
                            val = value + '.' + val
        return val

    @property
    def dns_entry(self):
        return self.generate_dns_entry(False)

    @property
    def dns_entry_iso(self):
        return self.generate_dns_entry(True)

    @property
    def radiodns_entry(self):
        return self.dns_entry + '.radiodns.org.'

    @property
    def station_name(self):
        if self.station:
            return self.station.name
        else:
            return ''

    @property
    def station_ascii_name(self):
        if self.station:
            return self.station.ascii_name
        else:
            return ''

    @property
    def default_picture_data(self):
        if self.default_picture:
            return self.default_picture.json
        else:
            return None

    @property
    def json(self):
        return to_json(self, self.__class__, [
            'topic', 'station_json', 'radiodns_entry', 'station_name',
            'station_ascii_name', 'default_picture_data', 'topic_no_slash',
            'client_json'
        ])

    @property
    def client_json(self):
        return self.client.json if self.client else {'name': 'default'}

    @property
    def station_json(self):
        if self.station:
            return self.station.json
        else:
            return None

    @property
    def dns_values(self):
        fqdn = ''
        vis = ''
        epg = ''
        tag = ''

        dns_entry = self.radiodns_entry

        # Special case with *
        if dns_entry[0] == '*':
            dns_entry = '10800' + dns_entry[1:]

        # Find radiodns servers
        ns = str(dns.resolver.query('radiodns.org', 'NS')[0])
        ip = str(dns.resolver.query(ns, 'A')[0])

        # Build a resolver using radiodns.org nameserver, timeout of 2, to be sure to have the latested FQDN
        resolver = dns.resolver.Resolver()
        resolver.lifetime = 2  # Timeout of 2
        resolver.nameservers = [ip]  # Use radiodns.org servers

        try:
            fqdn = str(resolver.query(dns_entry, 'CNAME')[0])
        except:
            pass

        # Build resolver for others queries using local nameserver
        resolver = dns.resolver.Resolver()
        resolver.lifetime = 2  # Timeout of 2

        if fqdn:
            try:
                vis = str(resolver.query('_radiovis._tcp.' + fqdn, 'SRV')[0])
            except:
                pass

            try:
                epg = str(resolver.query('_radioepg._tcp.' + fqdn, 'SRV')[0])
            except:
                pass

            try:
                tag = str(resolver.query('_radiotag._tcp.' + fqdn, 'SRV')[0])
            except:
                pass

        return (fqdn, vis, epg, tag)

    @property
    def epg_uri(self):

        # Special Case Urls / Streaming / Ip / Ids
        if self.type_id == 'id' and self.stream_url:
            return self.stream_url

        splited = self.dns_entry.split('.')
        return splited[-1] + ':' + '.'.join(splited[::-1][1:])
示例#15
0
class ServiceProvider(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    codops = db.Column(db.String(255), index=True)

    short_name = db.Column(db.String(8))
    medium_name = db.Column(db.String(16))
    long_name = db.Column(db.String(128))
    short_description = db.Column(db.String(180))
    long_description = db.Column(db.String(1200))
    url_default = db.Column(db.String(255))

    postal_name = db.Column(db.String(255))
    street = db.Column(db.String(255))
    city = db.Column(db.String(255))
    zipcode = db.Column(db.String(25))
    phone_number = db.Column(db.String(128))

    keywords = db.Column(db.String(255))

    default_language = db.Column(db.String(5))

    location_country = db.Column(db.String(5))

    default_logo_image_id = db.Column(
        db.Integer,
        db.ForeignKey('logo_image.id',
                      use_alter=True,
                      name='fk_default_logo_id'))
    default_logo_image = db.relationship("LogoImage",
                                         foreign_keys=[default_logo_image_id])

    stations = db.relationship('Station',
                               backref='service_provider',
                               lazy='dynamic')

    def __init__(self, codops):
        self.codops = codops

    def __eq__(self, other):
        return other is not None and self.id == other.id

    def check_aws(self):
        return awsutils.check_serviceprovider(self)

    def escape_slash_rfc3986(self, value):
        if value:
            return value.replace('/', '%2F')
        return ''

    @property
    def default_logo_image_data(self):
        if self.default_logo_image:
            return self.default_logo_image.json
        else:
            return None

    @property
    def epg_country(self):
        if self.location_country:
            ecc = Ecc.query.filter_by(iso=self.location_country).first()
            if ecc:
                return ecc.name
        return None

    @property
    def epg_postal(self):
        if self.postal_name:
            return "postal:%s/%s/%s/%s/%s" % (self.escape_slash_rfc3986(
                self.postal_name), self.escape_slash_rfc3986(
                    self.street), self.escape_slash_rfc3986(
                        self.city), self.escape_slash_rfc3986(self.zipcode),
                                              self.escape_slash_rfc3986(
                                                  self.epg_country))
        return None

    @property
    def epg_phone_number(self):
        if self.phone_number:
            return "tel:%s" % (self.phone_number)
        return None

    @property
    def fqdn(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(), config.DOMAIN)
        return None

    @property
    def vis_fqdn(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(), config.RADIOVIS_DNS)
        return None

    @property
    def epg_fqdn(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(), config.RADIOEPG_DNS)
        return None

    @property
    def spi_fqdn(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(), config.RADIOSPI_DNS)
        return None

    @property
    def tag_fqdn(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(), config.RADIOTAG_DNS)
        return None

    @property
    def vis_service(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(),
                              config.RADIOVIS_SERVICE_DEFAULT)
        return None

    @property
    def epg_service(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(),
                              config.RADIOEPG_SERVICE_DEFAULT)
        return None

    @property
    def tag_service(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(),
                              config.RADIOTAG_SERVICE_DEFAULT)
        return None

    @property
    def spi_service(self):
        if self.codops:
            return "%s.%s" % (self.codops.lower(),
                              config.RADIOSPI_SERVICE_DEFAULT)
        return None

    @property
    def image_url_prefix(self):
        if config.STANDALONE:
            return config.LOGO_PUBLIC_URL + "/"
        else:
            return awsutils.get_public_urlprefix(self)

    @property
    def json(self):
        return to_json(self, self.__class__, [
            'default_logo_image_data', 'image_url_prefix', 'epg_postal',
            'epg_phone_number', 'epg_country', 'fqdn', 'vis_fqdn', 'epg_fqdn',
            'tag_fqdn', 'vis_service', 'epg_service', 'tag_service'
        ])
示例#16
0
class Station(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    orga = db.Column(db.Integer, index=True)
    parent = db.Column(db.Integer)
    name = db.Column(db.String(80))
    short_name = db.Column(db.String(8))
    medium_name = db.Column(db.String(16))
    long_name = db.Column(db.String(128))
    short_description = db.Column(db.String(180))
    long_description = db.Column(db.String(1200))
    url_default = db.Column(db.String(255))
    random_password = db.Column(db.String(32))

    postal_name = db.Column(db.String(255))
    street = db.Column(db.String(255))
    city = db.Column(db.String(255))
    zipcode = db.Column(db.String(25))
    phone_number = db.Column(db.String(128))
    sms_number = db.Column(db.String(128))
    sms_body = db.Column(db.String(255))
    sms_description = db.Column(db.String(255))
    email_address = db.Column(db.String(255))
    email_description = db.Column(db.String(255))

    keywords = db.Column(db.String(255))

    default_language = db.Column(db.String(5))

    location_country = db.Column(db.String(5))

    # Services
    # fqdn_station_prefix = db.Column(db.String(255)) maybe to add due to filtering issue in Alchemy
    radiovis_enabled = db.Column(db.Boolean, index=True)
    radiovis_service = db.Column(db.String(255))
    radioepg_enabled = db.Column(db.Boolean, index=True)
    radioepgpi_enabled = db.Column(db.Boolean, default=False, index=True)
    radioepg_service = db.Column(db.String(255))
    radiotag_enabled = db.Column(db.Boolean, index=True)
    radiotag_service = db.Column(db.String(255))
    radiospi_enabled = db.Column(db.Boolean, index=True)
    radiospi_service = db.Column(db.String(255))

    service_provider_id = db.Column(db.Integer,
                                    db.ForeignKey('service_provider.id'))

    ip_allowed = db.Column(
        db.String(256))  # A list of ip/subnet, with , between

    genres = db.Column(db.Text())

    channels = db.relationship('Channel', backref='station', lazy='dynamic')
    shows = db.relationship('Show', backref='station', lazy='dynamic')
    schedules = db.relationship('Schedule', backref='station', lazy='dynamic')
    servicefollowingentries = db.relationship('GenericServiceFollowingEntry',
                                              backref='station',
                                              lazy='dynamic')

    # epg_picture_id = db.Column(db.Integer, db.ForeignKey('picture_forEPG.id'))
    default_logo_image_id = db.Column(
        db.Integer,
        db.ForeignKey('logo_image.id',
                      use_alter=True,
                      name='fk_epg_default_logo_id'))
    default_logo_image = db.relationship("LogoImage",
                                         foreign_keys=[default_logo_image_id])

    fk_client = db.Column(
        db.Integer,
        db.ForeignKey('clients.id',
                      use_alter=True,
                      name='station_clients_id_fk'))
    client = db.relationship("Clients", foreign_keys=[fk_client])

    __table_args__ = (db.Index('ix_station_spid_radioepg_enabled',
                               "service_provider_id", "radioepg_enabled"), )

    def __getitem__(self, item):
        return getattr(self, item)

    def __eq__(self, other):
        return other is not None and self.id == other.id

    def escape_slash_rfc3986(self, value):
        if value:
            return value.replace('/', '%2F')
        return None

    @property
    def service_provider_data(self):
        if self.service_provider:
            return self.service_provider.json
        else:
            return None

    @property
    def epg_country(self):
        if self.location_country:
            ecc = Ecc.query.filter_by(iso=self.location_country).first()
            if ecc:
                return ecc.name
        return None

    @property
    def epg_postal(self):
        if self.postal_name:
            return "postal:%s/%s/%s/%s/%s" % (self.escape_slash_rfc3986(
                self.postal_name), self.escape_slash_rfc3986(
                    self.street), self.escape_slash_rfc3986(
                        self.city), self.escape_slash_rfc3986(self.zipcode),
                                              self.escape_slash_rfc3986(
                                                  self.epg_country))
        return None

    @property
    def epg_phone_number(self):
        if self.phone_number:
            return "tel:%s" % (self.phone_number)
        return None

    @property
    def epg_email(self):
        if self.email_address:
            return "mailto:%s" % (self.email_address)
        return None

    @property
    def epg_sms(self):
        if self.sms_body:
            if self.sms_body:
                return "sms:%s?%s" % (
                    self.sms_number, urllib.urlencode({'body': self.sms_body}))
            else:
                return "sms:%s" % (self.sms_number)
        return None

    @property
    def genres_list(self):
        try:
            return json.loads(self.genres)
        except:
            return []

    @property
    def default_logo_image_data(self):
        if self.default_logo_image:
            return self.default_logo_image.json
        else:
            return None

    @property
    def fqdn(self):
        if self.service_provider:
            if self.service_provider.codops:
                return "%s.%s.%s" % (
                    filter(lambda x: x in string.ascii_letters + string.digits,
                           self.ascii_name.lower()),
                    self.service_provider.codops.lower(), config.DOMAIN)
        return None

    @property
    def service_identifier(self):
        if self.service_provider:
            if self.service_provider.codops:
                return "ebu%s%s" % (self.id,
                                    self.service_provider.codops.lower())
        return None

    def __init__(self, orga, name=u''):
        self.orga = orga
        self.name = name

    @property
    def ascii_name(self):
        return unicodedata.normalize('NFKD',
                                     self.name if self.name else u'').encode(
                                         'ascii', 'ignore')

    def gen_random_password(self):
        self.random_password = ''.join(
            random.choice(string.ascii_letters + string.digits)
            for x in range(32))

    def check_aws(self):
        return awsutils.check_station(self)

    @property
    def short_name_to_use(self):
        """Return the shortname, based on the name or the short one"""
        return (self.short_name
                or self.name)[:8] if self.short_name or self.name else u''

    @property
    def fqdn_prefix(self):
        return filter(lambda x: x in string.ascii_letters + string.digits,
                      self.ascii_name.lower())

    @property
    def fqdn(self):
        if self.service_provider:
            return "%s.%s" % (self.fqdn_prefix, self.service_provider.fqdn)
        return None

    @property
    def stomp_username(self):
        return str(self.id) + '.' + filter(
            lambda x: x in string.ascii_letters + string.digits,
            self.ascii_name.lower())

    @property
    def json(self):
        return to_json(self, self.__class__, [
            'stomp_username', 'short_name_to_use', 'service_provider_data',
            'default_logo_image_data', 'epg_country', 'epg_postal',
            'epg_phone_number', 'epg_sms', 'epg_email', 'genres_list',
            'ascii_name', 'fqdn', 'fqdn_prefix', 'service_identifier'
        ])