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)
}
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
