From 2096bf0d3782a3a11e280e175afd5cfb873599d8 Mon Sep 17 00:00:00 2001 From: Jacek Kowalski <Jacek@jacekk.info> Date: Fri, 21 Jun 2019 11:59:15 +0000 Subject: [PATCH] Fix formatting of LICENSE to make GitHub recognize it as BSD-3-Clause --- stops/populate_db.php | 18 +++++++++++------- 1 files changed, 11 insertions(+), 7 deletions(-) diff --git a/stops/populate_db.php b/stops/populate_db.php index 3364d2d..845ec95 100644 --- a/stops/populate_db.php +++ b/stops/populate_db.php @@ -9,17 +9,21 @@ $pdo->query('DROP TABLE IF EXISTS stop_search'); $pdo->query('CREATE TABLE stop_search ( word VARCHAR(60), - id INT + id VARCHAR(255) )'); + +function processStops($st, $stops) { + foreach($stops as $id => $name) { + foreach(split_stop_name($name) as $word) { + $st->execute([$word, $id]); + $st->closeCursor(); + } + } +} $pdo->beginTransaction(); $st = $pdo->prepare('INSERT INTO stop_search (word, id) VALUES (?, ?)'); -foreach($stops as $id => $name) { - foreach(split_stop_name($name) as $word) { - $st->execute(array($word, $id)); - $st->closeCursor(); - } -} +processStops($st, $stops); $pdo->commit(); $pdo->query('CREATE INDEX stop_search_word ON stop_search (word COLLATE NOCASE)'); -- Gitblit v1.9.1