<?php require __DIR__ . '/../../vendor/autoload.php'; $db = new \Phalcon\Db\Adapter\Pdo\Sqlite(['dbname' => __DIR__ . '/../db.sqlite']); // Generating 1000 record in user table $db->query("DELETE FROM user;"); $balances = [100, 200, 500]; for ($i = 0; $i < 100; $i++) { $faker = Faker\Factory::create(); $name = $faker->userName; $email = $faker->email; $balance = $balances[array_rand($balances)]; $db->query("INSERT INTO user VALUES({$i}, '{$name}', '{$email}', '{$balance}')"); echo 'Insert record [' . $i . '/100]' . PHP_EOL; } echo 'All done!' . PHP_EOL;