Telefricabot es un bot de telegram para controlar publicaciones en friendica, admite plugins en python3
https://writefreely.public.cat/x93
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
93 lines
1.9 KiB
93 lines
1.9 KiB
import sqlite3 |
|
import random |
|
|
|
|
|
|
|
def connect(name): |
|
""" |
|
_________________________________________ |
|
Crea una conexion a una database indicada |
|
_________________________________________ |
|
""" |
|
global database,db_cursor |
|
database=sqlite3.connect(name) |
|
db_cursor=database.cursor() |
|
|
|
def runcode(args): |
|
""" |
|
______________________ |
|
Ejecuta codigo sqlite3 |
|
______________________ |
|
""" |
|
db_cursor.execute(args) |
|
|
|
def create(args1,args2): |
|
""" |
|
_________________________ |
|
CRUD |
|
^ |
|
CREATE = CREA un registro |
|
_________________________ |
|
""" |
|
db_cursor.execute("INSERT INTO "+args1+" VALUES("+args2+")") |
|
|
|
def read(args1,*args2): |
|
""" |
|
______________________ |
|
CRUD |
|
^ |
|
READ = LEE un registro |
|
______________________ |
|
""" |
|
try: |
|
data=db_cursor.execute("SELECT * FROM "+str(args1)+" WHERE "+str(args2[0])+"="+str(args2[1])) |
|
except: |
|
data=db_cursor.execute("SELECT * FROM "+str(args1)) |
|
return data.fetchall() |
|
|
|
def update(args1,*args2): |
|
""" |
|
______________________________ |
|
CRUD |
|
^ |
|
UPDATE = ACTUALIZA un registro |
|
______________________________ |
|
""" |
|
db_cursor.execute("UPDATE "+str(args1)+" SET "+str(args2[0])+" = "+str(args2[1])+" where "+str(args2[2])+" = "+str(args2[3])+"") |
|
|
|
def delete(args1,args2,args3): |
|
""" |
|
____________________________ |
|
CRUD |
|
^ |
|
DELETE = ELIMINA un registro |
|
____________________________ |
|
""" |
|
db_cursor.execute("DELETE FROM "+args1+" WHERE "+args2+"="+args3) |
|
|
|
def save(): |
|
""" |
|
_____________________ |
|
Guarda los cambios |
|
hechos en la database |
|
_____________________ |
|
""" |
|
database.commit() |
|
|
|
def close(): |
|
""" |
|
__________________ |
|
Cierra la conexión |
|
__________________ |
|
""" |
|
database.close() |
|
def crud_doc(): |
|
print("connect"+connect.__doc__) |
|
print("runcode"+runcode.__doc__) |
|
print("create"+create.__doc__) |
|
print("read"+read.__doc__) |
|
print("update"+update.__doc__) |
|
print("delete"+delete.__doc__) |
|
print("save"+save.__doc__) |
|
print("close"+close.__doc__) |
|
|
|
|