iTrauco

Downloading Music Playlists from YouTube

Disclaimer

Use this knowledge at your own risk.

youtube-dl for Windows

youtube-dl will allow you to download entire youtube playlists and store them as MP3s. This will also allow you to download individual MP3s.

iTrauco

Prompt:

"I am working on a new Git project, and I need a clear feature map for branch naming conventions. The feature map should outline each development phase, the corresponding tasks, and suggested branch naming conventions for each step.

Here are the requirements:

Provide a list of development phases (initial setup, core logic, testing, continuous integration, additional features, linting/formatting, documentation, code review, release, and post-release maintenance). For each phase, describe the objective and the key tasks that need to be completed. For each phase, suggest a branch naming convention following this structure: feat/feature-description, fix/bug-description, release/version, etc. Ensure each phase follows this format:

iTrauco

Project: Data Normalization and BigQuery Integration for Gaming Compliance

Context: I am developing a cloud-based system for normalizing and processing gaming compliance data from various operators, specifically starting with RSI BetRivers. The system needs to handle Excel file inputs, process them according to a predefined schema, and output the normalized data to BigQuery tables.

Key Components:

1. Cloud Function: Triggered by file uploads to a Google Cloud Storage bucket.
2. Data Processing: Normalizing Excel data based on a JSON schema.
3. BigQuery Integration: Loading processed data into specified BigQuery tables.

iTrauco

Prompt for Future Sessions

Please ensure the following behavior in all future sessions:

1. Output a single code block at a time: Provide the path to the file and use an echo command to modify the code directly from the terminal.
2. Include sed commands: Provide sed commands to remove, modify, or change old code if necessary.
3. Summarize next steps: Before proceeding, summarize the next steps and seek user approval.

Example

iTrauco

sudo bash -c '
# Install required packages
apt-get update
apt-get install -y macchanger iproute2 curl iptables ufw

# Create the secure_connection.sh script
cat <<EOF > /usr/local/bin/secure_connection.sh
#!/bin/bash

# Configuration

iTrauco

#!/usr/bin/env python3
# -*- coding: utf-8 -*-

import pandas as pd
import random
import os
from google.cloud import storage, bigquery

def authenticate_user():
    print("Authenticating with Google Cloud...")

iTrauco

Dynamic Generation of GCP Resource Mapping

Overview

This document explains the logic used to dynamically generate a master list of GCP resources and their corresponding utility scripts. The master list is automatically created by scanning the utility scripts in the project and mapping them to human-readable resource descriptions. This approach ensures that the mapping is always up to date and reduces manual intervention.

Steps Involved

1. Scanning the utils/ Directory

iTrauco

. ├── conda.yaml ├── keywords │ ├── browser_keywords.robot │ └── page_keywords.robot ├── libraries ├── output ├── requirements.txt ├── resources │ └── common.robot

iTrauco

Robocorp Robot Framework Project Setup

I am working on a Robocorp Robot Framework project. Previously, we set up the project with the following directory structure and files:

Project Directory Structure

project/ ├── output/ ├── tasks/ │ └── task.robot

iTrauco

echo 'alias gistsecret='\''function _gistsecret() { vim "$1"; local filename="$1"; gh gist create "$filename"; }; _gistsecret'\''' >> ~/.zshrc