/** * @test */ public function getCreateStatement() { $createStatementString = $this->databaseConnection->getCreateStatement('users'); $createStatementArray = $this->databaseConnection->getCreateStatement('users', true); $exceptedString = "CREATE TABLE `users` (\n `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n `first_name` varchar(64) COLLATE utf8_bin NOT NULL,\n `last_name` varchar(64) COLLATE utf8_bin NOT NULL,\n `email` varchar(256) COLLATE utf8_bin NOT NULL,\n `username` varchar(64) COLLATE utf8_bin NOT NULL,\n `password` varchar(32) COLLATE utf8_bin NOT NULL,\n `type_id` int(10) unsigned DEFAULT NULL,\n `status_id` int(10) unsigned DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `type_id` (`type_id`),\n KEY `status_id` (`status_id`),\n CONSTRAINT `users_ibfk_4` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,\n CONSTRAINT `users_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `sTaT_useS` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin"; $exceptedArray = array("CREATE TABLE `users` (", "`id` int(10) unsigned NOT NULL AUTO_INCREMENT,", "`first_name` varchar(64) COLLATE utf8_bin NOT NULL,", "`last_name` varchar(64) COLLATE utf8_bin NOT NULL,", "`email` varchar(256) COLLATE utf8_bin NOT NULL,", "`username` varchar(64) COLLATE utf8_bin NOT NULL,", "`password` varchar(32) COLLATE utf8_bin NOT NULL,", "`type_id` int(10) unsigned DEFAULT NULL,", "`status_id` int(10) unsigned DEFAULT NULL,", "PRIMARY KEY (`id`),", "KEY `type_id` (`type_id`),", "KEY `status_id` (`status_id`),", "CONSTRAINT `users_ibfk_4` FOREIGN KEY (`type_id`) REFERENCES `types` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,", "CONSTRAINT `users_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `sTaT_useS` (`ID`) ON DELETE SET NULL ON UPDATE CASCADE", ") ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin"); $this->assertSame($exceptedString, $createStatementString); $this->assertSame($exceptedArray, $createStatementArray); }