17:00:16 #startmeeting tws 17:00:16 Meeting started Mon May 11 17:00:16 2015 UTC. The chair is colindixon. Information about MeetBot at http://ci.openstack.org/meetbot.html. 17:00:16 Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. 17:00:16 The meeting name has been set to 'tws' 17:00:22 #topic agenda bashing 17:01:01 #link https://wiki.opendaylight.org/index.php?title=Tech_Work_Stream:Main&oldid=30240#Upcoming_Meeting_Agendas today’s meeting will be Sharon covering how to figure out who’s using what schema fragments in the MD-SAL 17:01:14 #info the agenda is open for future meetings 17:06:20 #topic demo of how to use XSQL to query the MD-SAL for schema things 17:06:24 #undo 17:06:24 Removing item from minutes: 17:06:26 #topic background 17:06:48 #info Sharon basically says XSQL is trying to provide an easier XSQL interface on top of the MD-SAL 17:08:28 #info he says that until a month ago, it was very buggy, but there’s been a lot of work in the last month to make it more real 17:08:58 #info it basically shows each MD-SAL schema level as an SQL table 17:09:34 #info shows “list vfields nodes/node/table/flow” which shosw shte proprties of a flow 17:10:25 #info shows “select * from nodes/node;” and gets the list of the nodes 17:11:36 #info shows a simple query builder where you can get control-space context-senseitive auto-completion for writing queries which is really pretty cool 17:12:33 any thoughts about making the query builder web based and part of the ODL distribution? 17:12:46 dbainbri: good question 17:12:48 feel free to speak up 17:12:54 or I can when there’s a lull 17:15:11 #info dbainbri asks if there is a plan to turn this into a web-based tool and release it as part of the normal distribution 17:17:03 #info Sharon says that he couldn’t get it to work the web-based thing and the REST RPC call for some reason and so he fell back to making a Java/swing app 17:17:32 #topic demo of working with Pentaho Report Designer 17:17:38 very cool!!! 17:18:24 #info shows how to generate reports including PDF output 17:18:42 #topic binding aware code 17:19:12 #info the big new feature is that you can do an XSQL query and then get back the BindingAware java objects directly 17:19:18 don't want to interrupt flow of demo, any plans to get this to work with the time series work as well? 17:19:49 #info shows ToasterProviderModule in org.opendaylight.controller.config.yang.config.toaster_provider.impl 17:22:02 * colindixon adds dbainbri’s question to his mental queue 17:23:22 #info you should be able to produce an instance identifier from the results to be able to do get where it actually is in the backing store 17:23:25 pretty cool 17:23:56 or really any metric data queries might be able to mine some pretty useful information and or make pretty charts 17:25:25 #info dbainbri asks if you can also query TSDR, the answers is not right now, but it’s doable 17:27:23 #info currently when it gets the data, it does full table scans which is potentially slow 17:28:10 #info Sharon has been thinking about how to construct indices and make things faster, Sharon says he could use help here 17:29:36 #link https://lists.opendaylight.org/pipermail/controller-dev/2015-May/009214.html Sharon’s request for help 17:31:40 https://wiki.opendaylight.org/view/InternProjects:Main 17:32:26 #topic forums to get help 17:34:10 We might get better attendance if we quit using the "No TWS meeting today" subject in subsequent meeting announcements 17:36:52 #info colindixon points out that calls for help sent to controller-dev, which is somewhat of a black hole these days 17:39:10 #info figuring out how to bring topics up that have broad interest is hard and something we’re bad at as a community 17:39:21 #info the TSC call and TWS call are good for things that need to be a discussion 17:39:41 #action colindixon says he’ll bring up the topic of XSQL help at the TSC meeting on Thursday 17:40:02 #action dbainbri to bring a few slides around threading modules, load balancing, etc. for next week 17:40:25 #topic can you query who uses a given grouping (the original question)? 17:40:33 #info the answer is not yet, but it shoudl be doable 17:44:05 #topic security in ODL 17:44:22 #Info Sharon asks about security in ODL and gets a bunch of pointers 17:56:58 colindixon: I think we didn't do #endmeeting yet. (I'm not sure if I have the right to do #endmeeting.) 17:57:08 #endmeeting