EssenceSentry

swagger: "2.0"
servers:
  - url: https://www.kaggle.com/api/v1
    description: Kaggle API
    variables:
      host:
        default: www.kaggle.com
      basePath:
        default: /api/v1
info:

EssenceSentry

#!/bin/bash

GITHUB_TOKEN=<DO-NOT-COMMIT>
SWAP_SIZE="16G"

# install pyenv to install alternative python versions
sudo apt-get update
sudo apt-get install make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev \
libsqlite3-dev wget curl llvm libncursesw5-dev xz-utils tk-dev libxml2-dev libxmlsec1-dev \
libffi-dev liblzma-dev libedit-dev git -y

EssenceSentry

from typing import Optional

import pydantic
from pydantic_sqlalchemy import sqlalchemy_to_pydantic

from app.core import models


class AllOptional(pydantic.main.ModelMetaclass):
    def __new__(mcs, name, bases, namespaces, **kwargs):

EssenceSentry

.PHONY: all prepare-dev venv lint test run shell clean build install docker
SHELL=/bin/bash

VENV_NAME?=venv
VENV_BIN=$(shell pwd)/${VENV_NAME}/bin
VENV_ACTIVATE=. ${VENV_BIN}/activate

PYTHON=${VENV_BIN}/python3

FLASK=${VENV_BIN}/flask

EssenceSentry

curl -fsSL https://cli.github.com/packages/githubcli-archive-keyring.gpg | sudo gpg --dearmor -o /usr/share/keyrings/githubcli-archive-keyring.gpg
echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/githubcli-archive-keyring.gpg] https://cli.github.com/packages stable main" | sudo tee /etc/apt/sources.list.d/github-cli.list > /dev/null
sudo apt update
sudo apt install gh

EssenceSentry

ssh-keygen -t ed25519 -C "sellanes.jose@gmail.com"

EssenceSentry

sudo apt-get update; sudo apt-get install make build-essential libssl-dev zlib1g-dev libbz2-dev libreadline-dev libsqlite3-dev wget curl llvm libncursesw5-dev xz-utils tk-dev libxml2-dev libxmlsec1-dev libffi-dev liblzma-dev libedit-dev git
curl https://pyenv.run | bash
echo "export PATH=\$PATH:/home/agustin/.pyenv/bin" >> ./.bashrc
exec $SHELL

EssenceSentry

from pydantic import BaseModel
from sqlalchemy.dialects.mysql import (NUMERIC, DECIMAL, DOUBLE, REAL, FLOAT, INTEGER, BIGINT, MEDIUMINT, TINYINT,
                                       SMALLINT, BIT, TIME, TIMESTAMP, DATETIME, YEAR, TEXT, TINYTEXT, MEDIUMTEXT,
                                       LONGTEXT, VARCHAR, CHAR, NVARCHAR, NCHAR, TINYBLOB, MEDIUMBLOB, LONGBLOB)

class Column(BaseModel):
    autoincrement: bool
    comment: Optional[str]
    default: Optional[Any]
    name: str

EssenceSentry

# pks is a dictionary with table names as keys and primary keys columns names as values
# if SQLAlqemy cannot find the primary keys from the table metadata, specifying the keys
# enables the ORM to generate the classes and relationships

def automap_session(engine: Engine, pks: Dict[str, str]) -> Tuple[Dict[str, BaseModel], Session]:
    metadata = MetaData()
    metadata.reflect(engine, schema=SCHEMA)
    cols = {t.name: {c.name: c for c in t.columns._all_columns} for t in metadata.tables.values()}
    for t, c in pks.items():
        cols[t][c].primary_key = True

EssenceSentry

create_engine(f'snowflake://{user}:{password}@{account}/{table}',
              connect_args={'options': f'-csearch_path={schema}'})