Advertisement
Guest User

Untitled

a guest
Aug 25th, 2020
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.81 KB | None | 0 0
  1. # file dbcreate.py
  2. from metadb import db
  3. class tableName(metaclass = db): # создает таблицу tableName в mysql
  4.     vkid = 0    # создает поля
  5.     name = ''
  6.     money = 0
  7.  
  8. # file message_send.py
  9. def main(app, db):
  10.     tn = db.tableName(12323, 'Visya') #insert если нету и возратить select
  11.     tn.name = 'Petya'
  12.     tn.money += 100
  13.     tn.update()
  14.  
  15.     #или лучше классику
  16.     row = db('select * from tableName where vkid=12323 limit 1')[0]
  17.     if not row:
  18.         db('insert into tableName(vkid, name, money) value(12323, "Visya")')
  19.         row = db('select * from tableName where vkid=12323 limit 1')[0]
  20.     row['name'] = 'Petya'
  21.     row['money'] += 100
  22.     db(f'update tableName set name="{row["name"]}", money={row["money"]} where vkid=12323 limit 1')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement