drime

French rhyme dictionary with web and CLI interface
git clone https://a3nm.net/git/drime/
Log | Files | Refs | README

commit 863f7967a4dd6a9302c0b6cd24a328f2733e190c
parent 72ee1c7067a8a27212801b1712748eb9a341bc26
Author: Antoine Amarilli <a3nm@a3nm.net>
Date:   Fri, 30 Dec 2011 14:09:57 +0100

remove references to sqlite

Diffstat:
README | 10++--------
db_sqlite.py | 15---------------
2 files changed, 2 insertions(+), 23 deletions(-)

diff --git a/README b/README @@ -26,14 +26,6 @@ from the Lexique3 database <http://lexique.org/>: - lexique2sql.sh takes the tweaked version of Lexique on stdin and produces the SQL database on stdout. -To import the output of lexique2sql.sh in a sqlite3 database, run: - - cat output.sql | sqlite3 db.sqlite - -This can take some time: you can monitor progress using the pv utility: - - pv -l output.sql | sqlite3 db.sqlite - To import the output of lexique2sql.sh in a MySQL database (on localhost, database 'drime', as user 'drime', interactive password authentication), run: @@ -43,6 +35,8 @@ database 'drime', as user 'drime', interactive password authentication), run: sed 's/varchar([0-9]*)/& collate utf8_bin/g' | mysql --default-character-set=utf8 -D drime -u drime -p +To monitor progress, use the pv utility. + == 4. Using the DB == == 4.1. Configuring database access == diff --git a/db_sqlite.py b/db_sqlite.py @@ -1,15 +0,0 @@ -#!/usr/bin/python -O - -import sqlite3 -import os - -DBPATH = os.path.join(os.path.dirname(os.path.realpath(__file__)), - 'db.sqlite') - -def run_query(r, v): - db = sqlite3.connect(DBPATH) - db.row_factory = sqlite3.Row - cursor = db.cursor() - cursor.execute(r, v) - return cursor -