Posts

Django Class Based Views Blog App

 Models class Blog(models.Model):     title = models.CharField(max_length =200)     description = models.TextField()     def __str__(self):         return self.title Python manage.py makemigrations Python manage.py migrate views from .models import Blog from django.views.generic.edit import CreateView from django.views.generic.list import ListView from django.views.generic.edit import DeleteView from django.views.generic.edit import UpdateView class BlogCreate(CreateView):     model =  Blog     fields = '__all__'     success_url = '/blog' class BlogList(ListView):     model = Blog class BlogDelete(DeleteView):     model = Blog     success_url = '/list' class BlogUpdate(UpdateView):     model = Blog     fields = '__all__'     template_name = 'dapp/blog_form.html'     success_url = '/list' urls from .views import BlogCreate from .v...
Post a Comment
Read more

Django Search

 Html Form <form action="{% url 'search' %}" method="GET">       <input type="text" placeholder="Search.." name="q">       <button type="submit">Submit</button>     </form> views.py def query(request):     q = request.GET['q']     results = Image.objects.filter(name__icontains=q)     context= {         'results': results,     }     return render(request,"site.html",context) urls.py urlpatterns = [         path('search/',views.query,name='search'), ]
Post a Comment
Read more

Django Image Uploads

  Models.py from django.db import models # Create your models here. class Image(models.Model):     name = models.CharField(max_length=50)     image = models.ImageField(blank=True,upload_to='img')     def __str__(self):         return f"{self.name}" Admin.py from django.contrib import admin from .models import Image # Register your models here. admin.site.register(Image) Views.py from django.shortcuts import render from .models import Image # Create your views here. def view(request):     data = Image.objects.all()     context = {         'data':data     }     return render(request,"index.html",context) URLS.py from django.urls import path from . import views urlpatterns = [     path('',views.view), ] HMTL (Index.html) <!DOCTYPE html> <html> <head> <style> ul {   list-style-type: none;   margin: 0px 0px;   padding: 10px 400px;...
Post a Comment
Read more

Django Model Form

Models.py from django.db import models # Create your models here. class Students(models.Model):     sid = models.CharField(max_length=15)     name = models.CharField(max_length=100)     email = models.EmailField(max_length=50) py manage.py makemigrations students py manage.py  migrate Forms.py from django import forms from django.forms import ModelForm from .models import Students class StudentForm(forms.ModelForm):     class Meta:         model = Students         fields = "__all__" Views.py from django.shortcuts import render from .forms import StudentForm from .models import Students # Create your views here. def students(request):     form = StudentForm()     if request.method == "POST":         form = StudentForm(request.POST)         if form.is_valid():             form.save()     return render(reque...
Post a Comment
Read more

Flask and Sqlite Basic Crud Python Tutorial

Image
Flask app.py from flask import Flask, render_template, request, redirect import sqlite3 app = Flask(__name__) @app.route('/') def view():     con = sqlite3.connect("product.db")     con.row_factory =sqlite3.Row     cur = con.cursor()     cur.execute("SELECT * FROM PRODUCTS")     rows = cur.fetchall()     return render_template("viewdata.html",rows=rows) @app.route('/add<int:id>') def add(id):     con= sqlite3.connect("product.db")     con.row_factory =sqlite3.Row     cur = con.cursor()     cur.execute("INSERT INTO KART2 (id,name,price) SELECT id,name,price FROM PRODUCTS WHERE id = ?",[id])     con.commit()     cur = con.cursor()     cur.execute("SELECT * FROM kart2")     rows = cur.fetchall()     return render_template("kart.html",rows=rows) @app.route('/kart') def kart():     con = sqlite3.connect("product.db")   ...
Post a Comment
Read more

Flask Sqlite3 python Web App Tutorial

Image
 1) Creating Database import  sqlite3 conn = sqlite3.connect('bookapp.db') conn.execute("create table Books (id INTEGER PRIMARY KEY AUTOINCREMENT,                name TEXT NOT NULL,                quantity INT  NOT NULL,                edition INT NOT NULL,               year INT NOT NULL,                price INT NOT NULL)") conn.close() 2) need to create template folder and add html files to it 2.1)Html Form  (Template folder) <html> <head>     <title>form</title> </head> <body>  <form action="/input" method="post"> <p>Bookname</p>  <input name="name" type="text" /><br /><br /> <p>Bookquantity</p>  <input name="quantity" type="text" /><br /><br /> ...
Post a Comment
Read more

Tkinter SQlite Data Entry Python

Image
step 1: Creating Database import sqlite3 conn = sqlite3.connect('product.db') conn.execute('''CREATE TABLE PRODUCTS          (ID INT PRIMARY KEY     NOT NULL,          NAME           TEXT    NOT NULL,          PRICE            INT     NOT NULL );''') conn.close() Step 2: Inserting Values import sqlite3 conn = sqlite3.connect('product.db') conn.execute("INSERT INTO PRODUCTS (ID,NAME,PRICE) \       VALUES (1, 'SAMSUNG', 20000.00 )"); conn.commit() conn.close() Step 3: TKinter Code from tkinter import * from tkinter import ttk import sqlite3 conn = sqlite3.connect('product.db') root = Tk() root.geometry('600x500') tree = ttk.Treeview(root,column=("c1","c2","c3"),show='headings',height=8) tree.column("#1",anchor=CENTER) tree.heading("#1",text ="ID") tree.column("#2",anchor=CENTER) tree.heading("#2",text ...
Post a Comment
Read more