How to use SQLite SELECT query in python

Question

I have created 3 tables like the following

----------------Database name is chiledata.sqlite---------------

CREATE TABLE child (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT
);
----------------Database name is dogdata.sqlite---------------

CREATE TABLE dog (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    dog TEXT
);
----------------Database name is dogChilddata.sqlite---------------

CREATE TABLE child_dog {
    child_id INTEGER,
    dog_id INTEGER,
    FOREIGN KEY(child_id) REFERENCES child(id),
    FOREIGN KEY(dog_id) REFERENCES dog(id)
};

If I use python for make relationship between these tables and execute "SELECT" query how can I connect these 3 tables for this task?

ex:

#Import the sqlite3 module
import sqlite3
# Create a connection and cursor to your database
conn = sqlite3.connect('chiledata.sqlite')
c = conn.cursor()

So I can connect chiledata.sqlite but how can I connect other two database tables (dogdata.sqlite, dogChilddata.sqlite) to execute SELECT query?

Why did you create 3 separate database files? If the tables are related, you need to store them in one database. — Martijn Pieters
– Martijn Pieters, Commented Apr 16, 2014 at 10:40
yh..i create 3 separate database files..how can i store them in one database? — user3509090
– user3509090, Commented Apr 16, 2014 at 10:48
Just open one database connection and create your tables in that one database? — Martijn Pieters
– Martijn Pieters, Commented Apr 16, 2014 at 10:48

Martijn Pieters · Accepted Answer · 2014-04-16 11:19:02Z

1

Don't use separate database files if your tables are supposed to be related.

Store all your tables in one database file; connect to it, create the tables with that one connection only.

answered Apr 16, 2014 at 11:19

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user3509090 Over a year ago

same in MySQL and other DBMS ?

Martijn Pieters Over a year ago

@user3509090: same in any relational database.

Martijn Pieters Over a year ago

@user3509090: cross-database foreign-key relationships are possible in some DBMS products but require extra work. It is not the norm, however.

Collectives™ on Stack Overflow

How to use SQLite SELECT query in python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related