Skip to content

Instantly share code, notes, and snippets.

View morzzz007's full-sized avatar

Márton Papp morzzz007

View GitHub Profile
@morzzz007
morzzz007 / README.md
Created July 14, 2022 09:11
A streaming workflow for BigQuery to BigTable transfer with QUERY string

Itt project_id arg van es JO a UI-rol kimasolhato string a querybe (59-es sor)

Fontos:

Ez egy kulon jobot csinal, az IAM-ban a service accountnak kell a bigquery.datasets.create ES a bigquery.jobs.create jog.

@morzzz007
morzzz007 / README.md
Last active July 14, 2022 09:06
A batch workflow for BigQuery to BigTable transfer

Ez nem tud queryzni csak vegigmegy az egesz tablan, eleg a BigQuery Read Session User jog az IAM-ban a service accountnak.

FONTOS:

A --table_spec ems-plugins:sap_cc_products_test_dataset.sap_cc_products_test_table

!!!! KETTOSPONTTAL !!!!

mukodik csak a project neve utan, amit a kibaszott Cloud Console UI a vagolapra masol ott PONT van es NEM jo.

@morzzz007
morzzz007 / streaming-pubsub-to-bigtable.py
Created July 13, 2022 08:57
A streaming workflow for Pubsub to BigTable transfer
"""A streaming workflow for Pubsub to BigTable transfer
"""
# pytype: skip-file
from apache_beam.options.pipeline_options import StandardOptions
from apache_beam.options.pipeline_options import SetupOptions
from apache_beam.options.pipeline_options import PipelineOptions
from apache_beam.io.gcp.bigtableio import WriteToBigTable
from google.cloud.bigtable import row
@morzzz007
morzzz007 / part I
Created April 4, 2020 12:03
push the button
---
title: Push the button - Getting Started With IoT & MQTT
published: false
description: Creating an IoT button from scratch for beginners
tags: arduino,iot,mqtt,esp32
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/j8i605vntq9x76ge8dtt.jpg
series: Push the button
---
Yes, I know what you think: there are already a ton of MQTT related posts and videos circulating around the net. But here is one thing I noticed: most of them either failed to demonstrate how to get started with an MQTT broker, or did not show any code about how to actually get things working, or did not provide an easy enough concept to begin with.
Error in user YAML: (<unknown>): mapping values are not allowed in this context at line 1 column 20
---
title: Knex ❤️ PSQL: updating timestamps like a pro
published: false
description:
tags: node, knex, psql, postgres
---

Knex.js is the most popular SQL query builder around and the go-to solution for most of us working with PostgreSQL. You can find dozens of articles even at dev.to about how to get started, so I decided to focus on a more advanced and often overlooked topic on how to keep the updated_at fields really updated - automatically.

What does table.timestamps() do?

@morzzz007
morzzz007 / vim-heroku.sh
Created July 23, 2018 10:39 — forked from dvdbng/vim-heroku.sh
Run vim in heroku updated 2017
mkdir ~/vim
cd ~/vim
# Staically linked vim version compiled from https://github.com/ericpruitt/static-vim
# Compiled on Jul 20 2017
curl 'https://s3.amazonaws.com/bengoa/vim-static.tar.gz' | tar -xz
export VIMRUNTIME="$HOME/vim/runtime"
export PATH="$HOME/vim:$PATH"
cd -
@morzzz007
morzzz007 / Penz
Last active April 2, 2017 07:01
Excel Macro Date Format
Sub Makró1()
'
' Makró1 Makró
'
'
Dim dateCellValue As String
Dim rowValue As String
rowValue = 6
{
"_id" : ObjectId("575e65475dd724c737ce021c"),
"name" : "Giga template mocsok sok blokkal",
"customer_id" : 110392203,
"blocks" : [
{
"template" : ObjectId("575e6556e305ed7bf0000001"),
"_id" : ObjectId("575e66355dd724c737ce0223")
},
{
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width">
<title>JS Bin</title>
</head>
<body>
<script id="jsbin-javascript">
@morzzz007
morzzz007 / snippets.cson
Created May 9, 2016 08:40
Atom Snippets
'.source.js.jsx':
'Component class':
'prefix': 'comp'
'body': """
export class ${1:SampleComponent} {
constuctor() {
}
static create() {