Caiman at 21:06, 28 February 2010

2010-02-28T21:06:10Z

←Older revision		Revision as of 21:06, 28 February 2010
Line 1:		Line 1:
	This script needs to be placed in /var/www/lmce-ws/index.rb		This script needs to be placed in /var/www/lmce-ws/index.rb

	<~~nowiki~~>		<pre>

	#!/usr/bin/ruby		#!/usr/bin/ruby
Line 78:		Line 78:


	</~~nowiki~~>		</pre>

Caiman: New page: This script needs to be placed in /var/www/lmce-ws/index.rb #!/usr/bin/ruby require 'rubygems' require 'json' require 'cgi' require 'mysql' def hashresult(query) # Execute SQL...

2010-02-28T21:04:59Z

New page: This script needs to be placed in /var/www/lmce-ws/index.rb <nowiki> #!/usr/bin/ruby require 'rubygems' require 'json' require 'cgi' require 'mysql' def hashresult(query) # Execute SQL...

New page

This script needs to be placed in /var/www/lmce-ws/index.rb

<nowiki>

#!/usr/bin/ruby

require 'rubygems'
require 'json'
require 'cgi'
require 'mysql'

def hashresult(query)
# Execute SQL query and return result as an array, one entry per row
# setup sql database
db = Mysql.new("localhost", "root", "")
db.select_db("pluto_main")

result = db.query(query)
arr = Array.new
#result.each_hash(with_table=true) do |row|
result.each do |row|
arr << row
end
return arr
end

def getlights()
# return list of lights (devices with (DeviceTemplate.FK_DeviceCategory = 73)
query = "SELECT Device.PK_Device, Device.Description, Device.State, Device.FK_Room FROM Device,DeviceTemplate WHERE (Device.FK_DeviceTemplate = DeviceTemplate.PK_DeviceTemplate) AND (DeviceTemplate.FK_DeviceCategory = 73) ORDER BY PK_Device ASC"
return hashresult(query)
end

def getrooms()
# return list of all rooms
query = "SELECT Room.PK_Room, Room.Description FROM Room ORDER BY Room.Description ASC"
return hashresult(query)
end

def getscenarios()
query = "SELECT CommandGroup.PK_CommandGroup, CommandGroup.Description, CommandGroup.Hint, CommandGroup.FK_Template, CommandGroup_Room.FK_Room
FROM CommandGroup, CommandGroup_Room
WHERE (CommandGroup_Room.FK_CommandGroup = CommandGroup.PK_CommandGroup)
ORDER BY Sort ASC;"
return hashresult(query)
end

def gettemplates()
query = "
SELECT PK_Template, Description
FROM Template
;"
return hashresult(query)
end

def sendcommand(id,command)
return `/usr/pluto/bin/MessageSend localhost 0 #{id} 1 #{command}`
end

# Send header to http client
puts "Content-type: text/html\r\n\r\n"
#puts "Content-type: application/json\r\n\r\n"

# Process CGI arguments
c=CGI.new
cmd=c['cmd']

return_obj = case cmd
when 'getLights' then getlights()
when 'getRooms' then getrooms()
when 'getScenarios' then getscenarios()
when 'getTemplates' then gettemplates()
when 'sendCommand' then sendcommand(c['id'], c['command'])
else "use cmd=xxx where xxx is getLights, getRooms, getScenarios, getTemplates"
end

# Send the return object as JSON
puts return_obj.to_json

</nowiki>

WebServiceSource - Revision history

Caiman at 21:06, 28 February 2010

Caiman: New page: This script needs to be placed in /var/www/lmce-ws/index.rb #!/usr/bin/ruby require 'rubygems' require 'json' require 'cgi' require 'mysql' def hashresult(query) # Execute SQL...