Skip to content

Instantly share code, notes, and snippets.

@matse004
matse004 / save_restore_dependencies.sql
Created April 11, 2018 14:28 — forked from mateuszwenus/save_restore_dependencies.sql
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
$$
@matse004
matse004 / convert.md
Last active December 15, 2017 10:25
Convert pandas DataFrames and Series into python dictionaries that can be saved in MongoDB
def convert_to_dict(source):
    if isinstance(source, dict):
        data = {}
        for key, value in source.items():
            new_key = convert_to_dict(key)
            data[new_key] = convert_to_dict(value)
        return data
    elif isinstance(source, (pd.DataFrame, pd.Series)):
        # resetting multiindex levels