first drop

2 files changed, 41 insertions, 0 deletions

diff --git a/jm2l/scripts/__init__.py b/jm2l/scripts/__init__.py
new file mode 100644
index 0000000..5bb534f
--- /dev/null
+++ b/jm2l/scripts/__init__.py
@@ -0,0 +1 @@
+# package
diff --git a/jm2l/scripts/initializedb.py b/jm2l/scripts/initializedb.py
new file mode 100644
index 0000000..1152c07
--- /dev/null
+++ b/jm2l/scripts/initializedb.py
@@ -0,0 +1,40 @@
+# -*- coding: utf8 -*-
+import os
+import sys
+import transaction
+import time
+import lxml.etree as ET
+from datetime import datetime
+from sqlalchemy import engine_from_config
+from sqlalchemy import create_engine
+import unicodedata
+import urllib
+# Usefull tools
+from slugify import slugify
+from sqlite3 import dbapi2 as sqlite
+from os import path
+
+from pyramid.paster import (
+    get_appsettings,
+    setup_logging,
+    )
+    
+    
+from jm2l.models import *
+
+def usage(argv):
+    cmd = os.path.basename(argv[0])
+    print('usage: %s <config_uri>\n'
+          '(example: "%s development.ini")' % (cmd, cmd)) 
+    sys.exit(1)
+
+
+def main(argv=sys.argv):
+    if len(argv) != 2:
+        usage(argv)
+config_uri = "development.ini"
+setup_logging(config_uri)
+settings = get_appsettings(config_uri)
+engine = engine_from_config(settings, 'sqlalchemy.')
+DBSession.configure(bind=engine)
+Base.metadata.create_all(engine)