convert mysql dump to sqlite dump

convert.sh

#!/bin/sh

# ================================================================
#
# Convert a mysql database dump into something sqlite3 understands.
#
# Adapted from
# http://stackoverflow.com/questions/489277/script-to-convert-mysql-dump-sql-file-into-format-that-can-be-imported-into-sqlit
#
# (c) 2010 Martin Czygan <martin.czygan@gmail.com>
#
# ================================================================

if [ "$#" -lt 1 ]; then
   echo "Usage: $0 <dumpname>"
   exit
fi

SRC=$1
DST=$1.sqlite3.sql
DB=$1.sqlite3.db
ERR=$1.sqlite3.err

cat $SRC |
grep -v ' KEY "' |
grep -v ' UNIQUE KEY "' |
grep -v ' UNIQUE KEY `' |
grep -v ' PRIMARY KEY ' |

sed 's/ENGINE=MyISAM/ /g' |
sed 's/DEFAULT/ /g' |
sed 's/CHARSET=[a-zA-Z0-9]*/ /g' |
sed 's/AUTO_INCREMENT=[0-9]*/ /g' |

sed 's/\\r\\n/\\n/g' |
sed 's/\\"/"/g' |
sed '/^SET/d' |
sed 's/ unsigned / /g' |
sed 's/ auto_increment/ primary key autoincrement/g' |
sed 's/ AUTO_INCREMENT/ primary key autoincrement/g' |
sed 's/ smallint([0-9]*) / integer /g' |
sed 's/ tinyint([0-9]*) / integer /g' |
sed 's/ int([0-9]*) / integer /g' |
sed 's/ character set [^ ]* / /g' |
sed 's/ enum([^)]*) / varchar(255) /g' |
sed 's/ on update [^,]*//g' |
sed 's/UNLOCK TABLES;//g' |
sed 's/LOCK TABLES [^;]*;//g' |
perl -e 'local $/;$_=<>;s/,\n\)/\n\)/gs;print "begin;\n";print;print "commit;\n"' |
perl -pe '
  if (/^(INSERT.+?)\(/) {
     $a=$1;
     s/\\'\''/'\'\''/g;
     s/\\n/\n/g;
     s/\),\(/\);\n$a\(/g;
  }
  ' > $DST

cat $DST | sqlite3 $DB > $ERR

ERRORS=`cat $ERR | wc -l`

if [ "$ERRORS" -eq "0" ]; then
	echo "Conversion completed without error. Your db is ready under: $DB"
	echo "\$ sqlite3 $DB"
  rm -f $ERR
else
   echo "There were errors during conversion. \
	Please review $ERR and $DST for details."
fi

essex-keystone.sql.sqlite3.sql

begin;
-- MySQL dump 10.13  Distrib 5.1.58, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: keystone
-- ------------------------------------------------------
-- Server version	5.1.58-1ubuntu1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `credentials`
--

DROP TABLE IF EXISTS `credentials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `credentials` (
  `user_id` integer   NULL,
  `tenant_id` integer   NULL,
  `secret` varchar(255)   NULL,
  `key` varchar(255)   NULL,
  `type` varchar(20)   NULL,
  `id` integer NOT NULL primary key autoincrement
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credentials`
--


/*!40000 ALTER TABLE `credentials` DISABLE KEYS */;
INSERT INTO `credentials` VALUES (1,1,'0penstack','admin','EC2',1);
INSERT INTO `credentials` VALUES (2,2,'0penstack','demo','EC2',2);
INSERT INTO `credentials` VALUES (3,4,'croquet','will','EC2',3);
INSERT INTO `credentials` VALUES (4,5,'octopus','bcwaldon','EC2',4);
INSERT INTO `credentials` VALUES (5,6,'ilikercb','william','EC2',5);
INSERT INTO `credentials` VALUES (6,7,'welcome','andrew','EC2',6);
INSERT INTO `credentials` VALUES (7,8,'monkey','chmouel','EC2',7);
INSERT INTO `credentials` VALUES (8,9,'horizon','nebula','EC2',8);
INSERT INTO `credentials` VALUES (9,10,'reach','reach','EC2',9);
INSERT INTO `credentials` VALUES (10,11,'password','termie','EC2',10);
INSERT INTO `credentials` VALUES (11,12,'waterpolo','xtoddx','EC2',11);
INSERT INTO `credentials` VALUES (12,13,'bball','anthony','EC2',12);
INSERT INTO `credentials` VALUES (13,14,'joeboo','breu','EC2',13);
INSERT INTO `credentials` VALUES (14,15,'asdfasdf','nati','EC2',14);
INSERT INTO `credentials` VALUES (15,16,'racing','dtroyer','EC2',15);
INSERT INTO `credentials` VALUES (16,17,'asdf','dolph','EC2',16);
INSERT INTO `credentials` VALUES (17,18,'pa55w0rd','ben','EC2',17);
INSERT INTO `credentials` VALUES (18,19,'SuperSecurePassword','jordan','EC2',18);
INSERT INTO `credentials` VALUES (19,20,'rcbftw','scott','EC2',19);
INSERT INTO `credentials` VALUES (20,21,'curling','vish','EC2',20);
INSERT INTO `credentials` VALUES (21,22,'hockey','jakedahn','EC2',21);
INSERT INTO `credentials` VALUES (22,23,'softball','anne','EC2',22);
INSERT INTO `credentials` VALUES (23,24,'golfing','jesse','EC2',23);
/*!40000 ALTER TABLE `credentials` ENABLE KEYS */;


--
-- Table structure for table `endpoint_templates`
--

DROP TABLE IF EXISTS `endpoint_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `endpoint_templates` (
  `is_global` integer   NULL,
  `region` varchar(255)   NULL,
  `public_url` varchar(2000)   NULL,
  `enabled` integer   NULL,
  `internal_url` varchar(2000)   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `service_id` integer   NULL,
  `admin_url` varchar(2000)   NULL,
  `version_id` varchar(20)   NULL,
  `version_list` varchar(2000)   NULL,
  `version_info` varchar(500)   NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `endpoint_templates`
--


/*!40000 ALTER TABLE `endpoint_templates` DISABLE KEYS */;
INSERT INTO `endpoint_templates` VALUES (1,'RegionOne','http://50.56.12.206:8774/v1.1/%tenant_id%',1,'http://50.56.12.206:8774/v1.1/%tenant_id%',1,1,'http://50.56.12.206:8774/v1.1/%tenant_id%',NULL,NULL,NULL);
INSERT INTO `endpoint_templates` VALUES (1,'RegionOne','http://50.56.12.206:8773/services/Cloud',1,'http://50.56.12.206:8773/services/Cloud',2,2,'http://50.56.12.206:8773/services/Admin',NULL,NULL,NULL);
INSERT INTO `endpoint_templates` VALUES (1,'RegionOne','http://50.56.12.206:9292/v1',1,'http://50.56.12.206:9292/v1',3,3,'http://50.56.12.206:9292/v1',NULL,NULL,NULL);
INSERT INTO `endpoint_templates` VALUES (1,'RegionOne','http://50.56.12.206:5000/v2.0',1,'http://50.56.12.206:5000/v2.0',4,4,'http://50.56.12.206:35357/v2.0',NULL,NULL,NULL);
INSERT INTO `endpoint_templates` VALUES (1,'RegionOne','http://50.56.12.206:8080/v1/AUTH_%tenant_id%',1,'http://50.56.12.206:8080/v1/AUTH_%tenant_id%',5,5,'http://50.56.12.206:8080/',NULL,NULL,NULL);
/*!40000 ALTER TABLE `endpoint_templates` ENABLE KEYS */;


--
-- Table structure for table `endpoints`
--

DROP TABLE IF EXISTS `endpoints`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `endpoints` (
  `endpoint_template_id` integer   NULL,
  `tenant_id` integer   NULL,
  `id` integer NOT NULL primary key autoincrement
)      ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `endpoints`
--


/*!40000 ALTER TABLE `endpoints` DISABLE KEYS */;
/*!40000 ALTER TABLE `endpoints` ENABLE KEYS */;


--
-- Table structure for table `migrate_version`
--

DROP TABLE IF EXISTS `migrate_version`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrate_version` (
  `repository_id` varchar(250) NOT NULL,
  `repository_path` text,
  `version` integer   NULL
)      ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrate_version`
--


/*!40000 ALTER TABLE `migrate_version` DISABLE KEYS */;
INSERT INTO `migrate_version` VALUES ('Keystone','/opt/stack/keystone/keystone/backends/sqlalchemy/migrate_repo',11);
/*!40000 ALTER TABLE `migrate_version` ENABLE KEYS */;


--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `service_id` integer   NULL,
  `desc` varchar(255)   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `name` varchar(255)   NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--


/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (NULL,NULL,1,'admin');
INSERT INTO `roles` VALUES (NULL,NULL,2,'Member');
INSERT INTO `roles` VALUES (NULL,NULL,3,'KeystoneAdmin');
INSERT INTO `roles` VALUES (NULL,NULL,4,'KeystoneServiceAdmin');
INSERT INTO `roles` VALUES (NULL,NULL,5,'sysadmin');
INSERT INTO `roles` VALUES (NULL,NULL,6,'netadmin');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;


--
-- Table structure for table `services`
--

DROP TABLE IF EXISTS `services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `services` (
  `desc` varchar(255)   NULL,
  `type` varchar(255)   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `name` varchar(255)   NULL,
  `owner_id` integer   NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `services`
--


/*!40000 ALTER TABLE `services` DISABLE KEYS */;
INSERT INTO `services` VALUES ('Nova Compute Service','compute',1,'nova',NULL);
INSERT INTO `services` VALUES ('EC2 Compatability Layer','ec2',2,'ec2',NULL);
INSERT INTO `services` VALUES ('Glance Image Service','image',3,'glance',NULL);
INSERT INTO `services` VALUES ('Keystone Identity Service','identity',4,'keystone',NULL);
INSERT INTO `services` VALUES ('Swift Service','object-store',5,'swift',NULL);
/*!40000 ALTER TABLE `services` ENABLE KEYS */;


--
-- Table structure for table `tenants`
--

DROP TABLE IF EXISTS `tenants`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tenants` (
  `desc` varchar(255)   NULL,
  `enabled` integer   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `name` varchar(255)   NULL,
  `uid` varchar(255) NOT NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tenants`
--


/*!40000 ALTER TABLE `tenants` DISABLE KEYS */;
INSERT INTO `tenants` VALUES (NULL,1,1,'admin','ee5f864870244c72bca50abab64686ce');
INSERT INTO `tenants` VALUES (NULL,1,2,'demo','f3dbc945fdaf490cad03d8eac9bc649f');
INSERT INTO `tenants` VALUES (NULL,1,3,'invisible_to_admin','496c4c7f474a4cf592221c4bbada0b5d');
INSERT INTO `tenants` VALUES (NULL,1,4,'will','c1575443b6cd4d5784bd67df6452589a');
INSERT INTO `tenants` VALUES (NULL,1,5,'bcwaldon','ee7ae1442fcd4861b6a3cea959f534fb');
INSERT INTO `tenants` VALUES (NULL,1,6,'william','8e744544ede049d5b6e82f990da0a795');
INSERT INTO `tenants` VALUES (NULL,1,7,'andrew','56f604f2a453482dac002f2e0a0cabb7');
INSERT INTO `tenants` VALUES (NULL,1,8,'chmouel','1ee989ab9f464d59abbf3281b4aa279e');
INSERT INTO `tenants` VALUES (NULL,1,9,'nebula','1679b28cf5d24caab778cc2020f5b1dd');
INSERT INTO `tenants` VALUES (NULL,1,10,'reach','cfe7b5c4cb2242719787044a2fc92b9d');
INSERT INTO `tenants` VALUES (NULL,1,11,'termie','d7b73a8a36894f5d981b7c3a4c457c19');
INSERT INTO `tenants` VALUES (NULL,1,12,'xtoddx','d951984505ce49bd950956b55aaf8109');
INSERT INTO `tenants` VALUES (NULL,1,13,'anthony','e55125f7c3014ad2a073ec733f9c105e');
INSERT INTO `tenants` VALUES (NULL,1,14,'breu','6432950b0bca432694f4fc197536f546');
INSERT INTO `tenants` VALUES (NULL,1,15,'nati','0dcdd3c094ad41eb90df69dab9136761');
INSERT INTO `tenants` VALUES (NULL,1,16,'dtroyer','73ccd16ce80542f2833e2958981391b0');
INSERT INTO `tenants` VALUES (NULL,1,17,'dolph','5732b9cd9477433ea95fd0cb1037dfdb');
INSERT INTO `tenants` VALUES (NULL,1,18,'ben','16c1439221ea40e8bb5eb7220e11594c');
INSERT INTO `tenants` VALUES (NULL,1,19,'jordan','d060fcacdfba46f48cc6299e500f1af3');
INSERT INTO `tenants` VALUES (NULL,1,20,'scott','e69d397a26814f34993de8c7d4a2017a');
INSERT INTO `tenants` VALUES (NULL,1,21,'vish','6f78f3c751c547ceb94afee434d1a314');
INSERT INTO `tenants` VALUES (NULL,1,22,'jakedahn','0846d416ad6e4213b300dd91d8be73ec');
INSERT INTO `tenants` VALUES (NULL,1,23,'anne','3f3fbffd541a49f495d80197d83ea08e');
INSERT INTO `tenants` VALUES (NULL,1,24,'jesse','c8cff58e3e2a47838147bbecce752bde');
/*!40000 ALTER TABLE `tenants` ENABLE KEYS */;


--
-- Table structure for table `tokens`
--

DROP TABLE IF EXISTS `tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tokens` (
  `tenant_id` integer   NULL,
  `expires` datetime   NULL,
  `user_id` integer   NULL,
  `id` varchar(255) NOT NULL
)      ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tokens`
--


/*!40000 ALTER TABLE `tokens` DISABLE KEYS */;
INSERT INTO `tokens` VALUES (1,'2015-02-05 00:00:00',1,'cd0d1a03-b701-4fcb-801a-8b4d0bc3d06e');
INSERT INTO `tokens` VALUES (NULL,'2012-02-14 05:23:55',1,'b0f96472-e731-4cc4-8ae5-c137050149ff');
INSERT INTO `tokens` VALUES (24,'2012-02-14 05:23:55',23,'36b0e37c-cc8d-487a-8d54-7b7f1a1b5b62');
INSERT INTO `tokens` VALUES (16,'2012-02-14 07:15:21',15,'715fcdef-fc08-4d73-8403-2adb3743bdca');
INSERT INTO `tokens` VALUES (NULL,'2012-02-14 12:17:11',21,'213daf6b-35c1-4397-94fc-af2d17c4c1a1');
INSERT INTO `tokens` VALUES (22,'2012-02-14 12:17:12',21,'70f65b73-03c8-4ceb-839e-7a1ad8760bb0');
/*!40000 ALTER TABLE `tokens` ENABLE KEYS */;


--
-- Table structure for table `user_roles`
--

DROP TABLE IF EXISTS `user_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_roles` (
  `tenant_id` integer   NULL,
  `user_id` integer   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `role_id` integer   NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_roles`
--


/*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
INSERT INTO `user_roles` VALUES (1,1,1,1);
INSERT INTO `user_roles` VALUES (2,2,2,2);
INSERT INTO `user_roles` VALUES (2,2,3,5);
INSERT INTO `user_roles` VALUES (2,2,4,6);
INSERT INTO `user_roles` VALUES (3,2,5,2);
INSERT INTO `user_roles` VALUES (2,1,6,1);
INSERT INTO `user_roles` VALUES (NULL,1,7,1);
INSERT INTO `user_roles` VALUES (NULL,1,8,3);
INSERT INTO `user_roles` VALUES (NULL,1,9,4);
INSERT INTO `user_roles` VALUES (4,3,10,5);
INSERT INTO `user_roles` VALUES (4,3,11,6);
INSERT INTO `user_roles` VALUES (4,3,12,2);
INSERT INTO `user_roles` VALUES (5,4,13,5);
INSERT INTO `user_roles` VALUES (5,4,14,6);
INSERT INTO `user_roles` VALUES (5,4,15,2);
INSERT INTO `user_roles` VALUES (6,5,16,5);
INSERT INTO `user_roles` VALUES (6,5,17,6);
INSERT INTO `user_roles` VALUES (6,5,18,2);
INSERT INTO `user_roles` VALUES (7,6,19,5);
INSERT INTO `user_roles` VALUES (7,6,20,6);
INSERT INTO `user_roles` VALUES (7,6,21,2);
INSERT INTO `user_roles` VALUES (8,7,22,5);
INSERT INTO `user_roles` VALUES (8,7,23,6);
INSERT INTO `user_roles` VALUES (8,7,24,2);
INSERT INTO `user_roles` VALUES (9,8,25,5);
INSERT INTO `user_roles` VALUES (9,8,26,6);
INSERT INTO `user_roles` VALUES (9,8,27,2);
INSERT INTO `user_roles` VALUES (10,9,28,5);
INSERT INTO `user_roles` VALUES (10,9,29,6);
INSERT INTO `user_roles` VALUES (10,9,30,2);
INSERT INTO `user_roles` VALUES (11,10,31,5);
INSERT INTO `user_roles` VALUES (11,10,32,6);
INSERT INTO `user_roles` VALUES (11,10,33,2);
INSERT INTO `user_roles` VALUES (12,11,34,5);
INSERT INTO `user_roles` VALUES (12,11,35,6);
INSERT INTO `user_roles` VALUES (12,11,36,2);
INSERT INTO `user_roles` VALUES (13,12,37,5);
INSERT INTO `user_roles` VALUES (13,12,38,6);
INSERT INTO `user_roles` VALUES (13,12,39,2);
INSERT INTO `user_roles` VALUES (14,13,40,5);
INSERT INTO `user_roles` VALUES (14,13,41,6);
INSERT INTO `user_roles` VALUES (14,13,42,2);
INSERT INTO `user_roles` VALUES (15,14,43,5);
INSERT INTO `user_roles` VALUES (15,14,44,6);
INSERT INTO `user_roles` VALUES (15,14,45,2);
INSERT INTO `user_roles` VALUES (16,15,46,5);
INSERT INTO `user_roles` VALUES (16,15,47,6);
INSERT INTO `user_roles` VALUES (16,15,48,2);
INSERT INTO `user_roles` VALUES (17,16,49,5);
INSERT INTO `user_roles` VALUES (17,16,50,6);
INSERT INTO `user_roles` VALUES (17,16,51,2);
INSERT INTO `user_roles` VALUES (18,17,52,5);
INSERT INTO `user_roles` VALUES (18,17,53,6);
INSERT INTO `user_roles` VALUES (18,17,54,2);
INSERT INTO `user_roles` VALUES (19,18,55,5);
INSERT INTO `user_roles` VALUES (19,18,56,6);
INSERT INTO `user_roles` VALUES (19,18,57,2);
INSERT INTO `user_roles` VALUES (20,19,58,5);
INSERT INTO `user_roles` VALUES (20,19,59,6);
INSERT INTO `user_roles` VALUES (20,19,60,2);
INSERT INTO `user_roles` VALUES (21,20,61,5);
INSERT INTO `user_roles` VALUES (21,20,62,6);
INSERT INTO `user_roles` VALUES (21,20,63,2);
INSERT INTO `user_roles` VALUES (22,21,64,5);
INSERT INTO `user_roles` VALUES (22,21,65,6);
INSERT INTO `user_roles` VALUES (22,21,66,2);
INSERT INTO `user_roles` VALUES (23,22,67,5);
INSERT INTO `user_roles` VALUES (23,22,68,6);
INSERT INTO `user_roles` VALUES (23,22,69,2);
INSERT INTO `user_roles` VALUES (24,23,70,5);
INSERT INTO `user_roles` VALUES (24,23,71,6);
INSERT INTO `user_roles` VALUES (24,23,72,2);
/*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;


--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `name` varchar(255)   NULL,
  `tenant_id` integer   NULL,
  `enabled` integer   NULL,
  `id` integer NOT NULL primary key autoincrement,
  `password` varchar(255)   NULL,
  `email` varchar(255)   NULL,
  `uid` varchar(255) NOT NULL
)        ;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--


/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES ('admin',NULL,1,1,'$6$rounds=40000$8xwnwT9lodbGl5.w$nQsJCxfGAkR7QogurIBdydOHvJoGygH6SkozL2uCgqPmO3qqXAUXkHMPoui/H6af/54LYGHGsSfx/zGaLvqul0',NULL,'172b8b65ff454ce0a248241cb9186848');
INSERT INTO `users` VALUES ('demo',NULL,1,2,'$6$rounds=40000$nFXDPqWsXAkO4LI5$J30HZ9IgU4cuyidMB8xWKDKY/NOdj56jSd0gVsQUe5qniNq9sVnZfjZ3EhhNGXu/guea5SF.NgdUzvo63ryzx.',NULL,'da980a804b894723bd9e32e9281c800e');
INSERT INTO `users` VALUES ('will',NULL,1,3,'$6$rounds=40000$OwfhPxM3qIqbHp1K$/qODF0ayapcldlEUOPdQFacgTsvr3.9lfOpr3Z0/6SIrhw07TMk60esefxEjvxCx0SsQVaP8KwdZ18nc7NU1O0',NULL,'a0357356c32b48c39d62fc1d25976ffb');
INSERT INTO `users` VALUES ('bcwaldon',NULL,1,4,'$6$rounds=40000$cwwXuSijIR0AxTD.$qDF0ULpvFkkQi9CwUNsnCakzavdUn/UpTdBjgaIivBZhi5c.VZjDbgxWPjLtTnb86fC1T5SHRoIRbuTJYn0u30',NULL,'855d21c1bbfc4724bbe65bf91e407bc7');
INSERT INTO `users` VALUES ('william',NULL,1,5,'$6$rounds=40000$UZlgsc1IN5MFyffz$/MPqo93qIh2hcn/soOTYZgPgudarXQdhnhbNFeBHvha1WrjT4.NoTUm5TjkBh2zep02ViTYGNnwKT6Alwkp2o1',NULL,'70c9f84bb2df446cad4584907ab5f717');
INSERT INTO `users` VALUES ('andrew',NULL,1,6,'$6$rounds=40000$eruVQIr3pWoDYiLV$HRtg1MXiLlAaEfi3fWkCnxs9WzaL1N/rOkVGo2U386qNOEtR4X/FrYtTDLfbmW9s7nfGg3E9kLgqKN/GyOGy71',NULL,'1163c3b82d9b4d118950b499404ee9d0');
INSERT INTO `users` VALUES ('chmouel',NULL,1,7,'$6$rounds=40000$yvvn5iEiSyB4ajUs$tFvBUvPRaBWolRJSn5ZXngTVufu5XIRB8Ym5/LVEhW4tNT9BttqUWJpCgraOb5va0WohHNGhJcKrFcKJjOAXx0',NULL,'1afda5c4de56426f8c2b62642229af78');
INSERT INTO `users` VALUES ('nebula',NULL,1,8,'$6$rounds=40000$0NzhgOgfrU1GQ6Ja$kEmLxyXacN/c6qUJHM5xy90pPtKr43q9nbzYcEB/zHAzaL3Z4IWpgbXU6M3VNqAEmQiG2B14/5mUEKQacYJI61',NULL,'8810a9e440c347e9bebd2ba82365ad01');
INSERT INTO `users` VALUES ('reach',NULL,1,9,'$6$rounds=40000$sv66EEDRC7l8KAyx$c7A6A6LnhE2CCBfzdVy1hKjDzKlcXdrqeYOK84eE946em41SpgVPSe3LFKuD1Y6/G.vntYbILGqjwPMNGfPm11',NULL,'42a75f6673464ff1962c68eb734c6c49');
INSERT INTO `users` VALUES ('termie',NULL,1,10,'$6$rounds=40000$Jl2Qvpi5W8sTdoyS$5kXpGSILy9YpFXlLQUhrtsVXG95l./NAdej.dkKAnSd.52PbS/dIdEDLlqOzRh1yS4DXdFTqhn2kUaMNwTqDq1',NULL,'5fa110a255df4d6d97157fb9faed451b');
INSERT INTO `users` VALUES ('xtoddx',NULL,1,11,'$6$rounds=40000$mNhZTdM1nAhru1Vl$N.PLGonzqj3KUuZSHIbmVtWkuvmH62qRPvZgDibsaOGn3jbg5iTiEr9thym/gL8UcBeaj5Todo6BOTv12KbvP0',NULL,'8df1268546ce45c8957bb494824d2a41');
INSERT INTO `users` VALUES ('anthony',NULL,1,12,'$6$rounds=40000$pK4iz4t4qrQz8p6K$sXO0xxhKlggtfPuYN7K.uDLUUd4w1gRmpsMqC/GG.8j96.8G/VDKqfxem5MkMxmeWKxBFYU91PJodcQQUzs3a/',NULL,'8200e944767643689885d6948e5219d4');
INSERT INTO `users` VALUES ('breu',NULL,1,13,'$6$rounds=40000$X95J.F9DVLEbhyCa$CUduakjUoiDlTAqxP42aTEDzm8w9/c.qnNneBiz5qfkjwCNZsbLc7cCx6GDLDjwPDIgHaqSuVKaf/s7r6sRbv1',NULL,'022c8fbfaa1a46499ba3247950f320d7');
INSERT INTO `users` VALUES ('nati',NULL,1,14,'$6$rounds=40000$QJkfT4CuxhTqCRed$D1JS/9kNEhMNnvPTGpk6nnj1IrnJEbL89rkv9uoycILSA.hvIpZcjlRQYMtOiX4uxLcpfQSXB9vB5joLKi0461',NULL,'febedea71e2e4ba6b12c528612d999ca');
INSERT INTO `users` VALUES ('dtroyer',NULL,1,15,'$6$rounds=40000$DmFFCnK1QadDoPtD$Zfzg8KbMMxLwFw3iTdt7y.vtzZfUKDC5tdK8d2voYGK8ReUGr7uDsJNaGRTeYF90EjPkVLjOMkcADJSSctHrm/',NULL,'22e40b67465a413197c7289afe6c9a22');
INSERT INTO `users` VALUES ('dolph',NULL,1,16,'$6$rounds=40000$w0ru.z/71w3fvzpq$q/LMSXdM9EiFaQ2W.Q2qxfY3wajVoMQhAhWf/7eDmJeaqPrHf34wIJeVBRLePi1Vz3iCNOQgXD05PKZ3OKvp71',NULL,'65d6a6e511c74fe78d6791191acdaf44');
INSERT INTO `users` VALUES ('ben',NULL,1,17,'$6$rounds=40000$DhzVbwN/y3Le7QP9$GWpIJxCB7BDKIACOUiop5XWv.AlhToY/LkcyFueIPWk8vt3ZE8DtfZZhRiCJNBKbaa9InqqDvBaCAYlpy4guc0',NULL,'386a442677cd4334a2f15fa04d86c2b0');
INSERT INTO `users` VALUES ('jordan',NULL,1,18,'$6$rounds=40000$a33/gmDlEDznD3y7$9yFGs09QhWm2vArM5oNRVeqlx7t6.nWefcPJ9t2AoRxuAtFU1wBVKSNlgLsXz1rpRnX8uWksic9jxQR2UBHbc0',NULL,'71212adba4764e9eb62fa7652fac9e73');
INSERT INTO `users` VALUES ('scott',NULL,1,19,'$6$rounds=40000$XJiJTprpatlu.YKQ$7ZJs1dCaOQXqW040dh6VNU6K0UisynSsXP/cF53RwqkBNwU.rAuzw42jB.g.ys7Mzqp0NKS0JSjE9Hcqfh6/B1',NULL,'7799ba7d86c24e218c84e9ad6fb2a210');
INSERT INTO `users` VALUES ('vish',NULL,1,20,'$6$rounds=40000$ca9.0InD3xt8Flzi$o9Ju8oDvtF5Fh7feZR/FyheijlGWSPAXaGuJhPg5Sk1lD24mgaDHEFwJ5mUOQ8R3ct0mVXuYnc.Z.PtN/83sj/',NULL,'5e72bcafe22b4c248e78ca6cb4b32285');
INSERT INTO `users` VALUES ('jakedahn',NULL,1,21,'$6$rounds=40000$Vn.uAcnRpPzNtkdN$PIh./Ys1sJrj/2lSECWD/CV8y3eCY.IzxiUefa7we6EWGeq8c7j11NzpdKIT6wafZNlsWQuE8WlojHv3n0lc8/',NULL,'5dd11ea45d4b42ef80f8aabe9adf5ec5');
INSERT INTO `users` VALUES ('anne',NULL,1,22,'$6$rounds=40000$AbeVz0dHT9Rw5MNP$0MDkPt3OcUz0j.uF6DnaJSuTLdzxepvneltHfIfiZe8xYuMDBk4Kml2zJL9XpUvUTAvle/NBQeJF0Qonv7snj0',NULL,'efc0ab553b444072833a978ef53ac8af');
INSERT INTO `users` VALUES ('jesse',NULL,1,23,'$6$rounds=40000$yMjVIF4YpV4q9Drz$rqnjceFqTWryXFngosK4IzHxx6YgsoG5GsK1wLPawsG2zcyfXVMXPp.hVkU5UBaADiPoE2YQY8c9t8ylDYwBV1',NULL,'e720ea69159f414cacdb7ebd828146c6');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2012-02-13 15:37:55
commit;

t.py

from keystone import config
from keystone.common.sql import legacy

CONF = config.CONF

old_db = 'sqlite:///essex-keystone.sql.sqlite3.db'

args = CONF(['etc/keystone.conf'])

migration = legacy.LegacyMigration(old_db)
migration.migrate_all()