Populating function

prepopulate-populate-shrinked.ts

/**
 * Populates Cities
 */
 async function populateCities(db: Database, cities: Array<City>) {
    db.serialize();
    db.run("begin transaction");
    const stmt = db.prepare("REPLACE INTO cities VALUES (?,?,?,?,?,?)");

    for (const city of cities) {
           stmt.run(
                [
                    city.id,
                    city.name,
                    city.state.length > 0 ? city.state : null,
                    city.country,
                    city.coord.lat,
                    city.coord.lon
                ]
           );
    }
    stmt.finalize();
    db.run("commit");
}