Re: How to integrate Postgresql db with Django,so that data will be retrieved from that postgresql db table and show it on browser via html

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 django-users+unsubscribe@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
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.