Skip to content

Instantly share code, notes, and snippets.

View qlawmarq's full-sized avatar
🏠
Working from home

Masaki Yoshiiwa qlawmarq

🏠
Working from home
View GitHub Profile
@qlawmarq
qlawmarq / cloud-sql-python-connector-with-pytds-for-sql-server.py
Last active October 26, 2022 01:23
Example of using PyTDS and Cloud SQL Python Connector to connect SQL server of Cloud SQL
from google.cloud.sql.connector import Connector, IPTypes
import pytds
import os
##### SQL connecter #############################################
#################################################################
# Grabbing the user and password from environment variables
db_name = os.getenv("APPLICATION_DB")
@qlawmarq
qlawmarq / drop_columns_with_constraints.sql
Created May 26, 2022 06:52
Delete/drop columns with foreign key constraints or default values constraints in SQL server.
-- Search default value constraints:
SELECT
obj.name
FROM
sys.objects AS obj
JOIN
sys.columns AS clm ON obj.object_id = clm.default_object_id
WHERE
obj.type = 'D' AND obj.parent_object_id = OBJECT_ID('User') AND clm.name = 'CompanyId';
@qlawmarq
qlawmarq / How_to_switch_between_multiple_GitHub_accounts_via_ssh.md
Last active February 22, 2022 05:31
How to switch between multiple GitHub accounts via ssh

How to switch between multiple GitHub accounts via ssh

Generate a new SSH key

Open Terminal, and create SSH keys for each accounts.

ssh-keygen -t ed25519 -C "[email protected]"
@qlawmarq
qlawmarq / hi.gif
Last active February 8, 2022 02:10
hi
hi.gif