Documentation Index
Fetch the complete documentation index at: https://mintlify.com/17Franco/CulturarteWeb/llms.txt
Use this file to discover all available pages before exploring further.
copia.sql is a full MySQL dump that provides a ready-to-use dataset for local development and testing. It is loaded automatically when the Docker MySQL container is created for the first time: the docker-compose.yml maps ./copia.sql into /docker-entrypoint-initdb.d/copia.sql, so MySQL executes it on container initialisation without any manual intervention.
Running copia.sql against an existing database will execute DROP TABLE IF EXISTS for every table before recreating it. All existing data will be permanently lost. Always make a backup before re-seeding.
Before re-seeding, export your current data with mysqldump:mysqldump -u tecnologo -p Culturarte > backup_$(date +%F).sql
Categories Seeded
The seed inserts 21 category rows into the Categoria table — six root-level categories and fifteen subcategories.
Root categories
| Category |
|---|
| Carnaval |
| Cine |
| Danza |
| Literatura |
| Música |
| Teatro |
Subcategories
| Subcategory | Parent |
|---|
| Humoristas | Carnaval |
| Lubolos | Carnaval |
| Murga | Carnaval |
| Parodistas | Carnaval |
| Revista | Carnaval |
| Cine a Pedal | Cine |
| Cine al Aire Libre | Cine |
| Ballet | Danza |
| Flamenco | Danza |
| Concierto | Música |
| Festival | Música |
| Comedia | Teatro |
| Teatro Dramático | Teatro |
| Teatro Musical | Teatro |
| Stand-up | Comedia |
Stand-up is a child of Comedia, which is itself a child of Teatro, making it a third-level category. Literatura has no subcategories in the seed data.
copia.sql:
INSERT INTO `Categoria` VALUES
('Carnaval',NULL),('Cine',NULL),('Danza',NULL),
('Literatura',NULL),('Música',NULL),('Teatro',NULL),
('Humoristas','Carnaval'),('Lubolos','Carnaval'),
('Murga','Carnaval'),('Parodistas','Carnaval'),('Revista','Carnaval'),
('Cine a Pedal','Cine'),('Cine al Aire Libre','Cine'),
('Stand-up','Comedia'),
('Ballet','Danza'),('Flamenco','Danza'),
('Concierto','Música'),('Festival','Música'),
('Comedia','Teatro'),('Teatro Dramático','Teatro'),('Teatro Musical','Teatro');
Sample Users
The seed populates 20 users in the Usuario table. Among them, 11 are registered as Colaborador and 9 as Proponente (roles are not mutually exclusive at the database level).
Collaborator nicknames
| Nickname |
|---|
| chino |
| juanP |
| marcelot |
| Mengano |
| nicoJ |
| novick |
| Peregano |
| robinh |
| sergiop |
| Tiajaci |
| tonyp |
Proposer nicknames
| Nickname | Name | Notable work |
|---|
cachilas | Waldemar “Cachila” Silva | Comparsa Cuareim 1080 |
diegop | Diego Parodi | Efecto Cine cycle |
hectorg | Héctor Guido | Teatro El Galpón |
hrubino | Horacio Rubino | Momosapiens (Carnaval) |
juliob | Julio Bocca | Ballet Nacional del Sodre |
kairoh | Kairo Herrera | Pilsen Rock festival |
losBardo | Los Bardo | Bardo Científico science comedy |
mbusca | Martín Buscaglia | Musician / El Pimiento Indomable |
tabarec | Tabaré Cardozo | Murga Agarrate Catalina |
Sample Proposals
Eight cultural event proposals are seeded into the Propuesta table:
| Title | Category | Venue | Funding Target | Ticket Price | Proposer |
|---|
| Cine en el Botanico | Cine al Aire Libre | Jardin Botanico | $150,000 | $200 | diegop |
| Religiosamente | Parodistas | Teatro de Verano | $300,000 | $300 | hrubino |
| El Pimiento Indomable | Concierto | Teatro Solís | $400,000 | $400 | mbusca |
| Pilsen Rock | Festival | Rural del Prado | $900,000 | $1,000 | kairoh |
| Romeo y Julieta | Ballet | Auditorio Nacional del Sodre | $750,000 | $800 | juliob |
| Un día de Julio | Murga | Landia | $300,000 | $650 | tabarec |
| El Lazarillo de Tormes | Teatro Dramático | Teatro el Galpón | $175,000 | $350 | hectorg |
| Bardo en la FING | Stand-up | Anfiteatro Edificio “José Luis Massera” | $100,000 | $200 | losBardo |
Sample Collaborations
The seed inserts 17 collaboration records into the Colaboracion table. The tipoRetorno column is a MySQL ENUM with two values:
EntradaGratis — free admission to the event.PorcentajeGanancia — a percentage of the event’s profits.
| ID | Date | Colaborador | Propuesta | Monto | TipoRetorno |
|---|
| 1 | 2017-05-20 | novick | Cine en el Botanico | 50,000 | PorcentajeGanancia |
| 2 | 2017-05-24 | robinh | Cine en el Botánico | 50,000 | PorcentajeGanancia |
| 3 | 2017-05-30 | nicoJ | Cine en el Botánico | 50,000 | PorcentajeGanancia |
| 4 | 2017-06-30 | marcelot | Religiosamente | 200,000 | PorcentajeGanancia |
| 5 | 2017-07-01 | Tiajaci | Religiosamente | 500 | EntradaGratis |
| 6 | 2017-07-07 | Mengano | Religiosamente | 600 | EntradaGratis |
| 7 | 2017-07-10 | novick | Religiosamente | 50,000 | PorcentajeGanancia |
| 8 | 2017-07-15 | sergiop | Religiosamente | 50,000 | PorcentajeGanancia |
| 9 | 2017-08-01 | marcelot | El Pimiento Indomable | 200,000 | PorcentajeGanancia |
| 10 | 2017-08-03 | sergiop | El Pimiento Indomable | 80,000 | PorcentajeGanancia |
| 11 | 2017-08-05 | chino | Pilsen Rock | 50,000 | EntradaGratis |
| 12 | 2017-08-10 | novick | Pilsen Rock | 120,000 | PorcentajeGanancia |
| 13 | 2017-08-15 | tonyp | Pilsen Rock | 120,000 | EntradaGratis |
| 14 | 2017-08-13 | sergiop | Romeo y Julieta | 100,000 | PorcentajeGanancia |
| 15 | 2017-08-14 | marcelot | Romeo y Julieta | 200,000 | PorcentajeGanancia |
| 16 | 2017-08-15 | tonyp | Un día de Julio | 30,000 | EntradaGratis |
| 17 | 2017-08-17 | marcelot | Un día de Julio | 150,000 | PorcentajeGanancia |
Loading Seed Data Manually
To load copia.sql into a running MySQL instance outside of Docker:
mysql -u tecnologo -p Culturarte < copia.sql
tecnologo in the default Docker setup).
To load it into the Dockerised database directly:
docker exec -i BaseDatosC mysql -u tecnologo -ptecnologo Culturarte < copia.sql
Docker Auto-Seed
The docker-compose.yml file configures auto-seeding via a volume mount into MySQL’s initialisation directory:
dbculturarteWeb:
image: mysql:8.0.17
container_name: BaseDatosC
environment:
MYSQL_DATABASE: Culturarte
MYSQL_ROOT_PASSWORD: tecnologo
MYSQL_PASSWORD: tecnologo
MYSQL_USER: tecnologo
volumes:
- ./copia.sql:/docker-entrypoint-initdb.d/copia.sql
- db_data:/var/lib/mysql
ports:
- "3307:3306"
BaseDatosC container starts for the first time and /var/lib/mysql is empty (i.e., the db_data named volume does not yet contain an initialised database), MySQL automatically executes every .sql file found in /docker-entrypoint-initdb.d/. Because copia.sql is mounted there, the full schema and seed dataset are created without any manual steps.
The auto-seed only runs on the first container creation. If the db_data volume already exists with an initialised database, MySQL skips the docker-entrypoint-initdb.d scripts entirely. To force a fresh seed, remove the volume first:docker compose down -v
docker compose up -d