This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
# coding: utf8 | |
import copy | |
import PyPDF2 | |
import sys | |
def split_page(src, dst, row=1, col=1, margin=0): | |
src_f = file(src, 'r+b') |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env bash | |
# Work for OpenChronic project https://entrepreneur-interet-general.etalab.gouv.fr/defis/2019/openchronic.html | |
# https://docs.question2answer.org/install/ | |
SERVER= | |
ROOT_PASSWORD= | |
Q2A_MYSQL_PASSWORD= | |
Q2A_ROOT_PASSWORD= |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE OR REPLACE VIEW table_to_role AS ( | |
SELECT | |
tables.id as table_id, | |
tables.table_name as table_name, | |
ab_role.name as role_name | |
FROM | |
tables | |
LEFT JOIN ab_view_menu ON ab_view_menu.name = tables.perm | |
LEFT JOIN ab_permission_view on ab_permission_view.view_menu_id = ab_view_menu.id | |
LEFT JOIN ab_permission on ab_permission_view.permission_id = ab_permission.id |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python | |
# coding: utf8 | |
# Script to create superset users | |
import pandas as pd | |
from sqlalchemy import create_engine | |
import datetime | |
import pexpect | |
import os |