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