Session 29: Instructor-led Live Training on Python - Full Stack Development using Flask

Free of Cost – Specialist in Python (with Flask Towards Data Science) basic to advance by World Record Holder - Mr. Vimal Daga.

➡️ IIEC-RISE Social Media Platforms :-

➡️ Join our Telegram channels :-

#pythonwithiiec #iiecrise #vimaldaga #worldrecordholder

[aditichaudhary]

Session 29-
🔰CURD refers to create, read, update and delete operations performed on a database system.
🔰An object-relational mapper (ORM) is a code library that automates the transfer of data stored in relational database tables into objects that are more commonly used in application code.
🔰SQLite is a relational database management system contained in a C library. In contrast to many other database management systems, SQLite is not a client–server database engine. Rather, it is embedded into the end program.
🔰serial numbers are given to each row as it acts as a primary key which uniquely identifies each row.
🔰Create, write, update and delete operations through python.

[shivanshchoudhary]

Session 29 summary:-
1. App Development using python
2. Database management and connection
3. About developing using flask
4. Commands to work with database
5. About CRUD operation, ORM, to configure SQL Alchemy using SQLlite

[saffronindia]

In this session :
We learnt about ;
1)DBMS
2)Opm
3) crud
4)development with flask and squalchem libraray.
Thank u sir for this session.

[rohitsadanandlende]

Session 29 summary:
# Use of python in database management with CRUD(create, read, update, delete) operations.
# SQL alchemy
# Concept of ORM( object relational mapper)
# Database connectivity with python
# SQLite allows single database storage to connect multiple databases and have access to it.

[rvkay]

Session 29 summary-
1) Basics of Database- Tables, records
2)Crud operations- create, read, update, delete
3)ORM - object relation mapper
4)SQlite as reltional database management system
5) Giving numbers/ids to modify the data
6)Some of the syntaxes used were-
db.session.add()
record=class.query.get(id)
db.session.commit()
db.session.delete()

[sakshijadhav]

Summary for session 29 :
20 March 2020

✅CURD is an operation that we do on the data. C for creating, U for the update, R for reading, D for delete. 
✅Object Relational Mapper is used to map the data of object and class into database tables.
✅SQLite is a relational DB server used for storing the data in the table format and allow to query on the data.
✅We should give serial number to column as it can make manipulation and retrieval of data easier.
✅a) Command for Create operation :
db.session.add(ObjectName)

  b) Command for Read operation :
     ObjectName.query.all()

   c) Command for Update operation:
    
     db.session.add(ObjectName)

[ShaileshKumar-icrq]

Day-29

Things I have learned;

(1) Persistent Storage comprise of four basic operations which are known as CRUD (create, read, update and delete).

(2) Object-Relational Mapping (ORM) is a technique which allows you to query and manipulate data from a database using an object-oriented model.

(3) SQLite allows a single database connection to access multiple database files simultaneously. This brings many nice features like joining tables in different databases or copying data between databases in a single command.

(4) We give serial number to column so that its uniquely identifies records in a table. we practiced this by making our own table (model) using classes with the SQLAlchemy function.

[Kumar-Dhiraj]

Session 29 Summary-
1 App development
2 Database connection
3 Data management
4 Database commands
5 Working with flask

[D--]

Session 29 Summary :-

> CRUD Operation ( create, read, update and delete)
> ORM( Object Relation mapping)
> sqlalchemy
> database management in flask app
> create database using commands
> some database commands

[edith_]

Summary:- Day-29 (20th March, 2021)
👉 If data is stored in files then operations like updating, retrieving, and deleting any particular data from file is not easy task.
👉 CRUD means Create, Read, Update, and Delete.
👉 Object Relational Mapper (ORM) is a way of mapping webapp to a database.
👉 SQLite is database server.
👉 We should give unique numbers to column to uniquely identify each column in the database.
👉Commands for :
a) Create operation :
>>> db.session.add()
>>> db.session.commit()
b) Read operation :
>>> record =class.query.get(id)
>>> db.session.add()
>>> db.session.commit()
c) Update operation :
>>> record =class.query.get(id)
>>> db.session.delete()
>>> db.session.commit()

[rishabhgupta]

Summary-
>> Discussion on connecting a database to our flask app
>> CRUD operations on database
>> How SQLALCHEMY library is used in python for ORM operations using objects and classes
>> In the session we used SQLite database
>> Some functions like :
-- db.session.add(obj)
-- db.session.get(obj id)
-- db.session.commit()
--
-- db.session.delete(obj id)

[aayushivyas]

Session 29 Summary:
- *Database with Flask*
-Basics of DBMS
-CRUD ~create, read, update, delete.
-ORM ~Object Relational Mapping
-SQLite
-Library ~SQLAlchemy
sqlite:///mydb/data.sqlite
-How to add data to database
~db.create_all()
~db.session_add()
~db.session_commit()
-Using Query in SQL through Python(bit different from SQL's query)
-filter the query
-Update the database.
-Delete the data from the database.

[rahulreddy]

Summary:
-->App development
-->Connection with the Data base
-->Developing with flask
-->Data management
-->Data base commands

[milindkumar]

Session 29 Summary:
- Python use in database learning with four basic operations CRUD-create, read, update and delete.
- SQLite uses single databases for storage purposes and those for accessing data in it.
- SQL alchemy
- It will uses single database files which will take up and access different files which is under the consideration for the various access in it.
- It will be provided with the single ID colum in order to uniquely identify the value over in it.
- Mapping the objects of classes to the relational database tables is the concept of ORM (Object Relational Mapper).
- Learnt to do database connectivity with
Python.
- We have to provide an id to every record for identifying them uniquely. Generally, we refer to this as a Primary Key.
- Instantiating a class in Python is similar to creating a database record.

[karanvalooran]

Session 29 summary:
* Database
* CRUD -(Create, Read, Update, Delete)
* Structured Query Language
* SQLite
* Data management
* Object Relational Mapper (ORM)
* SQLAlchemy Library
* various commands (get, add, commit, update, delete, filter_by)

[samriddhimishra]

Session 29 Summary:
- App development
- Data management
- Connecting the database
- About Database commands

[bhushangawade]

Session Summary 29:
- Database type
- SQL lite library
- object relational mapping (orm)
- crud create read update and deleting records in database

[cankush]

Session summary:

1. Mapping the objects of classes to the relational database tables is the concept of ORM (Object Relational Mapper).
2. Learnt to do database connectivity with Python.
3. We have to provide an id to every record for identifying them uniquely. Generally, we refer to this as a Primary Key.
4. Instantiating a class in Python is similar to creating a database record.
5. Learnt to do CRUD (Create, Read, Update, and Delete) operations using the Python and SQLite connectivity.

[pankajchauhan]

Session 29 summary:
- ORM (object relationship mapper) is a technique used to map classes and databases with each other.
- SQLAlcemy library perform ORM operations.
- Installed and used SQLite database.
- configured SQLite database with our application.
- created python program using classes and object and subsequently creates database with class as table name, class variables as field and objects as records.

[arpitsironiya]

In this video, I'm learned about the concept like:-
=> We can easily read and write data inside in any file in python
=> Radis, MySQL, MongoDb is all are the example of Database
=> CRUD operations
=> Object-Relational Mapping (ORM)
and lots of more hidden knowledge...