How to edit with forms-mode a table from MySQL?

How to edit with forms-mode a table from MySQL?

[R. Readi]

Dear Sirs!

I have a table exported from a database (I think MySQL) and want to edit
it with emacs forms-mode. Although this should be a very usual thing, I
dont think I can do it without some (more or less trivial) elisp
programming. I wanted to ask you here if you know a more direct way
before I begin writing programms.

The rows (records) of the tables are separated as DOS separate lines
(with ^M^J), the collumns (fields) are separated with commas and their
contents are quoted with the double-quote-symbol (") at the beginning
and the end. The problem I see: some fields contain commas, line-feeds
(^J) and even double-quotes-symbols (not followed by comma).

I would thank you any hint,
Rodrigo Readi
(scire_AT_web_DOT_de).

Re: How to edit with forms-mode a table from MySQL?

[Robert Pollard]

Hi R.,

I have posted a question about forms and haven't received an answer 
yet.  I am having trouble with creating new records or editing them.  
It indicates the file is not writable.  Although I toggle the read only 
mode and made sure I am the owner of the file it still does not allow 
me to write to it.  I try to insert a record and it tells me the file 
cannot be changed because it is read only.
If you get any responses from your post please let me know.

I believe there is a way to convert the field delimiters to something 
that isn't used like ^K.   It sounds like you will also have to allow 
multiple line fields in your control definitions.

I don't know all the details but it sounds doable.

HTH,

Robert Pollard

On Wednesday, May 21, 2003, at 09:41 AM, R. Readi wrote:

> Dear Sirs!
>
> I have a table exported from a database (I think MySQL) and want to 
> edit
> it with emacs forms-mode. Although this should be a very usual thing, I
> dont think I can do it without some (more or less trivial) elisp
> programming. I wanted to ask you here if you know a more direct way
> before I begin writing programms.
>
> The rows (records) of the tables are separated as DOS separate lines
> (with ^M^J), the collumns (fields) are separated with commas and their
> contents are quoted with the double-quote-symbol (") at the beginning
> and the end. The problem I see: some fields contain commas, line-feeds
> (^J) and even double-quotes-symbols (not followed by comma).
>
> I would thank you any hint,
> Rodrigo Readi
> (scire_AT_web_DOT_de).
>
>
>
> _______________________________________________
> Help-gnu-emacs mailing list
> Help-gnu-emacs@gnu.org
> http://mail.gnu.org/mailman/listinfo/help-gnu-emacs
>

Re: How to edit with forms-mode a table from MySQL?

[Kai Großjohann]

"R. Readi" <no@spam.de> writes:

> The rows (records) of the tables are separated as DOS separate lines
> (with ^M^J), the collumns (fields) are separated with commas and their
> contents are quoted with the double-quote-symbol (") at the beginning
> and the end. The problem I see: some fields contain commas, line-feeds
> (^J) and even double-quotes-symbols (not followed by comma).

This format will be difficult to work with in Emacs' forms mode.  The
problem is the double quotes.

Forms mode by default uses C-k (ascii 11?) to separate fields, I
think.  Can you transmogrify the file to match Emacs' idea of a field
better?
-- 
This line is not blank.

Re: How to edit with forms-mode a table from MySQL?

[Kevin Dziulko]

Sounds like you will want to rely heavily on regular expressions.  The 
double quotes inside the column fields will be the difficult part, because 
the regular expression is normally greedy.  You should be able to find 
help on this on the web.  Good luck!


On Wed, 21 May 2003, R. Readi wrote:

> Dear Sirs!
> 
> I have a table exported from a database (I think MySQL) and want to edit
> it with emacs forms-mode. Although this should be a very usual thing, I
> dont think I can do it without some (more or less trivial) elisp
> programming. I wanted to ask you here if you know a more direct way
> before I begin writing programms.
> 
> The rows (records) of the tables are separated as DOS separate lines
> (with ^M^J), the collumns (fields) are separated with commas and their
> contents are quoted with the double-quote-symbol (") at the beginning
> and the end. The problem I see: some fields contain commas, line-feeds
> (^J) and even double-quotes-symbols (not followed by comma).
> 
> I would thank you any hint,
> Rodrigo Readi
> (scire_AT_web_DOT_de).
> 
> 
> 
> _______________________________________________
> Help-gnu-emacs mailing list
> Help-gnu-emacs@gnu.org
> http://mail.gnu.org/mailman/listinfo/help-gnu-emacs
>