Dive Into Python

The odbchelper.py program and its output should now make perfect sense.

Example 1.38. odbchelper.py

def buildConnectionString(params):
 """Build a connection string from a dictionary of parameters.
 Returns string."""
 return ";".join(["%s=%s" % (k, v) for k, v in params.items()])
if __name__ == "__main__":
 myParams = {"server":"mpilgrim", \
 "database":"master", \
 "uid":"sa", \
 "pwd":"secret" \
 }
 print buildConnectionString(myParams)

Example 1.39. Output of odbchelper.py

server=mpilgrim;uid=sa;database=master;pwd=secret

Before diving into the next chapter, make sure you’re comfortable doing all of these things: