Extract metadata from RDMS using pythonCalling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonDifference between append vs. extend list methods in PythonHow can I safely create a nested directory in Python?Does Python have a ternary conditional operator?How to get the current time in PythonHow can I make a time delay in Python?Extracting extension from filename in PythonDoes Python have a string 'contains' substring method?
Meta programming: Declare a new struct on the fly
How can a jailer prevent the Forge Cleric's Artisan's Blessing from being used?
Can I create an upright 7-foot × 5-foot wall with the Minor Illusion spell?
How will losing mobility of one hand affect my career as a programmer?
Partial sums of primes
Identify a stage play about a VR experience in which participants are encouraged to simulate performing horrific activities
Indicating multiple different modes of speech (fantasy language or telepathy)
No idea how to draw this using tikz
Would it be legal for a US State to ban exports of a natural resource?
Should my PhD thesis be submitted under my legal name?
Word describing multiple paths to the same abstract outcome
What was required to accept "troll"?
How to deal with or prevent idle in the test team?
The most efficient algorithm to find all possible integer pairs which sum to a given integer
A workplace installs custom certificates on personal devices, can this be used to decrypt HTTPS traffic?
How to check participants in at events?
Giant Toughroad SLR 2 for 200 miles in two days, will it make it?
Freedom of speech and where it applies
Do all polymers contain either carbon or silicon?
Reply ‘no position’ while the job posting is still there (‘HiWi’ position in Germany)
Female=gender counterpart?
The One-Electron Universe postulate is true - what simple change can I make to change the whole universe?
Is a naturally all "male" species possible?
How do I rename a LINUX host without needing to reboot for the rename to take effect?
Extract metadata from RDMS using python
Calling an external command in PythonWhat are metaclasses in Python?Finding the index of an item given a list containing it in PythonDifference between append vs. extend list methods in PythonHow can I safely create a nested directory in Python?Does Python have a ternary conditional operator?How to get the current time in PythonHow can I make a time delay in Python?Extracting extension from filename in PythonDoes Python have a string 'contains' substring method?
I have a use-case where I've multiple RDMS data-sources and I want to extract the metadata from those data-sources. On the Basis of lookup user will select the data-source type and make the connection. After a successful connection, the tables and columns details will be populated.
As I'm a newbie with Python, I came with a solution to write code with conditional statements and make the connection accordingly. But I believe this is not the best and appropriate solution because for every new data-source I've to make the changes in code.
I'm looking for some ideas/suggestions through which I could archive some dynamic behavior. Like dialects available in ORM tools or some library which will execute the same query for all data-source types.
I appreciate your ideas/suggestions.
python python-3.x metadata python-2.x
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
add a comment |
I have a use-case where I've multiple RDMS data-sources and I want to extract the metadata from those data-sources. On the Basis of lookup user will select the data-source type and make the connection. After a successful connection, the tables and columns details will be populated.
As I'm a newbie with Python, I came with a solution to write code with conditional statements and make the connection accordingly. But I believe this is not the best and appropriate solution because for every new data-source I've to make the changes in code.
I'm looking for some ideas/suggestions through which I could archive some dynamic behavior. Like dialects available in ORM tools or some library which will execute the same query for all data-source types.
I appreciate your ideas/suggestions.
python python-3.x metadata python-2.x
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
1
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32
add a comment |
I have a use-case where I've multiple RDMS data-sources and I want to extract the metadata from those data-sources. On the Basis of lookup user will select the data-source type and make the connection. After a successful connection, the tables and columns details will be populated.
As I'm a newbie with Python, I came with a solution to write code with conditional statements and make the connection accordingly. But I believe this is not the best and appropriate solution because for every new data-source I've to make the changes in code.
I'm looking for some ideas/suggestions through which I could archive some dynamic behavior. Like dialects available in ORM tools or some library which will execute the same query for all data-source types.
I appreciate your ideas/suggestions.
python python-3.x metadata python-2.x
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
I have a use-case where I've multiple RDMS data-sources and I want to extract the metadata from those data-sources. On the Basis of lookup user will select the data-source type and make the connection. After a successful connection, the tables and columns details will be populated.
As I'm a newbie with Python, I came with a solution to write code with conditional statements and make the connection accordingly. But I believe this is not the best and appropriate solution because for every new data-source I've to make the changes in code.
I'm looking for some ideas/suggestions through which I could archive some dynamic behavior. Like dialects available in ORM tools or some library which will execute the same query for all data-source types.
I appreciate your ideas/suggestions.
python python-3.x metadata python-2.x
python python-3.x metadata python-2.x
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
edited Mar 8 at 13:07
Muneeb A.
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
asked Mar 8 at 8:20
Muneeb A.Muneeb A.
4801315
4801315
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
1
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32
add a comment |
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
1
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
1
1
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55059211%2fextract-metadata-from-rdms-using-python%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55059211%2fextract-metadata-from-rdms-using-python%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
If you show some skeleton code or pseudocode, people will be more inclined to help. Just posting a requirements dump then asking for package recommendations is considered off-topic. For example, your choice of GUI is separate and not relevant to this question.
– smci
Mar 8 at 10:20
@smci thanks for hitting me back, I'm currently looking for recommendations and best practices so that I would RnD that in right direction. The above mentioned is one of the use-case which we wanted to implement which is currently on papers.
– Muneeb A.
Mar 8 at 10:33
1
I'm trying to tell you your question is likely to get quickly downvoted and/or closed unless you show a little code/pseudocode. And remove the GUI mentions.
– smci
Mar 8 at 12:32