Chemistry::SQL 0.01 review
DownloadChemistry::SQL is an access database functions module. SYNOPSIS use strict; use Chemistry::SQL; use C
|
|
Chemistry::SQL is an access database functions module.
SYNOPSIS
use strict;
use Chemistry::SQL;
use Chemistry::Artificial::SQL;
my $db_name = $ARGV[0];
my $file = $ARGV[1];
my $db1 = Chemistry::SQL::new(db_host=>"127.0.0.1",db_user=>"root",db_port=>"3306",db_pwd=>"",
db_name=>$db_name,db_driver=>"mysql");
if ($db1->db_exist)
{ $db1->connect_db;
$db1->del_tables;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
else
{
$db1->create_db;
$db1->connect_db;
$db1->create_tables_mysql;
$db1->inscomp_from_file("$file");
}
# Reaction Insertion
my $qart = Chemistry::Artificial::SQL::new($db1);
my $qr =$qart->q_reaccion('C=CC=C.C=C>>C1=CCCCC1','smiles');
$db1->reactionsert($qr,"","0");
This package provides the necessary functions to interact with the database. The methods implemented in this module are oriented to give users control of the database without knowing how to use SQL queries.
Requirements:
Perl
Chemistry::SQL 0.01 search tags