in the mean time i was able to populate datas's from postgres table by modifying the models.py and views.py as follows:: Models.py: from __future__ import unicode_literals
from django.db import models
class DeviceTable(models.Model):
serial_no = models.IntegerField()
macid = models.CharField(max_length=100, primary_key=True)
class Meta:
db_table = 'device_table'
VIEWS.py::
from django.http import HttpResponse
from django.shortcuts import render_to_response
from django.shortcuts import render
from app.models import DeviceTable
def home(request):
rows = DeviceTable.objects.all()
data = []
for row in rows:
data.append(row.macid)
return render_to_response('app/home.html', {'data':data})
def blisteddevies(request):
return render_to_response(
'app/blisteddevies.html',
)
and in app folder i hav created admin.py::
from django.contrib import admin
from app.models import DeviceTable
admin.site.register(DeviceTable)
NOW what i require is :if i select tick button against that macid to be
blacklisted and click on save it should save it to postgres database table
and also show it on the blacklisted page when i access blacklisted.html
page via django.
Please guide me and i have also attached some screenshots for better idea
of scenario.
Thank you
On Tuesday, 3 December 2013 12:12:10 UTC+5:30, Swastik Acharya wrote:
>
> django 1.4 version
> postgresql 9.1 version
>
> I have successfully loaded all the html files and css on browser using
> django.
> Now i have some tables in postgresql ,which i need to integrate it with
> django and .html files so that data will be read and execute both from html
> file inputs and database table.
> what are the steps to achieve this ?
>
> the home.html contains the macid,hostname,blacklisted etc whatever are
> there in postgresql table.
> i just need to connect and file up those blank spaces in html with data
> from postgresql table.
>
> for ex:
> my folder structure is
> >folder
> >mysite
> >app
> -static
> -style.css
> -main.css
> -templates
> -home.html
> -init.py and init.pyc
> -models.py and models.pyc
> -test.py
> -views.py
>
> >mysite
> -init.py
> -settings.py and settings.pyc
> -urls.py and urls.pyc
> -views.py and views.pyc
> -wsgi.py
> >mysite.db
> >manage.py
>
>
> and in postgresql the table name is device_table
> and its contents are:
>
>
> CREATE TABLE device_table
> (
> serial_no serial NOT NULL,
> macid character varying(100) NOT NULL,
> date_time_of_installation timestamp without time zone,
> blacklisted boolean,
> activated integer,
> deactivated boolean,
> reason character varying(500),
> hostname character varying(255),
> host_ip character varying(50),
> agent_version character varying(75),
> CONSTRAINT device_table_pkey PRIMARY KEY (macid)
> )
> WITH (
> OIDS=FALSE
> );
> ALTER TABLE device_table OWNER TO postgres;
>
> Note:I have created models.py by running inspectdb command.
>
> Waiting for a solution..apart from solutions any guide/advice/suggestion
> are mostly welcome
>
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/2f9cd080-b2e3-44c2-aef1-8f4e4780e8b0%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
<<attachment: blacklist_page.png>>
<<attachment: home.png>>
