lib/db.py
changeset 22 72696ca68c34
child 24 001f52cd057e
equal deleted inserted replaced
21:b75f9514e797 22:72696ca68c34
       
     1 # DeGAL - A pretty simple web image gallery
       
     2 # Copyright (C) 2007 Tero Marttila
       
     3 # http://marttila.de/~terom/degal/
       
     4 #
       
     5 # This program is free software; you can redistribute it and/or modify
       
     6 # it under the terms of the GNU General Public License as published by
       
     7 # the Free Software Foundation; either version 2 of the License, or
       
     8 # (at your option) any later version.
       
     9 #
       
    10 # This program is distributed in the hope that it will be useful,
       
    11 # but WITHOUT ANY WARRANTY; without even the implied warranty of
       
    12 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
       
    13 # GNU General Public License for more details.
       
    14 #
       
    15 # You should have received a copy of the GNU General Public License
       
    16 # along with this program; if not, write to the
       
    17 # Free Software Foundation, Inc.,
       
    18 # 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
       
    19 #
       
    20 
       
    21 import sqlite3
       
    22 
       
    23 conn = sqlite3.connect("degal.db")
       
    24 
       
    25 def execute (expr, *args) :
       
    26     c = conn.cursor()
       
    27     c.execute(expr, args)
       
    28 
       
    29     return c
       
    30 
       
    31 def insert (expr, *args) :
       
    32     return execute(expr, *args).rowcount
       
    33 
       
    34 select = execute
       
    35 
       
    36 cursor = conn.cursor
       
    37