bigquery-public-data.new_york_taxi_trips.tlc_yellow_trips_2017
Table size 12.79 GB
Number of rows 113,496,874
``SELECT total_amount, pickup_datetime, trip_distance
| <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> | |
| <modelVersion>4.0.0</modelVersion> | |
| <groupId>gcfv2</groupId> | |
| <artifactId>http</artifactId> | |
| <version>0.0.1</version> | |
| <name>HTTP Function for Cloud Functions 2nd gen</name> | |
| <properties> | |
| <maven.compiler.target>11</maven.compiler.target> |
| <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd"> | |
| <modelVersion>4.0.0</modelVersion> | |
| <groupId>gcfv2</groupId> | |
| <artifactId>http</artifactId> | |
| <version>0.0.1</version> | |
| <name>HTTP Function for Cloud Functions 2nd gen</name> | |
| <properties> | |
| <maven.compiler.target>11</maven.compiler.target> |
| package gcfv2; | |
| import java.io.BufferedWriter; | |
| import com.google.gson.Gson; | |
| import com.google.gson.JsonObject; | |
| import java.io.BufferedReader; | |
| import java.io.InputStreamReader; | |
| import java.util.stream.Collectors; |
| import datetime | |
| import os | |
| from google.cloud import logging | |
| from typing import Mapping | |
| import google.auth.transport.requests | |
| import google.oauth2.id_token | |
| import requests | |
| import flask | |
| gcloud functions deploy summarizeText \ | |
| --gen2 \ | |
| --runtime=python311 \ | |
| --region=$GCP_REGION \ | |
| --source=. \ | |
| --entry-point=summarizeText \ | |
| --trigger-http \ | |
| --set-env-vars=GCP_PROJECT=$GCP_PROJECT,GCP_REGION=$GCP_REGION \ | |
| --allow-unauthenticated |
| import os | |
| import json | |
| import functions_framework | |
| import google.cloud.logging | |
| import vertexai | |
| from vertexai.language_models import TextGenerationModel | |
| PROJECT_ID = os.environ.get('GCP_PROJECT','-') |
| const browser = await puppeteer.launch({args: ['--no-sandbox']}); | |
| const page = await browser.newPage(); | |
| await page.goto("https://loveiscomix.com/random"); | |
| let imageurl = await page.evaluate(() => { | |
| let item = document.querySelector('#primary > main > article > div > div.cellcomic > a > img'); | |
| return 'https://loveiscomix.com/' + item.getAttribute('src'); | |
| }) | |
| browser.close(); |
| let LoveIsComic_HTMLTemplate = ( | |
| url | |
| ) => { | |
| return ` | |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <title>Love Is Comic</title> | |
| </head> | |
| <body> |
| function retrieveSentimentCF (line) { | |
| var apiEndpoint = 'YOUR_CLOUDFUNCTIONS_HTTPS_ENDPOINT'; | |
| var reviewData = { | |
| review_text: line | |
| }; | |
| var cfCallOptions = { | |
| method : 'post', | |
| contentType: 'application/json', |