Skip to content

Instantly share code, notes, and snippets.

View Corvan's full-sized avatar

Lars Liedtke Corvan

View GitHub Profile
@Corvan
Corvan / create_tablestring.py
Created February 26, 2023 14:36
Using sqlalchemy to inspect a postgres database
import sqlalchemy
engine = sqlalchemy.create_engine("postgresql+psycopg2:///lars")
meta = sqlalchemy.schema.MetaData()
meta.reflect(bind=engine)
inspector = sqlalchemy.inspect(engine)
default_schema_name = inspector.default_schema_name
schema_names = inspector.get_schema_names()
def create_tables(if_exists: bool = False) -> str:
[00:00:00] =>> Building java/openjdk11
[00:00:00] build started at Tue Oct 6 08:48:10 CEST 2020
[00:00:00] port directory: /usr/ports/java/openjdk11
[00:00:00] package name: openjdk11-11.0.8+10.1
[00:00:00] building for: FreeBSD builder.intern.punkt.de 12.1-RELEASE-p10 FreeBSD 12.1-RELEASE-p10 amd64
[00:00:00] maintained by: java@FreeBSD.org
[00:00:00] Makefile ident:
[00:00:00] Poudriere version: 3.3.4
[00:00:00] Host OSVERSION: 1201000
[00:00:00] Jail OSVERSION: 1201000
@Corvan
Corvan / second_run_ipv4
Created June 17, 2019 13:21
Gist to show a bug in vagrant
lars@tuxedo:/home/lars/PycharmProjects/ansible-poudriere git:(master*) $ vagrant --debug up
INFO global: Vagrant version: 2.2.4
INFO global: Ruby version: 2.4.4
INFO global: RubyGems version: 2.6.14.1
INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.2.4/gems/vagrant-2.2.4/bin/vagrant"
INFO global: VAGRANT_INSTALLER_ENV="1"
INFO global: VAGRANT_INSTALLER_VERSION="2"
INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded"
INFO global: VAGRANT_LOG="debug"
WARN global: resolv replacement has not been enabled!
@Corvan
Corvan / first_run_ipv4
Created June 17, 2019 13:19
Gist to show a bug in vagrant
lars@tuxedo:/home/lars/PycharmProjects/ansible-poudriere git:(master*) $ vagrant --debug up
INFO global: Vagrant version: 2.2.4
INFO global: Ruby version: 2.4.4
INFO global: RubyGems version: 2.6.14.1
INFO global: VAGRANT_INSTALLER_ENV="1"
INFO global: VAGRANT_INSTALLER_VERSION="2"
INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded"
INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.2.4/gems/vagrant-2.2.4/bin/vagrant"
INFO global: VAGRANT_LOG="debug"
WARN global: resolv replacement has not been enabled!
@Corvan
Corvan / second_run_ipv6
Created June 17, 2019 13:13
Gist to show a bug in vagrant
lars@tuxedo:/home/lars/PycharmProjects/ansible-poudriere git:(master*) $ vagrant --debug up
INFO global: Vagrant version: 2.2.4
INFO global: Ruby version: 2.4.4
INFO global: RubyGems version: 2.6.14.1
INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded"
INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.2.4/gems/vagrant-2.2.4/bin/vagrant"
INFO global: VAGRANT_INSTALLER_VERSION="2"
INFO global: VAGRANT_INSTALLER_ENV="1"
INFO global: VAGRANT_LOG="debug"
WARN global: resolv replacement has not been enabled!
@Corvan
Corvan / first_run_ipv6
Last active June 17, 2019 13:12
Gist to show a bug in vagrant
lars@tuxedo:/home/lars/PycharmProjects/ansible-poudriere git:(master*) $ vagrant --debug up
INFO global: Vagrant version: 2.2.4
INFO global: Ruby version: 2.4.4
INFO global: RubyGems version: 2.6.14.1
INFO global: VAGRANT_INSTALLER_VERSION="2"
INFO global: VAGRANT_EXECUTABLE="/opt/vagrant/embedded/gems/2.2.4/gems/vagrant-2.2.4/bin/vagrant"
INFO global: VAGRANT_INSTALLER_ENV="1"
INFO global: VAGRANT_INSTALLER_EMBEDDED_DIR="/opt/vagrant/embedded"
INFO global: VAGRANT_LOG="debug"
WARN global: resolv replacement has not been enabled!