Skip to content

Instantly share code, notes, and snippets.

@gdespirito

gdespirito/ChileanTableSeeder.php

Created September 17, 2018 03:16
Show Gist options
  • Save gdespirito/96a05e487f97e9d938c82b83d55645c9 to your computer and use it in GitHub Desktop.
Save gdespirito/96a05e487f97e9d938c82b83d55645c9 to your computer and use it in GitHub Desktop.
Download ZIP
Table Seeder para cargar regiones y comunas de chile en Laravel (2018). Incluyendo nueva Región de Ñuble.
Raw
ChileanTableSeeder.php
<?php
use Illuminate\Database\Seeder;
class ChileTableSeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$this->insertRegions();
$this->insertCommunes();
}
public function insertRegions(): void
{
$now = now();
$regions = [
[1, 'Arica y Parinacota', 'XV'],
[2, 'Tarapacá', 'I'],
[3, 'Antofagasta', 'II'],
[4, 'Atacama', 'III'],
[5, 'Coquimbo', 'IV'],
[6, 'Valparaiso', 'V'],
[7, 'Metropolitana de Santiago', 'RM'],
[8, 'Libertador General Bernardo O\'Higgins', 'VI'],
[9, 'Maule', 'VII'],
[10, 'Ñuble', 'XVI'],
[11, 'Biobío', 'VIII'],
[12, 'La Araucanía', 'IX'],
[13, 'Los Ríos', 'XIV'],
[14, 'Los Lagos', 'X'],
[15, 'Aisén del General Carlos Ibáñez del Campo', 'XI'],
[16, 'Magallanes y de la Antártica Chilena', 'XII']
];
$regions = array_map(function ($region) use ($now) {
return [
'id' => $region[0],
'order' => $region[0],
'name' => $region[1],
'ordinal_symbol' => $region[2],
'updated_at' => $now,
'created_at' => $now,
];
}, $regions);
\DB::table('regions')->insert($regions);
}
/**
* @param $now
*/
public function insertCommunes(): void
{
$now = now();
$communes = [
['Arica', 1],
['Camarones', 1],
['General Lagos', 1],
['Putre', 1],
['Alto Hospicio', 2],
['Iquique', 2],
['Camiña', 2],
['Colchane', 2],
['Huara', 2],
['Pica', 2],
['Pozo Almonte', 2],
['Antofagasta', 3],
['Mejillones', 3],
['Sierra Gorda', 3],
['Taltal', 3],
['Calama', 3],
['Ollague', 3],
['San Pedro de Atacama', 3],
['María Elena', 3],
['Tocopilla', 3],
['Chañaral', 4],
['Diego de Almagro', 4],
['Caldera', 4],
['Copiapó', 4],
['Tierra Amarilla', 4],
['Alto del Carmen', 4],
['Freirina', 4],
['Huasco', 4],
['Vallenar', 4],
['Canela', 5],
['Illapel', 5],
['Los Vilos', 5],
['Salamanca', 5],
['Andacollo', 5],
['Coquimbo', 5],
['La Higuera', 5],
['La Serena', 5],
['Paihuaco', 5],
['Vicuña', 5],
['Combarbalá', 5],
['Monte Patria', 5],
['Ovalle', 5],
['Punitaqui', 5],
['Río Hurtado', 5],
['Isla de Pascua', 6],
['Calle Larga', 6],
['Los Andes', 6],
['Rinconada', 6],
['San Esteban', 6],
['La Ligua', 6],
['Papudo', 6],
['Petorca', 6],
['Zapallar', 6],
['Hijuelas', 6],
['La Calera', 6],
['La Cruz', 6],
['Limache', 6],
['Nogales', 6],
['Olmué', 6],
['Quillota', 6],
['Algarrobo', 6],
['Cartagena', 6],
['El Quisco', 6],
['El Tabo', 6],
['San Antonio', 6],
['Santo Domingo', 6],
['Catemu', 6],
['Llaillay', 6],
['Panquehue', 6],
['Putaendo', 6],
['San Felipe', 6],
['Santa María', 6],
['Casablanca', 6],
['Concón', 6],
['Juan Fernández', 6],
['Puchuncaví', 6],
['Quilpué', 6],
['Quintero', 6],
['Valparaíso', 6],
['Villa Alemana', 6],
['Viña del Mar', 6],
['Colina', 7],
['Lampa', 7],
['Tiltil', 7],
['Pirque', 7],
['Puente Alto', 7],
['San José de Maipo', 7],
['Buin', 7],
['Calera de Tango', 7],
['Paine', 7],
['San Bernardo', 7],
['Alhué', 7],
['Curacaví', 7],
['María Pinto', 7],
['Melipilla', 7],
['San Pedro', 7],
['Cerrillos', 7],
['Cerro Navia', 7],
['Conchalí', 7],
['El Bosque', 7],
['Estación Central', 7],
['Huechuraba', 7],
['Independencia', 7],
['La Cisterna', 7],
['La Granja', 7],
['La Florida', 7],
['La Pintana', 7],
['La Reina', 7],
['Las Condes', 7],
['Lo Barnechea', 7],
['Lo Espejo', 7],
['Lo Prado', 7],
['Macul', 7],
['Maipú', 7],
['Ñuñoa', 7],
['Pedro Aguirre Cerda', 7],
['Peñalolén', 7],
['Providencia', 7],
['Pudahuel', 7],
['Quilicura', 7],
['Quinta Normal', 7],
['Recoleta', 7],
['Renca', 7],
['San Miguel', 7],
['San Joaquín', 7],
['San Ramón', 7],
['Santiago', 7],
['Vitacura', 7],
['El Monte', 7],
['Isla de Maipo', 7],
['Padre Hurtado', 7],
['Peñaflor', 7],
['Talagante', 7],
['Codegua', 8],
['Coínco', 8],
['Coltauco', 8],
['Doñihue', 8],
['Graneros', 8],
['Las Cabras', 8],
['Machalí', 8],
['Malloa', 8],
['Mostazal', 8],
['Olivar', 8],
['Peumo', 8],
['Pichidegua', 8],
['Quinta de Tilcoco', 8],
['Rancagua', 8],
['Rengo', 8],
['Requínoa', 8],
['San Vicente de Tagua Tagua', 8],
['La Estrella', 8],
['Litueche', 8],
['Marchihue', 8],
['Navidad', 8],
['Peredones', 8],
['Pichilemu', 8],
['Chépica', 8],
['Chimbarongo', 8],
['Lolol', 8],
['Nancagua', 8],
['Palmilla', 8],
['Peralillo', 8],
['Placilla', 8],
['Pumanque', 8],
['San Fernando', 8],
['Santa Cruz', 8],
['Cauquenes', 9],
['Chanco', 9],
['Pelluhue', 9],
['Curicó', 9],
['Hualañé', 9],
['Licantén', 9],
['Molina', 9],
['Rauco', 9],
['Romeral', 9],
['Sagrada Familia', 9],
['Teno', 9],
['Vichuquén', 9],
['Colbún', 9],
['Linares', 9],
['Longaví', 9],
['Parral', 9],
['Retiro', 9],
['San Javier', 9],
['Villa Alegre', 9],
['Yerbas Buenas', 9],
['Constitución', 9],
['Curepto', 9],
['Empedrado', 9],
['Maule', 9],
['Pelarco', 9],
['Pencahue', 9],
['Río Claro', 9],
['San Clemente', 9],
['San Rafael', 9],
['Talca', 9],
['Bulnes', 10],
['Chillán', 10],
['Chillán Viejo', 10],
['Cobquecura', 10],
['Coelemu', 10],
['Coihueco', 10],
['El Carmen', 10],
['Ninhue', 10],
['Ñiquen', 10],
['Pemuco', 10],
['Pinto', 10],
['Portezuelo', 10],
['Quirihue', 10],
['Ránquil', 10],
['Treguaco', 10],
['Quillón', 10],
['San Carlos', 10],
['San Fabián', 10],
['San Ignacio', 10],
['San Nicolás', 10],
['Yungay', 10],
['Arauco', 11],
['Cañete', 11],
['Contulmo', 11],
['Curanilahue', 11],
['Lebu', 11],
['Los Álamos', 11],
['Tirúa', 11],
['Alto Biobío', 11],
['Antuco', 11],
['Cabrero', 11],
['Laja', 11],
['Los Ángeles', 11],
['Mulchén', 11],
['Nacimiento', 11],
['Negrete', 11],
['Quilaco', 11],
['Quilleco', 11],
['San Rosendo', 11],
['Santa Bárbara', 11],
['Tucapel', 11],
['Yumbel', 11],
['Chiguayante', 11],
['Concepción', 11],
['Coronel', 11],
['Florida', 11],
['Hualpén', 11],
['Hualqui', 11],
['Lota', 11],
['Penco', 11],
['San Pedro de La Paz', 11],
['Santa Juana', 11],
['Talcahuano', 11],
['Tomé', 11],
['Carahue', 12],
['Cholchol', 12],
['Cunco', 12],
['Curarrehue', 12],
['Freire', 12],
['Galvarino', 12],
['Gorbea', 12],
['Lautaro', 12],
['Loncoche', 12],
['Melipeuco', 12],
['Nueva Imperial', 12],
['Padre Las Casas', 12],
['Perquenco', 12],
['Pitrufquén', 12],
['Pucón', 12],
['Saavedra', 12],
['Temuco', 12],
['Teodoro Schmidt', 12],
['Toltén', 12],
['Vilcún', 12],
['Villarrica', 12],
['Angol', 12],
['Collipulli', 12],
['Curacautín', 12],
['Ercilla', 12],
['Lonquimay', 12],
['Los Sauces', 12],
['Lumaco', 12],
['Purén', 12],
['Renaico', 12],
['Traiguén', 12],
['Victoria', 12],
['Corral', 13],
['Lanco', 13],
['Los Lagos', 13],
['Máfil', 13],
['Mariquina', 13],
['Paillaco', 13],
['Panguipulli', 13],
['Valdivia', 13],
['Futrono', 13],
['La Unión', 13],
['Lago Ranco', 13],
['Río Bueno', 13],
['Ancud', 14],
['Castro', 14],
['Chonchi', 14],
['Curaco de Vélez', 14],
['Dalcahue', 14],
['Puqueldón', 14],
['Queilén', 14],
['Quemchi', 14],
['Quellón', 14],
['Quinchao', 14],
['Calbuco', 14],
['Cochamó', 14],
['Fresia', 14],
['Frutillar', 14],
['Llanquihue', 14],
['Los Muermos', 14],
['Maullín', 14],
['Puerto Montt', 14],
['Puerto Varas', 14],
['Osorno', 14],
['Puero Octay', 14],
['Purranque', 14],
['Puyehue', 14],
['Río Negro', 14],
['San Juan de la Costa', 14],
['San Pablo', 14],
['Chaitén', 14],
['Futaleufú', 14],
['Hualaihué', 14],
['Palena', 14],
['Aisén', 15],
['Cisnes', 15],
['Guaitecas', 15],
['Cochrane', 15],
['O\'higgins', 15],
['Tortel', 15],
['Coihaique', 15],
['Lago Verde', 15],
['Chile Chico', 15],
['Río Ibáñez', 15],
['Antártica', 16],
['Cabo de Hornos', 16],
['Laguna Blanca', 16],
['Punta Arenas', 16],
['Río Verde', 16],
['San Gregorio', 16],
['Porvenir', 16],
['Primavera', 16],
['Timaukel', 16],
['Natales', 16],
['Torres del Paine', 16],
['Cabildo', 6],
];
$communes = array_map(function ($commune) use ($now) {
return [
'name' => $commune[0],
'region_id' => $commune[1],
'updated_at' => $now,
'created_at' => $now,
];
}, $communes);
//App\Commune::insert($data); // Eloquent approach
\DB::table('communes')->insert($communes); // Query Builder approach
}
}
@veggigit
Copy link

Muchas gracias!

@crushtkd
Copy link

crushtkd commented Sep 1, 2023

excelente aporte, lo que si, tuve que separar en dos tu código, ya que tengo regionSeeder y communeSeeder.

por lo demás nada mas que agradecer tu aporte.

@ulrich-code
Copy link

ulrich-code commented Sep 1, 2023 via email

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment