This function returns the SQLite database connection :param sid: server id :type sid: int :return: db connection
(sid)
| 800 | |
| 801 | |
| 802 | def get_db_server(sid): |
| 803 | """ |
| 804 | This function returns the SQLite database connection |
| 805 | :param sid: server id |
| 806 | :type sid: int |
| 807 | :return: db connection |
| 808 | """ |
| 809 | connection = '' |
| 810 | conn = sqlite3.connect(config.TEST_SQLITE_PATH) |
| 811 | cur = conn.cursor() |
| 812 | server = cur.execute( |
| 813 | 'SELECT name, host, port, maintenance_db,' |
| 814 | ' username FROM server where id=%s' % sid |
| 815 | ) |
| 816 | server = server.fetchone() |
| 817 | if server: |
| 818 | name = server[0] |
| 819 | host = server[1] |
| 820 | db_port = server[2] |
| 821 | db_name = server[3] |
| 822 | username = server[4] |
| 823 | config_servers = test_setup.config_data['server_credentials'] |
| 824 | # Get the db password from config file for appropriate server |
| 825 | db_password = get_db_password(config_servers, name, host, db_port) |
| 826 | if db_password: |
| 827 | # Drop database |
| 828 | connection = get_db_connection( |
| 829 | db_name, username, db_password, host, db_port |
| 830 | ) |
| 831 | conn.close() |
| 832 | return connection |
| 833 | |
| 834 | |
| 835 | def configure_preferences(default_binary_path=None): |
no test coverage detected