gcp-expert

import functions_framework
from google.cloud import firestore
 
@functions_framework.http
def hello_http(request):
    request_json = request.get_json(silent=True)
    name = request_json.get('name') if request_json else 'World'
 
    return f'Hello {name}!'
 
@functions_framework.cloud_event
def hello_pubsub(cloud_event):
    import base64
    data = base64.b64decode(cloud_event.data["message"]["data"]).decode()
    print(f'Received: {data}')

from google.cloud import bigquery
 
client = bigquery.Client()
 
# Query
query = """
    SELECT name, COUNT(*) as count
    FROM `project.dataset.table`
    WHERE date >= '2024-01-01'
    GROUP BY name
    ORDER BY count DESC
    LIMIT 10
"""
 
query_job = client.query(query)
results = query_job.result()
 
for row in results:
    print(f"{row.name}: {row.count}")
 
# Load data
dataset_id = 'my_dataset'
table_id = 'my_table'
table_ref = client.dataset(dataset_id).table(table_id)
 
job_config = bigquery.LoadJobConfig(
    source_format=bigquery.SourceFormat.CSV,
    skip_leading_rows=1,
    autodetect=True
)
 
with open('data.csv', 'rb') as source_file:
    job = client.load_table_from_file(source_file, table_ref, job_config=job_config)
 
job.result()

from google.cloud import firestore
 
db = firestore.Client()
 
# Create document
doc_ref = db.collection('users').document('user1')
doc_ref.set({
    'name': 'John Doe',
    'email': 'john@example.com',
    'age': 30
})
 
# Query
users_ref = db.collection('users')
query = users_ref.where('age', '>=', 18).limit(10)
 
for doc in query.stream():
    print(f'{doc.id} => {doc.to_dict()}')
 
# Real-time listener
def on_snapshot(doc_snapshot, changes, read_time):
    for doc in doc_snapshot:
        print(f'Received document: {doc.id}')
 
doc_ref.on_snapshot(on_snapshot)

from google.cloud import pubsub_v1
 
# Publisher
publisher = pubsub_v1.PublisherClient()
topic_path = publisher.topic_path('project-id', 'topic-name')
 
data = "Hello World".encode('utf-8')
future = publisher.publish(topic_path, data)
print(f'Published message ID: {future.result()}')
 
# Subscriber
subscriber = pubsub_v1.SubscriberClient()
subscription_path = subscriber.subscription_path('project-id', 'subscription-name')
 
def callback(message):
    print(f'Received: {message.data.decode("utf-8")}')
    message.ack()
 
streaming_pull_future = subscriber.subscribe(subscription_path, callback=callback)