<?php

$pdo = new PDO('mysql:host=localhost;dbname=big_records_test', 'root', 'YOUR DB PASS');

$numOfRecords = 150000;
$msisdnTypes = array('prepaid', 'postpaid', 'hybrid');
$actionTypes = array('Widget / Basic', 'app_start', 'Pregled', 'Usluge / Sve usluge', 'povezivanje broja', 'Usluge / Moje ponude');
$actionTypesCount = count($actionTypes) - 1;
$msisdns = [];

$insertSql = "INSERT INTO users (msisdn, activation_date, msisdn_type) VALUES (:msisdn, :activation_date, :msisdn_type)";
$stmt = $pdo->prepare($insertSql);

$userMsisdn;
$userMsisdnsType = [];

for($i = 0; $i < 200; $i++)
{
    $userMsisdnType = $msisdnTypes[mt_rand(0, 2)];
    $userMsisdn = mt_rand(10000000000, 999999999999);
    $msisdns[] = $userMsisdn;
    $userMsisdnsType[$userMsisdn] = $userMsisdnType;

    $stmt->bindParam('msisdn', $userMsisdn);
    $stmt->bindParam('activation_date', date('Y-m-d', mt_rand(1411111550, time())));
    $stmt->bindParam('msisdn_type', $userMsisdnType);

    if(!$stmt->execute()) {
        print_r($stmt->errorInfo());
        exit;
    }
}


$userAgentStrings = [
    'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.132 Safari/537.36',
    'Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/41.0.2228.0 Safari/537.36',
    'Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; AS; rv:11.0) like Gecko'
];

$insertSql = "INSERT INTO log_archive (msisdn, msisdn_type, date, action, num_actions, useragent, aggregated)
                                      VALUES (:msisdn, :msisdn_type, :date, :action, :num_actions, :useragent, :aggregated)";

$stmt = $pdo->prepare($insertSql);

echo "\n\n" . date('H:i:s') . "\n\n";

for($i = 0; $i < $numOfRecords; $i++)
{
    $userMsisdn = $msisdns[mt_rand(0, 199)];

    $stmt->bindParam('msisdn', $userMsisdn);
    $stmt->bindParam('msisdn_type', $userMsisdnsType[$userMsisdn]);
    $stmt->bindParam('date', date('Y-m-d', mt_rand(1411111550, time())));
    $stmt->bindParam('action', $actionTypes[mt_rand(0, $actionTypesCount)]);
    $stmt->bindParam('num_actions', mt_rand(0, 10));
    $stmt->bindParam('useragent', $userAgentStrings[mt_rand(0, 2)]);
    $stmt->bindParam('aggregated', mt_rand(0, 1));

    if(!$stmt->execute()) {
        print_r($stmt->errorInfo());
        exit;
    }

    if($i !== 0 && $i % 10000 === 0) {
        echo "Inserted records: " . $i . " - " . date('H:i:s') . "\n";
    }
}

echo "\n\n" . date('H:i:s') . "\n\n";