Profiling for R Scripts

Uploads benchmarking/profiling results to a database. This function tries to connect to a MySQL or SQLite database using provided information. If connection is sucessfull, data frames BM and META from .BenchEnv environment to the database tables BENCHMARKS and META. These tables should exist in the provided database. The BENCHMARKS table can be created by using:

CREATE TABLE "BENCHMARKS" ( `runId` VARCHAR(18) NOT NULL, `systemId` VARCHAR(32) NOT NULL, `file` VARCHAR(64) NOT NULL, `version` VARCHAR(32) NOT NULL, `process` VARCHAR(16) NOT NULL, `start_time` DECIMAL NOT NULL, `end_time` DECIMAL NOT NULL, `duration` DECIMAL NOT NULL, `runs` INTEGER NOT NULL, PRIMARY KEY(runId,process,end_time) )

and for META table use:

CREATE TABLE META ( systemId VARCHAR(32), variable VARCHAR(32), value VARCHAR(32), PRIMARY KEY(systemId,variable))

1	benchDBReport(usr, pwd, host_loc, conn_str, db_name, con_type, bench_log, warn_log)

`usr`	database usrname. Default is `NULL`.
`pwd`	database password. Default is `NULL`.
`host_loc`	IP address of the MySQL server. Default is `NULL`.
`conn_str`	a complete connection string (eg jdbc:mysql:127.0.0.1:36/myDatabase). Default is `NULL`.
`db_name`	database name. Default is `NULL`.
`con_type`	type of database (currently only mysql and sqlite supported)
`bench_log`	filename to use to store message/warning/errors. Default is "benchmark.log"
`warn_log`	level of logging to use (choose from -1, "INFO", "WARN", "STOP". Default value is -1.