shawnho1018’s gists

shawnho1018 / insert_data.txt

Created February 19, 2025 14:09

Data used in the qwiklab

INSERT INTO `finance_graph_bq.Person` (id, name) VALUES (1,"Bertrand"),(2,"Menville"),(3,"Rowe"),(4,"Rowlands"),(5,"Kerschensteiner"),(6,"Abutalybov"),(7,"Skala"),(8,"Bukofzer"),(9,"Shabazz"),(10,"Zakharov"),(11,"Baumgartner"),(12,"Hodgman"),(13,"Baardsen"),(14,"Castanon"),(15,"Akhavan"),(16,"Patten"),(17,"Hulbert"),(18,"House"),(19,"Prussia"),(20,"Gunn"),(21,"Cook"),(22,"O'Hearn"),(23,"Brocklebank"),(24,"Farnall"),(25,"Culver"),(26,"Hatfield"),(27,"Aden"),(28,"Moon"),(29,"Boyes"),(30,"Hergesheimer"),(31,"Itakura"),(32,"Llamazares"),(33,"Fannin"),(34,"Buttiglione"),(35,"Dafydd"),(36,"Algaze"),(37,"Gaztañaga"),(38,"Bennahmias"),(39,"Peart"),(40,"Dooley"),(41,"Rogerson"),(42,"Staudle"),(43,"Sim"),(44,"Le Lacheur"),(45,"Domingo"),(46,"Riby"),(47,"Kaljujarv"),(48,"Leniston"),(49,"Vaccari"),(50,"Barshadly"),(51,"Cutler"),(52,"Alberstein"),(53,"Ide"),(54,"Horton"),(55,"Sossamon"),(56,"Chaparro"),(57,"Blaché"),(58,"Carranza"),(59,"Shapiro"),(60,"Briginshaw"),(61,"Orji"),(62,"West"),(63,"Cervell"),(64,"Jackova"),(65,

shawnho1018 / main.py

Last active November 6, 2024 14:57

This function uses fastapi and gemini to create a graphgpt query service

	from neo4j import GraphDatabase
	from typing import Dict, Any, Optional, List
	import logging, sys, json
	import vertexai
	from vertexai.generative_models import GenerativeModel, Part, SafetySetting, Tool
	from fastapi import FastAPI, Request, HTTPException


	app = FastAPI()
	root = logging.getLogger()

shawnho1018 / engineer.csv

Last active November 6, 2024 05:54

Engineer Data

Id	Name	Skills	Email
1	Joe Smith	Cypher:Java:JavaScript	[email protected]
2	Mary Jones	Java	[email protected]
3	Trevor Scott	Java:JavaScript	[email protected]
4	Perl Tsai	.NET:Perl:Bash	[email protected]
5	Owen Wu	.NET:Python:Bash:Cypher	[email protected]
6	Shawn Ho	Python:Bash:Cypher	[email protected]

shawnho1018 / urlmap-loadbalancer.yaml

Created November 8, 2022 01:27

urlmap-loadbalancer.yaml

	defaultService: projects/shawn-mesh-2022/global/backendServices/bs-svc-a
	name: matcher1
	routeRules:
	- urlRedirect:
	pathRedirect: /balance
	stripQuery: true
	hostRedirect: tsmc.shawnk8s.com
	redirectResponseCode: FOUND
	matchRules:
	- prefixMatch: /meet

shawnho1018 / prometheus-istiod-2.yaml

Created September 19, 2022 10:56

	apiVersion: v1
	kind: ConfigMap
	metadata:
	namespace: gmp-test
	name: prometheus-test
	labels:
	prometheus: test
	data:
	config.yaml: \|
	global:

shawnho1018 / prometheus-istiod-1.yaml

Created September 19, 2022 10:55

	apiVersion: v1
	kind: ConfigMap
	metadata:
	namespace: gmp-test
	name: prometheus-test
	labels:
	prometheus: test
	data:
	config.yaml: \|
	global:

shawnho1018 / prometheus-config-addon.yaml

Last active September 19, 2022 09:18

prometheus-config-addon.yaml

	# 收集istiod上數據
	- job_name: 'istiod'
	kubernetes_sd_configs:
	- role: endpoints
	namespaces:
	names:
	- istio-system
	relabel_configs:
	- source_labels: [__meta_kubernetes_service_name, __meta_kubernetes_endpoint_port_name]
	action: keep

shawnho1018 / httproute.yaml

Created September 14, 2022 16:08

httproute.yaml

	kind: HTTPRoute
	apiVersion: gateway.networking.k8s.io/v1alpha2
	metadata:
	name: jitsi-1
	namespace: default
	labels:
	gateway: jitsi-http3
	spec:
	parentRefs:
	- name: jitsi-http3

shawnho1018 / gateway.yaml

Created September 14, 2022 15:59

gateway.yaml public

	kind: Gateway
	apiVersion: gateway.networking.k8s.io/v1alpha2
	metadata:
	name: jitsi-http3
	spec:
	gatewayClassName: gke-l7-gxlb
	listeners:
	- name: https
	protocol: HTTPS
	port: 443

shawnho1018 / mongodb-impl.yaml

Created September 6, 2022 06:10

	---
	apiVersion: mongodbcommunity.mongodb.com/v1
	kind: MongoDBCommunity
	metadata:
	name: example-mongodb
	namespace: mongodb
	spec:
	members: 3
	type: ReplicaSet
	version: "4.2.6"

Shawnho shawnho1018