Python Tutorial: Sending SQL to an access database

Example shown: the creation of a users Home folder and user information insertion into multiple databases

Python new user example:

Ok so what is going on, first we open by importing our fuctions, in this case we need the ODBC module to talk to our database. pprint to format our ouput. Next we set our first variable, the new users full name. Now we set the users "Username" since in this example we assume that we use users u-name as part of the email address and also that the home folder is the user name. Now that we have the base information we create our first variable, the email address. In this case as mentioned above we are setting it to the "user" user name and the email domain. Next we need to open the ODBC connection to the database. In a windows enviroment you would have created the DSN previously by using the ODBC admin tool. In this example we set our DSN name "database-name" and the coresponding password "databasepassword". Next using the cursor function we insert our SQL variable. This process is repeated below in the 2nd database. Last we make a new vairable that is the path to the users home folder. Note that for Python to draw a "\" on screen you must enter it as "\\" in your code, other wise Python will think you are tring to pass a command.

Python Tutorial: Sending a command to Maya from Python

Example shown: Allow a text input variable to be passed to Maya

Prior to starting, you will need to opena port on Maya to allow commands to be sent. This can be done done in one of two ways. Copy (Right click and choose save) this script to your Maya scripts Start up directory.

Windows: :\Documents and Settings\\My Documents\maya\\scripts
Mac: ~/Library/Preferences/Alias/maya//scripts.
IRIX/Linux: ~/maya//scripts.

or you can create your own script using the following command to open the port and save the script as userSetup.mel

Python Passing Text:

You may be saying, big deal, you can send a message in maya. Well, think about some of the broader implications. In this example we sent text, but you could also pass things like scenes, render commands, Custom Mel scripts accross an entire network etc.