From bc7d7704330c2209de4d726a834df115a021451f Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Mon, 2 May 2016 02:05:48 +0100
Subject: [PATCH] sqlite csv

---
 lib/php/db/types/sqlite.php | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/lib/php/db/types/sqlite.php b/lib/php/db/types/sqlite.php
index f6d566a7..4c4762f0 100644
--- a/lib/php/db/types/sqlite.php
+++ b/lib/php/db/types/sqlite.php
@@ -1,4 +1,8 @@
 <?php
+if (!class_exists('Db')) {
+	echo "Hi there! I'm just a plugin, not much I can do when called directly.\n";
+	exit;
+}
 $DB_TYPES['sqlite'] = array (
 'exec' => 'PRAGMA encoding = "'.strtoupper(Db::$encoding).'"', 
 'use_path' => true,
@@ -9,6 +13,7 @@ $DB_TYPES['sqlite'] = array (
 
 'table.sql' => 'SELECT sql FROM sqlite_master WHERE name=\'<NAME>\'',
 'table.truncate' => 'DELETE FROM \'<NAME>\'',
+'table.csv.load' => ['.mode csv','.sep \\t','.import <FILE> <NAME>'],
 
 'sqliteCreateFunction' => array (
   'ip2int' => function ($value) { return ip2long($value); },
-- 
2.47.3