Skip to content

Instantly share code, notes, and snippets.

View mapcentia's full-sized avatar

Martin Høgh mapcentia

View GitHub Profile
@mateuszwenus
mateuszwenus / save_restore_dependencies.sql
Last active May 13, 2025 10:08
PostgreSQL: How to handle table and view dependencies
create table deps_saved_ddl
(
deps_id serial primary key,
deps_view_schema varchar(255),
deps_view_name varchar(255),
deps_ddl_to_run text
);
create or replace function deps_save_and_drop_dependencies(p_view_schema varchar, p_view_name varchar) returns void as
$$
module.exports = {
// Følgende settings bliver sat under build/startup.
// Dvs at de ikke kan ændres i runtime.
// Bemærk, at baselayers er flyttet ud af cartodb objektet.
// ========================================================
backend: "cartodb",
cartodb: {
db: "mhoegh"
@baffioso
baffioso / add_plan_document.py
Created February 3, 2018 12:31
Opdater lokalplan tabel i postgres med tekst fra plandokument pdf
import requests
import io
import PyPDF2
import psycopg2
from sqlalchemy import create_engine, Table, MetaData, update, select
def get_document(url):
try:
r = requests.get(url)
except Exception as e: