to add counter in the project

[Bharati Sharma]

I want to add counter in my project so that the value in the table increases as the data is put in the database. Can anyone help me plz.

[Jon Black]

That's quite a vague requirement. You could override form_valid() in your view and increment a counter in your model manually before saving. It might pay to ask yourself why you need a counter. Does it make more sense to record the actions in a separate table and count the records? Will the count require filtering later (e.g. number of counts each month, week, day).

 

--

Jon Black

www.jonblack.org

 

 

On Mon, Jul 2, 2012, at 23:25, Bharati Sharma wrote:

I want to add counter in my project so that the value in the table increases as the data is put in the database. Can anyone help me plz.

 

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django...@googlegroups.com.
To unsubscribe from this group, send email to django-users...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

 

[Sandeep kaur]

On Tue, Jul 3, 2012 at 11:55 AM, Bharati Sharma <bharat...@gmail.com> wrote:
> I want to add counter in my project so that the value in the table increases
> as the data is put in the database. Can anyone help me plz.
>

If you want a counter in database, you can make it auto-increment.
Like I want job_no as a counter field in a table, then in models.py, add this :

job_no = models.AutoField(primary_key=True)

But if you want the counter in tables in the template file then add
<td>{{forloop.counter}}</td> as your table field.

Correct me if I am wrong anywhere.

--
Sandeep Kaur
E-Mail: mkaur...@gmail.com
Blog: sandymadaan.wordpress.com

[Bharati Sharma]

thanks Jon...

actually I am making project of faculty management system of my college.I have added some of the faculty member's resume in the database. i want a counter in my project that should increment its value whenever a new faculty member's resume is added into the database. yes, it will require filter also as i want it should count no of assistant professors,no of associate professors etc seperately....help me please..

[Jon Black]

It sounds like you have different user's (User) with different roles (Group with permission set) that have a resume:

 

class Resume(models.Model):

  resume = models.FileField()

  date_uploaded = models.DateTimeField()

 

You can then query by aggregating across the group and date_uploaded fields. That's one option.

 

--

Jon Black

www.jonblack.org

[kenneth gonsalves]

On Tue, 2012-07-03 at 01:08 -0700, Bharati Sharma wrote:
> actually I am making project of faculty management system of my
> college.I
> have added some of the faculty member's resume in the database. i want
> a
> counter in my project that should increment its value whenever a new
> faculty member's resume is added into the database. yes, it will
> require
> filter also as i want it should count no of assistant professors,no of
> associate professors etc seperately....help me please..

you are storing redundant data in the database - not good. If you want
the number of assistant professors, use filter() and count().
--
regards
Kenneth Gonsalves

[Bharati Sharma]

thanks jon... 

[Bharati Sharma]

thanks  kenneth ...but will it count those entries also which I will enter in the database after using filter() and count()?

On Tue, Jul 3, 2012 at 4:06 AM, kenneth gonsalves <law...@thenilgiris.com> wrote:

[kenneth gonsalves]

On Tue, 2012-07-03 at 04:16 -0700, Bharati Sharma wrote:
> thanks kenneth ...but will it count those entries also which I will
> enter
> in the database after using filter() and count()?

if you want to know the number of assistant profs do a query like this:

no_of_asstprofs =
Faculty.objects.filter(job_title='AssistantProf').count()

do not store this in the database - call it when you need it. If you
have a counter, you need to maintain it - increment when adding, reduce
when deleting - which also means setting up signals to adjust the
counter when a model is changed. A huge waste of time and energy.


--
regards
Kenneth Gonsalves

[Bharati Sharma]

sorry  kenneth ...but I have stored information(resume) of professors in the database.

in models.py , i have taken fields like name, dob, qualification,designation etc. then these are saved in the database of every professor.

but the point is designation of professors vary(like there are professors, assistant professors and associate professors).I want that it should count  the no of   professors, assistant professors and associate professors automatically and increments their value after I fill and save the next resume in the database. Is there any logic like this...plz help me. I shall be very thankfull.

--
regards
Kenneth Gonsalves