public function run()
{
$students = array(array("surname" => "Dare", "firstname" => "Koby", "nationality" => "UK", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Dicki", "firstname" => "Kelli", "nationality" => "UK", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Carter", "firstname" => "Golden", "nationality" => "UK", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Koch", "firstname" => "Emory", "nationality" => "UK", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kilback", "firstname" => "Marjorie", "nationality" => "Dominican Republic", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hoeger", "firstname" => "Ernest", "nationality" => "Panama", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hudson", "firstname" => "Rebecca", "nationality" => "Chile", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hirthe", "firstname" => "Josefina", "nationality" => "Kyrgyzstan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Ebert", "firstname" => "Wanda", "nationality" => "Palau", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Denesik", "firstname" => "Burnice", "nationality" => "Kuwait", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Moen", "firstname" => "Harold", "nationality" => "Vatican City", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Spencer", "firstname" => "Brennon", "nationality" => "Cambodia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Ziemann", "firstname" => "Stanley", "nationality" => "Azerbaijan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Rempel", "firstname" => "Forest", "nationality" => "Seychelles", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Zboncak", "firstname" => "Gregory", "nationality" => "Kazakhstan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Weimann", "firstname" => "Valentine", "nationality" => "Turks and Caicos Islands", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Waelchi", "firstname" => "Alexandria", "nationality" => "People's Democratic Republic of Yemen", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Altenwerth", "firstname" => "Florian", "nationality" => "Wake Island", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Zieme", "firstname" => "Faye", "nationality" => "Guatemala", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Beatty", "firstname" => "Raleigh", "nationality" => "British Antarctic Territory", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kuhic", "firstname" => "Dolly", "nationality" => "Paraguay", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Koepp", "firstname" => "Mikel", "nationality" => "Liberia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Pfannerstill", "firstname" => "May", "nationality" => "Puerto Rico", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Douglas", "firstname" => "Otho", "nationality" => "Denmark", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Conroy", "firstname" => "Napoleon", "nationality" => "Afghanistan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Doyle", "firstname" => "Elza", "nationality" => "Liechtenstein", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Schulist", "firstname" => "Maci", "nationality" => "United States", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hansen", "firstname" => "Kyler", "nationality" => "Canada", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Conn", "firstname" => "Jean", "nationality" => "Kiribati", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Yost", "firstname" => "Reilly", "nationality" => "South Africa", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Quigley", "firstname" => "Shad", "nationality" => "Bhutan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Quitzon", "firstname" => "Beatrice", "nationality" => "Timor-Leste", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Langworth", "firstname" => "Lonny", "nationality" => "New Zealand", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kiehn", "firstname" => "Rosalinda", "nationality" => "Dominican Republic", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Parker", "firstname" => "Rebekah", "nationality" => "Kyrgyzstan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kuhlman", "firstname" => "Rhoda", "nationality" => "Gibraltar", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Cruickshank", "firstname" => "Judd", "nationality" => "Macau SAR China", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Yundt", "firstname" => "Sarah", "nationality" => "Papua New Guinea", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Pacocha", "firstname" => "Russ", "nationality" => "Greenland", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Purdy", "firstname" => "Kali", "nationality" => "Mauritania", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Block", "firstname" => "Janick", "nationality" => "Belarus", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Waelchi", "firstname" => "Ford", "nationality" => "Paraguay", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Batz", "firstname" => "Francesca", "nationality" => "Netherlands Antilles", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Rogahn", "firstname" => "Lukas", "nationality" => "Cape Verde", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Funk", "firstname" => "Wilhelmine", "nationality" => "Zimbabwe", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Nader", "firstname" => "Jude", "nationality" => "Panama Canal Zone", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Stroman", "firstname" => "Frankie", "nationality" => "Saint Martin", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Jaskolski", "firstname" => "Mina", "nationality" => "Bermuda", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Zieme", "firstname" => "Mack", "nationality" => "Uzbekistan", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Tromp", "firstname" => "Celestine", "nationality" => "Peru", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Nitzsche", "firstname" => "Zella", "nationality" => "New Zealand", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kuphal", "firstname" => "Ila", "nationality" => "Maldives", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Cruickshank", "firstname" => "Eda", "nationality" => "Jamaica", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Koepp", "firstname" => "Jaylen", "nationality" => "Monaco", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kohler", "firstname" => "Kristina", "nationality" => "Russia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Ondricka", "firstname" => "Sean", "nationality" => "Turks and Caicos Islands", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Leuschke", "firstname" => "Estelle", "nationality" => "Niue", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Funk", "firstname" => "Roselyn", "nationality" => "Djibouti", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Romaguera", "firstname" => "Kariane", "nationality" => "Djibouti", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Nitzsche", "firstname" => "Adrian", "nationality" => "Guernsey", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Windler", "firstname" => "Maggie", "nationality" => "Guernsey", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Blanda", "firstname" => "Ken", "nationality" => "French Southern Territories", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Reilly", "firstname" => "Antone", "nationality" => "Yemen", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Cassin", "firstname" => "Yadira", "nationality" => "Mayotte", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Macejkovic", "firstname" => "Marge", "nationality" => "Slovakia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Feest", "firstname" => "Rogers", "nationality" => "Monaco", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Fadel", "firstname" => "Candelario", "nationality" => "Belarus", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Shields", "firstname" => "Eldridge", "nationality" => "Neutral Zone", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Romaguera", "firstname" => "Lavina", "nationality" => "Canton and Enderbury Islands", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hessel", "firstname" => "Matt", "nationality" => "Czech Republic", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Donnelly", "firstname" => "Barrett", "nationality" => "South Korea", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Hagenes", "firstname" => "Betty", "nationality" => "Samoa", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Schmeler", "firstname" => "Alphonso", "nationality" => "Palau", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Shields", "firstname" => "Selmer", "nationality" => "Samoa", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kemmer", "firstname" => "Earl", "nationality" => "Niger", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kunde", "firstname" => "Sharon", "nationality" => "French Guiana", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Jacobs", "firstname" => "Jeffry", "nationality" => "Albania", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Ritchie", "firstname" => "Eliane", "nationality" => "Chad", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Erdman", "firstname" => "Howard", "nationality" => "Puerto Rico", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Schimmel", "firstname" => "Lance", "nationality" => "Serbia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Tillman", "firstname" => "Elliott", "nationality" => "Botswana", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Boyle", "firstname" => "Emanuel", "nationality" => "Tokelau", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Feest", "firstname" => "Norma", "nationality" => "Georgia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "O'Conner", "firstname" => "Jenifer", "nationality" => "Nepal", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Towne", "firstname" => "Lilliana", "nationality" => "New Caledonia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Padberg", "firstname" => "Verner", "nationality" => "Seychelles", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Stiedemann", "firstname" => "Adelia", "nationality" => "Greece", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Turcotte", "firstname" => "Tristin", "nationality" => "Nauru", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Pouros", "firstname" => "Cooper", "nationality" => "Micronesia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Romaguera", "firstname" => "Judy", "nationality" => "Australia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Tremblay", "firstname" => "Maxie", "nationality" => "French Guiana", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Barrows", "firstname" => "Akeem", "nationality" => "Mozambique", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Funk", "firstname" => "Florencio", "nationality" => "Malawi", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Welch", "firstname" => "Margarita", "nationality" => "Ethiopia", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Legros", "firstname" => "Helmer", "nationality" => "Antigua and Barbuda", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Labadie", "firstname" => "Carole", "nationality" => "Martinique", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Klein", "firstname" => "Desiree", "nationality" => "Nepal", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Kuvalis", "firstname" => "Eloy", "nationality" => "Panama Canal Zone", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Macejkovic", "firstname" => "Lucinda", "nationality" => "Austria", "email" => "*****@*****.**", "address_id" => rand(0, 88), "course_id" => rand(0, 199)), array("surname" => "Bosco", "firstname" => "Emilia", "nationality" => "São Tomé and Príncipe", "email" => "*****@*****.**"));
foreach ($students as $student) {
Students::create($student);
}
}
function saveRawSkillScore($studentId, $skillId, $rawScore)
{
$studentId = str_replace("'", "", $studentId);
if ($existingStudent = Students::findFirst("email = '{$studentId}'")) {
// If they do, update the existing database row
$existingStudent->{$skillId} = $rawScore;
if ($existingStudent->update() == false) {
//print_r($existingStudent->getMessages());
return false;
} else {
return true;
}
} else {
// If they don't, create a new student
$student = new Students();
$student->email = $studentId;
$student->{$skillId} = $rawScore;
// Initialize all other skill scores to 0 (done by default)
//$student->time = 0;
//$student->activity = 0;
//$student->consistency = 0;
//$student->awareness = 0;
//$student->deep_learning = 0;
//$student->persistence_attempts = 0;
//$student->persistence_watched = 0;
if ($student->create() == false) {
return false;
} else {
return true;
}
}
}
<?php
/**
* Created by IntelliJ IDEA.
* User: jordan.knott
* Date: 4/21/2016
* Time: 9:19 AM
*/
/**
* This is the editor-centric portion of the API. This is the endpoint the editor can use to add new users as well as update them.
* METHOD: POST
* API-KEY: true
*/
require '../data/api_keys.php';
require '../data/students.php';
if (isset($_POST['action'])) {
$action = $_POST['action'];
if ($action == 'add') {
if ($_POST['name']) {
$name = $_POST['name'];
$students = Students::create();
$students->addStudent($name);
echo "Student added! {$name}";
} else {
echo "student name not defined!";
}
}
} else {
}
