/**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $faker = Faker\Factory::create();
     foreach (range(1, 25) as $index) {
         Keyword::create(['keyword' => $faker->word]);
     }
 }
 public function test_getKeywordsByName()
 {
     // Verifies that functions works as expected
     $input = array("animi", "error", "cat");
     $items = Keyword::getKeywordsByName($input);
     $this->assertCount(count($items), $input, 
             "Verified that returned item count matches input count");
     
 }
 /**
  *   @name getKeywordsByName
  *  
  *   @description Returns a list of all keywords ids given array of names 
  *    
  *   @params Array of keyword names 
  *
  *   @return Array of keywords id to be returned
  *
  *   @author Shweta Sabne  
  *
  **/
 public function getKeywordsByName(array $input)
 {
     /**         Algorithm One TODO
      ** In this algo, I will fetch all keywords from db and do the filtering on the code side
      **          Test
      ** loadTest, unitTest 
      **          Note : will be considered only if the first algo doesn't work satisfactorily
      **/
     /**         Algorithm Two
      ** In this algo, I will fetch all keywords from db using where clause 
      **          Test
      ** loadTest, unitTest 
      **
      **/
     $keyword_ids = Keyword::getKeywordsByName($input);
     return $keyword_ids;
 }
Example #4
0
 /**
  * Execute the console command.
  *
  * @return mixed
  */
 public function handle()
 {
     // $url = 'http://map.naver.com/search2/local.nhn?query='. urlencode('서울특별시+중구+애견호텔');
     //     $job = (new CollectionLocal($url));
     //     dispatch($job);
     // return;
     $this->comment("Collector job staring...");
     $collect_local_main = '';
     $collect_local_sub = '';
     $collect_ord = 1;
     $collect_url = array();
     $collection = Collection::orderby('id', 'desc')->first();
     if (empty($collection->id)) {
         $local = Local::where('ord', 1)->first();
         $collect_local_main = $local->main;
         $collect_local_sub = $local->sub;
     } else {
         $local = Local::where('ord', '>', $collection->ord)->first();
         if (empty($local->id)) {
             $local = Local::where('ord', 1)->first();
         }
         $collect_local_main = $local->main;
         $collect_local_sub = $local->sub;
         $collect_ord = $local->ord;
     }
     //2분단위로 데이터 가져오기 실행
     $keywordSets = Keyword::orderby('ord', 'asc')->get();
     foreach ($keywordSets as $k => $value) {
         $url = 'http://map.naver.com/search2/local.nhn?query=' . urlencode($collect_local_main . '+' . $collect_local_sub . '+' . $value->keyword);
         $job = (new CollectionLocal($url))->delay($k * 120);
         dispatch($job);
     }
     $collection = new Collection();
     $collection->local_main = $collect_local_main;
     $collection->local_sub = $collect_local_sub;
     $collection->ord = $collect_ord;
     $collection->save();
     $this->comment("Collector : [" . $collect_local_main . "/" . $collect_local_sub . "]");
 }
Example #5
0
 public static function insertProduct($product)
 {
     Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Attempting to insert product data into database");
     #First insert any new keywords
     $keyword_array = explode(" ", $product['keywords']);
     $final_key_array = array();
     foreach ($keyword_array as $key) {
         $key = substr($key, 1);
         $inserted_key = Keyword::firstOrCreate(['keyword' => $key]);
         array_push($final_key_array, $inserted_key->id);
     }
     #Now retrieve the keyword ids and save them
     $keywords_from_db = DB::table('keywords')->whereIn('id', $final_key_array)->get();
     # Get all the filenames in form of an array
     $filename_array = explode(":", $product['filenamestring']);
     $primary_image_path = 'no_image.jpg';
     if (count($filename_array) > 0) {
         $primary_image_path = $filename_array[0];
     }
     # Now that we have all the information, start transaction
     try {
         DB::beginTransaction();
         $logged_in_user = Auth::id();
         $user = User::where('id', $logged_in_user)->first();
         #First insert in the product table
         Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Attempting to insert product data into database");
         $product_id = DB::table('products')->insertGetId(['title' => $product['title'], 'description' => $product['description'], 'delivery' => $product['delivery'], 'pickup' => $product['pickup'], 'price' => $product['price'], 'free' => $product['free'], 'user_id' => $logged_in_user, 'primary_image_path' => $primary_image_path, 'new' => $product['new'], 'used' => $product['used'], 'state' => 'PRESUBMIT', 'university_id' => $user->university_id]);
         Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Got product id " . $product_id);
         #Now insert products_categories
         foreach ($product['category'] as $cat) {
             Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Inserting product category " . $product_id . ":" . $cat);
             DB::table('products_categories')->insert(['product_id' => $product_id, 'category_id' => $cat]);
         }
         # Now insert keywors
         foreach ($keywords_from_db as $keyword_db) {
             Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Inserting product keyword " . $product_id . ":" . $keyword_db->id);
             DB::table('products_keywords')->insert(['product_id' => $product_id, 'keyword_id' => $keyword_db->id]);
         }
         # Now insert the images
         if (count($filename_array) > 1) {
             for ($i = 1; $i < count($filename_array) - 1; $i++) {
                 Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Inserting product image " . $product_id . ":" . $filename_array[$i]);
                 DB::table('products_images')->insert(['product_id' => $product_id, 'image_path' => $filename_array[$i]]);
             }
         }
         DB::commit();
         return $product_id;
     } catch (Exception $e) {
         Log::info(__CLASS__ . "::" . __METHOD__ . "::" . "Exception inserting product" . $e->message());
         DB::rollBack();
         return $e->message();
     }
     return $results;
 }
 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     Model::unguard();
     $lipsum = new LoremIpsumGenerator();
     Role::create(['title' => 'Administrator', 'slug' => 'admin']);
     Role::create(['title' => 'User', 'slug' => 'user']);
     User::create(['username' => 'Master', 'email' => '*****@*****.**', 'password' => bcrypt('master1234'), 'seen' => true, 'role_id' => 1, 'confirmed' => true]);
     Version::create(['app' => '0.1.1', 'data' => '0.1.1']);
     // collection keyword insert
     Keyword::create(['keyword' => '동물병원', 'ord' => 1]);
     Keyword::create(['keyword' => '애견용품', 'ord' => 2]);
     Keyword::create(['keyword' => '애견카페', 'ord' => 3]);
     Keyword::create(['keyword' => '애견펜션', 'ord' => 4]);
     Keyword::create(['keyword' => '애견분양', 'ord' => 5]);
     Keyword::create(['keyword' => '애견운동장', 'ord' => 6]);
     Keyword::create(['keyword' => '애견미용', 'ord' => 7]);
     Keyword::create(['keyword' => '애견호텔', 'ord' => 8]);
     // collection local insert
     // 서울
     Local::create(['main' => '서울특별시', 'sub' => '종로구', 'ord' => 1]);
     Local::create(['main' => '서울특별시', 'sub' => '중구', 'ord' => 2]);
     Local::create(['main' => '서울특별시', 'sub' => '용산구', 'ord' => 3]);
     Local::create(['main' => '서울특별시', 'sub' => '성동구', 'ord' => 4]);
     Local::create(['main' => '서울특별시', 'sub' => '광진구', 'ord' => 5]);
     Local::create(['main' => '서울특별시', 'sub' => '동대문구', 'ord' => 6]);
     Local::create(['main' => '서울특별시', 'sub' => '중랑구', 'ord' => 7]);
     Local::create(['main' => '서울특별시', 'sub' => '성북구', 'ord' => 8]);
     Local::create(['main' => '서울특별시', 'sub' => '강북구', 'ord' => 9]);
     Local::create(['main' => '서울특별시', 'sub' => '도봉구', 'ord' => 10]);
     Local::create(['main' => '서울특별시', 'sub' => '노원구', 'ord' => 11]);
     Local::create(['main' => '서울특별시', 'sub' => '은평구', 'ord' => 12]);
     Local::create(['main' => '서울특별시', 'sub' => '서대문구', 'ord' => 13]);
     Local::create(['main' => '서울특별시', 'sub' => '마포구', 'ord' => 14]);
     Local::create(['main' => '서울특별시', 'sub' => '양천구', 'ord' => 15]);
     Local::create(['main' => '서울특별시', 'sub' => '강서구', 'ord' => 16]);
     Local::create(['main' => '서울특별시', 'sub' => '구로구', 'ord' => 17]);
     Local::create(['main' => '서울특별시', 'sub' => '금천구', 'ord' => 18]);
     Local::create(['main' => '서울특별시', 'sub' => '영등포구', 'ord' => 19]);
     Local::create(['main' => '서울특별시', 'sub' => '동작구', 'ord' => 20]);
     Local::create(['main' => '서울특별시', 'sub' => '관악구', 'ord' => 21]);
     Local::create(['main' => '서울특별시', 'sub' => '서초구', 'ord' => 22]);
     Local::create(['main' => '서울특별시', 'sub' => '강남구', 'ord' => 23]);
     Local::create(['main' => '서울특별시', 'sub' => '송파구', 'ord' => 24]);
     Local::create(['main' => '서울특별시', 'sub' => '강동구', 'ord' => 25]);
     // 강원
     Local::create(['main' => '강원도', 'sub' => '춘천시', 'ord' => 26]);
     Local::create(['main' => '강원도', 'sub' => '원주시', 'ord' => 27]);
     Local::create(['main' => '강원도', 'sub' => '강릉시', 'ord' => 28]);
     Local::create(['main' => '강원도', 'sub' => '동해시', 'ord' => 29]);
     Local::create(['main' => '강원도', 'sub' => '태백시', 'ord' => 30]);
     Local::create(['main' => '강원도', 'sub' => '속초시', 'ord' => 31]);
     Local::create(['main' => '강원도', 'sub' => '삼척시', 'ord' => 32]);
     Local::create(['main' => '강원도', 'sub' => '홍천군', 'ord' => 33]);
     Local::create(['main' => '강원도', 'sub' => '횡성군', 'ord' => 34]);
     Local::create(['main' => '강원도', 'sub' => '영월군', 'ord' => 35]);
     Local::create(['main' => '강원도', 'sub' => '평창군', 'ord' => 36]);
     Local::create(['main' => '강원도', 'sub' => '정선군', 'ord' => 37]);
     Local::create(['main' => '강원도', 'sub' => '철원군', 'ord' => 38]);
     Local::create(['main' => '강원도', 'sub' => '화천군', 'ord' => 39]);
     Local::create(['main' => '강원도', 'sub' => '양구군', 'ord' => 40]);
     Local::create(['main' => '강원도', 'sub' => '인제군', 'ord' => 41]);
     Local::create(['main' => '강원도', 'sub' => '고성군', 'ord' => 42]);
     Local::create(['main' => '강원도', 'sub' => '양양군', 'ord' => 43]);
     // 경기
     Local::create(['main' => '경기도', 'sub' => '장안군', 'ord' => 44]);
     Local::create(['main' => '경기도', 'sub' => '권선구', 'ord' => 45]);
     Local::create(['main' => '경기도', 'sub' => '팔달구', 'ord' => 46]);
     Local::create(['main' => '경기도', 'sub' => '영통구', 'ord' => 47]);
     Local::create(['main' => '경기도', 'sub' => '수정구', 'ord' => 48]);
     Local::create(['main' => '경기도', 'sub' => '중원구', 'ord' => 49]);
     Local::create(['main' => '경기도', 'sub' => '분당구', 'ord' => 50]);
     Local::create(['main' => '경기도', 'sub' => '의정부시', 'ord' => 51]);
     Local::create(['main' => '경기도', 'sub' => '만안구', 'ord' => 52]);
     Local::create(['main' => '경기도', 'sub' => '동안구', 'ord' => 53]);
     Local::create(['main' => '경기도', 'sub' => '원미구', 'ord' => 54]);
     Local::create(['main' => '경기도', 'sub' => '소사구', 'ord' => 55]);
     Local::create(['main' => '경기도', 'sub' => '오정구', 'ord' => 56]);
     Local::create(['main' => '경기도', 'sub' => '광명시', 'ord' => 57]);
     Local::create(['main' => '경기도', 'sub' => '평택시', 'ord' => 58]);
     Local::create(['main' => '경기도', 'sub' => '동두천시', 'ord' => 59]);
     Local::create(['main' => '경기도', 'sub' => '상록구', 'ord' => 60]);
     Local::create(['main' => '경기도', 'sub' => '단원구', 'ord' => 61]);
     Local::create(['main' => '경기도', 'sub' => '덕양구', 'ord' => 62]);
     Local::create(['main' => '경기도', 'sub' => '일산동구', 'ord' => 63]);
     Local::create(['main' => '경기도', 'sub' => '일산서구', 'ord' => 64]);
     Local::create(['main' => '경기도', 'sub' => '과천시', 'ord' => 65]);
     Local::create(['main' => '경기도', 'sub' => '구리시', 'ord' => 66]);
     Local::create(['main' => '경기도', 'sub' => '남양주시', 'ord' => 67]);
     Local::create(['main' => '경기도', 'sub' => '오산시', 'ord' => 68]);
     Local::create(['main' => '경기도', 'sub' => '시흥시', 'ord' => 69]);
     Local::create(['main' => '경기도', 'sub' => '군포시', 'ord' => 70]);
     Local::create(['main' => '경기도', 'sub' => '의왕시', 'ord' => 71]);
     Local::create(['main' => '경기도', 'sub' => '하남시', 'ord' => 72]);
     Local::create(['main' => '경기도', 'sub' => '처인구', 'ord' => 73]);
     Local::create(['main' => '경기도', 'sub' => '기흥구', 'ord' => 74]);
     Local::create(['main' => '경기도', 'sub' => '수지구', 'ord' => 75]);
     Local::create(['main' => '경기도', 'sub' => '파주시', 'ord' => 76]);
     Local::create(['main' => '경기도', 'sub' => '이천시', 'ord' => 77]);
     Local::create(['main' => '경기도', 'sub' => '안성시', 'ord' => 78]);
     Local::create(['main' => '경기도', 'sub' => '김포시', 'ord' => 79]);
     Local::create(['main' => '경기도', 'sub' => '화성시', 'ord' => 80]);
     Local::create(['main' => '경기도', 'sub' => '광주시', 'ord' => 81]);
     Local::create(['main' => '경기도', 'sub' => '양주시', 'ord' => 82]);
     Local::create(['main' => '경기도', 'sub' => '포천시', 'ord' => 83]);
     Local::create(['main' => '경기도', 'sub' => '여주시', 'ord' => 84]);
     Local::create(['main' => '경기도', 'sub' => '연천군', 'ord' => 85]);
     Local::create(['main' => '경기도', 'sub' => '가평군', 'ord' => 86]);
     Local::create(['main' => '경기도', 'sub' => '양평군', 'ord' => 87]);
     Local::create(['main' => '경상북도', 'sub' => '남구', 'ord' => 88]);
     Local::create(['main' => '경상북도', 'sub' => '북구', 'ord' => 89]);
     Local::create(['main' => '경상북도', 'sub' => '경주시', 'ord' => 90]);
     Local::create(['main' => '경상북도', 'sub' => '김천시', 'ord' => 91]);
     Local::create(['main' => '경상북도', 'sub' => '안동시', 'ord' => 92]);
     Local::create(['main' => '경상북도', 'sub' => '구미시', 'ord' => 93]);
     Local::create(['main' => '경상북도', 'sub' => '영주시', 'ord' => 94]);
     Local::create(['main' => '경상북도', 'sub' => '영천시', 'ord' => 95]);
     Local::create(['main' => '경상북도', 'sub' => '상주시', 'ord' => 96]);
     Local::create(['main' => '경상북도', 'sub' => '문경시', 'ord' => 97]);
     Local::create(['main' => '경상북도', 'sub' => '경산시', 'ord' => 98]);
     Local::create(['main' => '경상북도', 'sub' => '군위군', 'ord' => 99]);
     Local::create(['main' => '경상북도', 'sub' => '의성군', 'ord' => 100]);
     Local::create(['main' => '경상북도', 'sub' => '청송군', 'ord' => 101]);
     Local::create(['main' => '경상북도', 'sub' => '영양군', 'ord' => 102]);
     Local::create(['main' => '경상북도', 'sub' => '영덕군', 'ord' => 103]);
     Local::create(['main' => '경상북도', 'sub' => '청도군', 'ord' => 104]);
     Local::create(['main' => '경상북도', 'sub' => '고령군', 'ord' => 105]);
     Local::create(['main' => '경상북도', 'sub' => '성주군', 'ord' => 106]);
     Local::create(['main' => '경상북도', 'sub' => '칠곡군', 'ord' => 107]);
     Local::create(['main' => '경상북도', 'sub' => '예천군', 'ord' => 108]);
     Local::create(['main' => '경상북도', 'sub' => '봉화군', 'ord' => 109]);
     Local::create(['main' => '경상북도', 'sub' => '울진군', 'ord' => 110]);
     Local::create(['main' => '경상북도', 'sub' => '울릉군', 'ord' => 111]);
     Local::create(['main' => '광주광역시', 'sub' => '동구', 'ord' => 112]);
     Local::create(['main' => '광주광역시', 'sub' => '서구', 'ord' => 113]);
     Local::create(['main' => '광주광역시', 'sub' => '남구', 'ord' => 114]);
     Local::create(['main' => '광주광역시', 'sub' => '북구', 'ord' => 115]);
     Local::create(['main' => '경상남도', 'sub' => '의창구', 'ord' => 116]);
     Local::create(['main' => '경상남도', 'sub' => '성산구', 'ord' => 117]);
     Local::create(['main' => '경상남도', 'sub' => '마산합포구', 'ord' => 118]);
     Local::create(['main' => '경상남도', 'sub' => '마산회원구', 'ord' => 119]);
     Local::create(['main' => '경상남도', 'sub' => '진해구', 'ord' => 120]);
     Local::create(['main' => '경상남도', 'sub' => '진주시', 'ord' => 121]);
     Local::create(['main' => '경상남도', 'sub' => '통영시', 'ord' => 122]);
     Local::create(['main' => '경상남도', 'sub' => '사천시', 'ord' => 123]);
     Local::create(['main' => '경상남도', 'sub' => '김해시', 'ord' => 124]);
     Local::create(['main' => '경상남도', 'sub' => '밀양시', 'ord' => 125]);
     Local::create(['main' => '경상남도', 'sub' => '거제시', 'ord' => 126]);
     Local::create(['main' => '경상남도', 'sub' => '양산시', 'ord' => 127]);
     Local::create(['main' => '경상남도', 'sub' => '의령군', 'ord' => 128]);
     Local::create(['main' => '경상남도', 'sub' => '함안군', 'ord' => 129]);
     Local::create(['main' => '경상남도', 'sub' => '창녕군', 'ord' => 130]);
     Local::create(['main' => '경상남도', 'sub' => '고성군', 'ord' => 131]);
     Local::create(['main' => '경상남도', 'sub' => '남해군', 'ord' => 132]);
     Local::create(['main' => '경상남도', 'sub' => '하동군', 'ord' => 133]);
     Local::create(['main' => '경상남도', 'sub' => '산청군', 'ord' => 134]);
     Local::create(['main' => '경상남도', 'sub' => '함양군', 'ord' => 135]);
     Local::create(['main' => '경상남도', 'sub' => '거창군', 'ord' => 136]);
     Local::create(['main' => '경상남도', 'sub' => '합천군', 'ord' => 137]);
     Local::create(['main' => '대구광역시', 'sub' => '중구', 'ord' => 138]);
     Local::create(['main' => '대구광역시', 'sub' => '동구', 'ord' => 139]);
     Local::create(['main' => '대구광역시', 'sub' => '서구', 'ord' => 140]);
     Local::create(['main' => '대구광역시', 'sub' => '남구', 'ord' => 141]);
     Local::create(['main' => '대구광역시', 'sub' => '북구', 'ord' => 142]);
     Local::create(['main' => '대구광역시', 'sub' => '수성구', 'ord' => 143]);
     Local::create(['main' => '대구광역시', 'sub' => '달서구', 'ord' => 144]);
     Local::create(['main' => '대구광역시', 'sub' => '달성군', 'ord' => 145]);
     Local::create(['main' => '대전광역시', 'sub' => '동구', 'ord' => 146]);
     Local::create(['main' => '대전광역시', 'sub' => '중구', 'ord' => 147]);
     Local::create(['main' => '대전광역시', 'sub' => '서구', 'ord' => 148]);
     Local::create(['main' => '대전광역시', 'sub' => '유성구', 'ord' => 149]);
     Local::create(['main' => '대전광역시', 'sub' => '대덕구', 'ord' => 150]);
     Local::create(['main' => '부산광역시', 'sub' => '중구', 'ord' => 151]);
     Local::create(['main' => '부산광역시', 'sub' => '서구', 'ord' => 152]);
     Local::create(['main' => '부산광역시', 'sub' => '동구', 'ord' => 153]);
     Local::create(['main' => '부산광역시', 'sub' => '영도구', 'ord' => 154]);
     Local::create(['main' => '부산광역시', 'sub' => '부산진구', 'ord' => 155]);
     Local::create(['main' => '부산광역시', 'sub' => '동래구', 'ord' => 156]);
     Local::create(['main' => '부산광역시', 'sub' => '남구', 'ord' => 157]);
     Local::create(['main' => '부산광역시', 'sub' => '북구', 'ord' => 158]);
     Local::create(['main' => '부산광역시', 'sub' => '해운대구', 'ord' => 159]);
     Local::create(['main' => '부산광역시', 'sub' => '사하구', 'ord' => 160]);
     Local::create(['main' => '부산광역시', 'sub' => '금정구', 'ord' => 161]);
     Local::create(['main' => '부산광역시', 'sub' => '강서구', 'ord' => 162]);
     Local::create(['main' => '부산광역시', 'sub' => '연제구', 'ord' => 163]);
     Local::create(['main' => '부산광역시', 'sub' => '수영구', 'ord' => 164]);
     Local::create(['main' => '부산광역시', 'sub' => '사상구', 'ord' => 165]);
     Local::create(['main' => '부산광역시', 'sub' => '기장군', 'ord' => 166]);
     Local::create(['main' => '울산광역시', 'sub' => '중구', 'ord' => 167]);
     Local::create(['main' => '울산광역시', 'sub' => '남구', 'ord' => 168]);
     Local::create(['main' => '울산광역시', 'sub' => '동구', 'ord' => 169]);
     Local::create(['main' => '울산광역시', 'sub' => '북구', 'ord' => 170]);
     Local::create(['main' => '울산광역시', 'sub' => '울주군', 'ord' => 171]);
     Local::create(['main' => '인천광역시', 'sub' => '중구', 'ord' => 172]);
     Local::create(['main' => '인천광역시', 'sub' => '동구', 'ord' => 173]);
     Local::create(['main' => '인천광역시', 'sub' => '남구', 'ord' => 174]);
     Local::create(['main' => '인천광역시', 'sub' => '연수구', 'ord' => 175]);
     Local::create(['main' => '인천광역시', 'sub' => '남동구', 'ord' => 176]);
     Local::create(['main' => '인천광역시', 'sub' => '부평구', 'ord' => 177]);
     Local::create(['main' => '인천광역시', 'sub' => '계양구', 'ord' => 178]);
     Local::create(['main' => '인천광역시', 'sub' => '서구', 'ord' => 179]);
     Local::create(['main' => '인천광역시', 'sub' => '강화군', 'ord' => 180]);
     Local::create(['main' => '인천광역시', 'sub' => '옹진군', 'ord' => 181]);
     Local::create(['main' => '전라남도', 'sub' => '목포시', 'ord' => 182]);
     Local::create(['main' => '전라남도', 'sub' => '여수시', 'ord' => 183]);
     Local::create(['main' => '전라남도', 'sub' => '순천시', 'ord' => 184]);
     Local::create(['main' => '전라남도', 'sub' => '나주시', 'ord' => 185]);
     Local::create(['main' => '전라남도', 'sub' => '광양시', 'ord' => 186]);
     Local::create(['main' => '전라남도', 'sub' => '담양군', 'ord' => 187]);
     Local::create(['main' => '전라남도', 'sub' => '곡성군', 'ord' => 188]);
     Local::create(['main' => '전라남도', 'sub' => '구례군', 'ord' => 189]);
     Local::create(['main' => '전라남도', 'sub' => '고흥군', 'ord' => 190]);
     Local::create(['main' => '전라남도', 'sub' => '보성군', 'ord' => 191]);
     Local::create(['main' => '전라남도', 'sub' => '화순군', 'ord' => 192]);
     Local::create(['main' => '전라남도', 'sub' => '장흥군', 'ord' => 193]);
     Local::create(['main' => '전라남도', 'sub' => '강진군', 'ord' => 194]);
     Local::create(['main' => '전라남도', 'sub' => '해남군', 'ord' => 195]);
     Local::create(['main' => '전라남도', 'sub' => '영암군', 'ord' => 196]);
     Local::create(['main' => '전라남도', 'sub' => '무안군', 'ord' => 197]);
     Local::create(['main' => '전라남도', 'sub' => '함평군', 'ord' => 198]);
     Local::create(['main' => '전라남도', 'sub' => '영광군', 'ord' => 199]);
     Local::create(['main' => '전라남도', 'sub' => '장성군', 'ord' => 200]);
     Local::create(['main' => '전라남도', 'sub' => '완도군', 'ord' => 201]);
     Local::create(['main' => '전라남도', 'sub' => '진도군', 'ord' => 202]);
     Local::create(['main' => '전라남도', 'sub' => '신안군', 'ord' => 203]);
     Local::create(['main' => '전라북도', 'sub' => '완산구', 'ord' => 204]);
     Local::create(['main' => '전라북도', 'sub' => '덕진구', 'ord' => 205]);
     Local::create(['main' => '전라북도', 'sub' => '군산시', 'ord' => 206]);
     Local::create(['main' => '전라북도', 'sub' => '익산시', 'ord' => 207]);
     Local::create(['main' => '전라북도', 'sub' => '정읍시', 'ord' => 208]);
     Local::create(['main' => '전라북도', 'sub' => '남원시', 'ord' => 209]);
     Local::create(['main' => '전라북도', 'sub' => '김제시', 'ord' => 210]);
     Local::create(['main' => '전라북도', 'sub' => '완주군', 'ord' => 211]);
     Local::create(['main' => '전라북도', 'sub' => '진안군', 'ord' => 212]);
     Local::create(['main' => '전라북도', 'sub' => '무주군', 'ord' => 213]);
     Local::create(['main' => '전라북도', 'sub' => '장수군', 'ord' => 214]);
     Local::create(['main' => '전라북도', 'sub' => '임실군', 'ord' => 215]);
     Local::create(['main' => '전라북도', 'sub' => '순창군', 'ord' => 216]);
     Local::create(['main' => '전라북도', 'sub' => '고창군', 'ord' => 217]);
     Local::create(['main' => '전라북도', 'sub' => '부안군', 'ord' => 218]);
     Local::create(['main' => '제주특별자치도', 'sub' => '제주시', 'ord' => 219]);
     Local::create(['main' => '제주특별자치도', 'sub' => '서귀포시', 'ord' => 220]);
     Local::create(['main' => '충청남도', 'sub' => '동남구', 'ord' => 221]);
     Local::create(['main' => '충청남도', 'sub' => '서북구', 'ord' => 222]);
     Local::create(['main' => '충청남도', 'sub' => '공주시', 'ord' => 223]);
     Local::create(['main' => '충청남도', 'sub' => '보령시', 'ord' => 224]);
     Local::create(['main' => '충청남도', 'sub' => '아산시', 'ord' => 225]);
     Local::create(['main' => '충청남도', 'sub' => '서산시', 'ord' => 226]);
     Local::create(['main' => '충청남도', 'sub' => '논산시', 'ord' => 227]);
     Local::create(['main' => '충청남도', 'sub' => '계룡시', 'ord' => 228]);
     Local::create(['main' => '충청남도', 'sub' => '당진시', 'ord' => 229]);
     Local::create(['main' => '충청남도', 'sub' => '금산군', 'ord' => 230]);
     Local::create(['main' => '충청남도', 'sub' => '부여군', 'ord' => 231]);
     Local::create(['main' => '충청남도', 'sub' => '서천군', 'ord' => 232]);
     Local::create(['main' => '충청남도', 'sub' => '청양군', 'ord' => 233]);
     Local::create(['main' => '충청남도', 'sub' => '홍성군', 'ord' => 234]);
     Local::create(['main' => '충청남도', 'sub' => '예산군', 'ord' => 235]);
     Local::create(['main' => '충청남도', 'sub' => '태안군', 'ord' => 236]);
     Local::create(['main' => '충청북도', 'sub' => '상당구', 'ord' => 237]);
     Local::create(['main' => '충청북도', 'sub' => '서원구', 'ord' => 238]);
     Local::create(['main' => '충청북도', 'sub' => '흥덕구', 'ord' => 239]);
     Local::create(['main' => '충청북도', 'sub' => '청원구', 'ord' => 240]);
     Local::create(['main' => '충청북도', 'sub' => '충주시', 'ord' => 241]);
     Local::create(['main' => '충청북도', 'sub' => '제천시', 'ord' => 242]);
     Local::create(['main' => '충청북도', 'sub' => '보은군', 'ord' => 243]);
     Local::create(['main' => '충청북도', 'sub' => '옥천군', 'ord' => 244]);
     Local::create(['main' => '충청북도', 'sub' => '영동군', 'ord' => 245]);
     Local::create(['main' => '충청북도', 'sub' => '증평군', 'ord' => 246]);
     Local::create(['main' => '충청북도', 'sub' => '진천군', 'ord' => 247]);
     Local::create(['main' => '충청북도', 'sub' => '괴산군', 'ord' => 248]);
     Local::create(['main' => '충청북도', 'sub' => '음성군', 'ord' => 249]);
     Local::create(['main' => '충청북도', 'sub' => '단양군', 'ord' => 250]);
     Local::create(['main' => '세종특별자치시', 'sub' => '나성동', 'ord' => 251]);
     Local::create(['main' => '세종특별자치시', 'sub' => '어진동', 'ord' => 252]);
     Local::create(['main' => '세종특별자치시', 'sub' => '종촌동', 'ord' => 253]);
     Local::create(['main' => '세종특별자치시', 'sub' => '고운동', 'ord' => 254]);
     Local::create(['main' => '세종특별자치시', 'sub' => '아름동', 'ord' => 255]);
     Local::create(['main' => '세종특별자치시', 'sub' => '도담동', 'ord' => 256]);
     Local::create(['main' => '세종특별자치시', 'sub' => '조치원읍', 'ord' => 257]);
     Local::create(['main' => '세종특별자치시', 'sub' => '금남면', 'ord' => 258]);
     Local::create(['main' => '세종특별자치시', 'sub' => '장군면', 'ord' => 259]);
     Local::create(['main' => '세종특별자치시', 'sub' => '전의면', 'ord' => 260]);
     Local::create(['main' => '세종특별자치시', 'sub' => '전동면', 'ord' => 261]);
 }