1624865721
Delete Multiple Records Using Jquey Ajax Python Flask PostgreSQL
In today’s video we will show you how to delete multiple records using Jquey Ajax Python Flask PostgreSQL
Subscribe: https://www.youtube.com/c/Cairocoders/featured
Source Code
#app.py
from flask import Flask, render_template, request, jsonify
import psycopg2 #pip install psycopg2
import psycopg2.extras
app = Flask(__name__)
app.secret_key = "caircocoders-ednalan"
DB_HOST = "localhost"
DB_NAME = "sampledb"
DB_USER = "postgres"
DB_PASS = "admin"
conn = psycopg2.connect(dbname=DB_NAME, user=DB_USER, password=DB_PASS, host=DB_HOST)
@app.route('/')
def index():
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute("SELECT * FROM employee ORDER BY id DESC")
employeelist = cur.fetchall()
return render_template('index.html', employeelist=employeelist)
@app.route("/delete",methods=["POST","GET"])
def delete():
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
for getid in request.form.getlist('checkdelete'):
print(getid)
cur.execute('DELETE FROM employee WHERE id = {0}'.format(getid))
conn.commit()
cur.close()
return jsonify('Records deleted successfully')
if __name__ == "__main__":
app.run(debug=True)
templates/index.html
//templates/index.html
<!DOCTYPE html>
<html>
<head>
<title>Delete Multiple Records using Jquey Ajax Python Flask PostgreSQL</title>
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.form/4.3.0/jquery.form.min.js" integrity="sha384-qlmct0AOBiA2VPZkMY3+2WqkHtIQ9lSdAsAn5RUJD/3vA5MKDgSGcdmIv4ycVxyn" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<br />
<div class="table-responsive">
<h3 align="center">Delete Multiple Records using Jquey Ajax Python Flask PostgreSQL</h3><br />
<div class="table-responsive">
<div id="targetLayer" class="btn btn-success" style="display:none;width:100%;margin-bottom: 10px;"></div>
<div id="loader-icon" style="display:none;"><img src="/static/img/loader.gif" /></div>
<form id="deleteall" action="/delete" method="post">
<table class="table table-bordered">
<thead>
<tr>
<th width="5%">
<input type="submit" value="Delete" name="delete_all" id="delete_all" class="btn btn-danger btn-xs" />
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Salary</th>
</tr>
</thead>
{% for row in employeelist %}
<tr>
<td>
<input type="checkbox" name="checkdelete" id="checkdelete" class="delete_checkbox" value="{{row.id}}" />
</td>
<td>{{row.name}}</td>
<td>{{row.position}}</td>
<td>{{row.office}}</td>
<td>{{row.age}}</td>
<td>$ {{ "%.2f"|format(row.salary) }}</td>
</tr>
{% endfor %}
</table>
</form>
</div>
</div>
</div>
<style>
.removeRow {background-color: #64b418;color:#FFFFFF;}
</style>
<script>
$(document).ready(function(){
$('.delete_checkbox').click(function(){
if($(this).is(':checked')) {
$(this).closest('tr').addClass('removeRow');
}else{
$(this).closest('tr').removeClass('removeRow');
}
});
$('#deleteall').submit(function(event){
if($('#checkdelete').val()){
event.preventDefault();
$('#loader-icon').show();
$('#targetLayer').hide();
$(this).ajaxSubmit({
target: '#targetLayer',
success:function(data){
$('.removeRow').fadeOut(1500);
$('#loader-icon').hide();
$('#targetLayer').show();
$('#targetLayer').html(data);
},
resetForm: true
});
}
return false;
});
});
</script>
</body>
</html>
#python #postgresql #flask
What is GEEK
Buddha Community
1595201363
Php how to delete multiple rows through checkbox using ajax in laravel
First thing, we will need a table and i am creating products table for this example. So run the following query to create table.
CREATE TABLE `products` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Next, we will need to insert some dummy records in this table that will be deleted.
INSERT INTO `products` (`name`, `description`) VALUES
('Test product 1', 'Product description example1'),
('Test product 2', 'Product description example2'),
('Test product 3', 'Product description example3'),
('Test product 4', 'Product description example4'),
('Test product 5', 'Product description example5');
Now we are redy to create a model corresponding to this products table. Here we will create Product model. So let’s create a model file Product.php file under app directory and put the code below.
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Product extends Model
{
protected $fillable = [
'name','description'
];
}
Step 2: Create Route
Now, in this second step we will create some routes to handle the request for this example. So opeen routes/web.php file and copy the routes as given below.
routes/web.php
Route::get('product', 'ProductController@index');
Route::delete('product/{id}', ['as'=>'product.destroy','uses'=>'ProductController@destroy']);
Route::delete('delete-multiple-product', ['as'=>'product.multiple-delete','uses'=>'ProductController@deleteMultiple']);
#laravel #delete multiple rows in laravel using ajax #laravel ajax delete #laravel ajax multiple checkbox delete #laravel delete multiple rows #laravel delete records using ajax #laravel multiple checkbox delete rows #laravel multiple delete
1619518440
top 30 Python Tips and Tricks for Beginners
Welcome to my Blog , In this article, you are going to learn the top 10 python tips and tricks.
1) swap two numbers.
2) Reversing a string in Python.
3) Create a single string from all the elements in list.
4) Chaining Of Comparison Operators.
5) Print The File Path Of Imported Modules.
6) Return Multiple Values From Functions.
7) Find The Most Frequent Value In A List.
8) Check The Memory Usage Of An Object.
…
#python #python hacks tricks #python learning tips #python programming tricks #python tips #python tips and tricks #python tips and tricks advanced #python tips and tricks for beginners #python tips tricks and techniques #python tutorial #tips and tricks in python #tips to learn python #top 30 python tips and tricks for beginners
1624865721
Delete Multiple Records Using Jquey Ajax Python Flask PostgreSQL
In today’s video we will show you how to delete multiple records using Jquey Ajax Python Flask PostgreSQL
Subscribe: https://www.youtube.com/c/Cairocoders/featured
Source Code
#app.py
from flask import Flask, render_template, request, jsonify
import psycopg2 #pip install psycopg2
import psycopg2.extras
app = Flask(__name__)
app.secret_key = "caircocoders-ednalan"
DB_HOST = "localhost"
DB_NAME = "sampledb"
DB_USER = "postgres"
DB_PASS = "admin"
conn = psycopg2.connect(dbname=DB_NAME, user=DB_USER, password=DB_PASS, host=DB_HOST)
@app.route('/')
def index():
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
cur.execute("SELECT * FROM employee ORDER BY id DESC")
employeelist = cur.fetchall()
return render_template('index.html', employeelist=employeelist)
@app.route("/delete",methods=["POST","GET"])
def delete():
cur = conn.cursor(cursor_factory=psycopg2.extras.DictCursor)
for getid in request.form.getlist('checkdelete'):
print(getid)
cur.execute('DELETE FROM employee WHERE id = {0}'.format(getid))
conn.commit()
cur.close()
return jsonify('Records deleted successfully')
if __name__ == "__main__":
app.run(debug=True)
templates/index.html
//templates/index.html
<!DOCTYPE html>
<html>
<head>
<title>Delete Multiple Records using Jquey Ajax Python Flask PostgreSQL</title>
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.form/4.3.0/jquery.form.min.js" integrity="sha384-qlmct0AOBiA2VPZkMY3+2WqkHtIQ9lSdAsAn5RUJD/3vA5MKDgSGcdmIv4ycVxyn" crossorigin="anonymous"></script>
</head>
<body>
<div class="container">
<br />
<div class="table-responsive">
<h3 align="center">Delete Multiple Records using Jquey Ajax Python Flask PostgreSQL</h3><br />
<div class="table-responsive">
<div id="targetLayer" class="btn btn-success" style="display:none;width:100%;margin-bottom: 10px;"></div>
<div id="loader-icon" style="display:none;"><img src="/static/img/loader.gif" /></div>
<form id="deleteall" action="/delete" method="post">
<table class="table table-bordered">
<thead>
<tr>
<th width="5%">
<input type="submit" value="Delete" name="delete_all" id="delete_all" class="btn btn-danger btn-xs" />
<th>Name</th>
<th>Position</th>
<th>Office</th>
<th>Age</th>
<th>Salary</th>
</tr>
</thead>
{% for row in employeelist %}
<tr>
<td>
<input type="checkbox" name="checkdelete" id="checkdelete" class="delete_checkbox" value="{{row.id}}" />
</td>
<td>{{row.name}}</td>
<td>{{row.position}}</td>
<td>{{row.office}}</td>
<td>{{row.age}}</td>
<td>$ {{ "%.2f"|format(row.salary) }}</td>
</tr>
{% endfor %}
</table>
</form>
</div>
</div>
</div>
<style>
.removeRow {background-color: #64b418;color:#FFFFFF;}
</style>
<script>
$(document).ready(function(){
$('.delete_checkbox').click(function(){
if($(this).is(':checked')) {
$(this).closest('tr').addClass('removeRow');
}else{
$(this).closest('tr').removeClass('removeRow');
}
});
$('#deleteall').submit(function(event){
if($('#checkdelete').val()){
event.preventDefault();
$('#loader-icon').show();
$('#targetLayer').hide();
$(this).ajaxSubmit({
target: '#targetLayer',
success:function(data){
$('.removeRow').fadeOut(1500);
$('#loader-icon').hide();
$('#targetLayer').show();
$('#targetLayer').html(data);
},
resetForm: true
});
}
return false;
});
});
</script>
</body>
</html>
#python #postgresql #flask
1619510796
Lambda, Map, Filter functions in python
Welcome to my Blog, In this article, we will learn python lambda function, Map function, and filter function.
Lambda function in python: Lambda is a one line anonymous function and lambda takes any number of arguments but can only have one expression and python lambda syntax is
Syntax: x = lambda arguments : expression
Now i will show you some python lambda function examples:
#python #anonymous function python #filter function in python #lambda #lambda python 3 #map python #python filter #python filter lambda #python lambda #python lambda examples #python map
1597751700
How To Compare Tesla and Ford Company By Using Magic Methods in Python
Magic Methods are the special methods which gives us the ability to access built in syntactical features such as ‘<’, ‘>’, ‘==’, ‘+’ etc…
You must have worked with such methods without knowing them to be as magic methods. Magic methods can be identified with their names which start with __ and ends with __ like init, call, str etc. These methods are also called Dunder Methods, because of their name starting and ending with Double Underscore (Dunder).
Now there are a number of such special methods, which you might have come across too, in Python. We will just be taking an example of a few of them to understand how they work and how we can use them.
1. init
class AnyClass:
def __init__():
print("Init called on its own")
obj = AnyClass()
The first example is _init, _and as the name suggests, it is used for initializing objects. Init method is called on its own, ie. whenever an object is created for the class, the init method is called on its own.
The output of the above code will be given below. Note how we did not call the init method and it got invoked as we created an object for class AnyClass.
Init called on its own
2. add
Let’s move to some other example, add gives us the ability to access the built in syntax feature of the character +. Let’s see how,
class AnyClass:
def __init__(self, var):
self.some_var = var
def __add__(self, other_obj):
print("Calling the add method")
return self.some_var + other_obj.some_var
obj1 = AnyClass(5)
obj2 = AnyClass(6)
obj1 + obj2
#python3 #python #python-programming #python-web-development #python-tutorials #python-top-story #python-tips #learn-python