I am currently working on a Python CherryPy controller that needs to validate a database URL by attempting a connection. However, I am facing challenges with passing the parameter to the method. Below is my AJAX call:
$.ajax({ async: false,
type: 'POST',
url: "/settings/check_db_url/" + db_url ,
success: function(r) { alert(r) },
error: function(r) { alert('failure') }
});
The URLs that need to be tested have formats like:
'sqlite':'sqlite:///Users/Home/tvb-database.db' or
'postgresql+psycopg2://postgres:<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="c6b4a9a9b286f7f4f1e8f6e8f6e8f7">[email protected]</a>:5432/tvb?user=postgres&password=postgres'
For the sqlite part, I was able to handle it by splitting and joining the URL in a specific way, but it feels like a hacky solution. For the postgres part, I anticipate needing more replacements. Can anyone suggest a better approach for this scenario?