Re: [Libreoffice] [PATCH] rpath / ... for extensions (and the case of PostgreSQL-SDBC)

On Mon, 2012-01-23 at 15:28 +0100, Lionel Elie Mamane wrote:
> On Mon, Jan 23, 2012 at 02:20:31PM +0100, Stephan Bergmann wrote:
> > On 01/23/2012 01:45 PM, Lionel Elie Mamane wrote:
>
> > > Users loose the feature to use a newer PostgreSQL-SDBC with an
> > > older LibreOffice. But Fridrich and you agree it fixes all our
> > > issues, so OK, I consent to it. I'm happy to let you and/or
> > > Fridrich do the change.
>
> > Doing it.  Lionel, do you have a recipe for database-dummies how to
> > actually test the postgresql-sdbc functionality?
>
> To really test it, you need a PostgreSQL server. However, you can do a
> very limited, but still meaningful, test without it:
>
>  - Menu: File / New / Database
>
>  - Connect to an existing database: PostgreSQL
>
>  - Next
>
>  - Datasource URL: host=localhost
>
>  - Next
>
>  - User name: blank
>
>  - Test connection -> the error message should be along the lines of:
>
>    Couldn't establish database connection to 'sdbc:postgresql:host=localhost'
>    could not connect to server: Connection refused
>    is the server running on host "localhost" (::1) and accepting
>    TCP/IP connections on port 5432?
>    could not connect to server: Connection refused
>    is the server running on host "localhost" (127.0.0.1) and accepting
>    TCP/IP connections on port 5432?
>
>    If you get any other error message (such as "no driver registered
>    for URL"), then there is something wrong with PostgreSQL-SDBC or
>    LibreOffice more generally. I you get the error message only with
>    127.0.0.1 and not with ::1, that's fine and not a problem.
>
>  - OK to click error message away
>
>  - next
>
>  - no, do not register the database
>
>  - uncheck "open the database for editing"
>
>  - finish
>
>  - choose a filename to save file to
>
>  - save
>
>  - close libreoffice
>
>  - open libreoffice again, open file you just created
>
>  - in the left part of the main screen, click "tables"
>
>    You should get the same error message as above with "test
>    connection". If not, it is a problem.
>
>
>
> As to installing a PostgreSQL server, rather easy on Debian GNU/Linux
> and probably most other distros. Make sure you get version 8.4 or
> later.
>
> aptitude install postgresql
> sudo -u postgres createdb -O $USER name_you_choose "$USER's test DB"
> psql --db name_you_choose
> CREATE TABLE "names" ( num serial, name varchar(30) NOT NULL, PRIMARY KEY (num) );
> # It says:
> # NOTICE:  CREATE TABLE will create implicit sequence "names_num_seq" for serial column 
> "names.num"
> # NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "names_pkey" for table "names"
> # CREATE TABLE
> INSERT INTO "names" (name) VALUES ('Alice'), ('Bob'), ('Eve'), ('Mallory');
> INSERT INTO "names" (num, name) VALUES (0, 'Nominem incognitum');
> \q
> #back to the shell
>
> Now, do as above in LibreOffice, except put:
>
> Datasource URL: host=localhost dbname=name_you_choose
> User name: Your UNIX username
> Do *not* check "needs password".
>
> You'll see in tables the "names" table. You can double-click on it and
> modify data, insert new data, delete row, etc.


There is a rather extensive test(s) that I've been building 

I put the very first nugget of it to the wiki a while back
http://wiki.documentfoundation.org/User:Drew/BaseRegTest001
have not kept the wiki up to date, but I have extended it quite a bit,
locally. 

Worked over the bug hunting weekend on it a goodly bit, nearly done with
Query designer tests, including the latest join problems.

These are not scriptable tests..but if I can get a daily build with the
update I'll do it all against pg and push the tests and results up to
the wiki ASAP.

//drew