Queries (crawler)

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

CREATE TABLE `BookMetadata` (
 `ISBN` varchar(13) CHARACTER SET ucs2 NOT NULL,
 `Title` varchar(500) CHARACTER SET ucs2 NOT NULL,
 `AuthorsNames` varchar(3000) CHARACTER SET ucs2 NOT NULL,
 `PublisherName` varchar(100) CHARACTER SET ucs2 NOT NULL,
 `InsertDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 `ReportSourceId` int(11) DEFAULT NULL,
 PRIMARY KEY (`ISBN`),
 KEY `BookMetadata_ReportSource_FK` (`ReportSourceId`),
 CONSTRAINT `BookMetadata_ReportSource_FK` FOREIGN KEY (`ReportSourceId`) REFERENCES `ReportSource` (`Id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
CREATE TABLE `ReportSource` (
 `Id` int(11) NOT NULL AUTO_INCREMENT,
 `Name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
 `RemoveFingerprint` tinyint(1) DEFAULT '0',
 `ShortName` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
 PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
SHOW VARIABLES LIKE "max_connections";
ALTER USER 'root' IDENTIFIED WITH mysql_native_password BY 'root.local.db';
SELECT user FROM mysql.user;
DROP TABLE BookMetadata;
DROP TABLE BookMetadata_Temp;
DROP TABLE ReportSource;
INSERT IGNORE INTO BookMetadata_Temp (ISBN, Title, AuthorsNames, PublisherName)
VALUES ('9786555760057', 'Curso de direito constitucional ', '', 'Editora Manole');
INSERT INTO 
	fileManagement.BookMetadata (ISBN, Title, AuthorsNames, PublisherName)
SELECT BT.ISBN, BT.Title, BT.AuthorsNames, BT.PublisherName FROM fileManagement.BookMetadata_Temp BT
WHERE BT.ISBN NOT IN (
	SELECT B.ISBN FROM fileManagement.BookMetadata B WHERE B.ISBN IS NOT NULL
);