jftuga / upsert.py

Created May 19, 2021 08:06 — forked from bhtucker/upsert.py

A demonstration of Postgres upserts in SQLAlchemy

	"""
	Upsert gist

	Requires at least postgres 9.5 and sqlalchemy 1.1

	Initial state:

	[]
	Initial upsert:

jftuga / sqlalchemy_upsert.py

Created May 19, 2021 08:05 — forked from malexer/sqlalchemy_upsert.py

Modelling UPSERT in SQLAlchemy (well actually it is not upsert but speed improvement is significant in comparison with simple session.merge)

	# Note: it is a copy of great answer by "mgoldwasser" from Stackoverflow
	# Check the original answer here: http://stackoverflow.com/a/26018934/1032439

	# Imagine that post1, post5, and post1000 are posts objects with ids 1, 5 and 1000 respectively
	# The goal is to "upsert" these posts.
	# we initialize a dict which maps id to the post object

	my_new_posts = {1: post1, 5: post5, 1000: post1000}

	for each in posts.query.filter(posts.id.in_(my_new_posts.keys())).all():

jftuga / app.py

Created May 19, 2021 07:54 — forked from DmitryBe/app.py

SQLAlchemy quick start

	# http://bytefish.de/blog/first_steps_with_sqlalchemy/

	from sqlalchemy.ext.declarative import declarative_base
	from sqlalchemy import create_engine
	from datetime import datetime, timedelta
	from sqlalchemy import Table, Column, Integer, String, DateTime, ForeignKey
	from sqlalchemy.orm import relationship, backref
	from sqlalchemy.orm import sessionmaker

	Base = declarative_base()

jftuga / MyViewController.cs

Created January 28, 2021 20:39 — forked from ShayMe21/MyViewController.cs

Xamarin with Auth0 and TouchID Authentication

	// https://github.com/auth0-community/auth0-xamarin-oidc-samples/tree/master/Quickstart/01-Login/iOS

	using System;

	using UIKit;
	using Auth0.OidcClient;
	using System.Text;
	using LocalAuthentication;
	using Foundation;
	using Xamarin.Auth;

jftuga / go-os-arch.md

Created December 4, 2020 19:07 — forked from asukakenji/0-go-os-arch.md

Go (Golang) GOOS and GOARCH

All of the following information is based on go version go1.14.7 darwin/amd64.

A list of valid GOOS values

(Bold = supported by go out of the box, ie. without the help of a C compiler, etc.)

jftuga / macapp.go

Last active December 8, 2020 12:33 — forked from mholt/macapp.go

Distribute your Go program (or any single binary) as a native macOS application

	// Package main is a sample macOS-app-bundling program to demonstrate how to
	// automate the process described in this tutorial:
	//
	// https://medium.com/@mattholt/packaging-a-go-application-for-macos-f7084b00f6b5
	//
	// Bundling the .app is the first thing it does, and creating the DMG is the
	// second. Making the DMG is optional, and is only done if you provide
	// the template DMG file, which you have to create beforehand.
	//
	// Example use:

John Taylor jftuga