StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODjango/MySQL time datatype
primarykey
Id
12809448
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2012-10-09T22:42:04.803
FavoriteCount
0
LastActivityDate
2015-10-04T20:37:53.630
LastEditDate
2012-10-11T15:36:56.630
LastEditorUserId
268418
OwnerUserId
268418
ParentId
0
PostTypeId
1
Score
0
ViewCount
453
LastEditorDisplayName
text
Body
I´m using Django to import from an existing mysql database thats already created and is used by somebody else. Im using: <pre><code>python manage.py inspectdb > models.py </code></pre> And the class from my model in question is the following: <pre><code>class Funciones(models.Model): idfuncion = models.IntegerField(primary_key=True) idpelicula = models.ForeignKey(Peliculas, db_column='idpelicula') idcine = models.ForeignKey(Cines, db_column='idcine') hora = models.TextField() # This field type is a guess. tipo_3d = models.IntegerField(null=True, db_column=u'3d', blank=True) # Field renamed xd = models.IntegerField(null=True, blank=True) gtmax = models.IntegerField(null=True, blank=True) vip = models.IntegerField(null=True, blank=True) idioma = models.CharField(max_length=33) idciudad = models.ForeignKey(Ciudades, db_column='idciudad') class Meta: db_table = u'funciones' </code></pre> Now this attribute: hora = models.TextField() # This field type is a guess corresponds to a time dataType in MYSQL. Now, since I cant change the dataType in MYSQL because somebody else has already created a number of queries to the database from another app, I would like to know what would be the appropriate corresponding django datatype that I should use in my django model. I was thinking DateTimeField but then I should have to somehow truncate the date part before writing to the database. Any ideas? Thanks Edit: As pointed out by Pedro: Django actually has a TimeField, why not use that? – Pedro Romano
Tags
<python><mysql><django>
Title
Django/MySQL time datatype
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USedu222
UserOwnerUserId
1. USedu222
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. CODjango actually has a [TimeField](https://docs.djangoproject.com/en/dev/ref/models/fields/#timefield), why not use that?
 singulars
 PostPostId
 PODjango/MySQL time datatype
 UserUserId
 USPedro Romano
2. COOops, my bad, seems like I missed the *TimeField*. Thanks!
 singulars
 PostPostId
 PODjango/MySQL time datatype
 UserUserId
 USedu222

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.