وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Building Full Stack Python Web Apps Backed By Google Sheets

سرفصل های دوره

Develop and deploy a full-stack application using Python, Google Sheets, FastAPI, React, Next.js, and Tailwind CSS


1 - Python vs Worksheets
  • 1 -Welcome!
  • 2 -My Other Work

  • 2 - Introduction To The Google Sheets API
  • 1 -High-Level Concepts
  • 2 -Credentials And Service Account
  • 3 -Virtual Environment And Dependencies
  • 4 -Setting Up The Sheets Service
  • 5 -Inserting Values Into Existing Sheet
  • 6 -Programmatically Creating New Sheets
  • 7 -Managing Permissions Through The Drive API
  • 8 -The Discovery Document

  • 3 - Building The Python API Layer
  • 1 -Setup And Dependencies
  • 1 - Section Resources + All The Code Files.html
  • 2 -Scaffolding The API
  • 3 -Defining A Sheets Abstraction
  • 4 -Service Account Credentials
  • 5 -Injecting Dependencies In FastAPI
  • 6 -Creating A New Sheet
  • 7 -Permissioning A Specific User Or Anyone
  • 8 -Pydantic Models
  • 9 -Swagger UI API Documentation
  • 10 -API Routers
  • 11 -Rename Spreadsheet Operation
  • 12 -Adding The Route Handler
  • 13 -Deleting Spreadsheets
  • 14 -Extra Centralizing Exception Handling
  • 15 -The Worksheets API Router
  • 16 -Navigating Between Sheet Names And Ids
  • 17 -Renaming A Worksheet
  • 18 -Reading Worksheet Data And Returning JSON
  • 19 -Writing Data To A Worksheet
  • 20 -Handling Rows With Asymmetric Dimensions
  • 21 -Appending Records With New Dimensions
  • 22 -Handling Multiple New Columns Correctly
  • 23 -Implementing Auto-Incrementing Ids
  • 24 -Adding New Worksheets
  • 25 -Clearing All Worksheet Content
  • 26 -Deleting A Worksheet
  • 27 -Introducing Environment Variables
  • 28 -Creating Expirable JSON Web Tokens
  • 29 -Implementing The token Endpoint
  • 30 -Adding Some Missing Dependencies
  • 31 -Authentication And JWTs
  • 32 -Defining An Auth Dependency
  • 33 -Protecting Routes With Token-Based Authentication
  • 34 -Finishing Touches
  • 35 -Relaxing The CORS Policy
  • 36 -Deployment Checklist
  • 37 -Locking Dependencies And Config
  • 38 -Git And .gitignore
  • 39 -GitHub Remote Repository
  • 40 -Deploying To The World Wide Web

  • 4 - Creating User Interfaces With React And Next.js
  • 1 -The Big Picture
  • 1 -gsheets-ui-main-repo.zip
  • 1 - Section Resources + All The Code Files.html
  • 2 -JavaScript, Node, React, And Next.js
  • 3 -Setting Up A New Project
  • 4 -Running The App
  • 5 -Our First Component
  • 6 -Controlling Components With JavaScript
  • 7 -Styling Interfaces With Tailwind CSS
  • 8 -Obtaining the JWT From The Backend
  • 9 -Adding Interactivity To The Form
  • 10 -Next.js Environment Variables
  • 11 -Client-side Accessible Env Variables
  • 12 -Conditionally Rendering On Successful Login
  • 13 -Passing Down Props To Other Components
  • 14 -Creating A New Workbook For Our Online Store
  • 15 -Seeding Our Inventory
  • 16 -Fetching Inventory Data Via The API
  • 17 -Rendering Products
  • 18 -Styling The Products Grid
  • 19 -Defining A New ProductCard Component
  • 20 -AddToCart Functionality
  • 21 -Header With View Cart Button
  • 22 -Opening And Closing The Cart
  • 23 -Cart Container
  • 24 -Displaying Items In The Cart
  • 25 -Removing Items From The Cart
  • 26 -Unique Cart Item Ids
  • 27 -Calculating And Rendering TotalAmount
  • 28 -Introducing A Checkout Button
  • 29 -Creating The Orders Worksheet
  • 30 -HandleCheckout From The UI
  • 31 -Generating Unique Order Ids
  • 32 -Updating Cart State On Order Checkout
  • 33 -Persisting The Authentication Token
  • 34 -Deploying The User Interface
  • 35 -Deployed App
  • 36 -Thank You!

  • 5 - Appendix - Python Fundamentals
  • 1 -Data Type
  • 1 -notebook resource.zip
  • 1 - A Quick Note + Section Resources.html
  • 2 -Variables
  • 3 -Arithmetic And Augmented Assignment Operators
  • 4 -Ints And Floats
  • 5 -Booleans And Comparison Operators
  • 6 -Strings
  • 7 -Methods
  • 8 -Containers I Lists
  • 9 -Lists vs. Strings
  • 10 -List Methods And Functions
  • 11 -Containers II Tuples
  • 12 -Containers III Sets
  • 13 -Containers IV Dictionaries
  • 14 -Dictionary Keys And Values
  • 15 -Membership Operators
  • 16 -Controlling Flow if, else, And elif
  • 17 -Truth Value Of Non-booleans
  • 18 -For Loops
  • 19 -The range() Immutable Sequence
  • 20 -While Loops
  • 21 -Break And Continue
  • 22 -Zipping Iterables
  • 23 -List Comprehensions
  • 24 -Defining Functions
  • 25 -Function Arguments Positional vs Keyword
  • 26 -Lambdas
  • 27 -Importing Modules
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 42904
    حجم: 4711 مگابایت
    مدت زمان: 721 دقیقه
    تاریخ انتشار: ۲۹ دی ۱۴۰۳
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید