This file contains 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: |
This file contains 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 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 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 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 |