BSBD_TSQLR/README.md~ at master · Sibuken/BSBD_TSQLR · GitHub

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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
# Testing of the SQL Requests

Required - >=Python3.4
sudo su
sudo apt-get update
sudo apt-get install git
git clone https://github.com/artkuznetsov/BSBD_TSQLR.git
sudo apt-get install mysql-server

Create Database for Application (see configuration TestApp/settings.py). Default: testbsbd---
mysql -u root -p
mysql>create database testbsbd;
mysql>exit;

sudo apt-get install python3-setuptools
sudo apt-get install python3-pip
sudo pip3 install pymysql
sudo apt-get install unixodbc-dev
sudo pip3 install pyodbc
sudo pip3 install pytz
sudo pip3 install sqlalchemy
sudo apt-get install graphviz libgraphviz-dev pkg-config
sudo pip3 install pygraphviz --install-option="--include-path=/usr/include/graphviz" --install-option="--library-path=/usr/lib/graphviz/"
sudo pip3 install eralchemy

Install libraries for working with images:
sudo apt-get install python3-dev
sudo apt-get install libtiff5-dev libjpeg8-dev zlib1g-dev libfreetype6-dev liblcms2-dev libwebp-dev tcl8.6-dev tk8.6-dev python3-tk
sudo apt-get install pillow


All required libraries has been installed and now we can to migrate
project's database; For this run following command:
python3 manage.py migrate


Now we need to create a superuser:
python3 manage.py createsuperuser


Install MySQL ODBC Driver:
sudo apt-get install mysql-client
sudo apt-get install libmyodbc unixodbc-bin

find / -name 'lib*odbc*.so'

OUTPUT (EXAMPLE):
/usr/lib/x86_64-linux-gnu/odbc/liboplodbcS.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcminiS.so
/usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
/usr/lib/x86_64-linux-gnu/odbc/libodbctxtS.so
/usr/lib/x86_64-linux-gnu/odbc/liboraodbcS.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg2S.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcdrvcfg1S.so
/usr/lib/x86_64-linux-gnu/odbc/libodbcnnS.so
/usr/lib/x86_64-linux-gnu/libodbcinst.so
/usr/lib/x86_64-linux-gnu/libodbccr.so
/usr/lib/x86_64-linux-gnu/libodbc.so

nano /etc/odbcinst.ini

[MySQL]
Description     = ODBC for MySQL
Driver          = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup           = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount      = 1

nano /etc/odbc.ini

[MySQL]                                    # this is your system D$
Description = description of your DSN
Driver      = MySQL                        # custom driver name
Server      = localhost                    # or external IP if nee$
Port        = 3306                         # or custom port if nee$
Socket      = /var/run/mysqld/mysqld.sock  # socket, see above
Database    = testbsbd                     # MySQL DB name or empty
Option      = 3
ReadOnly    = No

Install the ODBC driver:
odbcinst -i -d -f /etc/odbcinst.ini

Install your system DSN:
odbcinst -i -s -l -f /etc/odbc.ini

Test if your system DSN was installed successfully:
odbcinst -s -q

OUTPUT (EXAMPLE):
[MySQL]

Currently we should to create white mysql database which can see an users and shadow database for check SQL requests.

mysql -u root -p
mysql> create database whitedb;
mysql> create database shadowdb;
mysql> exit

Example for connection string to whitedb and shadowdb:
DRIVER={MySQL}; DATABASE=whitedb; SERVER=localhost; UID=root; PWD=12345;
DRIVER={MySQL}; DATABASE=shadowdb; SERVER=localhost; UID=root; PWD=12345;