Nov 24, 2022 | PyQt5, PyQt6, Python
Buy Me a Coffee? Your support is much appreciated! demo.py import sys from PyQt6.QtWidgets import (QApplication, QWidget, QTableWidget, QTableWidgetItem, QHBoxLayout, QVBoxLayout) from PyQt6.QtCore import Qt class TableWidget(QTableWidget): def __init__(self,...
Nov 22, 2022 | Python, YouTube API
Buy Me a Coffee? Your support is much appreciated! Source Code import os import pypyodbc as odbc # pip install pypyodbc def bulk_insert(date_file, target_table): sql = f””” BULK INSERT {target_table} FROM ‘{date_file}’ WITH (...
Nov 15, 2022 | Python, YouTube API
Buy Me a Coffee? Your support is much appreciated! youtube.py from google_apis import create_service class YouTube: API_NAME = ‘youtube’ API_VERSION = ‘v3’ SCOPES = [‘https://www.googleapis.com/auth/youtube’,...
Nov 13, 2022 | Google BigQuery, Google BigQuery API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code: from google.cloud import bigquery, bigquery_datatransfer class DatasetManager: def __init__(self, client): self.client = client def delete_dataset(self, dataset_id): # update `not_found_ok` parameter to...
Nov 13, 2022 | MS Graph API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code: import requests from rich import console from ms_graph import generate_access_token, GRAPH_API_ENDPOINT console = console.Console() APP_ID = ‘<APP ID>’ SCOPES =...
Nov 13, 2022 | Google BigQuery, Google BigQuery API, Python
Buy Me a Coffee? Your support is much appreciated! Source Code: import os from google.cloud import bigquery os.environ[‘GOOGLE_APPLICATION_CREDENTIALS’] = ‘bigquery_service_acct.json’ client = bigquery.Client(‘sql-for-bigquery’) #...