Database setup got problem, not sure where went wrong

[kang jia]

hi

this is my database in models.py in the Django application, however, i don not know where is the error, i have tried many times, but always got error to set up database, sometimes they claim indention, however, i checked very carefully the indentation should be correct. the following is my database tables

 
from django.db import models
from django import newforms as forms
 
import datetime
 
# Create your models here.
 
class Car(models.Model):
    car_brand = models.CharField(maxlength=50)
    car_model = models.CharField(maxlength=60)
    car_specification = models.TextField()
    booking_price = models.FloatField(max_digits=5, decimal_places=2)
    car_status = models.CharField(maxlength=50)
    car_inventory = models.IntegerField()
    carshot = models.ImageField(upload_to='/images/')
 
    def __str__(self):
        return self.car_brand
 
        class Admin:
            pass
 
        class Meta:
            db_table = 'car'
 
class Address(models.Model):
    unit_level = models.CharField(maxlength=50)
    block_number = models.IntegerField()
    unit_number = models.IntegerField()
    post_code = models.IntegerField()
    street_name = models.TextField()
 
    def __str__(self):
        return self.unit_level
 
        class Admin:
            pass
 
        class Meta:
            db_table = 'address'
 
class Transaction(models.Model):
    customer = models.ForeignKey("auth_user")
    payment_type = models.CharField(maxlength=50)
    total_amount = models.FloatField(max_digits=5, decimal_places=2)
       payment_date = models.DateTimeField()
 
    def __str__(self):
        return self.payment_type    
 
        class Meta:
            db_table = 'transaction'   
 
class Booking(models.Model):
    car_status = models.ForeignKey("car")
    start_date = models.DateTimeField()
    return_date = models.DateTimeField()
    location = models.CharField(maxlength=50)
 
    def __str__(self):
            return self.car_status
 
    class Admin:
            pass
 
    class Meta:
            db_table = 'booking'  
 
 
 

thanks for any help given to enable me set up this database, as without this set up, i can not do any application. i am quite new to this framework, thanks for any kind of help :)

[bartonc]

This one (and all the others above it) looks wrong:

 
class Transaction(models.Model):
    customer = models.ForeignKey("auth_user")
    payment_type = models.CharField(maxlength=50)
    total_amount = models.FloatField(max_digits=5, decimal_places=2)
       payment_date = models.DateTimeField()
 
    def __str__(self):
        return self.payment_type    
   # THIS CLASS IS INDENTED TOO FAR #
        class Meta:
            db_table = 'transaction'   

This one looks right to me:

class Booking(models.Model):
    car_status = models.ForeignKey("car")
    start_date = models.DateTimeField()
    return_date = models.DateTimeField()
    location = models.CharField(maxlength=50)
 
    def __str__(self):
            return self.car_status
 
    class Admin:
            pass
 
    class Meta:
            db_table = 'booking'  
 

Please not that CODE tags look like CODE=python in side the braces and you have an hour to edit your post if it doesn't look right after you hit the Submit button. Thanks.

[kang jia]

This one (and all the others above it) looks wrong:

 
class Transaction(models.Model):
    customer = models.ForeignKey("auth_user")
    payment_type = models.CharField(maxlength=50)
    total_amount = models.FloatField(max_digits=5, decimal_places=2)
       payment_date = models.DateTimeField()
 
    def __str__(self):
        return self.payment_type    
   # THIS CLASS IS INDENTED TOO FAR #
        class Meta:
            db_table = 'transaction'   

This one looks right to me:

class Booking(models.Model):
    car_status = models.ForeignKey("car")
    start_date = models.DateTimeField()
    return_date = models.DateTimeField()
    location = models.CharField(maxlength=50)
 
    def __str__(self):
            return self.car_status
 
    class Admin:
            pass
 
    class Meta:
            db_table = 'booking'  
 

Please not that CODE tags look like CODE=python in side the braces and you have an hour to edit your post if it doesn't look right after you hit the Submit button. Thanks.

thanks for your kind reminder, but i am still not sure where went wrong? can tell me what i should do in order to set up this database correctly?

[bartonc]

thanks for your kind reminder, but i am still not sure where went wrong? can tell me what i should do in order to set up this database correctly?

It turns out that you do have indentation errors (3 tabs instead of 2, etc.). Here it is, corrected:

 
from django.db import models
from django import newforms as forms
 
import datetime
 
# Create your models here.
 
class Car(models.Model):
    car_brand = models.CharField(maxlength=50)
    car_model = models.CharField(maxlength=60)
    car_specification = models.TextField()
    booking_price = models.FloatField(max_digits=5, decimal_places=2)
    car_status = models.CharField(maxlength=50)
    car_inventory = models.IntegerField()
    carshot = models.ImageField(upload_to='/images/')
 
    def __str__(self):
        return self.car_brand
 
    class Admin:
        pass
 
    class Meta:
        db_table = 'car'
 
class Address(models.Model):
    unit_level = models.CharField(maxlength=50)
    block_number = models.IntegerField()
    unit_number = models.IntegerField()
    post_code = models.IntegerField()
    street_name = models.TextField()
 
    def __str__(self):
        return self.unit_level
 
    class Admin:
        pass
 
    class Meta:
        db_table = 'address'
 
class Transaction(models.Model):
    customer = models.ForeignKey("auth_user")
    payment_type = models.CharField(maxlength=50)
    total_amount = models.FloatField(max_digits=5, decimal_places=2)
       payment_date = models.DateTimeField()
 
    def __str__(self):
        return self.payment_type    
 
    class Meta:
        db_table = 'transaction'   
 
class Booking(models.Model):
    car_status = models.ForeignKey("car")
    start_date = models.DateTimeField()
    return_date = models.DateTimeField()
    location = models.CharField(maxlength=50)
 
    def __str__(self):
        return self.car_status
 
    class Admin:
        pass
 
    class Meta:
        db_table = 'booking'  
 

[kang jia]

It turns out that you do have indentation errors (3 tabs instead of 2, etc.). Here it is, corrected:
[code=python]

from django.db import models
from django import newforms as forms

import datetime

# Create your models here.

class Car(models.Mode l):
car_brand = models.CharFiel d(maxlength=50)
car_model = models.CharFiel d(maxlength=60)
car_specificati on = models.TextFiel d()
booking_price = models.FloatFie ld(max_digits=5 , decimal_places= 2)
car_status = models.CharFiel d(maxlength=50)
car_inventory = models.IntegerF ield()
carshot = models.ImageFie ld(upload_to='/images/')

def __str__(self):
return self.car_brand

class Admin:
pass

class Meta:
db_table = 'car'

class Address(models. Model):
unit_level = models.CharFiel d(maxlength=50)
block_number = models.IntegerF ield()
unit_number = models.IntegerF ield()
post_code = models.IntegerF ield()
street_name = models.TextFiel d()

def __str__(self):
return self.unit_level

class Admin:
pass

class Meta:
db_table = 'address'

class Transaction(mod els.Model):
customer = models.ForeignK ey("auth_user" )
payment_type = models.CharFiel d(maxlength=50)
total_amount = models.FloatFie ld(max_digits=5 , decimal_places= 2)
payment_date = models.DateTime Field()

def __str__(self):
return self.payment_ty pe

class Meta:
db_table = 'transaction'

class Booking(models. Model):
car_status = models.ForeignK ey("car")
start_date = models.DateTime Field()
return_date = models.DateTime Field()
location = models.CharFiel d(maxlength=50)

def __str__(self):
return self.car_status

class Admin:
pass

class Meta:
db_table = 'booking'
[-code]

really thanks for your so kind help, i have setted up my database. actually, i did not import image library of Django and i use in the field ImageField(uplo ad_to='/images/'), thus the program complain. however, here i still have one question.
As you know i make use of Django's user authentication system to set up my database tables, thus it only provide me two fields available in the template, i mean only username and password field, how can i include Email, NRIC ( for Singaporean) and Passport No for foreigner? do i really have to setup another table for user/member? can i add into auth_user table, in fact, i have noticed that auth_user table got one field called Email, but i am not sure how to activate its function. can help me with this. thanks so much :)

[bartonc]

really thanks for your so kind help, i have setted up my database. actually, i did not import image library of Django and i use in the field ImageField(uplo ad_to='/images/'), thus the program complain. however, here i still have one question.
As you know i make use of Django's user authentication system to set up my database tables, thus it only provide me two fields available in the template, i mean only username and password field, how can i include Email, NRIC ( for Singaporean) and Passport No for foreigner? do i really have to setup another table for user/member? can i add into auth_user table, in fact, i have noticed that auth_user table got one field called Email, but i am not sure how to activate its function. can help me with this. thanks so much :)

I'm sorry to say that I don't know a thing about internet programming.
I have only been able to spot errors in your python code because I have been working with python every day for years.

[kang jia]

I'm sorry to say that I don't know a thing about internet programming.
I have only been able to spot errors in your python code because I have been working with python every day for years.

never mind, i still would like to thank you for your kind help, however, if possible, could forward my problems to some one who know more of Django, i am really sorry about this as this is my Final year project, thus the time line is also quite tight, there is only few weeks before i submit. thanks for all your kind help to me...:)