Skip to content

Instantly share code, notes, and snippets.

View guiathayde's full-sized avatar
🚀
Flying high

Guilherme Athayde guiathayde

🚀
Flying high
View GitHub Profile
@guiathayde
guiathayde / portal_do_cidadao_grupo_10.sql
Created June 11, 2025 18:06
Script SQL para criação do esquema físico do subsistema Portal do Cidadão - Grupo 10 - PIBD
-- ================================================================
-- 1. Criação do Banco de Dados e Implementação de Restrições
-- ================================================================
-- Drop e criação do banco de dados
DROP DATABASE IF EXISTS portal_cidadao;
CREATE DATABASE portal_cidadao;
\c portal_cidadao;
-- Tabela: Cidadão
{
"basics": {
"name": "Thomas Edison",
"label": "Inventor and Businessman",
"picture": "https://example.com/photo.jpg",
"email": "[email protected]",
"phone": "(123) 456-7890",
"website": "https://thomasedison.com",
"summary": "Prolific inventor and businessman known for developing many devices that greatly influenced life around the world, including the phonograph, the motion picture camera, and the electric light bulb.",
"location": {
{
"basics": {
"name": "Thomas Edison",
"label": "Inventor and Businessman",
"picture": "https://example.com/photo.jpg",
"email": "[email protected]",
"phone": "(123) 456-7890",
"website": "https://thomasedison.com",
"summary": "Prolific inventor and businessman known for developing many devices that greatly influenced life around the world, including the phonograph, the motion picture camera, and the electric light bulb.",
"location": {
@guiathayde
guiathayde / createInstitution.ts
Last active September 30, 2021 22:46
Requisição POST para criação de nova instituição
const onDropFiles = useCallback((files: any) => {
const formData = new FormData();
formData.append('data', JSON.stringify(institution)); // Object with all the institution's data
formData.append('profileImage', files[0]);
formData.append('galleryImages', files[1]);
formData.append('galleryImages', files[2]);
formData.append('galleryImages', files[3]);
formData.append('galleryImages', files[4]);
axios