Avocano is a sample dropship/fake product website with Cloud Run, Cloud SQL and Cloud Build

Related tags

Database avocano
Overview

Avocano - A Fake Product Website

Avocano is a sample dropship/fake product website, combining:

  • Firebase Hosting front end, written with Lit,
  • Cloud Run API backend, written with Django REST Framework,
  • Cloud SQL database, with migrations applied through Cloud Run Jobs, and
  • Terraform and Cloud Build provisioning.

Launch

Launch this application using the Cloud Shell:

Open in Cloud Shell

Screenshot of the deployed application

Use this application

Read more about how to use this application in the docs.

Code of Conduct

Please see the code of conduct

Contributions

Please see the contributing guidelines

License

This sample is licensed under Apache 2.0. Full license text is available in LICENSE.

Demo images used are part of Emoji Kitchen, mashups of Google's emoji set.

Comments
  • (feat): full project automation testing

    (feat): full project automation testing

    This project brings the experimental content from unicodex into avocano, where a scheduled Cloud Build trigger can be setup to have a service account create a project, deploy this sample, run tests, and destroy the project again.

    Uses playwright for client testing, pytest for server testing, and copious yaml/shell

    opened by glasnt 0
  • (minor): Cloud Run Jobs, cleanup

    (minor): Cloud Run Jobs, cleanup

    Intended to be an implementation of cloud run jobs in the main cloudbuild.yaml, but for reasons it didn't work (see docs/django/applying-migrations.md for more)

    also:

    • consolidates all server container/folder/service to server
    • adds docs for local dev (based on lessons learnt creating new migration file)
    • cleans up cloud run jobs task to create-once, run many (based on lessons learnt from another friction log)
    • misc spelling, formatting

    Tested manually in glasnt-featcrj2-7834 (next PR automates such testing)

    opened by glasnt 0
  • 📄 Document Products used

    📄 Document Products used

    As a...

    person interested in this project

    I want to...

    see what parts of Google Cloud this project users

    so that I can...

    better understand if this project is relevant to my interests.

    We should translate the internal documentation about integrations into a top level doc/architecture diagram. Probably right in /doc

    documentation 
    opened by glasnt 0
  • 🐞 [Bug Report] - Django IAM permissions too high

    🐞 [Bug Report] - Django IAM permissions too high

    Describe the bug

    The Django service account has viewer permissions on all Cloud Run services, not just itself

    To Reproduce https://github.com/GoogleCloudPlatform/avocano/blob/main/provisioning/terraform/iam.tf#L39

    Expected behavior

    https://cloud.google.com/iam/docs/using-iam-securely#least_privilege

    bug 
    opened by glasnt 0
  • 📄 Management commands

    📄 Management commands

    As a... django admin

    I want to... Run management commands against my deployed service

    so I can... perform administration tasks without logging into the Django admin.

    documentation 
    opened by glasnt 0
  • 🐞 Misformatted Google Fonts link in Django admin

    🐞 Misformatted Google Fonts link in Django admin

    Describe the bug The URL linked to "Google Forms" is malformed. It's currently "https://fonts.google.com/%20target=_blank".

    To Reproduce Steps to reproduce the behavior:

    1. Log into a deployed site's Django admin
    2. Go to Store > Site Config, and edit the active listing
    3. In the Base Font field, click the link.
    4. Observe the cute 404 page ((˚Δ˚)b Unfortunately, this page doesn't exist.)

    Expected behavior Link work.

    Screenshots Cute 404 https://fonts.google.com/+target

    bug 
    opened by glasnt 0
Owner
Google Cloud Platform
Google Cloud Platform
GitHub
Connect to private Google Cloud SQL instance through Cloud SQL Auth Proxy running in Kubernetes.

⛅ google-cloud-sql A CLI app which establishes a connection to a private Google Cloud SQL instance and port-forwards it to a local machine. Connection

Dinko Osrecki 10 Oct 16, 2022
A simple UI client for most SQL Engines written in Electron. It is compatible with Windows, Mac, Ubuntu / Debian and Redhat. It supports most dialects of RMBDs like MySQL, Microsoft SQL Server, Postgres, SQLite and has limited supports for Cassandra, MongoDB and Redis.

sqlui-native sqlui-native is a simple UI client for most SQL Engines written in Electron. It is compatible with most desktop OS's and support most dia

Sy Le 49 Jan 1, 2023
A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for storage and cloud sql proxy.

Simple URL Shorter - Google Cloud - Kubernetes A simple url shorter API built with nodejs running on Kubernetes in Google Cloud, using PostgreSQL for

null 3 Nov 25, 2021
Run SPARQL/SQL queries directly on Virtuoso database with connection pool support.

?? virtuoso-connector Package that allows you to create a direct connection to the Virtuoso database and run queries on it. Connection can be used to

Tomáš Dvořák 6 Nov 15, 2022
AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel.

Please use version 1.x as prior versions has a security flaw if you use user generated data to concat your SQL strings instead of providing them as a

Andrey Gershun 6.1k Jan 9, 2023
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap, Ionic, React Native, NativeScript, Expo, and Electron platforms and can be used

null 30.1k Jan 3, 2023
To reach out to a great audience brand especially in electronic📷📱💻 segment requests the Youtubers to review their product📷📱💻 on their channel(kind of 🎉brand promotion🎉), or if anybody wants to invite any youtuber of a specific event🎉 or for a charity purpose so they can reach out📮📧 to them easily. For that they need to contact.🤔❓❓.

Youtubers About Youtube a platform for content creators ?? ?? , entrepreneurs ??‍?? , creative ✨ minds ?? , and many more. They all reach out to a wid

Anupam Kumar Krishnan 21 Oct 12, 2022
Lovefield is a relational database for web apps. Written in JavaScript, works cross-browser. Provides SQL-like APIs that are fast, safe, and easy to use.

Lovefield Lovefield is a relational database written in pure JavaScript. It provides SQL-like syntax and works cross-browser (currently supporting Chr

Google 6.8k Jan 3, 2023
An adapter-based ORM for Node.js with support for mysql, mongo, postgres, mssql (SQL Server), and more

Waterline is a next-generation storage and retrieval engine, and the default ORM used in the Sails framework. It provides a uniform API for accessing

Balderdash 5.4k Jan 4, 2023
Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

DbGate 2k Dec 30, 2022
Validate and auto-generate TypeScript types from raw SQL queries in PostgreSQL.

SafeQL Write SQL Queries With Confidence • Get started Install I would first recommend follow the instructions in the documentation. npm install --sav

null 747 Dec 28, 2022
An easy-to-use multi SQL dialect ORM tool for Node.js

Sequelize Sequelize is a promise-based Node.js ORM tool for Postgres, MySQL, MariaDB, SQLite and Microsoft SQL Server. It features solid transaction s

Sequelize 27.3k Jan 4, 2023
An SQL-friendly ORM for Node.js

Objection.js Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the

Vincit 6.9k Jan 5, 2023
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server & SQLite

Prisma Quickstart • Website • Docs • Examples • Blog • Slack • Twitter • Prisma 1 What is Prisma? Prisma is a next-generation ORM that consists of the

Prisma 28k Jan 2, 2023
Microsoft SQL Server client for Node.js

node-mssql Microsoft SQL Server client for Node.js Supported TDS drivers: Tedious (pure JavaScript - Windows/macOS/Linux, default) Microsoft / Contrib

null 2.1k Jan 4, 2023
TypeScript clients for databases that prevent SQL Injection

Safe From HTML Injection Using tagged template literals for queries, e.g. db.query(sql`SELECT * FROM users WHERE id=${userID}`); makes it virtually im

Forbes Lindesay 478 Dec 21, 2022
Conjure SQL from GraphQL queries 🧙🔮✨

Sqlmancer Conjure SQL from your GraphQL queries ?? ?? ✨ ⚠️ This project is currently on hiatus. I am hoping to resume working on Sqlmancer once I have

Daniel Rearden 132 Oct 30, 2022
Postgres SQL RCE.js

Postgres-SQLi-RCE.js PostgreSQL Large Objects and UDF (User Defined Functions) RCE exploit re-written in javascript, for easy chaining with XSS Methdo

Amit 1 Jan 20, 2022
Free Introduction to SQL eBook

This is an open-source introduction to SQL guide that will help you to learn the basics of SQL and start using relational databases for your SysOps, DevOps, and Dev projects. No matter if you are a DevOps/SysOps engineer, developer, or just a Linux enthusiast, you will most likely have to use SQL at some point in your career.

Bobby Iliev 207 Jan 2, 2023