kallithea Changeset - 911dab498eb2

Changeset - 911dab498eb2

Parent rev.

Child rev.

[Not reviewed]

default

0 1 0

Marcin Kuzminski - 16 years ago 2010-04-19 22:52:31
marcin@python-works.com

Updated db manage

1 file changed with 7 insertions and 6 deletions:

pylons_app/lib/db_manage.py

0 comments (0 inline, 0 general)

pylons_app/lib/db_manage.py

➞

Show inline comments

@@ @@ -3,33 +3,34 @@ import sqlite3 @@
 import os
 import crypt
 from os.path import dirname as dn
 ROOT = dn(dn(dn(os.path.realpath(__file__))))
 logging.basicConfig(level=logging.DEBUG)
 def get_sqlite_conn_cur():
     conn = sqlite3.connect(os.path.join(ROOT, 'hg_app.db'))
     cur = conn.cursor()
     return conn, cur
 def check_for_db():
     if os.path.isfile(os.path.join(ROOT, 'hg_app.db')):
         raise Exception('database already exists')
 def check_for_db(override):
     if not override:
         if os.path.isfile(os.path.join(ROOT, 'hg_app.db')):
             raise Exception('database already exists')
 def create_tables():
+def create_tables(override=False):
     """
     Create a auth database
     """
     check_for_db()
+    check_for_db(override)
     conn, cur = get_sqlite_conn_cur()
     try:
         logging.info('creating table %s', 'users')
         cur.execute("""DROP TABLE IF EXISTS users """)
         cur.execute("""CREATE TABLE users
                         (user_id INTEGER PRIMARY KEY AUTOINCREMENT,
                          username TEXT,
                          password TEXT,
                          active INTEGER,
                          admin INTEGER)""")
         logging.info('creating table %s', 'user_logs')
         cur.execute("""DROP TABLE IF EXISTS user_logs """)
@@ @@ -56,16 +57,16 @@ def create_user(username, password, admi @@
     conn, cur = get_sqlite_conn_cur()
     password_crypt = crypt.crypt(password, '6a')
     logging.info('creating user %s', username)
     try:
         cur.execute("""INSERT INTO users values (?,?,?,?,?) """,
                     (None, username, password_crypt, 1, admin))
         conn.commit()
     except:
         conn.rollback()
         raise
 if __name__ == '__main__':
     create_tables()
+    create_tables(True)
     admin_prompt()

0 comments (0 inline, 0 general)