Query generator #54

New issue

Open

opened 2019-08-10 16:16:34 +00:00 by eelke · 2 comments

eelke commented

2019-08-10 16:16:34 +00:00

(Migrated from gitlab.com)

Make it simple to quickly generate a basic query

SELECT

right click table then select generate, generates a select from with all tables in the select a list of tables is shown where column can by (un)checked
join table option inner/left/right/full select second table if there is an FKey the match is generated automatically (option for USING when column names match)
aliasses can be entered for tables, these are automatically used in select list and join condition

INSERT

column selections
options like use column insert or not
make parameters in parameter list with correct type already set (we may want an additional description column)

UPDATE

select where condition columns
select columns to change
fill in parameter list

DELETE

select where condition columns
fill in parameter list

Make it simple to quickly generate a basic query # SELECT 1. right click table then select generate, generates a select from with all tables in the select a list of tables is shown where column can by (un)checked 2. join table option inner/left/right/full select second table if there is an FKey the match is generated automatically (option for USING when column names match) 3. aliasses can be entered for tables, these are automatically used in select list and join condition # INSERT 1. column selections 2. options like use column insert or not 3. make parameters in parameter list with correct type already set (we may want an additional description column) # UPDATE 1. select where condition columns 2. select columns to change 3. fill in parameter list # DELETE 1. select where condition columns 2. fill in parameter list

eelke commented

2019-08-10 16:21:34 +00:00

(Migrated from gitlab.com)

changed the description

eelke commented

2019-08-15 18:35:54 +00:00

(Migrated from gitlab.com)

changed the description