def edit_asset(asset_id):
c = connection.cursor()
c.execute("SELECT name, uri, md5, start_date, end_date, duration, mimetype FROM assets WHERE asset_id=?", (asset_id,))
asset = c.fetchone()
name = asset[0]
uri = asset[1]
md5 = asset[2]
if asset[3]:
start_date = datestring.date_to_string(asset[3])
else:
start_date = None
if asset[4]:
end_date = datestring.date_to_string(asset[4])
else:
end_date = None
duration = asset[5]
mimetype = asset[6]
asset_info = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
#return str(asset_info)
return template('edit_asset', asset_info=asset_info)
def playlistitem(self, default_date_string=None):
return {
"name" : self.name,
"uri" : self.uri,
"duration" : self.duration,
"mimetype" : self.mimetype,
"asset_id" : self.asset_id,
"start_date" : datestring.date_to_string(self.start_date) if self.start_date else default_date_string,
"end_date" : datestring.date_to_string(self.end_date) if self.end_date else default_date_string
}
def get_playlist():
playlist = []
for asset in fetch_assets():
if is_active(asset):
asset['start_date'] = datestring.date_to_string(asset['start_date'])
asset['end_date'] = datestring.date_to_string(asset['end_date'])
playlist.append(asset)
return playlist
def get_playlist():
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute("SELECT * FROM assets ORDER BY name")
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
input_start_date = asset[4]
input_end_date = asset[5]
try:
start_date = datestring.date_to_string(asset[4])
except:
start_date = None
try:
end_date = datestring.date_to_string(asset[5])
except:
end_date = None
duration = asset[6]
mimetype = asset[7]
is_cached = asset[8]
cached_location = asset[9]
playlistitem = {
"name" : name,
"uri" : uri,
"duration" : duration,
"mimetype" : mimetype,
"asset_id" : asset_id,
"start_date" : start_date,
"end_date" : end_date,
"is_cached" : is_cached,
"cached_location" : cached_location
}
if (start_date and end_date) and (input_start_date < time_lookup() and input_end_date > time_lookup()):
playlist.append(playlistitem)
return dumps(playlist)
def edit_asset(asset_id):
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute("SELECT name, uri, md5, start_date, end_date, duration, mimetype, is_cached, cached_location FROM assets WHERE asset_id=?", (asset_id,))
asset = c.fetchone()
name = asset[0]
uri = asset[1]
md5 = asset[2]
if asset[3]:
start_date = datestring.date_to_string(asset[3])
else:
start_date = None
if asset[4]:
end_date = datestring.date_to_string(asset[4])
else:
end_date = None
duration = asset[5]
mimetype = asset[6]
is_cached = asset[7]
cached_location = asset[8]
if "on" in is_cached:
is_cached = "checked"
if "off" in is_cached:
is_cached = ""
asset_info = {
"name" : name,
"uri" : uri,
"duration" : duration,
"mimetype" : mimetype,
"asset_id" : asset_id,
"start_date" : start_date,
"end_date" : end_date,
"is_cached" : is_cached,
"cached_location" : cached_location
}
disk = statvfs("/home/pi/.screenly/cache")
free_space = size(disk.f_bsize * disk.f_bavail)
free_space_bytes = (disk.f_bsize * disk.f_bavail)
return template('edit_asset', asset_info=asset_info, free_space=free_space, free_space_bytes=free_space_bytes)
def get_playlist():
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute("SELECT * FROM assets ORDER BY name")
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
input_start_date = asset[4]
input_end_date = asset[5]
try:
start_date = datestring.date_to_string(asset[4])
except:
start_date = None
try:
end_date = datestring.date_to_string(asset[5])
except:
end_date = None
duration = asset[6]
mimetype = asset[7]
playlistitem = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
if (start_date and end_date) and (input_start_date < time_lookup()
and input_end_date > time_lookup()):
playlist.append(playlistitem)
return dumps(playlist)
def get_assets():
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute("SELECT asset_id, name, uri, start_date, end_date, duration, mimetype, is_cached, cached_location FROM assets ORDER BY name")
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
try:
start_date = datestring.date_to_string(asset[3])
except:
start_date = ""
try:
end_date = datestring.date_to_string(asset[4])
except:
end_date = ""
duration = asset[5]
mimetype = asset[6]
is_cached = asset[7]
cached_location = asset[8]
playlistitem = {
"name" : name,
"uri" : uri,
"duration" : duration,
"mimetype" : mimetype,
"asset_id" : asset_id,
"start_date" : start_date,
"end_date" : end_date,
"is_cached" : is_cached,
"cached_location" : cached_location
}
playlist.append(playlistitem)
return dumps(playlist)
def get_playlist():
c = connection.cursor()
c.execute("SELECT * FROM assets ORDER BY name")
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
input_start_date = asset[4]
input_end_date = asset[5]
try:
start_date = datestring.date_to_string(asset[4])
except:
start_date = None
try:
end_date = datestring.date_to_string(asset[5])
except:
end_date = None
if (start_date and end_date) and (input_start_date < get_current_time() and input_end_date > get_current_time()):
duration = asset[6]
mimetype = asset[7]
playlistitem = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
playlist.append(playlistitem)
return playlist
def get_assets():
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute(
"SELECT asset_id, name, uri, start_date, end_date, duration, mimetype FROM assets ORDER BY name"
)
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
try:
start_date = datestring.date_to_string(asset[3])
except:
start_date = ""
try:
end_date = datestring.date_to_string(asset[4])
except:
end_date = ""
duration = asset[5]
mimetype = asset[6]
playlistitem = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
playlist.append(playlistitem)
return dumps(playlist)
def edit_asset(asset_id):
conn = sqlite3.connect(database, detect_types=sqlite3.PARSE_DECLTYPES)
c = conn.cursor()
c.execute(
"SELECT name, uri, md5, start_date, end_date, duration, mimetype FROM assets WHERE asset_id=?",
(asset_id, ))
asset = c.fetchone()
name = asset[0]
uri = asset[1]
md5 = asset[2]
if asset[3]:
start_date = datestring.date_to_string(asset[3])
else:
start_date = None
if asset[4]:
end_date = datestring.date_to_string(asset[4])
else:
end_date = None
duration = asset[5]
mimetype = asset[6]
asset_info = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
#return str(asset_info)
return template('edit_asset', asset_info=asset_info)
def get_assets():
c = connection.cursor()
c.execute("SELECT asset_id, name, uri, start_date, end_date, duration, mimetype FROM assets ORDER BY name")
assets = c.fetchall()
playlist = []
for asset in assets:
# Match variables with database
asset_id = asset[0]
name = asset[1]
uri = asset[2] # Path in local database
try:
start_date = datestring.date_to_string(asset[3])
except:
start_date = ""
try:
end_date = datestring.date_to_string(asset[4])
except:
end_date = ""
duration = asset[5]
mimetype = asset[6]
playlistitem = {
"name": name,
"uri": uri,
"duration": duration,
"mimetype": mimetype,
"asset_id": asset_id,
"start_date": start_date,
"end_date": end_date
}
playlist.append(playlistitem)
return playlist
