the source code is in the article and can be copied & pasted into a python file. Not quite as easy as downloading it, but it works.
I use Geany, but do not use APSW. And I like to use sqliteman to review sqltables after I create them or other tasks directly. I use that to also test my sql code before copying into a python script.
Copy & paste into a python script. I copied sql from pdf and created this for just one table. You can then add the other tables. and queries.
Code:
#! /usr/bin/env python
# -*- coding: utf-8 -*-
import sys, threading, Queue, os
import sqlite3
def dbi(filename):
create = not os.path.exists(filename)
dbi = sqlite3.connect(filename)
return dbi
def makeTable(tblname, sql):
db = dbi(tblname)
cursor = db.cursor()
cursor.execute(sql)
sql = 'CREATE TABLE IF NOT EXISTS Recipes (pkiD INTEGER PRIMARY KEY, name TEXT, servings TEXT, source TEXT)'
makeTable("cookbook1.db", sql)
Bookmarks