Chemistry::SQL 0.01

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.