This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
##### | |
# | |
# GitHub Actions will deploy your app to Cloud Run in Google Cloud Platform (GCP) when you push to master or main branch. | |
# | |
# 1. Set up your GCP project and Cloud Run service account | |
# 2. Ensure your service account has permissions to push images to Artifact Registry and deploy to Cloud Run. | |
# 3. Create a key.json file for the service account and add it to your GitHub repo as a secret. (In this example, the secret name is GCP_DEPLOYER_KEY) | |
# 4. Enable the Cloud Run API and Artifact Registry API in your GCP project | |
# 5. Add this file as .github/workflows/deployer.yml | |
# 6. Add a Dockerfile to your repo to build your app |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# The following is an example of a command to clone an development(ex-app-development) as an production(ex-app-production). | |
kubectl get deployment ex-app-development -o json \ | |
| jq '.metadata.name = "ex-app-production"' \ | |
| kubectl apply -f - |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
from langchain.llms import OpenAI | |
from langchain import OpenAI, SQLDatabase, SQLDatabaseChain | |
from langchain.prompts.prompt import PromptTemplate | |
import os | |
def chat_with_mysql_database(prompt: str): | |
""" | |
Args: | |
prompt (str): Question to ask e.g. "Generate an SQL query to retrieve all users" | |
Returns: |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import random | |
import string | |
def generate_random_string(): | |
selects = random.sample(string.ascii_uppercase, 3) + random.sample( | |
string.digits, 3) + random.sample(string.ascii_lowercase, 3) | |
random.shuffle(selects) | |
unique_code = ''.join(selects) | |
print(unique_code) | |
return unique_code |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Remove old versions of Google App Engine | |
##### | |
# | |
# Add this file to .github/workflows/delete-old-gae.yml then GitHub Actions will remove old versions of Google App Engine. | |
# | |
##### | |
on: | |
workflow_dispatch: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: Deployer | |
##### | |
# | |
# Add this file to .github/workflows/google_app_engine_deployer.yml, then GitHub Actions will detect any updates on master/main branch and deploy changes. | |
# This example uses Node.js 18. You can choose any language you like. | |
# The build command is also `npm run build', change it as you like. | |
# | |
# 1. Set up service account for deployment and create key.json and set it to env variable | |
# 2. Create your app.yaml if you never deploy the app to GAE |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import os | |
from uuid import uuid4 | |
##### Memorize function for performance ################### | |
################################################################# | |
def get_id_tuple(f, args, kwargs, mark=object()): | |
l = [id(f)] | |
for arg in args: | |
l.append(id(arg)) |
NewerOlder