Skip to main content
Question

Change Database connection for a table via Python

  • October 5, 2020
  • 2 replies
  • 0 views
R
Level 6
Hi Team, I am currently working on auto-assignment of the DBConnection to the table all at once in the front end via the python code. But i am not getting any functions which can help me with that. I am able to connect to the datamodel, fetch the table ,table data and change the table names too. The only thing i am lacking is to change the DBConnection of everytable from python. I could analyze from the data of the table fetched via python that each DBConnection has their own DBConnectionID , but i am unable to change that ID from python. Please let me know if that change is possible, if so, how to do it. Thanks in advance.

2 replies

R
Level 6
  • rahul.bhat11
  • Author
  • Level 6
  • 21 replies
  • October 8, 2020
If someone is looking for the solution,its actually to use the i.data[store][dbConnectionId]=target.data[id] Where we find the target by looking through the results of target.database_connections (an instance of DatamodelTable ) to find a connection with the same name as the DBConnection used in the source table.
R
Level 6
  • rahul.bhat11
  • Author
  • Level 6
  • 21 replies
  • October 8, 2020
Thank you for the reply I have used your explanation in the above answer(for the people who are looking for this hint exactly) because thats what gave me the idea when i was going through your DEV to PROD topic,to change that is required and change the DBconnection and with one step further, the source table names corresponding to that DBConnection and syncronize the columns in a single shot for all the tables removing a lot of manual work . And Ofcourse thank you for the code this will help a lot Thank you.


Community Code of ConductAccessibility statement