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

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 تومان
    افزودن به سبد خرید