Redsuncube: django Project-10 (working on sql command)

Showing posts with label django Project-10 (working on sql command). Show all posts

Tutorial 6: sql command(update)

views.py
===

############### standard library files##########
from django.shortcuts import *
from django.http import *

########### support files/library/etc.... of app #################
from dmlapp.forms import EmployeeForm
from dmlapp.models import employee

################## insert query in django.######################

def insert(request):
    ename=request.POST.get('ename')
################## this will give you the textbox #################
    if request.method == 'GET':
        form = EmployeeForm()
    else:
         form = EmployeeForm(request.POST)
################ insert query in django    ##############################
         if form.is_valid():
             a = employee(ename=ename)
             a.save()
             return redirect('/insert/')
    return render(request, 'insert.html', {'form': form})

######################## end of insert query ######################

################# select query in django####################

def select(request):
    emp=employee.objects.all()
    return render(request,'select.html',{'emp':emp})

################# end of select query ########################

def index(request):
    return render(request,'index.html')

def delete(request):
    empname=employee.objects.all()
    ename = request.POST.get('dropdown1')
    if request.method == 'GET':
        form = EmployeeForm()
    else:
        empname = employee.objects.get(ename = ename)
        empname.delete()
        return redirect('/delete/')
    return render(request, 'delete.html', {'form': form, 'empname':empname})

def update(request):
    empname=employee.objects.all()
    ename1 = request.POST.get('dropdown1')
    ename2 = request.POST.get('emp_update')

    if request.method == 'GET':
        form = EmployeeForm()
    else:
        empname = employee.objects.filter(id = ename1).update(ename = ename2)

        return redirect('/update/')
    return render(request, 'update.html', {'form': form, 'empname':empname})

update.html
=======

{% block content %}

    <h2>Delete User</h1>
   <form action="{% url 'update' %}" method="POST" >{% csrf_token %}
    <table>
    <tr><td>employee Name:</td>
        <td>
            <select name="dropdown1">
                {% for empname in empname %}
                     <option value="{{ empname.id }}">{{ empname.ename }}</option>
                {% endfor %}
            </select>

        </td>
    <td>update the emp name<input type="text" name="emp_update" placeholder="enter the value to update" /></td>    <td><input type="submit" value="update employee name" /></td></tr>
    </table>

{% endblock %}

Tutorial 5: sql command(delete)

view.py
=====

############### standard library files##########
from django.shortcuts import *
from django.http import *

########### support files/library/etc.... of app #################
from dmlapp.forms import EmployeeForm
from dmlapp.models import employee

################## insert query in django.######################

def insert(request):
    ename=request.POST.get('ename')
################## this will give you the textbox #################
    if request.method == 'GET':
        form = EmployeeForm()
    else:
         form = EmployeeForm(request.POST)
################ insert query in django    ##############################
         if form.is_valid():
             a = employee(ename=ename)
             a.save()
             return redirect('/insert/')
    return render(request, 'insert.html', {'form': form})

######################## end of insert query ######################

################# select query in django####################

def select(request):
    emp=employee.objects.all()
    return render(request,'select.html',{'emp':emp})

################# end of select query ########################

def index(request):
    return render(request,'index.html')

def delete(request):
    empname=employee.objects.all()
    ename = request.POST.get('dropdown1')
    if request.method == 'GET':
        form = EmployeeForm()
    else:
        empname = employee.objects.get(ename = ename)
        empname.delete()
        return redirect('/delete/')
    return render(request, 'delete.html', {'form': form, 'empname':empname})

def update(request):
    return render(request,'update.html')

delete.html
=====

{% block content %}

    <h2>Delete User</h1>
   <form action="{% url 'delete' %}" method="POST" >{% csrf_token %}
    <table>
    <tr><td>employee Name:</td>
        <td>
            <select name="dropdown1">
                {% for empname in empname %}
                     <option value="{{ empname.ename }}">{{ empname.ename }}</option>
                {% endfor %}
            </select>
        </td>
    <td><input type="submit" value="Delete employee" /></td></tr>
    </table>

{% endblock %}

o/p
====

Delete User

Tutorial 4: sql command(select)

Views.py
========

############### standard library files##########
from django.shortcuts import *
from django.http import *

########### support files/library/etc.... of app #################
from dmlapp.forms import EmployeeForm
from dmlapp.models import employee

################## insert query in django.######################

def insert(request):
    ename=request.POST.get('ename')
################## this will give you the textbox #################
    if request.method == 'GET':
        form = EmployeeForm()
    else:
         form = EmployeeForm(request.POST)
################ insert query in django    ##############################
         if form.is_valid():
             a = employee(ename=ename)
             a.save()
             return redirect('/insert/')
    return render(request, 'insert.html', {'form': form})

######################## end of insert query ######################

################# select query in django####################

def select(request):
    emp=employee.objects.all()
    return render(request,'select.html',{'emp':emp})

################# end of select query ########################

def index(request):
    return render(request,'index.html')

def delete(request):
    return render(request,'delete.html')

def update(request):
    return render(request,'update.html')

urls.py
=====

from django.conf.urls import include, url
from django.contrib import admin
from dmlapp.views import *
urlpatterns = [
    url(r'^admin/', include(admin.site.urls)),
    url(r'^$','dmlapp.views.index', name='index'),
    url(r'^insert/$','dmlapp.views.insert', name='insert'),
    url(r'^delete/$','dmlapp.views.delete', name='delete'),
    url(r'^update/$','dmlapp.views.update', name='update'),
    url(r'^select/$','dmlapp.views.select', name='select'),

]

select.html
======

{% block content %}

    <h2>employee list</h1>
{% for emp in emp %}

<ul><li>
{{emp.ename}}
</li></ul>
{% endfor %}

{% endblock %}

o/p

===

employee list

django

python

Tutorial 3: sql command(Insert)

Come to previous model i change the field user to ename

model.py
======
from django.db import models

class employee(models.Model):
    ename = models.CharField(max_length=100)

terminal
=======

erp@erp-Inspiron-N5110:~/dml$ python manage.py makemigrations
Did you rename employee.user to employee.ename (a CharField)? [y/N] y
Migrations for 'dmlapp':
0002_auto_20150918_0731.py:
    - Rename field user on employee to ename
erp@erp-Inspiron-N5110:~/dml$ python manage.py migrate
Operations to perform:
Synchronize unmigrated apps: staticfiles, messages
Apply all migrations: admin, contenttypes, dmlapp, auth, sessions
Synchronizing apps without migrations:
Creating tables...
    Running deferred SQL...
Installing custom SQL...
Running migrations:
Rendering model states... DONE
Applying dmlapp.0002_auto_20150918_0731... OK

url.py
=====

from django.conf.urls import include, url
from django.contrib import admin
from dmlapp.views import *
urlpatterns = [
    url(r'^admin/', include(admin.site.urls)),
    url(r'^$','dmlapp.views.index', name='index'),
    url(r'^insert/$','dmlapp.views.insert', name='insert'),
    url(r'^delete/$','dmlapp.views.delete', name='delete'),
    url(r'^update/$','dmlapp.views.update', name='update'),

]

insert.html
========

{% block content %}

    <h2>Adding User</h1>
    <form action="{% url 'insert' %}" method="POST" >{% csrf_token %}

    <table>
    <tr><td>employee Name :</td><td>{{form.ename}}</td><td>{{ form.ename.errors }}</td></tr>
    <tr><td></td><td><input type="submit" value="Save Changes" /></td></tr>
    </table>
</form>
{% endblock %}

form.py
=====

from dmlapp.models import employee
from django import forms

import warnings

class EmployeeForm(forms.Form):
    ename = forms.CharField(max_length=200,label=("employee Name:"), required=True)

view.py
=====

############### standard library files##########
from django.shortcuts import *
from django.http import *

########### support files/library/etc.... of app #################
from dmlapp.forms import EmployeeForm
from dmlapp.models import employee

################## insert query in django.######################

def insert(request):
    ename=request.POST.get('ename')
################## this will give you the textbox #################
    if request.method == 'GET':
        form = EmployeeForm()
    else:
         form = EmployeeForm(request.POST)
################ insert query in django    ##############################
         if form.is_valid():
             a = employee(ename=ename)
             a.save()
             return redirect('/insert/')
    return render(request, 'insert.html', {'form': form})

######################## end of insert query ######################

def index(request):
    return render(request,'index.html')

def delete(request):
    return render(request,'delete.html')

def update(request):
    return render(request,'update.html')

in mysql
=====
mysql> select * from dmlapp_employee;
Empty set (0.00 sec)

o/p
===

Adding User

enter the django in the test box

and press save changes

in mysql
======

mysql> select * from dmlapp_employee;
+----+--------+
| id | ename |
+----+--------+
| 6 | django |
+----+--------+
1 row in set (0.00 sec)

############ end of insert query using django #################

Tutorial 2: get ready the pages for sql command

create the database
==================

model.py
=======

from django.db import models

class employee(models.Model):
    user = models.CharField(max_length=100)

terminal Help(according to the status of your project database
=======

if the database and tables are not created

$python manage.py syncdb

if the database and tables are created

$python manage.py migrate

if the new tables is created in the database

python manage.py makemigrations

my status in terminal
========

erp@erp-Inspiron-N5110:~/dml$ python manage.py makemigrations

Migrations for 'dmlapp':
0001_initial.py:
    - Create model employee
erp@erp-Inspiron-N5110:~/dml$

create or update the pages(index,insert,delete,update)
===================================

templates/delete.html
---------------

<html>
<body>
sql command

<br>
<a href="/insert/">insert</a>
<br>
<a href="/delete/">delete</a>
<br>
<a href="/update/">update</a>
delete page

</body></html>

index.html
---------

<html>
<body>

index page
sql command

<br>
<a href="/insert/">insert</a>
<br>
<a href="/delete/">delete</a>
<br>
<a href="/update/">update</a>

</body></html>

insert.html
----------

<html>
<body>
index page
sql command

<br>
<a href="/insert/">insert</a>
<br>
<a href="/delete/">delete</a>
<br>
<a href="/update/">update</a>

</body></html>

update.html
--------

<html>
<body>
sql command

<br>
<a href="/insert/">insert</a>
<br>
<a href="/delete/">delete</a>
<br>
<a href="/update/">update</a>

update page

</body></html>

Update views.py and url.py
===================

views.py
-----

from django.shortcuts import render

# Create your views here.

def index(request):
    return render(request,'index.html')

def insert(request):
    return render(request,'insert.html')

def delete(request):
    return render(request,'delete.html')

def update(request):
    return render(request,'update.html')

url.py
-----

from django.conf.urls import include, url
from django.contrib import admin
from dmlapp.views import *
urlpatterns = [
    url(r'^admin/', include(admin.site.urls)),
    url(r'^$','dmlapp.views.index', name='index'),
    url(r'^insert/$','dmlapp.views.insert', name='insert'),
    url(r'^delete/$','dmlapp.views.delete', name='delete'),
    url(r'^update/$','dmlapp.views.update', name='update'),

]

o/p

===

Tutorial 1: how to set the template and get the message hai welcome

Step:1(created the project and run it)
-----
$django-admin startproject dml
$cd dml
dml$ python manage.py runserver
Performing system checks...

System check identified no issues (0 silenced).
September 18, 2015 - 06:18:57
Django version 1.8.3, using settings 'dml.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CONTROL-C.

Step:2(create a app)
-------
dml$ python manage.py startapp dmlapp

Step:3(create templates,index.html)(update setting.py,url.py,view.py)
-------
1. first create a template folder in dmlapp folder
2. in the template folder create index.html page

ie.

<html>
<body>hai welcome
</body></html>

Step:4(update setting.py,url.py,view.py)
------

dmlapp/view.py
-------

from django.shortcuts import render

# Create your views here.

def index(request):
    return render(request,'index.html')

url.py
----
from django.conf.urls import include, url
from django.contrib import admin
from dmlapp.views import index
urlpatterns = [
    url(r'^admin/', include(admin.site.urls)),
    url(r'^$','dmlapp.views.index', name='index'),

]

setting.py
---------

INSTALLED_APPS = (
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'dmlapp',
)

$python manage.py runserver

output:

Redsuncube