Skip to content
Snippets Groups Projects
  • Tilghman Lesher's avatar
    52dbebad
    Add DB_KEYS. · 52dbebad
    Tilghman Lesher authored
    Discussion on #asterisk on 2011-01-19:
    (02:07:03 PM) boch: i wonder how to cycle all entries in a tree
    (02:07:11 PM) leifmadsen: use While()
    (02:07:17 PM) leifmadsen: you need to know the tree structure already though
    (02:07:36 PM) boch: what you mean?
    (02:09:02 PM) leifmadsen: you need to know the structure prior to looping, because you can't just return the structure from the dialplan
    (02:09:43 PM) leifmadsen: the only way I can think of doing that is via something like writing the output of:  asterisk -rx "database show" to a file, then looping through that to know the structure of the database and check everything
    (02:09:59 PM) leifmadsen: but at that point you're better off just using either a relational database or an external script
    (02:10:13 PM) boch: for example i need to know all entries in the tree
    (02:10:15 PM) boch: got it
    (02:10:20 PM) leifmadsen: exactly
    (02:10:22 PM) leifmadsen: that's the problem
    (02:10:22 PM) boch: thank you
    (02:13:09 PM) mateu: yeah, i'm surprised there isn't something from the dialplan like 'database show family' so one can get all keys in a family to loop over.
    (02:15:35 PM) leifmadsen: database shows everything
    (02:16:22 PM) mateu: i mean something from the dial plan that mimics 'database show <family>'
    (02:16:41 PM) leifmadsen: guess no one has found that important enough to program :)
    (02:16:52 PM) leifmadsen: at that point you should probably just use a relational database...
    (02:17:10 PM) mateu: i dunno
    (02:17:16 PM) mateu: seems pretty basic to me.
    (02:17:16 PM) leifmadsen: me either
    (02:17:19 PM) leifmadsen: sure does
    (02:17:24 PM) leifmadsen: no one has programmed it though
    (02:17:28 PM) ***leifmadsen shrugs
    (02:17:43 PM) mateu: ok, well at least we know how it currently stands.  thanks leifmadsen
    (02:28:52 PM) Corydon76-home: leifmadsen: something like HASHKEYS() ?
    (02:30:11 PM) leifmadsen: Corydon76-home: ummm, I was thinking more like DUNDI_QUERY() and DUNDI_RESULT()
    (02:30:31 PM) leifmadsen: although HASHKEYS() might work
    (02:30:58 PM) leifmadsen: actually ya, looking at it, similar to HASHKEYS()
    (02:31:01 PM) leifmadsen: DBKEYS() I guess?
    (02:31:45 PM) Corydon76-home: So with no argument, retrieves families, with an argument, retrieves keys of that family?
    (02:34:02 PM) leifmadsen: ya
    (02:34:16 PM) leifmadsen: how would you iterate through layers of them?
    (02:34:30 PM) leifmadsen: i.e. family/key/key/key ?
    (02:34:43 PM) Corydon76-home: Essentially, yes
    
    
    git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@303198 65c4cc65-6c06-0410-ace0-fbb531ad65f3
    52dbebad
    History
    Add DB_KEYS.
    Tilghman Lesher authored
    Discussion on #asterisk on 2011-01-19:
    (02:07:03 PM) boch: i wonder how to cycle all entries in a tree
    (02:07:11 PM) leifmadsen: use While()
    (02:07:17 PM) leifmadsen: you need to know the tree structure already though
    (02:07:36 PM) boch: what you mean?
    (02:09:02 PM) leifmadsen: you need to know the structure prior to looping, because you can't just return the structure from the dialplan
    (02:09:43 PM) leifmadsen: the only way I can think of doing that is via something like writing the output of:  asterisk -rx "database show" to a file, then looping through that to know the structure of the database and check everything
    (02:09:59 PM) leifmadsen: but at that point you're better off just using either a relational database or an external script
    (02:10:13 PM) boch: for example i need to know all entries in the tree
    (02:10:15 PM) boch: got it
    (02:10:20 PM) leifmadsen: exactly
    (02:10:22 PM) leifmadsen: that's the problem
    (02:10:22 PM) boch: thank you
    (02:13:09 PM) mateu: yeah, i'm surprised there isn't something from the dialplan like 'database show family' so one can get all keys in a family to loop over.
    (02:15:35 PM) leifmadsen: database shows everything
    (02:16:22 PM) mateu: i mean something from the dial plan that mimics 'database show <family>'
    (02:16:41 PM) leifmadsen: guess no one has found that important enough to program :)
    (02:16:52 PM) leifmadsen: at that point you should probably just use a relational database...
    (02:17:10 PM) mateu: i dunno
    (02:17:16 PM) mateu: seems pretty basic to me.
    (02:17:16 PM) leifmadsen: me either
    (02:17:19 PM) leifmadsen: sure does
    (02:17:24 PM) leifmadsen: no one has programmed it though
    (02:17:28 PM) ***leifmadsen shrugs
    (02:17:43 PM) mateu: ok, well at least we know how it currently stands.  thanks leifmadsen
    (02:28:52 PM) Corydon76-home: leifmadsen: something like HASHKEYS() ?
    (02:30:11 PM) leifmadsen: Corydon76-home: ummm, I was thinking more like DUNDI_QUERY() and DUNDI_RESULT()
    (02:30:31 PM) leifmadsen: although HASHKEYS() might work
    (02:30:58 PM) leifmadsen: actually ya, looking at it, similar to HASHKEYS()
    (02:31:01 PM) leifmadsen: DBKEYS() I guess?
    (02:31:45 PM) Corydon76-home: So with no argument, retrieves families, with an argument, retrieves keys of that family?
    (02:34:02 PM) leifmadsen: ya
    (02:34:16 PM) leifmadsen: how would you iterate through layers of them?
    (02:34:30 PM) leifmadsen: i.e. family/key/key/key ?
    (02:34:43 PM) Corydon76-home: Essentially, yes
    
    
    git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@303198 65c4cc65-6c06-0410-ace0-fbb531ad65f3
To find the state of this project's repository at the time of any of these versions, check out the tags.