kokizzu / wwwsqldesigner Goto Github PK

Hi Ondřej,
how can I catch the event when a schema was successful loaded?
Simon

What steps will reproduce the problem?
1. Generate SQL code for Postgresql using tables having foreign keys

What is the expected output? What do you see instead?
We get:
<< ALTER TABLE "table" ADD FOREIGN KEY (columnName) REFERENCES "table2"
("columnNameID"); >>
but should be:
<< ALTER TABLE "table" ADD FOREIGN KEY ("columnName") REFERENCES "table2"
("columnNameID"); >>
Quotes are missing at foreign key column.
What version of the product are you using? On what operating system?
version 2.3.2

Please provide any additional information below.
This will not be of any issue to anyone naming their columns in lowercase only.

Is it possible to just import a SQL string to wwwsqldesigner?

Dear Ondrej,

I attach a new locale xml file for Esperanto.

Could you add it to your project?

Thanks

It would be nice if we could also remove foreign key connections we may
have accidentally created.

What steps will reproduce the problem?
1. Click "Add field" adds a "new field" field to the selected table
2. Double click on the new field to edit its name / details

What is the expected output? What do you see instead?
It would make more sense to skip the 2nd step and directly open the edit
box when adding a new field.

What version of the product are you using? On what operating system?
Latest zip available

What steps will reproduce the problem?
1. Click edit field
2. Read NOT NULL
3. Be confused

What is the expected output? What do you see instead?

Maybe NOT NULL should read: "Field can be NULL" and the action of the checkbox 
is reversed.

Hi Ondřej,
is it possible to create the XML schema file out of a sql file?
Simon

What steps will reproduce the problem?
1. Install version 2.3.2 from google code
2. Use in Google Chrome
3. Compare Demo site @ http://ondras.zarovi.cz/sql/demo/?keyword=default

What is the expected output? What do you see instead?
My downloaded version does not show smooth connectors in google chrome also
the pane does not move in google chrome when moving the red rectangle in
the lower right corner. Functionality of local version is OK in IE7 and
Firefox. However when using the demo site in google chrome smooth
connectors and dragging the red rectangle works OK - Is the version on the
demo site different then the one on google code?

What version of the product are you using? On what operating system?
Windows XP, 

Please provide any additional information below.

What steps will reproduce the problem?
1. Add a table
2.
3.

What is the expected output? What do you see instead?
cursor is at end of 'name' field; 'new table' text should be highlighted to
save from having to do so.

What version of the product are you using? On what operating system?
2.3.2 Ubuntu 8.10

Please provide any additional information below.

What steps will reproduce the problem?
1. Vytvoreni tabulky bez primarniho klice
2. Export do SQL (MySQL)
3.

What is the expected output? What do you see instead?
Klasicky kod pro vytvoreni tabulky, ale BEZ direktivy PRIMARY KEY. Kdezto i
kdyz u tabulky nespecifikuji primarni klic, tak ona direktiva se
vygeneruje. Viz tento vypis:
CREATE TABLE `articles_tags` (
`article_id` INTEGER NOT NULL ,
`tag_id` INTEGER NOT NULL ,
PRIMARY KEY ()
) COMMENT 'Articles <> Tags spoiler';
coz samozrejme neni spravne :)


What version of the product are you using? On what operating system?
2.3.1, ArchLinux


Please provide any additional information below.

What steps will reproduce the problem?
1. Enable snap.
2. Drag a table around.
3. Create a new table.

What is the expected output? What do you see instead?
2: Table should snap while being dragged around. Instead,
it only snaps when the mouse cursor is released.
3: Newly placed tables are not snapped at all.

What version of the product are you using? On what operating system?
r61

Please provide any additional information below.
Attached patch implements visual feedback for snap while dragging, and while
placing new tables.

What steps will reproduce the problem?
--------------------------------------
1. Import a large MySQL Database (>100 tables w/ ~8-10 fields each)

What is the expected output? What do you see instead?
-----------------------------------------------------
Over 100 tables with all their fields

What version of the product are you using? On what operating system?
--------------------------------------------------------------------
wwwsqldesigner svn rev 47
Ubuntu Karmic Koala Alpha 2
LAMP stack (from debian repository)

Please provide any additional information below.
------------------------------------------------
Firebug shows that the data returned from
http://localhost/wwwsqldesigner-svn/backend/php-mysql/?action=import&database=XY
Z
is a untruncated XML file with what appears to be the complete data set
(unverified).  So this is likely an issue with whatever visualization
method is used.

Line 81:

$result = sqlite_query( "SELECT `data` FROM ".TABLE." WHERE keyword =
'$keyword'" , $GLOBALS['sqlConnect'] );

SQLite doesn't recognize the backtick operators, they should be removed.

the foreign key feature should be available on "unique" key

for instance

create table test (
  id bigserial unique
)
create table blah (
  test_id bigint references test(id)
)

works in postgresql

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

WWW SQL Designer will switch from GNU GPL to BSD. Someday.

What steps will reproduce the problem?
1. 'create foreign key' from a primary key of data type 'serial'
2.
3.

What is the expected output? What do you see instead?
the resultant foreign key is of data type serial. Should be 'integer' if
reference column is 'serial' or 'bigint' if reference column is 'bigserial'.

What version of the product are you using? On what operating system?
2.3.2 ubuntu 8.10

Please provide any additional information below.
This is a Postgresql related issue. Serial/bigserial are pseudo-types

Purely code style issues, namely

if (l) this.typeIndex[l] = i;
should be
if (l) { this.typeIndex[l] = i; }

and an object initialization should be moved to beginning of the
block to be consistent.

I missed it when submitting the patch that got integrated in r60.
Patch attached.

see image:
long word can't be displayed

When you select a value with the keyboard and then close the drop down list 
with your mouse, the value reverts to its previous selection.

To reproduce:
1. Add a table, then a column, then edit it and click the data type drop 
down list to open it.
2. Press V to select varchar.
3. Click the dropdown list again to close it.

Instead of remaining on varchar, it will revert to integer.  If you press 
tab or enter instead of clicking to close the dropdown, it stays on varchar 
as it should.

I'm using Google Chrome v3.0.195.33 on Windows 7 Ultimate 64 bit.

Dear Ondrej

Find the attached file. 
Congratulations for this nice project.

Zsolt

What steps will reproduce the problem?
1. Press Del when either row or a table is selected.

What is the expected output? What do you see instead?
Row/Table delete confirmation dialog should appear. Instead, nothing happens.

What version of the product are you using? On what operating system?
r57

Please provide any additional information below.
Implemented in the attached patch.

There are minor grammatical/style oddities in Polish localization.
The attached patch takes care of them.

What steps will reproduce the problem?
1. Add a table
2. Cancel operation
3.

What is the expected output? What do you see instead?
if 'cancel' is selected, a blank table is still inserted on page. No table
should be created.

What version of the product are you using? On what operating system?
2.3.2 Ubuntu 8.10

Please provide any additional information below.

It would be very nice if we had the TINYINT field option, as a TINYINT(1) is 
ussually treated by many 
frameworks as a BOOLEAN field.

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?


What version of the product are you using? On what operating system?


Please provide any additional information below.

What steps will reproduce the problem?
1. Press Delete (command-delete) -- selected row/table gets deleted.
2. Press plain delete ("backspace" on PCs) -- the browser goes to the previous 
page in the 
history.

What is the expected output? What do you see instead?
On Macs, backspace is the customary key used to delete things. It should work 
just like delete 
does on PCs.

What version of the product are you using? On what operating system?
r61

Please provide any additional information below.
Implemented in the attached patch. Tested on most recent Safari, Opera and 
Firefox on OS X 
10.6.1. Works fine. This functionality is only enabled on Macs. On PCs, delete 
is the right key to 
use, *not* backspace.
Opera on Mac needed the well-known workaround, the latter is not applied on any 
other 
browser/platform for performance reasons. 

What steps will reproduce the problem?
--------------------------------------
1. save the contents of a large database using the save/load dialog
2. refresh the page to clear the contents
3. load the document

What is the expected output? What do you see instead?
-----------------------------------------------------
all tables in the saved document to be visualized, instead nothing is shown
at all (likely the visualization is appropriately failing fast as the
output would be a malformed XML document).

Inspection of the database table (wwwsqldesigner) shows that the data
column is truncated in large XML files.

What version of the product are you using? On what operating system?
--------------------------------------------------------------------
wwwsqldesigner svn rev 47
Ubuntu Karmic Koala Alpha 2
LAMP stack (from debian repository)
Firefox 3.0.11 Ubuntu

Please provide any additional information below.
------------------------------------------------
As a suggestion perhaps the output of 'save' can be dumped into a static
xml file named, for example, "$WEBROOT/saved/$NAME.xml".  Its probably
realistic to assume whoever is hosting wwwsqldesigner has the ability to
set writable permissions on the "saved" folder.  

The wwwsqldesigner database table could then be modified to save only the
filename ($NAME) and not the data.  As a nice side benefit you should get
free client-side caching, at least if you're hosting off of Apache you should.

The load request could then either echo out the content of the file, or
just provide a URL for the browser to perform a second AJAX request with.

I have not looked into the other database options (sqlite, etc) - so feel
free to comment on whether or not this logic will break them.

What steps will reproduce the problem?
1. Clicking "Align tables" aligns the table at the top of the workspace
making the relations invisible (if you have some!)

What is the expected output? What do you see instead?
It would be great to have an "autolayout" button (like in mysql workbench)
to auto-magically organize all the tables in an optimal way (trying to have
the relations not crossing each other for instance)!

What version of the product are you using? On what operating system?
Latest zip available

What steps will reproduce the problem?
1. Load a database structure that is larger than the 'area' property
boundary in the 'styles/style.css' config file
2. Create a new foreign key constraint, or view existing FK constraint
connector lines
3. Scroll to the bottom of the defined CSS 'area' boundary and either view
that the existing connector lines going to tables located below the
boundary area are 'cut off', or drag a table with an existing FK connector
line below the boundary and note that the lines are cut off.

What is the expected output? What do you see instead?
Expected that the FK connector lines would continue to be drawn past the
'boundary', as the tables are correctly rendered past this point.

I see that the lines are 'cut off', although when dragging a table around
under the 'boundary', the lines continue to update and be drawn above the
'boundary'.

What version of the product are you using? On what operating system?

Latest stable download as of 06/30/2009. Fedora 10 Linux
2.6.27.21-170.2.56.fc10.x86_64 #1 SMP Mon Mar 23 23:08:10 EDT 2009 x86_64
x86_64 x86_64 GNU/Linux

Please provide any additional information below.
Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.11) Gecko/2009061118
Fedora/3.0.11-1.fc10 Firefox/3.0.11

[deleted issue]

What steps will reproduce the problem?
1. It is not possible to drag n drop more than one table at the time (when
moving them around)

What is the expected output? What do you see instead?
It would very practical to be able to do so! :)

What version of the product are you using? On what operating system?
r45

What steps will reproduce the problem?
1. Import MyISAM table (no constraints)
2. Try to draw relations between already existing rows

What is the expected output? What do you see instead?
It is not possible to achieve this goal.

What version of the product are you using? On what operating system?
Doesn't matter.

Please provide any additional information below.
Additional information provided personally.

What steps will reproduce the problem?
1. Click "Save xml" fills the text area with the resulting xml

What is the expected output? What do you see instead?
It would be nice (although i believe it would also require a server side
backend,) to propose the resulting xml to be downloaded (and therefore no
need to copy / paste the xml).
Also the description of the db tables and fields are concatenated making
the xml a huge one line string which is heavy for buffers of most IDEs out
there : simple work around : new line on every closing tag!

What version of the product are you using? On what operating system?
latest zip available

What steps will reproduce the problem?
1. When saving to db with the php-mysql backend we always overwrite the
existing data.

What is the expected output? What do you see instead?
It would be interesting to save revisions of the xml instead to one can
review the changes applied over time (I'll give it a try).

What version of the product are you using? On what operating system?
r45

The type drop down list doesn't contain a data type for boolean (aka bit) 
data types.

With the latest checkout, I have to 

* Click on "Save / Load"
* Click On "Save"
* Type keyword
* Confirm (Ok/Enter)

to save the drawing. If the drawing was previously loaded, perhaps it could
be auto-saved. Even a one-click option to save it with the current keyword
would be very helpful indeed.

What steps will reproduce the problem?
1. create mysql database with only table:
CREATE TABLE `tableA` (
`id` UNSIGNED INT NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`id`)
);
2. import database to SQL Designer
3. export sql to re-create the table again


What is the expected output? What do you see instead?
the id is signed by default

What version of the product are you using? On what operating system?
Version 2.3.2 (8.1.2009)

Please provide any additional information below.
The tool is used in most cases to design database and then generate sql and
create tables. Workaround is to create tables and change types, but it's
hard to do it with many tables. Also foreign keys are problem when you
change types. It would be better id the tool supports UNSIGNED attribute
just like it supports INTEGER.

better ru.xml translate (more translated words)

What steps will reproduce the problem?
1. Press LMB and drag across the viewport.

What is the expected output? What do you see instead?
A selection rubberband should appear. Regular browser text selection appears 
instead within the 
tables.

What version of the product are you using? On what operating system?
r63

Please provide any additional information below.
Working on a patch.

Hi Ondřej,
it would be nice to have always a live demo with the current development
release. This would help me to keep track of the development of
wwwsqldesigner without the need to download and installing it. It would
help me also to figure out if the new features would work in the browser/os
I support. It would also fasten the feedback I can give on new features. 
Simon

in order to be able to use the drawing in reports and the like, exporting
the schema as a picture, as a png file with transparent background (no grid)

What steps will reproduce the problem?
1. Set locale to PL
2. Reload
3. Look at the row manager

What is the expected output? What do you see instead?
Czech captions instead of Polish ones :)

What version of the product are you using? On what operating system?
r56

Please provide any additional information below.
Patch is attached.

What steps will reproduce the problem?
1. To load an existing model you need to copy paste the xml

What is the expected output? What do you see instead?
It would be nice to be able to "upload" (yes, again server backend needed
there) the file.

What version of the product are you using? On what operating system?
Latest zip available

Problem: PHP exceeds 30 second execution limit
Solution: place

ini_set("max_execution_time", 0);

At the top of the backend/php-mysql/index.php script

I save a scheme for every project and links are more comfortable than
navigating like "click on Save / Load, then Load and type 'projectname'"

Example: http://example.com/sql/#ps-projectname (where ps means php-sqlite
backend and projectname the title of stored schema)

Thanks ;)

What steps will reproduce the problem?
1. Create 2 tables w a relationship linking them together
2. Move one table so it is located beyond perimeter of 'full page viewer'.

What is the expected output? What do you see instead?
The relationship 'string' is no longer visible beyond the perimeter.

What version of the product are you using? On what operating system?
2.3.2 on firefox, ubuntu 8.1

What steps will reproduce the problem?
1. Creating a relation / foreign key requires clicking on the button in the
menus
1.1. Changing the order of the fields in a table too!

What is the expected output? What do you see instead?
It would be great with those fields were dragable both within the table to
change their order, and to another table to create a new relation.

What version of the product are you using? On what operating system?
Latest zip available

It would be invalueable if it'd have a PSQL backend and be able to load a
psql databases :)