Thread: [Web-erp-developers] Download manager

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

I need to try one of these things.

Which one do you use?

The work around sounds good.

Phil

There are quite a few options to the command line utility mysqldump that may
be of use in creating the db sql in the format you require.

I will try Kget in Konqueror

Phil
----- Original Message -----
From: "Danie Brink" <br...@na...>
To: "Phil Daintree" <p.d...@pa...>
Sent: Wednesday, February 25, 2004 9:12 AM
Subject: Re: [Web-erp-developers] Download manager

> On Wed, 2004-02-25 at 09:49, Daintree wrote:
> I use KGet, integrated into Konqueror.
>
> KGet integrates directly into, it can be disabled through KGet's
> settings/preferences.
>
> I am wondering whether a redirect would also be needed on posts, not
> sure!!
>
> P.S. Re:Database
>
> Made the basic modification to access Postgres. I am currently in the
> process of writing a small python SQL translator that can take a MySQL
> export, as provided through phpMyAdmin, and convert it to PGSQL for
> import. This will include the data/inserts but not the aditional indexes
> for now. This will also therefore allow us to scale a client from MySQL
> to Postgres if a bigger database is required at a later stage.
>
> Problems resolved so far :
>
> 1 ) request of last inserted id (DB_Last_Inser_ID(&$Conn)), required two
> extra parameters, table, and ID field, these are not used under MySQL,
> but is needed for Postgres, they are therefore enforced, new parameters
> looks as follows, DB_Last_Inser_ID(&$Conn,$table, $fieldname ). This is
> because postgres needs to exec a query like "Select Max(field) from
> tabel" in order to get the last ID, I have not yet resolved the issue of
> Transaction, as is required, will implement as soon as possible. Needs a
> bit more work.
>
> Kind Regards
> Danie Brink br...@na...
>
>
> > I need to try one of these things.
> >
> > Which one do you use?
> >
> > The work around sounds good.
> >
> > Phil
> >
> >
> > -------------------------------------------------------
> > SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> > Build and deploy apps & Web services for Linux with
> > a free DVD software kit from IBM. Click Now!
> > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>

Hi Danie,

I have been mucking about with Konqueror and Kget and cant duplicate this 
behaviour.

Are you using the demo on sourceforge or some remote machine or is it all 
local to your LAN. Could it be that the connection was broken for whatever 
reason and kget had to start another download?

Most folks here use windows anyway so I suspect your configuration would no be 
the norm. Mozillia has an inbuilt download manager which I use all the time 
with no worries - Opera too.

I would love to duplicate this problem!

>
> 1 ) request of last inserted id (DB_Last_Inser_ID(&$Conn)), required two
> extra parameters, table, and ID field, these are not used under MySQL,
> but is needed for Postgres, they are therefore enforced, new parameters
> looks as follows, DB_Last_Inser_ID(&$Conn,$table, $fieldname ). This is
> because postgres needs to exec a query like "Select Max(field) from
> tabel" in order to get the last ID, I have not yet resolved the issue of

Last_Insert_ID is used in I think 2 maybe 3 places it maybe there is a better 
work around in these three instances than re-writing the code in 
ConnectDB.inc - the code will need to be re-written anyway because of the 
extra parameters required. Since LastInsertID is mysql specific I'd rather do 
away with it in the interests of compatibility.

> Transaction, as is required, will implement as soon as possible. Needs a
> bit more work.

I thought:

begin

rollback

and 

commit 

were standard ANSI SQL - these are used everywhere and would prevent quite a 
snag if they need to be re-written.

Phil

I use SuSE 8.2
I see what you mean about select max when the transaction has incremented
the autonumber column.It would be nicer to retrieve this ID from the detail
table after the insert. However, I just did a search and discovered. ...

pg_last_oid
(PHP 4 >= 4.2.0)

pg_last_oid -- Returns the last object's oid
Description
int pg_last_oid ( resource result)

pg_last_oid() is used to retrieve the oid assigned to an inserted tuple
(record) if the result resource is used from the last command sent via
pg_query() and was an SQL INSERT. Returns a positive integer if there was a
valid oid. It returns FALSE if an error occurs or the last command sent via
pg_query() was not an INSERT or INSERT is failed.

OID field became an optional field from PostgreSQL 7.2. When OID field is
not defined in a table, programmer must use pg_result_status() to check if
record is is inserted successfully or not.

  Note: This function used to be called pg_getlastoid().

See also pg_query() and pg_result_status()

> >
> Yes, standard transacting is supported, however it using "select max" is
> still a clutch for now, I will replace it with looking up the current
> generator/autonumber value which is guaranteed to be correct in a
> transaction on a per connection basis. The changes to
> DB_LastInsertID is already done, and MySQL still runs without a hitch.
>
> I am busy finalizing the converter to calculate the generator/autonumber
> for setting it at the end of the script. So far everything imports.
>
> I would like to test it in the sql with the foreign keys included.
> I use > mysqldump -u root -c -Q weberp18 >./weberp.sql
>
> Danie
>

Thread: [Web-erp-developers] Download manager

Accounting & Best Practice Business Administration System

web-erp-developers