/fillDB.php
PHP | 223 lines | 29 code | 18 blank | 176 comment | 2 complexity | 9b2bbd023859d8fe6f8a604efb6a4765 MD5 | raw file
Possible License(s): Apache-2.0
- <?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.";
- ?>