<commit_before><?php

	// create_table.php - Script to create new table in existing MySQL database

	include "cred_ext.php";

	//Create connection
	$con = mysqli_connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
	// Check connection
	if (mysqli_connect_errno()) {
		echo "Failed to connect to MySQL: " . mysqli_connect_error();
	}


	// Create table
	$sql = "ALTER TABLE Apprentices
	ADD COLUMN AgeCheck VARCHAR(3)";
	if (mysqli_query($con, $sql)) {
		echo "Table Apprentices in test_db updated successfully.\n";
	}
	else {
		echo "Error creating database: " . mysqli_error($con);
	}

	// Close connection
	mysqli_close($con);

?><commit_msg>Added SQL statement array for updates, added SQL execution loop<commit_after><?php

	// create_table.php - Script to create new table in existing MySQL database

	include "cred_ext.php";

	//Create connection
	$con = mysqli_connect(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
	// Check connection
	if (mysqli_connect_errno()) {
		echo "Failed to connect to MySQL: " . mysqli_connect_error();
	}


	// Create table
	$sql = array(
		"ALTER TABLE Apprentices ADD COLUMN Gender VARCHAR(6)",
		"ALTER TABLE Apprentices ADD COLUMN AgeCheck VARCHAR(3)"
	);
	
	foreach ($sql as $stmt) {
		if (mysqli_query($con, $stmt)) {
			echo "Table Apprentices in test_db updated successfully.\n";
		}
		else {
			echo "Error updating database: " . mysqli_error($con);
		}

	// Close connection
	mysqli_close($con);

?>
{'fraction_non_alphanumeric': 0.11768754301445286, 'fraction_numerical': 0.0020646937370956643, 'mean_word_length': 4.137809187279152, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7118812', 'n_tokens_mistral': 522, 'n_tokens_neox': 484, 'n_words': 141}