from django.db import models
from django.contrib import admin

class SourcePackage (models.Model):
  name = models.CharField(max_length=1024)
  version = models.CharField(max_length=1024)
  format = models.CharField(max_length=64)
  loc = models.CharField(max_length=4096)
  diffgz_name = models.CharField(max_length=4096, null=True, blank=True)
  diffgz_size = models.IntegerField(null=True, blank=True)
  diffgz_md5sum = models.CharField(max_length=32, null=True, blank=True)
  debtar_name = models.CharField(max_length=4096, null=True, blank=True)
  debtar_size = models.IntegerField(null=True, blank=True)
  debtar_md5sum = models.CharField(max_length=32, null=True, blank=True)
  maintainer = models.CharField(max_length=1024)
  uploaders = models.CharField(max_length=4096, null=True, blank=True)

  def __unicode__( self ):
    return "%s (%s)"%(self.name, self.version)

  class Meta:
    managed = False
    db_table = 'packages'
    unique_together = (('name','version'),)

class RepositorySuite (models.Model):
  name = models.CharField(max_length=1024, unique=True)

  def __unicode__( self ):
    return unicode(self.name)

  class Meta:
    managed = False
    db_table = 'suites'

class RepositoryComponent (models.Model):
  name = models.CharField(max_length=1024, unique=True)

  def __unicode__( self ):
    return unicode(self.name)

  class Meta:
    managed = False
    db_table = 'components'

class SourcePackageMapping (models.Model):
  rowid = models.AutoField(primary_key=True)
  package = models.ForeignKey(SourcePackage)
  suite = models.ForeignKey(RepositorySuite)
  component = models.ForeignKey(RepositoryComponent)

  def __unicode__( self ):
    return "%s / %s / %s"%(unicode(self.package),unicode(self.suite),unicode(self.component))

  class Meta:
    managed = False
    db_table = 'package_rel_map'
    unique_together = (('package','suite','component'),)

admin.site.register(SourcePackage)
admin.site.register(RepositorySuite)
admin.site.register(RepositoryComponent)
admin.site.register(SourcePackageMapping)