48 lines
1.5 KiB
PHP
Executable File
48 lines
1.5 KiB
PHP
Executable File
<?php
|
|
|
|
$db = new SQLite3("migration.db");
|
|
|
|
$cities = json_decode(file_get_contents("cities.json"));
|
|
$defs = json_decode(file_get_contents("defs.json"));
|
|
$emails = json_decode(file_get_contents("emails.json"));
|
|
$img_urls = json_decode(file_get_contents("img_urls.json"));
|
|
|
|
|
|
foreach ($emails as $key => $value) {
|
|
$query = "insert into Emails (Id, EmailAddress) values (:id, :email)";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':id', $key);
|
|
$stmt->bindValue(':email', $value);
|
|
$stmt->execute();
|
|
}
|
|
|
|
|
|
foreach ($cities as $key => $value) {
|
|
$query = "insert into UserLocations (Id, City, CityId, Lat, Lng, TimeZone) values (:id, :city, :cityid, :lat, :lng, :timezone)";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':id', $key);
|
|
$stmt->bindValue(':city', $value->city);
|
|
$stmt->bindValue(':cityid', $value->id);
|
|
$stmt->bindValue(':lat', $value->lat);
|
|
$stmt->bindValue(':lng', $value->lon);
|
|
$stmt->bindValue(':timezone', $value->timezone);
|
|
$stmt->execute();
|
|
}
|
|
|
|
foreach ($defs as $key => $value) {
|
|
$query = "insert into Defs (Id, Def) values (:id, :def)";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':id', $key);
|
|
$stmt->bindValue(':def', $value);
|
|
$stmt->execute();
|
|
}
|
|
|
|
foreach ($img_urls as $key => $value) {
|
|
$query = "insert into Images (Id, FilePath) values (:id, :filepath)";
|
|
$stmt = $db->prepare($query);
|
|
$stmt->bindValue(':id', $key);
|
|
$stmt->bindValue(':filepath', $value);
|
|
$stmt->execute();
|
|
}
|
|
|