This file has been truncated, but you can view the full file.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Ahsoka": { | |
| "name": "Ahsoka", | |
| "id": 114461, | |
| "show_url": "https://api.themoviedb.org/3/tv/114461", | |
| "seasons": { | |
| "Specials": { | |
| "season_name": "Specials", | |
| "season_number": 0, | |
| "episode_count": 4, |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "Ahsoka": { | |
| "name": "Ahsoka", | |
| "base_url": "Z:\\Entertainment\\Media\\TV Shows", | |
| "url": "Z:\\Entertainment\\Media\\TV Shows\\Ahsoka", | |
| "seasons": { | |
| "Season 01": { | |
| "season_name": "Season 01", | |
| "season_url": "Z:\\Entertainment\\Media\\TV Shows\\Ahsoka\\Season 01", | |
| "episodes": [ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(tidyverse) | |
| library(dplyr) | |
| library(tibble) | |
| library(janitor) | |
| library("lubridate") | |
| library(here) | |
| library(skimr) | |
| library(ggplot2) | |
| #READ CSV FILES |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| local_tv_location <- "T:\\Media\\TV Shows" | |
| network_tv_location <- r"{Z:\Entertainment\Media\TV Shows/}" | |
| #************* ROOT COUNT ****************** | |
| root_local = list() | |
| root_network = list() | |
| root_local_dir = list.dirs(local_tv_location) | |
| for(x in root_local_dir) | |
| { |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use gtk::{prelude::*, Orientation}; | |
| use gtk::{glib, Application, ApplicationWindow, Widget}; | |
| use std::fs; | |
| const APP_ID: &str = "org.gtk_rs.HelloWorld2"; | |
| fn main() -> glib::ExitCode { | |
| // Create a new application | |
| let app = Application::builder().application_id(APP_ID).build(); | |
| // Connect to "activate" signal of `app` |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e01 - Currahee.mkv'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e01 - Currahee.srt'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e02 - Day of Days.mkv'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e02 - Day of Days.srt'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e03 - Carentan.mkv'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e03 - Carentan.srt'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e04 - Replacements.mkv'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e04 - Replacements.srt'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e05 - Crossroads.mkv'); | |
| INSERT INTO tv.episodes (name) values (E'Band of Brothers - s01e05 - Crossroads.srt'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import psycopg2 | |
| import json | |
| def get_drives_and_media_type(): | |
| results = [] | |
| with psycopg2.connect("host=# dbname=entertainment_database user=# password=#") as conn: | |
| with conn.cursor() as db_cursor: |