Esempio n. 1
0
def create_channel(session, station_id, client_id=None, name="TestChannel"):
    channel = Channel()
    channel.station_id = station_id
    channel.name = name
    channel.ecc_id = 159
    channel.frequency = "00917"
    channel.pi = "C00F"
    channel.type_id = "fm"
    if client_id:
        channel.fk_client = client_id
    session.add(channel)
    session.commit()
    time.sleep(config.SPI_GENERATION_INTERVAL * 3)
    return channel
Esempio n. 2
0
def create_channel(session, station_id, client_id=None, name="TestChannel"):
    channel = Channel()
    channel.station_id = station_id
    channel.name = name
    channel.ecc_id = 159
    channel.frequency = "00917"
    channel.pi = "C00F"
    channel.type_id = "fm"
    if client_id:
        channel.fk_client = client_id
    session.add(channel)
    session.commit()
    time.sleep(config.SPI_GENERATION_INTERVAL * 3)
    return channel
Esempio n. 3
0
def channels_edit(request, id):
    """Edit a channel."""

    object = None
    errors = []

    if id != '-':
        object = Channel.query.join(Station).filter(
            Channel.id == int(id), Station.orga == int(
                request.args.get('ebuio_orgapk')
                or request.form.get('ebuio_orgapk'))).first()

    if request.method == 'POST':

        if not object:
            object = Channel()

        object.station_id = int(request.form.get('station'))

        # Get values
        for x in [
                'name', 'type_id', 'ecc_id', 'pi', 'frequency', 'eid', 'sid',
                'scids', 'appty_uatype', 'pa', 'tx', 'cc', 'fqdn',
                'serviceIdentifier'
        ]:
            val = request.form.get(x)
            if val == '':
                val = None

            # Secial case : CC
            if x == 'cc' and val is not None:
                cc_obj = Ecc.query.filter_by(id=val).first()
                val = cc_obj.pi + cc_obj.ecc

            setattr(object, x, val)

        # Check errors
        if object.name == '' or object.name is None:
            errors.append("Please set a name")

        # Set to '' useless values, and check if values needed are present
        list_props = None
        for (type_id, _, type_props) in Channel.TYPE_ID_CHOICES:
            if type_id == object.type_id:
                list_props = type_props

        if list_props is None:
            errors.append('Type not found oO')

        if list_props:

            for x in [
                    'ecc_id', 'pi', 'frequency', 'eid', 'sid', 'scids',
                    'appty_uatype', 'pa', 'tx', 'cc', 'fqdn',
                    'serviceIdentifier'
            ]:
                if x in list_props:  # Want it ? Keep it !
                    if x != 'appty_uatype' and x != 'pa':  # Exception
                        if getattr(object, x) is None or getattr(object,
                                                                 x) == '':
                            errors.append(x + " cannot be empty")
                else:
                    setattr(object, x, None)

        # Check each prop
        if object.pi is not None:
            if not re.match(r"^[a-fA-F0-9]{4}$", object.pi):
                errors.append("pi must be 4 characters in hexadecimal")

        if object.frequency is not None:
            if not re.match(r"^[0-9]{5}$",
                            object.frequency) and object.frequency != '*':
                errors.append("frequency must be 5 digits or *")

        if object.eid is not None:
            if not re.match(r"^[a-fA-F0-9]{4}$", object.eid):
                errors.append("eid must be 4 characters in hexadecimal")

        if object.sid is not None:
            if not re.match(r"^[a-fA-F0-9]{4}([a-fA-F0-9]{4})?$", object.sid):
                errors.append("sid must be 4 or 8 characters in hexadecimal")

        if object.scids is not None:
            if not re.match(r"^[a-fA-F0-9]([a-fA-F0-9]{2})?$", object.scids):
                errors.append("scids must be 1 or 3 characters in hexadecimal")

        if object.appty_uatype is not None:
            if not re.match(r"^[a-fA-F0-9]{2}\-[a-fA-F0-9]{3}$",
                            object.appty_uatype):
                errors.append(
                    "appty_uatype must be 2 char hexadecimal, hyphen, 3 char hexadecimal"
                )

        if object.pa is not None:
            if object.pa < 1 or object.pa > 1023:
                errors.append("pa must be between 1 and 1023")

        if object.tx is not None:
            if not re.match(r"^[a-fA-F0-9]{5}$", object.tx):
                errors.append("tx must be 5 characters in hexadecimal")

        if object.cc is not None:
            if not re.match(r"^[a-fA-F0-9]{3}$", object.cc):
                errors.append("cc must be 3 characters in hexadecimal")

        if object.fqdn is not None:
            if not re.match(r"^[a-zA-Z\d-]{,63}(\.[a-zA-Z\d-]{,63}).$",
                            object.fqdn):
                errors.append("fqdn must be a domain name")

        if object.serviceIdentifier is not None:
            if not re.match(r"^[a-f0-9]{,16}$", object.serviceIdentifier):
                errors.append(
                    "serviceIdentifier must be up to 16 characters in hexadecimal, lowercase"
                )

        # Check station
        sta = Station.query.filter_by(id=object.station_id).first()
        if not sta or sta.orga != int(request.form.get('ebuio_orgapk')):
            errors.append("Please set a station")

        # If no errors, save
        if not errors:

            if not object.id:
                db.session.add(object)

            db.session.commit()

            return PlugItRedirect('channels/?saved=yes')

    if object:
        object = object.json

    stations = []

    for station in Station.query.filter_by(orga=int(
            request.args.get('ebuio_orgapk')
            or request.form.get('ebuio_orgapk'))).all():
        stations.append(station.json)

    return {
        'object': object,
        'errors': errors,
        'stations': stations,
        'types_id': Channel.TYPE_ID_CHOICES
    }
Esempio n. 4
0
def channels_edit(request, id):
    """Edit a channel."""

    station = None
    channel = None
    errors = []

    station_id = request.args.get('station_id')
    if station_id:
        station = Station.query.filter(
            Station.id == station_id, Station.orga == int(
                request.args.get('ebuio_orgapk')
                or request.form.get('ebuio_orgapk'))).first()

    if id != '-':
        channel = Channel.query.join(Station).filter(
            Channel.id == int(id), Station.orga == int(
                request.args.get('ebuio_orgapk')
                or request.form.get('ebuio_orgapk'))).first()

    if request.method == 'POST':

        if not channel:
            channel = Channel()

        channel.station_id = int(request.form.get('station'))

        # Get values
        for x in [
                'name', 'type_id', 'ecc_id', 'pi', 'frequency', 'eid', 'sid',
                'scids', 'appty_uatype', 'pa', 'tx', 'cc', 'fqdn',
                'stream_url', 'mime_type', 'bitrate', 'serviceIdentifier',
                'fk_client'
        ]:
            val = request.form.get(x)
            if val == '':
                val = None

            setattr(channel, x, val)

        # Check errors
        if channel.name == '' or channel.name is None:
            errors.append("Please set a name")

        # Set to '' useless values, and check if values needed are present
        list_props = None
        for (type_id, _, type_props) in Channel.TYPE_ID_CHOICES:
            if type_id == channel.type_id:
                list_props = type_props

        if list_props is None:
            errors.append('Type not found!')

        if list_props:

            for x in [
                    'ecc_id', 'pi', 'frequency', 'eid', 'sid', 'scids',
                    'appty_uatype', 'pa', 'tx', 'cc', 'fqdn', 'mime_type',
                    'stream_url', 'bitrate', 'serviceIdentifier'
            ]:
                if x in list_props:  # Want it ? Keep it !
                    if x != 'appty_uatype' and x != 'pa':  # Exception
                        if getattr(channel, x) is None or getattr(channel,
                                                                  x) == '':
                            errors.append(x + " cannot be empty")
                else:
                    setattr(channel, x, None)

        # Check each prop
        if channel.pi is not None:
            if not re.match(r"^[a-fA-F0-9]{4}$", channel.pi):
                errors.append("pi must be 4 characters in hexadecimal")

        if channel.frequency is not None:
            if not re.match(r"^[0-9]{5}$",
                            channel.frequency) and channel.frequency != '*':
                errors.append("frequency must be 5 digits or *")

        if channel.eid is not None:
            if not re.match(r"^[a-fA-F0-9]{4}$", channel.eid):
                errors.append("eid must be 4 characters in hexadecimal")

        if channel.sid is not None:
            if not re.match(r"^[a-fA-F0-9]{4}([a-fA-F0-9]{4})?$", channel.sid):
                errors.append("sid must be 4 or 8 characters in hexadecimal")

        if channel.scids is not None:
            if not re.match(r"^[a-fA-F0-9]([a-fA-F0-9]{2})?$", channel.scids):
                errors.append("scids must be 1 or 3 characters in hexadecimal")

        if channel.appty_uatype is not None:
            if not re.match(r"^[a-fA-F0-9]{2}\-[a-fA-F0-9]{3}$",
                            channel.appty_uatype):
                errors.append(
                    "appty_uatype must be 2 char hexadecimal, hyphen, 3 char hexadecimal"
                )

        if channel.pa is not None:
            if channel.pa < 1 or channel.pa > 1023:
                errors.append("pa must be between 1 and 1023")

        if channel.tx is not None:
            if not re.match(r"^[a-fA-F0-9]{5}$", channel.tx):
                errors.append("tx must be 5 characters in hexadecimal")

        if channel.cc is not None:
            if not re.match(r"^[a-fA-F0-9]{3}$", channel.cc):
                errors.append("cc must be 3 characters in hexadecimal")

        if channel.fqdn is not None:
            channel.fqdn = channel.fqdn.rstrip('.')
            if not re.match(
                    r"(?=^.{4,253}$)(^((?!-)[a-zA-Z0-9-]{1,63}(?<!-)\.)+[a-zA-Z]{2,63}\.?$)",
                    channel.fqdn):
                errors.append("fqdn must be a domain name")

        if channel.serviceIdentifier is not None:
            if not re.match(r"^[a-z0-9]{,16}$", channel.serviceIdentifier):
                errors.append(
                    "serviceIdentifier must be up to 16 letters or number, lowercase"
                )

        if channel.mime_type is not None:
            if not re.match(r"^([!-\.0-~]{1,}\/[!-\.0-~]{1,})+$",
                            channel.mime_type):
                errors.append("mime_type must be of format string/string ")

        if channel.bitrate is not None:
            if not re.match(r"^[0-9]+$", channel.bitrate):
                errors.append("bitrate must be digits")

        # Check station
        sta = Station.query.filter_by(id=channel.station_id).first()
        if not sta or sta.orga != int(request.form.get('ebuio_orgapk')):
            errors.append("Please set a station")

        # If no errors, save
        if not errors:

            if not channel.id:
                db.session.add(channel)

            db.session.commit()

            # Update the service entries for the channel
            channel.updateservicefollowingentry()

            if station:
                return PlugItRedirect(
                    ('stations/%s/channels?saved=yes') % station.id)
            else:
                return PlugItRedirect('channels/?saved=yes')

    default_country = None

    plugitapi = PlugItAPI(config.API_URL)
    orga_id = request.args.get('ebuio_orgapk') or request.form.get(
        'ebuio_orgapk')
    orga = plugitapi.get_orga(orga_id)
    if orga.codops:
        sp = ServiceProvider.query.filter_by(codops=orga.codops).order_by(
            ServiceProvider.codops).first()
        if sp:
            cc_obj = CountryCode.query.filter_by(
                iso=sp.location_country).first()
            if cc_obj:
                default_country = cc_obj.id

    if channel:
        channel = channel.json

    stations = []

    for s in Station.query.filter_by(orga=int(
            request.args.get('ebuio_orgapk')
            or request.form.get('ebuio_orgapk')),
                                     parent=None).all():
        stations.append(s.json)

    if station:
        station = station.json

    clients = [gen_default_client()] + Clients.query.filter_by(
        orga=orga_id).order_by(Clients.id).all()

    return {
        'object': channel,
        'errors': errors,
        'stations': stations,
        'station': station,
        'types_id': Channel.TYPE_ID_CHOICES,
        'default_country': default_country,
        'clients': map(lambda c: c.json, clients)
    }
Esempio n. 5
0
def string_to_channel(linedata, station):
    object = Channel()
    object.station_id = station

    # Split line
    data = linedata.split(',')

    if len(data) < 2:
        return None

    # Define Type
    object.name = data[0]
    object.type_id = data[1]

    # FM
    # name	fm	ecc	pid	frequency
    if object.type_id == 'fm':
        if len(data) < 5:
            return None
        # ECC
        cc_obj = Ecc.query.filter_by(iso=data[2].upper()).first()
        if not cc_obj:
            ecc_pi = data[2][:1].upper()
            ecc_ecc = data[2][1:].upper()
            cc_obj = Ecc.query.filter_by(pi=ecc_pi, ecc=ecc_ecc).first()
        if cc_obj:
            object.ecc_id = cc_obj.id
        # PI
        object.pi = data[3]
        object.frequency = data[4]

    # DAB
    # name	dab	ecc	eid	sid	scids	UAType	PA
    elif object.type_id == 'dab':
        if len(data) < 6:
            return None
        # ECC
        cc_obj = Ecc.query.filter_by(iso=data[2].upper()).first()
        if not cc_obj:
            ecc_pi = data[2][:1].upper()
            ecc_ecc = data[2][1:].upper()
            cc_obj = Ecc.query.filter_by(pi=ecc_pi, ecc=ecc_ecc).first()
        if cc_obj:
            object.ecc_id = cc_obj.id
        # eid
        object.eid = data[3]
        object.sid = data[4]
        object.scids = data[5]
        # Optional Elements
        if len(data) >= 7:
            object.appty_uatype = data[6]
        if len(data) >= 8:
            object.pa = data[7]

    # DRM
    # name	drm	sid
    elif object.type_id == 'drm':
        if len(data) < 3:
            return None
        # sid
        object.sid = data[2]

    # AMSS
    elif object.type_id == 'amss':
        if len(data) < 3:
            return None
        # sid
        object.sid = data[2]

    # HD Radio
    # name	hd	cc	tx
    elif object.type_id == 'hd':
        if len(data) < 4:
            return None
        # cc
        object.cc = data[2]
        object.tx = data[3]

    # IP
    # name	ip	fqdn	service id
    elif object.type_id == 'ip':
        if len(data) < 4:
            return None
        # cc
        object.fqdn = data[2]
        object.serviceIdentifier = data[3]

    else:
        return None

    return object