Gist Test

//This is a test gist. let things = ("Hello", "World") for item in things { print(item) }

Comments

Post a Comment

Popular posts from this blog

NULL vs None in sqlite3 for Python

Null vs None in sqlite3, Python The sqlite3 library in Python accepts Python data types for data insertion. This table in the docs shows the type conversion for data when transferred between SQLite and Python. NULL vs None SQLite automatically accepts NULL (and null ) since it is a reserved keyword in. It cannot, however, be accepted as input via parameter substitution. We build a database and explain the distinctions in the following gist: dbpath = "/.../test.db" >>> import sqlite3 >>> connection = sqlite3.connect(dbpath) >>> cursor = connection.cursor() >>> cursor.execute("CREATE TABLE Test (testcolumn TEXT);") >>> cursor.execute("INSERT INTO Test VALUES(NULL);") >>> #We now have exactly one entry in our table. Verify this with SELECT: >>> cursor.execute("SELECT * FROM Test WHERE testcolumn IS NULL;") >>> for item in cursor: print(item) (Non
Read more

Complete SQLite IMDb Database with Python

Create IMDb Database with Python Our goal now is to automate the process of downloading the IMDb data and creating an optimized SQLite database with it. Below are the SQLite statements to create the tables, additional columns, and indices: create_Title = ("CREATE TABLE IF NOT EXISTS Title (" "tconst TEXT PRIMARY KEY, " "title_type TEXT, " "primary_title TEXT, " "original_title TEXT, " "is_adult INTEGER, " "start_year INTEGER, " "end_year INTEGER, " "runtime_minutes INTEGER, " "genres TEXT);") create_Name = ("CREATE TABLE IF NOT EXISTS Name (" "nconst TEXT PRIMARY KEY, " "primary_name TEXT, " "birth_year INTEGER, " "death_year TEXT, " "primary_profession TEXT, " "known_for_titles TEXT);") create_Crew = ("CREATE TABLE IF NOT EXISTS Crew (" "tconst TEXT PRIMARY KEY, "
Read more