How can I check schema of SQLLEX?

[kingabzpro]

No description provided.

[v1a0]

Hey, kingabzpro, sorry but what do you mean under "check schema of SQLLEX"?

[kingabzpro]

When I create a relational database with a foreign key, I want to see some sort of diagram or relation how my all tables are connected.

[v1a0]

Hmm... I guess right now there is no such method in SQLite3x for this case. If sqlite3 ( from the box) have something for this case, you can use db.execute() and run any sql-script.

For example:

table_sql = db.execute("SELECT sql FROM sqlite_schema WHERE name = 'users';")
print(table_sql)

CREATE TABLE 'users'  (
username TEXT NOT NULL,
group_id INTEGER,
FOREIGN KEY (group_id) REFERENCES groups (group_id)
)

If you have any ides how to make something like that tell me.

UPD:
sqllex v0.1.8.3 released

pip install sqllex -U

[kingabzpro]

I think I am busy in Data Analysis part, I will come to you about schema soon,

I think it should show me names of tables available in the database but it shows the directory.

[kingabzpro]

I think I am busy in Data Analysis part, I will come to you about schema soon,

I think it should show me names of tables available in the database but it shows the directory.

I found it

academic_db.execute("SELECT name FROM sqlite_master WHERE type='table';")