Huang Geyang Hosuke

🐢

I code slowly

天空被未来浸染

Hosuke / lower_remover.py

Last active July 18, 2023 09:34

	import os
	import re

	# Get the current directory
	dir_path = os.getcwd()

	# Traverse all files and subdirectories in the current directory
	for root, dirs, files in os.walk(dir_path):
	for file_name in files:

Hosuke / hexstring_quotes_remover.py

Last active July 15, 2023 19:08

	import os
	import re

	# Get the current directory
	dir_path = os.getcwd()

	# Traverse all files and subdirectories in the current directory
	for root, dirs, files in os.walk(dir_path):
	for file_name in files:

Hosuke / legacy_spells_mover.py

Created July 6, 2023 09:19

legacy_spells_mover

	import os
	import re
	import shutil

	# Get current dir
	dir_path = os.getcwd()

	for root,dirs,files in os.walk(dir_path):

	for file in files:

Hosuke / trino_spells_mover.py

Last active July 11, 2023 05:58

trino_spells_mover

	import os
	import re
	import shutil

	def replace_with_alias_macros(model_contents):
	"""
	Replace alias = 'some_alias' with alias('some_alias', legacy_model=True)
	"""
	pattern = r"alias\s=\s'([^']*)'"
	# replace alias with legacy alias

Hosuke / ref_legacy_adder.py

Created July 11, 2023 06:19

	import os
	import re
	import shutil

	# Get current dir
	dir_path = os.getcwd()

	for root, dirs, files in os.walk(dir_path):

	for file in files:

Hosuke / dependency_scanner.py

Last active July 18, 2023 10:06

	import json

	def get_model_dependencies(manifest_file, model_name):
	with open(manifest_file, 'r') as f:
	manifest = json.load(f)

	def get_dependencies(full_model_name, indent=0):
	if full_model_name.startswith('model.'):
	model = manifest['nodes'].get(full_model_name)
	if model is None:

Hosuke / gen_dependancy_queue.py

Last active September 18, 2023 08:51

	import json

	def get_model_dependencies(manifest_file, model_name):
	with open(manifest_file, 'r') as f:
	manifest = json.load(f)

	# Build the adjacency list
	adj_list = {}
	for full_model_name, model in manifest['nodes'].items():
	if not full_model_name.startswith('model.'):

Hosuke / from_iso8601_timestamp.py

Created July 19, 2023 05:00

	import os
	import re

	# 获取当前工作目录
	directory = os.getcwd()

	# 遍历目录及其所有子目录下的所有文件
	for dirpath, dirnames, filenames in os.walk(directory):
	for filename in filenames:
	# 只处理.sql文件

Hosuke / date_to_timestamp.py

Created July 20, 2023 07:18

	import os
	import re

	# 获取当前工作目录
	directory = os.getcwd()

	# 遍历目录及其所有子目录下的所有文件
	for dirpath, dirnames, filenames in os.walk(directory):
	for filename in filenames:
	# 只处理.sql文件

Hosuke / auto_date_wrapper.py

Last active August 5, 2023 19:43