Your feedback is highly appreciated! Let's make Vertabelo even better.

  1. Forum: Vertabelo
0
W trakcie analizy

[Postgres] Constraint added automatically NOT DEFERRABLE INITIALLY IMMEDIATE

yun lee 7 lat temu • Ostatnio zmodyfikowane przez Adam Mościcki 6 lat temu • 3

By default is NOT DEFERRABLE and if it is NOT DEFERRABLE it is also IMMEDIATE, right?


Should I use those even it is set by default? Or it does imply something other?


Because the SQL generates with this Keyword in anyplace. and I'm not sure about the implications of all.


0
Naprawione

SQLite Autoincrement

Javier Tejedor 9 lat temu • Ostatnio zmodyfikowane przez hepeyowa 6 lat temu • 3

Hello, I have exported the SQL for a SQLite Database. In the tables, I have PRIMARY_KEY and AUTOINCREMENT.


CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL AUTOINCREMENT,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

Using this format, SQLite is throwing an error due the AUTOINCREMENT is not declared as PRIMARY KEY yet (it is being done in the CONSTRAINT). I am using the java sqlite-jdbc-3.8.11.2.jar driver from org.xerial


SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error) java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "AUTOINCREMENT": syntax error)


A possible correct syntax (regarding to the SQLite documentation https://www.sqlite.org/autoinc.html ) for the previous example would be:


CREATE TABLE CSS_AT_RULES (	
    id integer NOT NULL PRIMARY KEY AUTOINCREMENT,	
    css_version varchar(10) NOT NULL,	
    syntax_id integer NOT NULL
);

Could you please confirm if I am right?


Regards,

Javier.

Odpowiedź
anonymous 9 lat temu

Hello,

Yes, it is a bug.
I think, the correct syntax is (as sqlite's faq mentions https://www.sqlite.org/faq.html#q1):

CREATE TABLE CSS_AT_RULES (    
    id integer NOT NULL,
    css_version varchar(10) NOT NULL,
    syntax_id integer NOT NULL,
    CONSTRAINT CSS_AT_RULES_pk PRIMARY KEY (id)
);

If column has type 'integer' and 'primary key' then has also 'autoincrement'.

In this case, the fastes solution is to unset an autoincrement option.


I hope this helps.


0
Odrzucone

Is posible to share tables between diagrams?

Toni Aracil Sobrino 6 lat temu • Ostatnio zmodyfikowane przez Adam Mościcki 6 lat temu • 1

I need to share tables between diagrams. Because I need a change in one entity be replicated to table shared table with other diagram. Is that possible?


Thanks.

+1
W trakcie analizy

Please add adjustable rules for all of us anal-retentive people

Eric Norcross 9 lat temu • Ostatnio zmodyfikowane przez Joana PhotoshopSupply 6 lat temu • 3

I spend waaaaay too much time trying to align and make boxes the same size

0
W trakcie analizy

how to use the reverse Reverse engineering to? 14?

mo aarab 9 lat temu • Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 6 lat temu • 4

is it possible to get an example to SQL Server 14? I'm don't know anything of java

Odpowiedź
Adam Mościcki 9 lat temu

Please:
1. Download reverse engingeering http://www.vertabelo.com/_file/reverse-engineering/reverse-engineering-1_6_12.jar
2. Download jdbc driver https://www.microsoft.com/en-us/download/details.aspx?id=11774 (exe file should install jar somewhere)
3. In the download folder do:


java -cp .:reverse-engineering-1_6_12.jar:sqljdbc4.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]] -user USERNAME -password PASSWORD -o OUTPUT_FILENAME


I hope this helps.


Best regards,

Adam Mościcki

0
Z odpowiedzią

Getting error trying to use reverse engineering tool

Kent Graziano 10 lat temu • Ostatnio zmodyfikowane przez Yomiyu Malifu 6 lat temu • 11
I am using this command line on Windows 8:
java -cp .;reverse-engineering-1_6_9; com.vertabelo.reverse.Main -url jdbc:oracle:thin:@//localhost:1521/xe -user dv -password xx -o dv_demo

But get the error: Could not find or load main class com.vertabelo.reverse.Main
I am running in my \vertabelo directory. I downloaded the .jar file to that folder.

I am very bad at command line so have no idea how to fix this.
0
Ukończony

login history

Samir Agarwal 9 lat temu • Ostatnio zmodyfikowane przez Jeffrey E 6 lat temu • 1

I need the login history of employees also like google docs if you can show history with changes made by employees

+1
W trakcie analizy

Need for in-house version

shepel oleksiy 6 lat temu • Ostatnio zmodyfikowane przez Jarosław Błąd (CEO) 6 lat temu • 1

Hi guys,

Do you plan to develop desktop version of Vertabelo modeling tool, since there is no modern analogs of Erwin which is almost obsolete?

0
W trakcie analizy

FK tag in "properties" column of auto-generated documentation

Luka Čubelić 6 lat temu • Ostatnio zmodyfikowane przez Mariusz Zakrzewski 6 lat temu • 1

Is it possible to add the "FK" in the "properties" column of the fields that are foreign keys in some table, just like it says "PK" for the primary key?

+1
Planowane

Add data type support for PostgreSQL

Matthew Weber 6 lat temu • Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 6 lat temu • 1

This is the datatype recommended by PG to use but it isn't supported.

Likewise Serial2 would be a nice addition



Customer support service by UserEcho