Andres Vazquez avdata99

Overview

Goal is to migrate a database from Heroku to Google Cloud

Here's how I configured a GitHub Action so that a new version issued by GitHub's release interface will build a Dockerfile, tag it with the version number and upload it to Google Artifact Registry.

Before you attempt the steps below, you need the following:

	<div class="control-group">
	<label class="control-label">Location</label>
	<div class="controls">
	<input name="location" type="text" placeholder="City, State, Country" value="">
	<input name="location_city" type="hidden" value="">
	<input name="location_state" type="hidden" value="">
	<input name="location_country" type="hidden" value="">
	<input name="location_lat" type="hidden">
	<input name="location_lng" type="hidden">
	</div>

	WITH votos_summary AS
	(SELECT ve.mesa_desde,
	ve.mesa_hasta,
	SUM(total) AS total_parcodigo,
	ve.vot_parcodigo,
	ve.dne_distri,
	ve.dne_seccio,
	row_number() over(partition BY ve.mesa_desde,ve.mesa_hasta
	ORDER BY sum(total) DESC) AS rk
	FROM votos_establecimiento_octubre ve

	<?xml version="1.0" encoding="UTF-8"?>
	<csw:GetRecords xmlns:csw="http://www.opengis.net/cat/csw/2.0.2" service="CSW" version="2.0.2" resultType="results" maxRecords="100" xmlns:gmd="http://www.isotc211.org/2005/gmd">
	<csw:Query typeNames="csw:Record">
	<csw:ElementSetName>full</csw:ElementSetName>
	<csw:Constraint version="1.1.0">
	<ogc:Filter xmlns:ogc="http://www.opengis.net/ogc">
	<ogc:PropertyIsEqualTo matchCase="true">
	<ogc:PropertyName>subject</ogc:PropertyName>
	<ogc:Literal>Bâtiments</ogc:Literal>
	</ogc:PropertyIsEqualTo>