/EuroNations-SQLitePy

A database of the major European Nations created in SQLite and Python. A portfolio example of the use of SQLite, SQL queries and interaction Python-SQL.

Primary LanguagePythonMIT LicenseMIT

EuroNations-SQLitePy

Banner

A database of the major European Nations created in SQLite and Python.

A portfolio example of the use of SQLite, SQL queries and interaction Python-SQL.

Example

Import needed libraries

# Standard library imports
import sqlite3

# Local imports
from euronations.create_db import CreateEuroNationsDB
from euronations.modify_db import ModifyDB

Create the data base

cdb = CreateEuroNationsDB(db = "euronations.db")
cdb.create_new_db()

Add a first item

mdb = ModifyDB()

mdb.insert_in_db(
    # Nation
    nation_name = 'Italy', 

    # Major city
    city_name = 'Rome',
    capitol = True, 
    population = 2_783_809,

    # Organization 
    EU = True, 
    NATO = True, 
    commonwealth = False,
)

Footer