Re: Autosave in the SQL Editor - Mailing list pgadmin-hackers

From Guillaume Lelarge
Subject Re: Autosave in the SQL Editor
Date
Msg-id 1344409197.1964.48.camel@localhost.localdomain
Whole thread Raw
In response to Re: Autosave in the SQL Editor  (Vinicius Santos <vinicius.santos.lista@gmail.com>)
Responses Re: Autosave in the SQL Editor  (Vinicius Santos <vinicius.santos.lista@gmail.com>)
List pgadmin-hackers
On Tue, 2012-08-07 at 18:20 -0300, Vinicius Santos wrote:
>
>
>         Well, this seems good but there's an issue I don't know how
>         you want to
>         deal with it: what's happens if I had more than one window
>         opened?
>
> I'm saving a file for each window.
> Each window have a private variable called "fileNameAutoSave"
>
> The query is salved from time-to-time. As configuration.

OK.

>
>         IOW,
>         how do you decide which file you should open? if there is more
>         than one
>         file, and some files were open on different databases, how
>         will you
>         handle this?
>
> I had thought about putting the information in the file name. For
> example: "server_port_database_date_time.pga".

Where is it saved?

You also need to have a way to delete those files.

> The date and time are saved in the creation of frmQuery.
>
> We can save it in the file header too. We put this information in the
> first line. And we put another name for the file.
>

Yeah, I think the informations should be available in the file (for
example if your database has a _ in its name, it will be hard to decode
the informations from the filename.

> When there are more than one file, we asked for user, if he wants to
> open all of them.
> Of course we will open only the files that database.
>
> What do you think?
>

Should be enough. Not sure how you'll open that many query tools though.

> PS: Forgive my English. I'm learning english, and I'm using a little
> the Google Translate.

No problem, don't worry :) I'm also not a native speaker.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


pgadmin-hackers by date:

Previous
From: Vinicius Santos
Date:
Subject: Re: Autosave in the SQL Editor
Next
From: Akshay Joshi
Date:
Subject: Re: SSH Tunneling implementation