problems with syncing Python, XML and MySQL

Posted on 2007-10-21
Last Modified: 2012-06-27
Need of Help!

I have some experience in programming with C#, Java, SQL on Windows.
This is the first time I have to program in Python on Linux (Gutsy Gibbon) OS.
My task is to write middle ware for a small project. The front-end will spit XML to the middle ware, which needs to be traversed and then inserted in to the MySQL database base (on Apache Server). This process is suppose to flow back and forth from the DB to the front-end and Front-end to the DB.
I am very much confused by the concept of Python Modules (.py files) and Python Classes and the fact that everything in Python is an object. Due to this I am not able to think of how I should write this middle ware in Python. I have been able to work with minidom for XML parsing and I have been able to work woth MySQL and Python separately..
But, how this all will work together is something of a blank!
Whether I should write classes in Python or just write Modules(.py) files with functions in it is my biggest question.
I will appreciate if someone can please give me a idea of what approach should I use and  it would be great if someone has some basic sample code which achieves this.
I got some idea from this article but its still not clear:
Please help me out!!  
Question by:deersuper
    LVL 15

    Expert Comment

    You should read "Dive into Python" ( first.
    LVL 2

    Author Comment

    Thanks Mish,

    I have already read Dive into Python. Any other suggestions?
    LVL 17

    Expert Comment

    I suggest, before trying to write program(s) (in any language) that we focus on the analysis and design. I for one could not begin to answer your questions without a good analysis/design.

    Do you have you analysis/design skills? Access to analysis/design tools?
    LVL 2

    Author Comment

    hey ramrom,

    u are right about analysis and design. I have experience with that alot but can't find someone who knows Python in terms of teaching me the flow.

    can u suggest a good book or tutorial, where I can see actual developed code in python from start to end?
    LVL 17

    Accepted Solution

    Take a look at

    If you want more help here please post your design.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This article will show the steps for installing Python on Ubuntu Operating System. I have created a virtual machine with Ubuntu Operating system 8.10 and this installing process also works with upgraded version of Ubuntu OS. For installing Py…
    A set of related code is known to be a Module, it helps us to organize our code logically which is much easier for us to understand and use it. Module is an object with arbitrarily named attributes which can be used in binding and referencing. …
    Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
    Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now