crud.py

   1 import sqlite3\r
   2 import random\r
   3 \r
   4 \r
   5 \r
   6 def connect(name):\r
   7         """\r
   8         _________________________________________\r
   9         Crea una conexion a una database indicada\r
  10         _________________________________________\r
  11         """\r
  12         global database,db_cursor\r
  13         database=sqlite3.connect(name)\r
  14         db_cursor=database.cursor()\r
  15 \r
  16 def runcode(args):\r
  17         """\r
  18         ______________________\r
  19         Ejecuta codigo sqlite3\r
  20         ______________________\r
  21         """\r
  22         db_cursor.execute(args)\r
  23 \r
  24 def create(args1,args2):\r
  25         """\r
  26         _________________________\r
  27         CRUD\r
  28         ^\r
  29         CREATE = CREA un registro\r
  30         _________________________\r
  31         """\r
  32         db_cursor.execute("INSERT INTO "+args1+" VALUES("+args2+")")\r
  33 \r
  34 def read(args1,*args2):\r
  35         """\r
  36         ______________________\r
  37         CRUD\r
  38          ^\r
  39         READ = LEE un registro\r
  40         ______________________\r
  41         """\r
  42         try:\r
  43                 data=db_cursor.execute("SELECT * FROM "+str(args1)+" WHERE "+str(args2[0])+"="+str(args2[1]))\r
  44         except:\r
  45                 data=db_cursor.execute("SELECT * FROM "+str(args1))\r
  46         return data.fetchall()\r
  47 \r
  48 def update(args1,*args2):\r
  49         """\r
  50         ______________________________\r
  51         CRUD\r
  52           ^\r
  53         UPDATE = ACTUALIZA un registro\r
  54         ______________________________\r
  55         """\r
  56         db_cursor.execute("UPDATE "+str(args1)+" SET "+str(args2[0])+" = "+str(args2[1])+" where "+str(args2[2])+" = "+str(args2[3])+"")\r
  57 \r
  58 def delete(args1,args2,args3):\r
  59         """\r
  60         ____________________________\r
  61         CRUD\r
  62            ^\r
  63         DELETE = ELIMINA un registro\r
  64         ____________________________\r
  65         """\r
  66         db_cursor.execute("DELETE FROM "+args1+" WHERE "+args2+"="+args3)\r
  67 \r
  68 def save():\r
  69         """\r
  70         _____________________\r
  71         Guarda los cambios\r
  72         hechos en la database\r
  73         _____________________\r
  74         """\r
  75         database.commit()\r
  76 \r
  77 def close():\r
  78         """\r
  79         __________________\r
  80         Cierra la conexión\r
  81         __________________\r
  82         """\r
  83         database.close()\r
  84 def crud_doc():\r
  85         print("connect"+connect.__doc__)\r
  86         print("runcode"+runcode.__doc__)\r
  87         print("create"+create.__doc__)\r
  88         print("read"+read.__doc__)\r
  89         print("update"+update.__doc__)\r
  90         print("delete"+delete.__doc__)\r
  91         print("save"+save.__doc__)\r
  92         print("close"+close.__doc__)\r
  93 \r