YuriFontella

Camada Gold — Análise Financeira

Tabelas analíticas geradas a partir do Bronze. Executadas diariamente via run/gold.py, após a conclusão de todos os jobs Bronze.

---

Arquitetura

Bronze (dados brutos da API Omie)

YuriFontella

version: "3.8"

services:
  n8n_editor:
    image: n8nio/n8n:latest
    command: start
    networks:
      - traefik-public
      - backend
      - redis

YuriFontella

import asyncio
import logging

from pathlib import Path
from contextlib import asynccontextmanager
from enum import Enum

from litestar import Litestar, get, post, Controller, Request, Response, Router, WebSocket, websocket, MediaType
from litestar.types import ASGIApp, Scope, Receive, Send
from litestar.datastructures import State

YuriFontella

from starlette.applications import Starlette
from starlette.responses import JSONResponse, Response
from starlette.requests import Request
from starlette.routing import Route

import hmac
import hashlib
import secrets
import sqlite3

YuriFontella

import asyncio

from tortoise import Tortoise, fields
from tortoise.connection import connections
from tortoise.models import Model

class Author(Model):
    id = fields.IntField(pk=True)
    name = fields.CharField(max_length=255)

YuriFontella

import httpx
import asyncio

from fastapi import FastAPI, Request
from tortoise import Tortoise, Model, fields, connections
from WPP_Whatsapp import Create

from urllib.parse import parse_qs
from contextlib import asynccontextmanager

YuriFontella

sudo apt install libedit-dev libssl-dev libffi-dev lzma bzip2 sqlite3 zlib1g-dev build-essential

curl https://pyenv.run | bash

echo 'export PYENV_ROOT="$HOME/.pyenv"' >> ~/.bashrc
echo 'command -v pyenv >/dev/null || export PATH="$PYENV_ROOT/bin:$PATH"' >> ~/.bashrc
echo 'eval "$(pyenv init -)"' >> ~/.bashrc

pyenv install 3.12.2

YuriFontella

const xlsx = require('xlsx')
const { Writable, Transform } = require('stream')

const fs = require('fs')
const path = require('path')

console.log('início')


const workbook = xlsx.readFile('data-600.xlsx', { sheetStubs: true })

YuriFontella

import { inject, reactive, toRefs } from 'vue'

import { Cookies, Notify } from 'quasar'

export function useHttp() {

  const state = reactive({
    loading: false, data: null
  })

YuriFontella

(async () => {

  console.time()

  async function delay(ms) {
    return new Promise(resolve => setTimeout(resolve, ms))
  }

  const time = 2000
  const total = 2