# Introduction to IronPython and the CLR

# Standard first Python console command
2 + 2

# Create a string
s = 'Hello IronPython'

# Inspect its methods, note that its only Python methods.  
dir(s)

# Python has a method to make the text uppercase
s.upper()

# Import the CLR
import clr

# Now look at the same objects methods,
# We now see the .NET string methods!
dir(s)

# And can use them!
s.ToUpper()

import clr

# Create a WebClient and download a string of XML
from System.Net import WebClient
w = WebClient()
xml = w.DownloadString('http://feeds.theage.com.au/rssheadlines/technology.xml')

# Lets have a look at first 60 characters of the xml..
print xml[0:60]

# If bad stuff happens in the presentation..
#xml = open('theage.rss').read()

# Deserialize to objects using xml2py
from devhawk import xml2py
rss = xml2py.parseString(xml)

# Print the results
for post in rss.channel.item:
  print post.pubDate, post.title 

# Import Speech  
clr.AddReference('System.Speech')
from System.Speech import *
ss = Synthesis.SpeechSynthesizer()

# Say titles and dates using the SpeechSynthesizer 
for post in rss.channel.item:
  s = "%s. %s." % (post.pubDate[:16], post.title)
  ss.SpeakAsync(s)

# import a simple wrapper around System.Data.SqlClient  
# the wrapper is on my blog, I just wanted to show the AdventureWorks 
# database, it seems a bit of .NET presentation tradition. 
from demo import sql

# setup a query on the AdventureWords database
query = 'SELECT * FROM Production.Product'
sql.connection = 'Data Source=localhost\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=SSPI;'

# execute the query
products = sql.SqlQuery(query)

# print some results
for p in products[:5]:
  print p.Name

# More pythonic way of getting the feed.. lets hope I have internet
from devhawk import xml2py
rss = xml2py.parse('http://feeds.theage.com.au/rssheadlines/technology.xml')

# Importing avalon starts a new thread to run the WPF application
# It sets up some dispatures so the console can talk to the GUI 
from samples import avalon

# Create a window, show it and load some XAML into it
w = avalon.Window()
w.Show()
xaml = avalon.LoadXaml('demo.xaml')
w.Content = xaml

# Loading names is really cool, it traverses the control tree 
# described in the XAML and creates a dictionary of names and 
# controls. We can add those dictionary items to the local scope,
# so we get the same effect as a generated designer files in
# Visual Studio. 
avalon.LoadNames(xaml,locals())

# We can bind a Python list of Python objects to the ListView
listView.ItemsSource = rss.channel.item

# Create a button click callback that will execute the script
# in the query TextBox.
def OnClick(*args):
  try:
    exec (query.Text)
  except:
    print "Script threw an exception"
  pass  

# Wire up the click event to our function  
execute.Click += OnClick
  
# We can now execute this on the client  
listView.ItemsSource = [p for p in rss.channel.item if p.title.find('to') >= 0]