Auto generate form from a table ?

[heejit]

Is there way to create input form for all field in a table or is there way to generate a form from a table defination ?

[lovasoa]

Yes! which database system are you using?

[heejit]

postgresql

[lovasoa]

create temp table if not exists xxx(a text, b int);

SELECT 'form' AS component;

-- show fields
SELECT
  column_name AS name,
  CASE
    WHEN data_type = 'text' THEN 'text'
    WHEN data_type = 'integer' THEN 'number'
    ELSE 'text'
  END AS type
FROM information_schema.columns
WHERE table_name = 'xxx';

-- save on submit
INSERT INTO xxx (a, b)
SELECT :a, :b
WHERE :a IS NOT NULL;

[lovasoa]

But it's usually better to define the form by hand rather than create tying the database structure to the user interface

[heejit]

thanks it works