[subversion:1] inspectdb on trac.db

[esimorre@kenai.com]

Repository: subversion
Revision:   1
Author:     esimorre
Date:       2008-10-01 12:42:15 UTC

Log Message:
-----------
inspectdb on trac.db

Added Paths:
-----------
   
tracdb/admin.pytracdbtracdb/models.pyinspectdb.py__init__.pymanage.pytr
acdb/__init__.pytracdb/views.pyurls.pysettings.py

Diffs:
-----
Index: manage.py
===================================================================
--- manage.py   (revision 0)
+++ manage.py   (revision 1)
@@ -0,0 +1,11 @@
+#!/usr/bin/env python
+from django.core.management import execute_manager
+try:
+    import settings # Assumed to be in the same directory.
+except ImportError:
+    import sys
+    sys.stderr.write("Error: Can't find the file 'settings.py' in the
directory containing %r. It appears you've customized things.\nYou'll
have to run django-admin.py, passing it your settings module.\n(If the
file settings.py does indeed exist, it's causing an ImportError
somehow.)\n" % __file__)
+    sys.exit(1)
+
+if __name__ == "__main__":
+    execute_manager(settings)

Property changes on: manage.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: tracdb/admin.py
===================================================================

Property changes on: tracdb/admin.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: tracdb/views.py
===================================================================
--- tracdb/views.py     (revision 0)
+++ tracdb/views.py     (revision 1)
@@ -0,0 +1 @@
+# Create your views here.

Property changes on: tracdb/views.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: tracdb/__init__.py
===================================================================

Property changes on: tracdb/__init__.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: tracdb/models.py
===================================================================
--- tracdb/models.py    (revision 0)
+++ tracdb/models.py    (revision 1)
@@ -0,0 +1,157 @@
+from django.db import models
+
+# direct from inspectdb
+
+class Attachment(models.Model):
+    type = models.TextField(blank=True)
+    id = models.TextField(blank=True)
+    filename = models.TextField(blank=True)
+    size = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    author = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    class Meta:
+        db_table = u'attachment'
+
+class AuthCookie(models.Model):
+    cookie = models.TextField(blank=True)
+    name = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'auth_cookie'
+
+class Component(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    owner = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'component'
+
+class Enum(models.Model):
+    type = models.TextField(blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'enum'
+
+class Milestone(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    due = models.IntegerField(null=True, blank=True)
+    completed = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'milestone'
+
+class NodeChange(models.Model):
+    rev = models.TextField(blank=True)
+    path = models.TextField(blank=True)
+    node_type = models.TextField(blank=True)
+    change_type = models.TextField(blank=True)
+    base_path = models.TextField(blank=True)
+    base_rev = models.TextField(blank=True)
+    class Meta:
+        db_table = u'node_change'
+
+class Permission(models.Model):
+    username = models.TextField(blank=True)
+    action = models.TextField(blank=True)
+    class Meta:
+        db_table = u'permission'
+
+class Report(models.Model):
+    id = models.IntegerField(null=True, primary_key=True, blank=True)
+    author = models.TextField(blank=True)
+    title = models.TextField(blank=True)
+    query = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'report'
+
+class Revision(models.Model):
+    rev = models.TextField(primary_key=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    message = models.TextField(blank=True)
+    class Meta:
+        db_table = u'revision'
+
+class Session(models.Model):
+    sid = models.TextField(blank=True)
+    authenticated = models.IntegerField(null=True, blank=True)
+    last_visit = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'session'
+
+class SessionAttribute(models.Model):
+    sid = models.TextField(blank=True)
+    authenticated = models.IntegerField(null=True, blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'session_attribute'
+
+class System(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'system'
+
+class Ticket(models.Model):
+    id = models.IntegerField(null=True, primary_key=True, blank=True)
+    type = models.TextField(blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    changetime = models.IntegerField(null=True, blank=True)
+    component = models.TextField(blank=True)
+    severity = models.TextField(blank=True)
+    priority = models.TextField(blank=True)
+    owner = models.TextField(blank=True)
+    reporter = models.TextField(blank=True)
+    cc = models.TextField(blank=True)
+    version = models.TextField(blank=True)
+    milestone = models.TextField(blank=True)
+    status = models.TextField(blank=True)
+    resolution = models.TextField(blank=True)
+    summary = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    keywords = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket'
+
+class TicketChange(models.Model):
+    ticket = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    field = models.TextField(blank=True)
+    oldvalue = models.TextField(blank=True)
+    newvalue = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket_change'
+
+class TicketCustom(models.Model):
+    ticket = models.IntegerField(null=True, blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket_custom'
+
+class Version(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'version'
+
+class Wiki(models.Model):
+    name = models.TextField(blank=True)
+    version = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    text = models.TextField(blank=True)
+    comment = models.TextField(blank=True)
+    readonly = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'wiki'
+

Property changes on: tracdb/models.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: inspectdb.py
===================================================================
--- inspectdb.py        (revision 0)
+++ inspectdb.py        (revision 1)
@@ -0,0 +1,164 @@
+# This is an auto-generated Django model module.
+# You'll have to do the following manually to clean this up:
+#     * Rearrange models' order
+#     * Make sure each model has one field with primary_key=True
+# Feel free to rename the models, but don't rename db_table values or
field names.
+#
+# Also note: You'll have to insert the output of 'django-admin.py
sqlcustom [appname]'
+# into your database.
+
+from django.db import models
+
+class Attachment(models.Model):
+    type = models.TextField(blank=True)
+    id = models.TextField(blank=True)
+    filename = models.TextField(blank=True)
+    size = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    author = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    class Meta:
+        db_table = u'attachment'
+
+class AuthCookie(models.Model):
+    cookie = models.TextField(blank=True)
+    name = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'auth_cookie'
+
+class Component(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    owner = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'component'
+
+class Enum(models.Model):
+    type = models.TextField(blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'enum'
+
+class Milestone(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    due = models.IntegerField(null=True, blank=True)
+    completed = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'milestone'
+
+class NodeChange(models.Model):
+    rev = models.TextField(blank=True)
+    path = models.TextField(blank=True)
+    node_type = models.TextField(blank=True)
+    change_type = models.TextField(blank=True)
+    base_path = models.TextField(blank=True)
+    base_rev = models.TextField(blank=True)
+    class Meta:
+        db_table = u'node_change'
+
+class Permission(models.Model):
+    username = models.TextField(blank=True)
+    action = models.TextField(blank=True)
+    class Meta:
+        db_table = u'permission'
+
+class Report(models.Model):
+    id = models.IntegerField(null=True, primary_key=True, blank=True)
+    author = models.TextField(blank=True)
+    title = models.TextField(blank=True)
+    query = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'report'
+
+class Revision(models.Model):
+    rev = models.TextField(primary_key=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    message = models.TextField(blank=True)
+    class Meta:
+        db_table = u'revision'
+
+class Session(models.Model):
+    sid = models.TextField(blank=True)
+    authenticated = models.IntegerField(null=True, blank=True)
+    last_visit = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'session'
+
+class SessionAttribute(models.Model):
+    sid = models.TextField(blank=True)
+    authenticated = models.IntegerField(null=True, blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'session_attribute'
+
+class System(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'system'
+
+class Ticket(models.Model):
+    id = models.IntegerField(null=True, primary_key=True, blank=True)
+    type = models.TextField(blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    changetime = models.IntegerField(null=True, blank=True)
+    component = models.TextField(blank=True)
+    severity = models.TextField(blank=True)
+    priority = models.TextField(blank=True)
+    owner = models.TextField(blank=True)
+    reporter = models.TextField(blank=True)
+    cc = models.TextField(blank=True)
+    version = models.TextField(blank=True)
+    milestone = models.TextField(blank=True)
+    status = models.TextField(blank=True)
+    resolution = models.TextField(blank=True)
+    summary = models.TextField(blank=True)
+    description = models.TextField(blank=True)
+    keywords = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket'
+
+class TicketChange(models.Model):
+    ticket = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    field = models.TextField(blank=True)
+    oldvalue = models.TextField(blank=True)
+    newvalue = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket_change'
+
+class TicketCustom(models.Model):
+    ticket = models.IntegerField(null=True, blank=True)
+    name = models.TextField(blank=True)
+    value = models.TextField(blank=True)
+    class Meta:
+        db_table = u'ticket_custom'
+
+class Version(models.Model):
+    name = models.TextField(primary_key=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    description = models.TextField(blank=True)
+    class Meta:
+        db_table = u'version'
+
+class Wiki(models.Model):
+    name = models.TextField(blank=True)
+    version = models.IntegerField(null=True, blank=True)
+    time = models.IntegerField(null=True, blank=True)
+    author = models.TextField(blank=True)
+    ipnr = models.TextField(blank=True)
+    text = models.TextField(blank=True)
+    comment = models.TextField(blank=True)
+    readonly = models.IntegerField(null=True, blank=True)
+    class Meta:
+        db_table = u'wiki'
+

Property changes on: inspectdb.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: __init__.py
===================================================================

Property changes on: __init__.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: settings.py
===================================================================
--- settings.py (revision 0)
+++ settings.py (revision 1)
@@ -0,0 +1,81 @@
+# Django settings for django_trac project.
+
+DEBUG = True
+TEMPLATE_DEBUG = DEBUG
+
+ADMINS = (
+    # ('Your Name', 'your_email@domain.com'),
+)
+
+MANAGERS = ADMINS
+
+DATABASE_ENGINE = 'sqlite3'           # 'postgresql_psycopg2',
'postgresql', 'mysql', 'sqlite3' or 'oracle'.
+DATABASE_NAME = 'trac.db'             # Or path to database file if
using sqlite3.
+DATABASE_USER = ''             # Not used with sqlite3.
+DATABASE_PASSWORD = ''         # Not used with sqlite3.
+DATABASE_HOST = ''             # Set to empty string for localhost.
Not used with sqlite3.
+DATABASE_PORT = ''             # Set to empty string for default. Not
used with sqlite3.
+
+# Local time zone for this installation. Choices can be found here:
+# http://en.wikipedia.org/wiki/List_of_tz_zones_by_name
+# although not all choices may be available on all operating systems.
+# If running in a Windows environment this must be set to the same as
your
+# system time zone.
+TIME_ZONE = 'America/Chicago'
+
+# Language code for this installation. All choices can be found here:
+# http://www.i18nguy.com/unicode/language-identifiers.html
+LANGUAGE_CODE = 'en-us'
+
+SITE_ID = 1
+
+# If you set this to False, Django will make some optimizations so as
not
+# to load the internationalization machinery.
+USE_I18N = True
+
+# Absolute path to the directory that holds media.
+# Example: "/home/media/media.lawrence.com/"
+MEDIA_ROOT = ''
+
+# URL that handles the media served from MEDIA_ROOT. Make sure to use
a
+# trailing slash if there is a path component (optional in other
cases).
+# Examples: "http://media.lawrence.com", "http://example.com/media/";
+MEDIA_URL = ''
+
+# URL prefix for admin media -- CSS, JavaScript and images. Make sure
to use a
+# trailing slash.
+# Examples: "http://foo.com/media/", "/media/";.
+ADMIN_MEDIA_PREFIX = '/media/'
+
+# Make this unique, and don't share it with anybody.
+SECRET_KEY = '*@jf+sv(s&e!&e#^!*6+!&=ho6mi@c*ei2=k*fw%@#fm4gf)ej'
+
+# List of callables that know how to import templates from various
sources.
+TEMPLATE_LOADERS = (
+    'django.template.loaders.filesystem.load_template_source',
+    'django.template.loaders.app_directories.load_template_source',
+#     'django.template.loaders.eggs.load_template_source',
+)
+
+MIDDLEWARE_CLASSES = (
+    'django.middleware.common.CommonMiddleware',
+    'django.contrib.sessions.middleware.SessionMiddleware',
+    'django.contrib.auth.middleware.AuthenticationMiddleware',
+)
+
+ROOT_URLCONF = 'django_trac.urls'
+
+TEMPLATE_DIRS = (
+    # Put strings here, like "/home/html/django_templates" or
"C:/www/django/templates".
+    # Always use forward slashes, even on Windows.
+    # Don't forget to use absolute paths, not relative paths.
+)
+
+INSTALLED_APPS = (
+    'django.contrib.auth',
+    'django.contrib.contenttypes',
+    'django.contrib.sessions',
+    'django.contrib.sites',
+    'django.contrib.admin',
+    'django_trac.tracdb',
+)

Property changes on: settings.py
___________________________________________________________________
Name: svn:keywords
   + Id

Index: urls.py
===================================================================
--- urls.py     (revision 0)
+++ urls.py     (revision 1)
@@ -0,0 +1,17 @@
+from django.conf.urls.defaults import *
+
+# Uncomment the next two lines to enable the admin:
+from django.contrib import admin
+admin.autodiscover()
+
+urlpatterns = patterns('',
+    # Example:
+    # (r'^django_trac/', include('django_trac.foo.urls')),
+
+    # Uncomment the admin/doc line below and add
'django.contrib.admindocs' 
+    # to INSTALLED_APPS to enable admin documentation:
+    (r'^admin/doc/', include('django.contrib.admindocs.urls')),
+
+    # Uncomment the next line to enable the admin:
+    (r'^admin/(.*)', admin.site.root),
+)

Property changes on: urls.py
___________________________________________________________________
Name: svn:keywords
   + Id