| #!/usr/bin/env python3 | |
| import requests | |
| def fetch_province_cities(province:str)->list: | |
| """ | |
| Fetches all cities within a specific Canadian province. | |
| Args: | |
| province (str): the province's abbreviation. |
| #!/usr/bin/env python3 | |
| from pypostalcode import PostalCodeDatabase as pcdb | |
| import geonamescache as geoc | |
| # Fetching all postal code areas in Manitoba using the pypostalcode library | |
| pcdb = pcdb() | |
| radius_results = pcdb.get_postalcodes_around_radius('R3G', 999) | |
| radius_results = [pc for pc in radius_results if pc.province == 'Manitoba'] | |
| cities_in_radius = set(pc.city.split('(')[0].strip() for pc in radius_results) |
1.The primary key is a general concept to indicate one or more columns used to retrieve data from a Table.
SIMPLEcreate table stackoverflow (
key text PRIMARY KEY,
data text
);| #!/bin/bash | |
| echo -e '\nStarting the Bash script for the "Create and Manage Cloud Resources: Challenge Lab - Task 3"\n' | |
| gcloud config set compute/region us-central1 | |
| gcloud config set compute/zone us-central1-c | |
| echo -e '\nDefault Region and Zone set for Compute Engine\n' | |
| cat << EOF > startup.sh |
| [Desktop Entry] | |
| Name=VSCodium | |
| Comment=Code Editing. Redefined. | |
| GenericName=Text Editor | |
| Exec=FLATPAK_ENABLE_SDK_EXT=node14 /usr/bin/flatpak run --branch=stable --arch=x86_64 --command=/app/bin/codium --file-> | |
| Icon=com.vscodium.codium | |
| Type=Application | |
| StartupNotify=false | |
| StartupWMClass=VSCodium | |
| Categories=Utility;TextEditor;Development;IDE; |
| <!doctype html> | |
| <style> | |
| #wrapper_new { width: 100%; max-width: 725px; margin: 0px auto; } | |
| .gears { width:48%; display: inline-block; } | |
| .gears:first-child { margin-right: 3%; } | |
| .gears-container { width:150px; height: 150px; font-size:24px; padding: 9%; position: relative; margin: 0px auto; } | |
| .gear-rotate { | |
| width: 2em; | |
| height: 2em; | |
| top: 50%; |
| #modification of http://stackoverflow.com/questions/5983265/pythonic-way-of-determining-if-the-current-element-is-the-first-or-last-element | |
| def annotate_last_item(gen): | |
| prev_val = gen.next() | |
| for val in gen: | |
| yield False, prev_val | |
| prev_val = val | |
| yield True, prev_val |
| // Reason to create this script: | |
| // My profile was created in portuguese, but when I translated | |
| // it to english and tried to save my profile as PDF, it could not | |
| // translate some words and dates to english, so I created this gist | |
| // as an alternative. | |
| // Usage | |
| // 1. open your public profile in an incognito* browser tab. E.g.: https://www.linkedin.com/in/marioluan | |
| // 2. copy-n-past the code below into the browser console | |
| // 3. save as PDF |
| gcloud functions deploy ops-bigquery-etl \ | |
| --source ~/Git/data-pipelines/ops-bigquery-etl \ | |
| --entry-point ops_etl \ | |
| --gen2 \ | |
| --runtime python311 \ | |
| --region us-central1 \ | |
| --trigger-http \ | |
| --max-instances 1 \ | |
| --allow-unauthenticated \ | |
| --memory 1G |