This repository has been archived by the owner on Dec 21, 2017. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
/
config.jl
73 lines (62 loc) · 3.1 KB
/
config.jl
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
#Assign the variable number_of_datasets with an Integer, this will indicate the number of Insert and Update queries that will be created and executed using this program
global number_of_datasets = 1000
#DSN for ODBC connection
using ODBC
global const MySQL_DSN = "mysql" #Configure the default Database for MySQL within your DSN configuration i.e odbc.ini file
global const ODBC_MySQL_floating_point_tolerance = 999999999 #Retrieved values will be rounded off based on this constant
global const ODBC_MySQL_double_tolerance = 999999999
global const Oracle_DSN = "oracle_dsn"
global const Oracle_Username = "julia"
global const Oracle_Password = "password"
global const Oracle_table_name = "Employee"
global const ODBC_Oracle_floating_point_tolerance = 999999999 #Retrieved values will be rounded off based on this constant
global const ODBC_Oracle_double_tolerance = 999999999
global const ODBC_PostGres_dsn = "postgres"
global const ODBC_PostGres_username = "postgres"
global const ODBC_PostGres_password = "postgres"
global const ODBC_PostGres_floating_point_tolerance = 999999999 #Retrieved values will be rounded off based on this constant
global const ODBC_PostGres_double_tolerance = 999999999
#Credentials for MySQL connection
using MySQL
global const MySQL_Host = "127.0.0.1"
global const MySQL_Username = "root"
global const MySQL_Password = "root"
global const MySQL_Database = "mysqltest1"
global const MySQL_floating_point_tolerance = 999999999
global const MySQL_double_tolerance = 999999999
#Credentials for PostgreSQL credentials
using PostgreSQL, DataFrames, DBI
global const PostGres_Username = "postgres"
global const PostGres_Password = "postgres"
global const PostGres_Host = "127.0.0.1"
global const PostGres_Port_number = 5432
global const PostGres_Database = "mytest"
global const PostGres_floating_point_tolerance = 999999999
global const PostGres_double_tolerance = 999999999
#Credentials for JDBC connection
using JDBC
global const JDBC_MySQL_Class_Path = "/usr/share/java/mysql-connector-java.jar"
global const JDBC_MySQL_Username = "root"
global const JDBC_MySQL_Password = "root"
global const MySQL_JDBC_URL = "jdbc:mysql://127.0.0.1/mysqltest1"
global const JDBC_MySQL_floating_point_tolerance = 999999999
global const JDBC_MySQL_double_tolerance = 999999999
global const JDBC_Oracle_Connector_Path = "/u01/app/oracle/product/11.2.0/xe/jdbc/lib/ojdbc5.jar"
global const JDBC_Oracle_Username = "julia"
global const JDBC_Oracle_Password = "password"
global const Oracle_JDBC_URL= "jdbc:oracle:thin:@127.0.0.1:1521"
global const Oracle_table_name = "Employee"
global const JDBC_Oracle_floating_point_tolerance = 999999999
global const JDBC_Oracle_double_tolerance = 999999999
#Credentials for Mongo DB
using LibBSON, Mongo
global const Mongo_Host = "localhost"
global const Mongo_Port = 27017
global const Mongo_floating_point_tolerance = 999999999
global const Mongo_double_tolerance = 999999999
#Credentials for SQLite
using SQLite
global const SQLite_DBname = "Benchmark.sqlite"
global const SQLite_table = "Employee"
global const SQLite_floating_point_tolerance = 999999999
global const SQLite_double_tolerance = 999999999