Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # file dbcreate.py
- from metadb import db
- class tableName(metaclass = db): # создает таблицу tableName в mysql
- vkid = 0 # создает поля
- name = ''
- money = 0
- # file message_send.py
- def main(app, db):
- tn = db.tableName(12323, 'Visya') #insert если нету и возратить select
- tn.name = 'Petya'
- tn.money += 100
- tn.update()
- #или лучше классику
- row = db('select * from tableName where vkid=12323 limit 1')[0]
- if not row:
- db('insert into tableName(vkid, name, money) value(12323, "Visya")')
- row = db('select * from tableName where vkid=12323 limit 1')[0]
- row['name'] = 'Petya'
- row['money'] += 100
- 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