javitum / info-database

Python script to obtain data from a database

Info-database

Python script to obtain data from a database (SQLITE)

How are the number of tables, number of columns, rows and data in each table, and the number of total records

Write the name of the database and get some of its data

Script de Python para obtener los datos de una base de datos (SQLITE)

Como son el numero de tablas, numero de columna, filas y datos de cada tabla, y el numero de registros totales

Escribe el nombre de la base de datos y obten algunos de sus datos

EXAMPLE

The database has 12 tables

The tables android_metadata has 1 columns, 1 rows and 1 registers

The tables sport_summary has 8 columns, 205 rows and 1640 registers

The tables location_data has 13 columns, 177949 rows and 2313337 registers

The tables running_info_per_km has 11 columns, 1276 rows and 14036 registers

The tables heart_rate has 14 columns, 797587 rows and 11166218 registers

The tables request has 4 columns, 4 rows and 16 registers

The tables medal has 2 columns, 0 rows and 0 registers

The tables running_info_per_lap has 23 columns, 907 rows and 20861 registers

The tables cadence_detail has 7 columns, 0 rows and 0 registers

The tables sport_tha_info has 16 columns, 732 rows and 11712 registers

The tables daily_perpormance_info has 6 columns, 1999 rows and 11994 registers

The tables vo2_max_day_info has 5 columns, 172 rows and 860 registers

The database sport_data.db has 13540675 dates