NAME

elive_query

SYNOPSIS

elive_query   http://myserver.com/my-site[:port]

  -user someuser          # SDK/SOAP username
  -pass somepass          # SDK/SOAP password
  -c 'select ....'        # execute command(s), then exit
  -debug=n                # 1=some, 2=verbose, 3=verbose + soap
  -dump=yaml              # serialise results as YAML
  -? -help                # obtain help
  -v -version             # print Elive version
  -adapter type           # E.g. -adapter standardv2 (Elive::StandardV2)

DESCRIPTION

Simple read-only query shell/REPL for Elive.

Entity Data Queries

This example script lets you do simple queries, in a vaguely SQL like manner. For example:

% elive_query -user admin http://myserver.com/mysite
Password: ********
connecting to http://myserver.com/mysite...ok
Elive query ... (Elluminate Live! ...)  (c) ... - type 'help' for help

elive> select loginName,email,firstName,lastName,role from user where loginName like *m* 
loginName   |email                 |firstName|lastName   |role
------------|----------------------|---------|-----------|----
mr_miyagi   |mr_miyagi@hotmail.com |Pups     |Miyagi     |3
sthrogmorton|sthrogmorton@gmail.com|Sebastion|Throgmorton|2

elive>

Describing Entities

You can also use this script to describe Elive entity structures:

elive> describe
usage: describe group|meeting|meetingParameters|participantList|preload|recording|serverDetails|serverParameters|user

elive> describe meeting
meeting: Elive::Entity::Meeting:
meetingId         : pkey Int        
deleted           : Bool
end               : HiResDate    -- meeting end time
facilitatorId     : Str          -- userId of facilitator
name              : Str          -- meeting name
password          : Str          -- meeting password
privateMeeting    : Bool         -- don't display meeting in public schedule
start             : HiResDate    -- meeting start time

elive> 

SEE ALSO

perldoc Elive http://search.cpan.org/dist/Elive/