/fillDB.php

<?php

	$start = microtime(true);
	set_time_limit(0);

	require('jacked_configVars.php');
	require('../jacked_configMySQL.php');
	require('jacked_functions.php');
	require('jacked_pdnetfunctions.php');
	require( 'jacked_markovGenerator.php' );

    if($_GET['makethishappen'] != 'fuckyeah'){
        die("<h1>THIS IS DANGEROUS KEEP OUT</h1>");
    }

	ini_set('memory_limit', '50M'); // only needed to create the table

	$markov = new MarkovLetterChain( 6 );
	$markov->feed( file_get_contents( 'lib/great-expectations.txt' ) );
	$markov->root(2);

	@unlink( 'markov.state' );

	$v = $markov->save_state( 'markov.state', false );
	unset( $markov );
	print "save state: " . ( $v ? 'OK<br />' : 'FAIL<br />' ) ."\n";

	$markov = new MarkovLetterChain();
	$v = $markov->load_state( 'markov.state' );
	print "load state: " . ( $v ? 'OK<br />' : 'FAIL<br />' ) ."\n";

	
	//////////////////////////////////////////
	//ok i dunno wtf that was but now we have $markov i guess.
	
	$posts = getPosts(5000, '', 'hahalols', array('id'));
	
	foreach($posts as $post){
		
	}
	
	/*
	
	NO NOW WE ARE DOING COMMENTS THIS IS OLD AND IT SHOULD FEEL OLD
	
	$application_ids = array();
	$source_ids = array();
	$tag_ids = array();
	$pd_ids = array();
	
    function getRandomIdFrom($arr){
        return $arr[rand(0, (count($arr) - 1))];
    }
    
	
	function generateSentence($markov){
		$punct = array(0 => ".", 1 => "?", 2 => "!", 3 => "?!");
	    $lol = ucfirst($markov->generate(1, 20));
	    for($i = 0; $i < rand(2, 30); $i++){
	        $lol .= " " . $markov->generate(1, 20);
	    }
	    $lol .= $punct[rand(0, 3)];
	    
	    return $lol;
	}
	
	function generateParagraph($markov){
	    $lol = generateSentence($markov);
	    for($i = 0; $i < rand(0, 9); $i++){
	        $lol .= " " . generateSentence($markov);
	    }
	    
	    return $lol;
	}
	
	
    //MAKE DOES DO OF IT
    $i_apps = 0;
    $i_sources = 0;
    $i_tags = 0;
    $i_pds = 0;
    $i_tagrels = 0;
    $i_votes = 0;
    
    echo "<h4>first comes apps, 50 of them. </h4>";
    for($i_apps = 0; $i_apps < 50; $i_apps++){
        $lol = array(
                      "apiKey" => md5($markov->generate(1, 30)),
                      "name" => $markov->generate(1, 30) . "" . $markov->generate(1, 30) . "App",
                      "device" => rand(0, 1),
                      "platform" => $markov->generate(1, 20),
                      "authorName" => $markov->generate(1, 30) . " " . $markov->generate(1, 30),
                      "authorContact" => $markov->generate(1, 30) . "@" . $markov->generate(1, 30) . ".com",
                      "authorSite" => $markov->generate(1, 30) . ".com/" . $markov->generate(1, 30),
                      "description" => generateParagraph($markov)
                      );
        echo "adding " . $lol[name];
        $did = jackedDBInsertValues('Application', $lol);
        echo "...#$did done.<br>";
    }
    echo "populating apps id array...";
	$query = "SELECT `id` FROM Application WHERE 1";
	$result = mysql_query($query, JACKED_DEFAULT_LINK);
	while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	    $application_ids[] = $row['id'];
	}
    echo "done.<br>";
    
    echo "<h4>okay now Sources, linked to random apps. Let's make 200</h4>";
    for($i_sources = 0; $i_sources < 200; $i_sources++){
        $lol = array(
                      "uuid" => md5($markov->generate(1, 30)),
                      "Application" => getRandomIdFrom($application_ids)
                      );
        echo "adding " . $lol[uuid];
        $did = jackedDBInsertValues('Source', $lol);
        echo "...#$did done.<br>";
    }
    echo "populating sources id array...";
	$query = "SELECT `id` FROM Source WHERE 1";
	$result = mysql_query($query, JACKED_DEFAULT_LINK);
	while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	    $source_ids[] = $row['id'];
	}
    echo "done.<br>";

    
    echo "<h4>next is Tags, so 500 of those.</h4>";
    for($i_tags = 0; $i_tags < 500; $i_tags++){
        $tagname = $markov->generate(1, 40);
        $lol = array(
                      "usage" => rand(1, 50) * round((rand(1, 10) / 10)) + 1,
                      "name" => $tagname,
                      "slug" => slugify($tagname)
                      );
        echo "adding " . $lol[name];
        $did = jackedDBInsertValues('Tag', $lol);
        echo "...#$did done.<br>";
    }
    echo "populating tags id array...";
	$query = "SELECT `id` FROM Tag WHERE 1";
	$result = mysql_query($query, JACKED_DEFAULT_LINK);
	while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	    $tag_ids[] = $row['id'];
	}
    echo "done.<br>";


    echo "<h4>POSTS! 200 of em</h4>";
    for($i_pds = 0; $i_pds < 200; $i_pds++){
        $lol = array(
                      "Decision" => generateParagraph($markov),
                      "Result" => generateParagraph($markov),
                      "Votes" => rand(3, 15)
                      );
        echo "adding " . $lol[Decision];
        $did = jackedDBInsertValues('PoorDecision', $lol);
        echo "...#$did done.<br>";
    }
    echo "populating PDs id array...";
	$query = "SELECT `id` FROM PoorDecision WHERE 1";
	$result = mysql_query($query, JACKED_DEFAULT_LINK);
	while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
	    $pd_ids[] = $row['id'];
	}
    echo "done.<br>";

    echo "<h3>Now connecting all of those. The really hard part.</h3>";

    echo "<h4>TagRels time, matched to the Tags usages</h4>";
    for($i_tagrels = 0; $i_tagrels < count($tag_ids); $i_tagrels++){
        echo "working on tag $i_tagrels<br>";
        $usage = jackedDBGetVal('usage', 'Tag', "`id` = '$i_tagrels'");
        for($x = 0; $x < $usage; $x++){
            $lol = array(
                          "pdID" => getRandomIdFrom($pd_ids),
                          "tID" => $i_tagrels
                          );
            echo "adding " . $lol[pdID] . "=>" . $lol[tID];
            $did = jackedDBInsertValues('TagRel', $lol);
            echo "...#$did done.<br>";    
        }
        
    }


    echo "<h4>Votes time, HNNNG this is hard, </h4>";
    for($i_votes = 0; $i_votes < count($pd_ids); $i_votes++){
        echo "working on PD $i_votes<br>";
        $usage = jackedDBGetVal('votes', 'PoorDecision', "`id` = '$i_votes'");
        for($x = 0; $x < $usage; $x++){
            $r = rand(0, (count($arr) - 1));
            $uid = $source_ids[$r];
            $source_ids[$r] = null;
            $lol = array(
                          "value" => (rand(0, 1) ? -1 : 1),
                          "Source" => $uid,
                          "postID" => $i_votes
                          );
            echo "adding " . $lol[value] . "=>" . $lol[postID];
            $did = jackedDBInsertValues('Vote', $lol);
            echo "...#$did done.<br>";    
        }
        
        echo "repopulating sources id array...";
    	$query = "SELECT `id` FROM Source WHERE 1";
    	$result = mysql_query($query, JACKED_DEFAULT_LINK);
    	while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
    	    $source_ids[] = $row['id'];
    	}
        echo "done.<br>";
        
    }

	*/

	@unlink( 'markov.state' );
	
	$end = microtime(true);
	
	echo "<br><br><h2>I just made $i_apps Applications, $i_sources Sources, $i_tags Tags, $i_pds PoorDecisions, $i_tagrels TagRels, and $i_votes Votes, all completely batshit fucking insane random, in " . ($end - $start) . " seconds.";

?>