dbGet and playing with the database

I like your solution, Kari!  Very clever- I wouldn't have thought to leverage windowSelect like that- especially for rows.

Here's how I would have gone about it, given the interest in getting the pointers for the rows with a certain filter criteria, and then querying coordinates about each row:

set rowList {}
foreach row [dbGet top.fplan.rows] {
  set box [dbGet $row.box]
  set lly [lindex [lindex $box 0] 1]
  if {$lly > 500 && $lly < 600} {
    lappend rowList $row
  }
}

foreach row $rowList {
  set box [dbGet $row.box]
  Puts "Top Y: [lindex [lindex $box 0] 3] Bottom Y: [lindex [lindex $box 0] 1]"
}

A couple of points of information I'd like to add:

1. As you can see, it's a tad clunky to decompose a box in dbGet currently (with two lindex statements). In older style FE-TCL terms, we used commands like "dbBoxLLX" to get the lower left x coordinate of a box.  However, these functions don't work within dbGet since they support only database units and not microns. We've talked about having a similar processing command for dbGet usage but I don't recall whether that has come to fruition. I'll check and see.
   
2. dbGet's filtering mechanism doesn't work with fixed point numbers in 8.1.RTM. By that I mean, you can filter on an instance name "dbGet top.inst.name *i_9371" but you can't filter on numbers like this: "dbGet top.nets.numInputTerms 15".  This is something we're working on enhancing as part of a push for more sophisticated filtering in dbGet (for example, collecting all high fanout nets with "dbGet top.nets.numInputTerms > 15" could be useful).

Hope this helps,
Bob

I like your solution, Kari!  Very clever- I wouldn't have thought to leverage windowSelect like that- especially for rows.

Here's how I would have gone about it, given the interest in getting the pointers for the rows with a certain filter criteria, and then querying coordinates about each row:

set rowList {}
foreach row [dbGet top.fplan.rows] {
  set box [dbGet $row.box]
  set lly [lindex [lindex $box 0] 1]
  if {$lly > 500 && $lly < 600} {
    lappend rowList $row
  }
}

foreach row $rowList {
  set box [dbGet $row.box]
  Puts "Top Y: [lindex [lindex $box 0] 3] Bottom Y: [lindex [lindex $box 0] 1]"
}

A couple of points of information I'd like to add:

1. As you can see, it's a tad clunky to decompose a box in dbGet currently (with two lindex statements). In older style FE-TCL terms, we used commands like "dbBoxLLX" to get the lower left x coordinate of a box.  However, these functions don't work within dbGet since they support only database units and not microns. We've talked about having a similar processing command for dbGet usage but I don't recall whether that has come to fruition. I'll check and see.
   
2. dbGet's filtering mechanism doesn't work with fixed point numbers in 8.1.RTM. By that I mean, you can filter on an instance name "dbGet top.inst.name *i_9371" but you can't filter on numbers like this: "dbGet top.nets.numInputTerms 15".  This is something we're working on enhancing as part of a push for more sophisticated filtering in dbGet (for example, collecting all high fanout nets with "dbGet top.nets.numInputTerms > 15" could be useful).

Hope this helps,
Bob