jdmedeiros

/* ===========================
   Testes para northwind.Region
   =========================== */

/* 1️⃣ Inserir APENAS o nome em português (gera tradução automática para inglês) */
INSERT INTO northwind.Region (RegionID, RegionDescription, ptnome)
VALUES (110, 'Color test 1', 'Verde');

INSERT INTO northwind.Region (RegionID, RegionDescription, ptnome)
VALUES (111, 'Color test 2', 'Anil');

jdmedeiros

/* ================================
   AVALIAÇÃO PARTE 2 — northwind.Region
   Requisitos esperados:
   - Tabela `Region` existe
   - Colunas VARCHAR(50): `ptnome`, `ennome`
   - Triggers BEFORE INSERT e BEFORE UPDATE que:
       * PT -> EN automático quando só PT é fornecido
       * EN -> PT automático quando só EN é fornecido
       * No-op quando ambos são fornecidos
       * Validação: apenas 7 cores (PT/EN), case-insensitive

jdmedeiros

Great choice! Learning the Linux command line will give you much more control and flexibility with Ubuntu. Here’s a structured overview of the most important commands you’ll want to know as you get started:

---

🔎 System Navigation & File Management

• pwd → Show your current directory (print working directory).

• ls → List files and folders in the current directory.

• Options: ls -l (detailed), ls -a (show hidden), ls -lh (human-readable sizes).

jdmedeiros

f0VMRgIBAQAAAAAAAAAAAAIAPgABAAAAwAZAAAAAAABAAAAAAAAAAMAaAAAAAAAAAAAAAEAAOAAJ
AEAAHQAcAAYAAAAFAAAAQAAAAAAAAABAAEAAAAAAAEAAQAAAAAAA+AEAAAAAAAD4AQAAAAAAAAgA
AAAAAAAAAwAAAAQAAAA4AgAAAAAAADgCQAAAAAAAOAJAAAAAAAAcAAAAAAAAABwAAAAAAAAAAQAA
AAAAAAABAAAABQAAAAAAAAAAAAAAAABAAAAAAAAAAEAAAAAAANgLAAAAAAAA2AsAAAAAAAAAACAA
AAAAAAEAAAAGAAAAAA4AAAAAAAAADmAAAAAAAAAOYAAAAAAAaQIAAAAAAACQAgAAAAAAAAAAIAAA
AAAAAgAAAAYAAAAQDgAAAAAAABAOYAAAAAAAEA5gAAAAAADgAQAAAAAAAOABAAAAAAAACAAAAAAA
AAAEAAAABAAAAFQCAAAAAAAAVAJAAAAAAABUAkAAAAAAAEQAAAAAAAAARAAAAAAAAAAEAAAAAAAA
AFDldGQEAAAAhAoAAAAAAACECkAAAAAAAIQKQAAAAAAAPAAAAAAAAAA8AAAAAAAAAAQAAAAAAAAA
UeV0ZAYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAABS
5XRkBAAAAAAOAAAAAAAAAA5gAAAAAAAADmAAAAAAAAACAAAAAAAAAAIAAAAAAAABAAAAAAAAAC9s

jdmedeiros

// Build: gcc -O0 -fno-pie -no-pie totp.c -o totp -lcrypto
// Notes:
//  -O0 keeps simple branches
//  -fno-pie -no-pie makes addresses stable & easy to map to file offsets

#include <stdio.h>
#include <stdint.h>
#include <string.h>
#include <time.h>
#include <inttypes.h>

jdmedeiros

Network Configuration Management on Amazon Linux 2023

This guide details how to override the default gateway assigned by DHCP.

Opening and Editing Network Configuration

1. Open the Network Configuration File Use nano (or any text editor of your choice) to open the network configuration file:

sudo nano /usr/lib/systemd/network/80-ec2.network

jdmedeiros

sudo apt update && sudo apt -y upgrade
sudo apt -y install lvm2 mdadm gdisk raidutils cryptsetup
lsblk

: <<'END'
    NAME         MAJ:MIN RM  SIZE RO TYPE MOUNTPOINTS
    loop0          7:0    0 24.9M  1 loop /snap/amazon-ssm-agent/7628
    loop1          7:1    0 55.7M  1 loop /snap/core18/2812
    loop2          7:2    0   87M  1 loop /snap/lxd/27037
    loop3          7:3    0 63.9M  1 loop /snap/core20/2182

jdmedeiros

[Unit]
Description=Open-Mount and Unmount-Close LVM LUKS RAID6 Volume
After=local-fs-pre.targe

[Service]
Type=oneshot
RemainAfterExit=yes
ExecStartPre=-/bin/mkdir -p /mnt/raid6LVM
ExecStartPre=-/bin/umount /mnt/raid6LVM
ExecStart=/usr/lib/systemd/systemd-cryptsetup attach lv1_crypt /dev/vg1/lv1

jdmedeiros

[Unit]
Description=Open-Mount and Unmount-Close LUKS RAID6 Volume
After=local-fs-pre.targe

[Service]
Type=oneshot
RemainAfterExit=yes
ExecStartPre=-/bin/mkdir -p /mnt/raid6NoLVM
ExecStartPre=-/bin/umount /mnt/raid6NoLVM
ExecStart=/usr/lib/systemd/systemd-cryptsetup attach md0_crypt /dev/md0

jdmedeiros

from flask_appbuilder.security.manager import AUTH_OAUTH

SECRET_KEY = 'A1B4E2F0C3D7FE98456AC0BD34EF1234'

AUTH_TYPE = AUTH_OAUTH
AUTH_USER_REGISTRATION = True
AUTH_USER_REGISTRATION_ROLE = "Admin"
OAUTH_PROVIDERS = [
        {
            'name': 'auth0',