jayrizzo / random_scripts

My Own Creations & Stack Overflow Answers To Questions

Welcome To My Random Scripts

These are some of my works, either answers to Stack Overflow or my own personal creations.

SQL

postgres_master_everything_reset_script.sql

• This Script SETS / RESETS:
• PERMISSIONS
• CONSTRAINTS
• PRIMARY KEYS
• INDEXES OR INDICES
• ADDED REINDEX ON THE DATABASE
• REORDERED THE QUERIES USING THE ORDER BY REPLACE THIS IS MANDITORY

SQL Reset Script that is Dynamic & Static that builds queries that are designed to Standardize Permissions & Improve Performance. This is highly customizable and effective in making sure your database permissions do not get in the way when dealing with mulitiple users & or Groups with multi standardized structures.

PHP

shopify_to_csv.php

This Module was Built to Clean your data upon import Converting all Symbols (ASCII) to HTML References to help prevent issues when trying to create a clean "Encapsulated","CSV","FILE"

1. This module uses the following
2. Mandatory 1. shopify_key 1. shopify_password 1. shopify_store
3. Optional 1. shopify_collection_id

Script Ability:

• Download your Shopify Store Product Data in a "Clean","Data Set"
• Download your Shopify Store Product Variant Data in a "Clean","Data Set"
• Clean the imported data from data that may crash the bash, PHP or importing your data into sql. as the symbols have been converted to HTML References ™ turns into ™
• Can be used for CRONJOBS
• Has custom restrictions with proper notificiations
• Can be used to notify you for failures &/ Sucesses if desired & customized

Script Note:

• This is a Personal Creation of this Monstrosity

html_ascii_to_html.php

This Module is a subset of the shopify_to_csv.php

Python

char_to_html.py

Is a version of replacing non-ASCII characters with printable ASCII & Using HTML entities when possible.

custom_header.py

This Module was Built to showcase Examples Of Custom Headers, printing upon execution of your script.

• Answer to Stack Overflow Question: Python: What is a header?

FizzBuzz.py

Is my Python Version of fizzbuzz I wrote myself for fun.

organize_files.py

The Module Has Been Build for keeping your files organized by specific file types.

• Answer to Stack Overflow Question: Moving specific file types with Python

pyodbc_mssqldbtest.py

The Module Has Been Build for Interaction with MSSQL DBs To Test the console for pyodbc.

• Answer to Stack Overflow Question: Connect Python with SQL Server Database

regex_match.py

The Module Has Been Build for trying to find variations of emails in batches of text.

relativedelta.py

The Module Has Been Build for trying to decipyer measurements between dates. The Stack Overflow User was dealing with arbitrary dates, so my answer was not acceptible.

• Was an attempt to Answer a Stack Overflow Question: Calculating number of years between two dates, but rounded in the standard way

sendgmail.py

The Python Module Has Been Build for Sending Emails from your Gmail Account, bypassing the 2FA.

• Answer to Stack Overflow Question: How to send an email with Gmail as provider using Python?

testy_class_init.py

The Module Has Been Build to help a user fix their code.

• Answer to Stack Overflow Question: AttributeError: 'str' object has no attribute 'name' while defining a class & calling it

uuid_testing.py

A fix

"for attempting to read in CSV data and map it to the following XML structure".

• Answer to Stack Overflow Question: Python string formatting and UUID

xattr_example.py

A Module Built to help a showcase example usage, since no code examples for python's xattr could be found. at least for me.

"Showcasing a 'How-to' example."

• Answer to Stack Overflow Question: Python Module xattr has no attribute list

Shell

clean_mac.sh

This Module was Built to Clean your ~/Documents Folder from any "Truly" empty folders that may only contain some hidden/ZERO byte files.

• Answer to Stack Overflow Question: How can I delete empty folders in Mac OS X?

Thank You For Visiting!