Telegram-  :  ,  
 


  bot_booking.py   300     Python: Telegram-,     ,     ,  ,   ,        CSV  Excel.  frameworks   : SQLite  urllib, long-polling  Bot API.  :  ,  book()     , ,   13 ,     --check.  , ,  , ,         .  ,     @BotFather,       .





 

Telegram-  :  ,  





Telegram-  :  ,  



      . :    

,   ,      , 

  ,    ,     

.

,    ,     bot_booking.py (~300 ) 

  .




1.    


    ,     : , ,

, , ,  ,     .

   :    ,   ,

               .

   :

        ;

          ,  

 ;

       CSV,   

Excel   .

  :    .    

   Python     :  pip, 

 ,   .      :

,    ,       .




2. :  ,  -


SQLite     ,  .  db()   

     ,   .

def db():

con = sqlite3.connect(DB)

con.row_factory = sqlite3.Row

with con:

con.executescript("""

CREATE TABLE IF NOT EXISTS services(

id INTEGER PRIMARY KEY AUTOINCREMENT, title TEXT NOT NULL, price INTEGER DEFAULT 0);

CREATE TABLE IF NOT EXISTS bookings(

id INTEGER PRIMARY KEY AUTOINCREMENT,

chat_id INTEGER NOT NULL,

service_id INTEGER NOT NULL REFERENCES services(id),

starts TEXT NOT NULL,                    -- ISO datetime

minutes INTEGER NOT NULL,

status TEXT NOT NULL DEFAULT 'active',   -- active | canceled | done

reminded INTEGER NOT NULL DEFAULT 0,

created TEXT NOT NULL

);

CREATE INDEX IF NOT EXISTS ix_book_starts ON bookings(starts, status);

""")

seed_defaults(con)

return con

 ,   .

row_factory = sqlite3.Row       (r["starts"]),

    row[3]   ,  -  .

  minutes,    :   90   

  ,     .

 reminded       .  

      ,    :  

,      .




  .


   .

   ,     (https://www.litres.ru/book/shadrin-borisovich-d/telegram-bot-zapisi-klientov-odin-fail-nol-zavisimost-74697619/)  .

      Visa, MasterCard, Maestro,    ,   ,     ,  PayPal, WebMoney, ., QIWI ,       .


