From 892e1bd302cc1fac7cf78c7758e4c53baec46490 Mon Sep 17 00:00:00 2001
From: athreyab <athreyab@localhost>
Date: Mon, 23 Jan 2012 00:00:18 +0000
Subject: [PATCH] more changes

svn path=/; revision=268
---
 .../interactions/interactionPathsFromTsv.pl   | 162 +++---------------
 ...nInteraction.sql => interactionTables.sql} | 135 ++++++++++++---
 2 files changed, 130 insertions(+), 167 deletions(-)
 rename Personnel/athreyab/interactions/{insertTablesInInteraction.sql => interactionTables.sql} (62%)

diff --git a/Personnel/athreyab/interactions/interactionPathsFromTsv.pl b/Personnel/athreyab/interactions/interactionPathsFromTsv.pl
index 4ee3af5..a70da8b 100644
--- a/Personnel/athreyab/interactions/interactionPathsFromTsv.pl
+++ b/Personnel/athreyab/interactions/interactionPathsFromTsv.pl
@@ -5,132 +5,11 @@
 use DBI;
 use Config::IniFiles;
 use Switch;
-
+require "interactionPath.pl";
 
 #use constant SITE_ADJECTIVE => ($ENV{'DevelopmentSite'} ? 'Development': 'Live');
 use constant SITE_ADJECTIVE => 'Development';
 
-
-sub executeDbQuery{
-	($query, $dbh) = @_;
-	$stmnt = $dbh->prepare("$query");
-	$stmnt->execute() or die "Couldn't execute statement: " . $stmnt->errstr;
-}
-
-sub executeDbQueryAndFetchRowArray{
-	($query, $dbh) = @_;
-	#print $query."\n"; 
-	$stmnt = $dbh->prepare("$query");
-	$stmnt->execute() or die "Couldn't execute statement: " . $stmnt->errstr;
-	return $stmnt->fetchrow_array();
-}
-
-sub getObjectId{
-	($obj_abbr, $dbh) = @_;
-	$query = "SELECT object_id FROM Object WHERE object_abbreviation = '$obj_abbr'"; 
-	$obj_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$obj_id ne "" or die "$obj_abbr was not found in Object table";
-	return $obj_id;
-}
-
-
-sub getInteractorTypeId{
-	($int_type, $dbh) = @_;
-	$query = "SELECT interactor_type_id FROM Interactor_type WHERE interactor_type = '$int_type'"; 
-	$int_type_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$int_type_id ne "" or die "$int_type was not found in Interactor_type table";
-	return $int_type_id;
-}
-
-
-sub getInteractionTypeId{
-	($interaction_type, $dbh) = @_;
-	$query = "SELECT interaction_type_id FROM Interaction_type WHERE interaction_type = '$interaction_type'"; 
-	$interaction_type_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$interaction_type_id ne "" or die "$interaction_type was not found in Interaction_type table";
-	return $interaction_type_id;
-}
-
-
-sub getModeOfActionId{
-	($mode_of_action, $dbh) = @_;
-	$query = "SELECT mode_of_action_id FROM Mode_of_action WHERE mode_of_action = '$mode_of_action'"; 
-	$mode_of_action_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$mode_of_action_id ne "" or die "$mode_of_action was not found in ModeofAction table";
-	return $mode_of_action_id;
-}
-
-sub getEvidenceId{
-	($evidence, $dbh) = @_;
-	@evidenceArray = split(/:/,$evidence);
-	scalar(@evidenceArray) == 2 or die "Incorrect evidence information. Evidence source name or id missing";
-	$query = "SELECT evidence_id FROM Evidence WHERE source_name = '$evidenceArray[0]' and source_id='$evidenceArray[1]'"; 
-	$evidence_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	if($evidence_id eq ""){
-		$query = "INSERT INTO Evidence(`source_name`,`source_id`) VALUES('$evidenceArray[0]','$evidenceArray[1]')"; 
-		executeDbQuery($query,$dbh);
-		return getEvidenceId($evidence,$dbh);
-	}
-	return $evidence_id;
-}
-
-sub getEvidenceCodeId{
-	($evidence_code, $dbh) = @_;
-	$query = "SELECT evidence_code_id FROM Evidence_code WHERE evidence_code = '$evidence_code'"; 
-	$evidence_code_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$evidence_code_id ne "" or die "$evidence_code was not found in Evidence table";
-	return $evidence_code_id;
-}
-
-
-sub getExperimentId{
-	($experiment, $dbh) = @_;
-	$query = "SELECT experiment_id FROM Experiment WHERE experiment_name = '$experiment'"; 
-	$experiment_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	$experiment_id ne "" or die "$experiment was not found in Experiment table";
-	return $experiment_id;
-}
-
-sub getCuratorId{
-	$query = "SELECT curator_id FROM Curator WHERE lab_name = '$labName' and user_name = '$userName'"; 
-	$curator_id = executeDbQueryAndFetchRowArray($query,$dbh);
-	if($curator_id ne ""){
-		return $curator_id;	
-	}
-	else{
-		$query = "INSERT INTO Curator(`lab_name`,`user_name`) VALUES('$labName','$userName')";
-		executeDbQuery($query,$dbh);
-		return getCuratorId($labName,$userName);
-	}
-}
-
- 
-sub setUpDBConnection
-{
-	#read config file for db config values
-	$ini = Config::IniFiles->new( -file => "/home/balaji/Documents/code/interactions/dbConfig.ini");
-	$dbUser=$ini->val(SITE_ADJECTIVE, 'dbUser');
-	$dbPw=$ini->val(SITE_ADJECTIVE, 'dbPw');
-	$host=$ini->val(SITE_ADJECTIVE, 'host');
-	$dbName=$ini->val(SITE_ADJECTIVE, 'dbName');
-	$dbh = DBI->connect("DBI:mysql:$dbName;host=$host",$dbUser,$dbPw,{RaiseError=> 1}) or die("Failed to connect to database - $DBI::errstr");
-	return $dbh;
-}
-
-sub getCuratorProperties
-{
-	print "Enter curator lab name or press 'enter'. Default is Jaiswal Lab.\n";
-	$labName = <STDIN>;
-	if($labName eq "\n"){
-		$labName = "Jaiswal lab";
-	}
-	print "Enter curator name or press 'enter'. Default is ''.\n";
-	$userName = <STDIN>;
-	if($userName eq "\n"){
-		$userName = "";
-	}
-}
-
 sub showUsage(){
 	print "Usage: \n\tperl interactionPathsFromTsv <option> <fileName>\n";
 	print "options:\n\t";
@@ -144,7 +23,6 @@ sub importSeedInteractionData(){
 	print "reading seed interaction information from file\n";
 
 	open(interactions_file, "$fileName") || die "Error: file '$fileName' can not be opened\n";
-	$dbh = setUpDBConnection();
 	while(<interactions_file>){
 		my $entry = $_;
 		# strip off newline characters
@@ -164,15 +42,17 @@ sub importSeedInteractionData(){
 		next if(!defined($experiment) || $experiment eq "");
       
       #get ids(primary keys) from other tables
-      $obj_id_left = getObjectId($obj_abbr_left,$dbh);
-      $obj_id_right = getObjectId($obj_abbr_right,$dbh);
-      $int_type_id_left = getInteractorTypeId($int_type_left, $dbh);
-      $int_type_id_right = getInteractorTypeId($int_type_right, $dbh);
-      $mode_of_action_id = getModeOfActionId($mode_of_action,$dbh);
-      $interaction_type_id = getInteractionTypeId($interaction_type, $dbh);
-      $evidence_id = getEvidenceId($evidence,$dbh);
-      $evidence_code_id = getEvidenceCodeId($evidence_code,$dbh);
-      $experiment_id = getExperimentId($experiment,$dbh);
+      $obj_id_left = getObjectIdFromAbbreviation($obj_abbr_left);
+      $obj_id_right = getObjectIdFromAbbreviation($obj_abbr_right);
+      $interaction_type_id = getInteractionTypeId($interaction_type);
+      #we need a minimum of the above 3 values before we can insert data into the interaction table.
+      next if(!defined($obj_id_left) || $obj_id_left eq "" || !defined($obj_id_right) || $obj_id_right eq "" || !defined($interaction_type_id) || $interaction_type_id eq "");
+      $int_type_id_left = getInteractorTypeId($int_type_left);
+      $int_type_id_right = getInteractorTypeId($int_type_right);
+      $mode_of_action_id = getModeOfActionId($mode_of_action);
+      $evidence_id = getEvidenceId($evidence);
+      $evidence_code_id = getEvidenceCodeId($evidence_code);
+      $experiment_id = getExperimentId($experiment);
 		$curator_id = getCuratorId();
       
       print $obj_id_left."\t".$obj_id_right."\t".$int_type_id_left."\t".$int_type_id_right."\t".$interaction_type_id.
@@ -183,7 +63,7 @@ sub importSeedInteractionData(){
       VALUES ('$obj_id_left','$obj_id_right','$interaction_type_id','$mode_of_action_id','$int_type_id_left','$int_type_id_right'
       ,'$evidence_id','$evidence_code_id','$experiment_id','$comments','$curator_id')";
       
-      executeDbQuery($query,$dbh);
+      executeDbQuery($query);
 				
 	}
 }
@@ -191,7 +71,6 @@ sub importSeedInteractionData(){
 sub importGeneInformation(){
 	print "reading gene information from file\n";
 	open(gene_file, "$fileName") || die "Error: file '$fileName' can not be opened\n";
-	$dbh = setUpDBConnection();
 	while(<gene_file>){
 		my $entry = $_;
 		# strip off newline characters
@@ -215,31 +94,31 @@ sub importGeneInformation(){
 
 		#first, insert the species name into the species table.		
 		$query = "INSERT INTO Species(`species`,`NCBI_taxonomy_id`) VALUES ('$species_name','$ncbi_id') ON DUPLICATE KEY UPDATE species='$species_name'";
-		executeDbQuery($query,$dbh);		
+		executeDbQuery($query);		
 		
 		#get the species_id 
 		$query = "SELECT species_id FROM Species WHERE species = '$species_name'"; 
-		$species_id = executeDbQueryAndFetchRowArray($query,$dbh);	
+		$species_id = executeDbQueryAndFetchRowArray($query);	
 		
 		#insert synonym into the synonym table.
 		$query = "INSERT INTO Synonym(`synonym`) VALUES('$synonym') ON DUPLICATE KEY UPDATE synonym='$synonym'";
-		executeDbQuery($query,$dbh);	
+		executeDbQuery($query);	
 				
 		#get the synonym_id 
 		$query = "SELECT synonym_id FROM Synonym WHERE synonym = '$synonym'"; 
-		$synonym_id = executeDbQueryAndFetchRowArray($query,$dbh);
+		$synonym_id = executeDbQueryAndFetchRowArray($query);
 		
 		#insert gene information into the object table																											
 		$query = "INSERT INTO Object(`object_accession`,`species_id`,`object_full_name`,`object_abbreviation`,`object_type_id`) VALUES('$accession','$species_id','$full_name','$symbol','$object_type') ON DUPLICATE KEY UPDATE object_accession='$accession'";
-		executeDbQuery($query,$dbh);
+		executeDbQuery($query);
 		
 		#get the object_id 
 		$query = "SELECT object_id FROM Object WHERE object_accession = '$accession'";
-		$object_id = executeDbQueryAndFetchRowArray($query,$dbh);
+		$object_id = executeDbQueryAndFetchRowArray($query);
 	
 		#next, insert object_id and synonym_id into object_synonym table.
 		$query = "INSERT INTO Object_synonym(`object_id`,`synonym_id`) VALUES ('$object_id','$synonym_id') ON DUPLICATE KEY UPDATE object_id='$object_id'";
-		executeDbQuery($query,$dbh);
+		executeDbQuery($query);
 	
 	}
 
@@ -255,6 +134,7 @@ $optionId = $ARGV[0];
 $fileName = $ARGV[1];
 $labName = "";
 $userName = "";
+$dbh = setUpDBConnection();
 switch($optionId){
    case "1"
 	{
diff --git a/Personnel/athreyab/interactions/insertTablesInInteraction.sql b/Personnel/athreyab/interactions/interactionTables.sql
similarity index 62%
rename from Personnel/athreyab/interactions/insertTablesInInteraction.sql
rename to Personnel/athreyab/interactions/interactionTables.sql
index 790a421..594ad16 100644
--- a/Personnel/athreyab/interactions/insertTablesInInteraction.sql
+++ b/Personnel/athreyab/interactions/interactionTables.sql
@@ -81,7 +81,7 @@ DROP TABLE IF EXISTS `interaction`.`Experiment` ;
 
 CREATE  TABLE IF NOT EXISTS `interaction`.`Experiment` (
   `experiment_id` INT NOT NULL AUTO_INCREMENT ,
-  `experiment_name` VARCHAR(45) NOT NULL ,
+  `experiment_name` VARCHAR(55) NOT NULL ,
   PRIMARY KEY (`experiment_id`) ,
   UNIQUE INDEX `experiment_UNIQUE` (`experiment_name` ASC) )
 ENGINE = InnoDB;
@@ -93,7 +93,7 @@ ENGINE = InnoDB;
 DROP TABLE IF EXISTS `interaction`.`Evidence` ;
 
 CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence` (
-  `evidence_id` INT NOT NULL ,
+  `evidence_id` INT NOT NULL AUTO_INCREMENT ,
   `source_name` VARCHAR(45) NOT NULL ,
   `source_id` VARCHAR(45) NOT NULL ,
   PRIMARY KEY (`evidence_id`) )
@@ -114,15 +114,15 @@ ENGINE = InnoDB;
 
 
 -- -----------------------------------------------------
--- Table `interaction`.`Evidence`
+-- Table `interaction`.`Evidence_code`
 -- -----------------------------------------------------
-DROP TABLE IF EXISTS `interaction`.`Evidence` ;
+DROP TABLE IF EXISTS `interaction`.`Evidence_code` ;
 
-CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence` (
-  `evidence_id` INT NOT NULL ,
-  `source_name` VARCHAR(45) NOT NULL ,
-  `source_id` VARCHAR(45) NOT NULL ,
-  PRIMARY KEY (`evidence_id`) )
+CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence_code` (
+  `evidence_code_id` INT NOT NULL  AUTO_INCREMENT ,
+  `evidence_code` VARCHAR(45) NOT NULL ,
+  `evidence_name` VARCHAR(55) NOT NULL ,
+  PRIMARY KEY (`evidence_code_id`) )
 ENGINE = InnoDB;
 
 
@@ -135,7 +135,8 @@ CREATE  TABLE IF NOT EXISTS `interaction`.`Curator` (
   `curator_id` INT NOT NULL AUTO_INCREMENT ,
   `lab_name` VARCHAR(45) NOT NULL ,
   `user_name` VARCHAR(45) NULL ,
-  PRIMARY KEY (`curator_id`) )
+  PRIMARY KEY (`curator_id`),
+  UNIQUE INDEX `user_name_UNIQUE` (`user_name` ASC))
 ENGINE = InnoDB;
 
 
@@ -146,9 +147,9 @@ DROP TABLE IF EXISTS `interaction`.`Mode_of_action` ;
 
 CREATE  TABLE IF NOT EXISTS `interaction`.`Mode_of_action` (
   `mode_of_action_id` INT NOT NULL AUTO_INCREMENT ,
-  `type` VARCHAR(45) NOT NULL ,
+  `mode_of_action` VARCHAR(45) NOT NULL ,
   PRIMARY KEY (`mode_of_action_id`) ,
-  UNIQUE INDEX `type_UNIQUE` (`type` ASC) )
+  UNIQUE INDEX `mode_of_action_UNIQUE` (`mode_of_action` ASC) )
 ENGINE = InnoDB;
 
 
@@ -204,7 +205,7 @@ CREATE  TABLE IF NOT EXISTS `interaction`.`Interaction` (
     ON UPDATE NO ACTION,
   CONSTRAINT `fk_Interactions_6`
     FOREIGN KEY (`evidence_code_id` )
-    REFERENCES `interaction`.`Evidence` (`evidence_id` )
+    REFERENCES `interaction`.`Evidence_code` (`evidence_code_id` )
     ON DELETE NO ACTION
     ON UPDATE NO ACTION,
   CONSTRAINT `fk_Interactions_7`
@@ -293,19 +294,6 @@ CREATE  TABLE IF NOT EXISTS `interaction`.`Synonym` (
 ENGINE = InnoDB;
 
 
--- -----------------------------------------------------
--- Table `interaction`.`Evidence_pmid`
--- -----------------------------------------------------
-DROP TABLE IF EXISTS `interaction`.`Evidence_pmid` ;
-
-CREATE  TABLE IF NOT EXISTS `interaction`.`Evidence_pmid` (
-  `id` INT NOT NULL ,
-  `pmid` VARCHAR(45) NOT NULL ,
-  PRIMARY KEY (`id`) ,
-  UNIQUE INDEX `Evidence_pmid_UNIQUE` (`pmid` ASC) )
-ENGINE = InnoDB;
-
-
 -- -----------------------------------------------------
 -- Table `interaction`.`Object_synonym`
 -- -----------------------------------------------------
@@ -331,6 +319,101 @@ CREATE  TABLE IF NOT EXISTS `interaction`.`Object_synonym` (
 ENGINE = InnoDB;
 
 
+-- -----------------------------------------------------
+-- Populate `interaction`.`Object_type` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Object_type`(`object_type`) VALUE('gene');
+INSERT INTO `Object_type`(`object_type`) VALUE('metabolite');
+
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Homology_type` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Homology_type`(`homology_type`) VALUE('ortholog');
+INSERT INTO `Homology_type`(`homology_type`) VALUE('paralog');
+
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Interactor_type` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('DNA');
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('RNA');
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('protein');
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('metabolite');
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('gene');
+INSERT INTO `Interactor_type`(`interactor_type`) VALUE('NA');
+
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Interaction_type` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Interaction_type`(`interaction_type`) VALUE('protein-protein binding');
+INSERT INTO `Interaction_type`(`interaction_type`) VALUE('up regulation');
+INSERT INTO `Interaction_type`(`interaction_type`) VALUE('down regulation');
+INSERT INTO `Interaction_type`(`interaction_type`) VALUE('co-expression');
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Experiment` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Experiment`(`experiment_name`) VALUE('Co-immunoprecipiation (CoIP)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('bimolecular fluorescence complementation (BiFC)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast two-hybrid analysis (Y2H)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('affinity chromatography');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('transcriptome (microarray)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('transcriptome (RNA-Seq)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('proteomics');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast one-hybrid analysis (Y1H)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('yeast three-hybrid analysis (Y3H)');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('protein 2D gel');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('mobility shift gel assay');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('sequence homology');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('network modeling');
+INSERT INTO `Experiment`(`experiment_name`) VALUE('NA (not available)');
+
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Evidence_code` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('EXP','Inferred from Experiment');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IDA','Inferred from Direct Assay');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IPI','Inferred from Physical Interaction');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IMP','Inferred from Mutant Phenotype');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IGI','Inferred from Genetic Interaction');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IEP','Inferred from Expression Pattern');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IAGP','Inferred by association of genotype from phenotype');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISS','Inferred from Sequence or Structural Similarity');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISO','Inferred from Sequence Orthology');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISA','Inferred from Sequence Alignment');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ISM','Inferred from Sequence Model');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IGC','Inferred from Genomic Context');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IBA','Inferred from Biological aspect of Ancestor');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IBD','Inferred from Biological aspect of Descendant');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IKR','Inferred from Key Residues');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IRD','Inferred from Rapid Divergence');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('RCA','inferred from Reviewed Computational Analysis');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('TAS','Traceable Author Statement');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('NAS','Non-traceable Author Statement');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IC','Inferred by Curator');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('ND','No biological Data available');
+INSERT INTO `Evidence_code`(`evidence_code`,`evidence_name`) VALUES('IEA','Inferred from Electronic Annotation');
+
+
+
+-- -----------------------------------------------------
+-- Populate `interaction`.`Mode_of_action` with known values
+-- -----------------------------------------------------
+
+INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('binds');
+INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('co-expresses');
+INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('up regulates');
+INSERT INTO `Mode_of_action`(`mode_of_action`) VALUE('down regulates');
+
 
 SET SQL_MODE=@OLD_SQL_MODE;
 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
-- 
2.34.1