PostgreSQl guinea pig wanted

[barand]

I've been working on a datagrid class that I want to work with MySQL, ODBC and Postgresql, these being the most common.

I've tested on the first two, but I do not have access to a pg database to test out the pg functions (only about 5 of them).

Are there any volunteers out there who could give my class a test run with a postgresql database?

[Sxooter]

Sure...

[barand]

Thank you very much, Sxooter.

There's a couple of lines at the begginning of the file you'll need to edit for connection details etc.

Any probs, let me know.

[barand]

Is there anyone else who can help here?

You can download latest version of the datagrid class from here

TIA

[Sxooter]

Hi barand. Finally got a minute to test this (I've been swamped getting a project off the ground at work lately...)

First report, is on the tutorial. Postgresql pukes on int(11) and double, but accepts plain int and float. Unless int and float would break the tutorial for MySQL, I'd recommend changing them.

Back in a minute to add more...

OK. I got it installed, and connected to postgresql with my server. I'm getting these errors in the first tutorial:

This one repeats 3 times:
Notice: Undefined offset: -1 in /usr/local/lib/php/baaGrid.php on line 490
Line 490 is:

      function _padWithLast(&$a, $n) {
-> This line               $val = $a[count($a)-1];
               $a = array_pad($a, $n, $val);
               return;
      }

This one repeats about a 100 times:
Notice: Undefined offset: 0 in /usr/local/lib/php/baaGrid.php on line 367
And the number goes 0,1,2,3 and repeats over and over.
line 367 is:

                      for ($i=0; $i<$this->fieldCount; $i++) {
                           $atxt = array();
                           $stxt = '';
-> This line            if ($this->align[$i]) {
                                   $atxt[] = "text-align: {$this->align[$i]}";
                               }

OK, some more output as well..

Next error after these:
Warning: pg_fetch_row(): Unable to jump to row 18 on PostgreSQL result index 4. in /usr/local/lib/php/baaGrid.php on line 293

then inside the table I get:

Notice: Undefined offset: 1 in /usr/local/lib/php/baaGrid.php on line 390

where the offset goes to 2 then 3 as we go across, then starts over. This is in the locname, qty, and value fields. But the output is still there.

[Sxooter]

Versions:

OS: RedHat 7.2
Apache 1.3.28
PHP 4.3.2
Postgresql 7.4 beta1

[Sxooter]

Bugs found and fixed:

Changed these lines:

        function display() {
               if ($this->cursor = $this->_query()) {
                   $this->_getFieldNames($farray,$fcount);
                   $this->fieldCount = $fcount;
# Added the "&& $this->headClass"
                   if (isset($this->headClass) && $this->headClass)
                       $this->_padWithLast($this->headClass,$fcount);
# Added the "&& $this->totClass"
                   if (isset($this->totClass) && $this->totClass)
                       $this->_padWithLast($this->totClass,$fcount);
# Added the "&& $this->subtotClass"
                   if (isset($this->subTotClass) && $this->subTotClass)
                       $this->_padWithLast($this->subTotClass,$fcount);
                   if ($this->classMode=='C')
                       $this->_padWithLast($this->colClass,$fcount);
                   $this->_chkHeads($farray,$fcount);
                   echo "\n<table $this->tableAttr >\n";
                   $this->_printHeadings();
                   $this->_printData();
                   if (count($this->totals) > 0)
                       $this->_printTotals();
                   echo "\n</table>\n";
               }
               return;
      }

[Sxooter]

Next, around line 333 I was getting unknown offset on a line, changed it like this:

      function _printHeadings() {
                   echo "\n<tr>\n";
                   for ($c = 0; $c < $this->fieldCount; $c++) {
                        echo "<th";
   # Changed to an isset on this one, since newer versions of 
   #PHP don't like testing non-existant vars.
                        if (isset($this->headClass[$c])) echo " class=\"{$this->headClass[$c]}\"";
                        echo ">";
                        echo "{$this->heads[$c]}</th>\n";
                   }
                   echo "\n</tr>\n";

           return;

  }

[Sxooter]

I looked up the double thing, it appears there are three SQL 89/92 names for non-precision numbers, they are: float, real, and double precision

It appears double is a MySQL shorthand for double precision, so changing the entry to double precision would work for both in the data declaration section.

The SQL spec explicitly does NOT allow precision for int, integer or smallint, the three standard int types it defines, so the int(11) thing should probably just be changed to int for portability / sql spec etc...

[barand]

Thanks for all that , Sxooter. I'll get the changes incorporated in the version on my site this weekend.

[Sxooter]

Originally posted by barand
Thanks for all that , Sxooter. I'll get the changes incorporated in the version on my site this weekend.

Please note that I somehow posted my last response in this thread in another thread (brain fart...) It's here:

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10253446

[barand]

Your changes now incorporated. Latest version, including cross-tab (pivot table) functionality at

here and also User guide

Thanks again