Das deutsche Python-Forum

Code: Alles auswählen

def db_sqlite_verbindung():
    import sqlite3
    db_name = "c:/gb_sqlite.db"
    verbindung = sqlite3.connect(db_name)
    schreibmarke = verbindung.cursor()
    return schreibmarke

Code: Alles auswählen

schreibmarke.execute(...)

Code: Alles auswählen

def connect(uri):
      return sqlite.connect(uri)

def tuwas(conn):
      c  = conn.cursor()
      c.execute("some sql")
      return c


die_verbindung = connect(uri) # rueckgabewerte muessen gebunden werden

for row in tuwas(die_verbindung):
     print row

Code: Alles auswählen

def foo(name):
    s = "{}, the mighty!".format(name)
    return s

# so geht 's natürlich nicht!
foo("Hyperion")
print(s)

# so ist es richtig:
s = foo("Hyperion")
print(s)

Code: Alles auswählen

CREATE TABLE guestbook (name text, kommentar text)

Code: Alles auswählen

def eingabe():
    data = []
    name = raw_input('Name: ')
    comment = raw_input('Kommentar: ')
    data.append(name)
    data.append(comment)
    for elements in data:
        my_cursor.execute('INSERT INTO guestbook VALUES (?,?)', elements)
    my_db_connection.commit()

Code: Alles auswählen

    name = raw_input('Name: ')
    comment = raw_input('Kommentar: ')
    data.append(name)
    data.append(comment)
# besser:
data.append(raw_input('Name: '))
data.append(raw_input('Kommentar: '))

Code: Alles auswählen

my_cursor.execute('INSERT INTO guestbook VALUES (?, ?)', (name, comment))

Code: Alles auswählen

import sqlite3
def db_connect():
    return sqlite3.connect("c:\guestbook.db")


def db_create():
    db_action = db_connect()
    db_action.execute('''CREATE TABLE if not exists guestbook
                         (name text, kommentar text)''')
    db_action.close()


def db_add_entry():
    entries = (raw_input("Name: "), raw_input("Kommentar: "))
    db_action = db_connect()
    db_action.execute('INSERT INTO guestbook VALUES(?,?)',entries)
    db_action.commit
    
    

Code: Alles auswählen

import sqlite3
def db_connect(db_path):
    return sqlite3.connect(db_path)


def db_create():
    db_action = db_connection.cursor()
    db_action.execute('''CREATE TABLE if not exists guestbook
                         (name text, kommentar text)''')
    db_action.close()


def db_add_entry():
    db_action = db_connection.cursor()
    db_action.execute('INSERT INTO guestbook VALUES(?,?)',
                      (raw_input("Name: "), raw_input("Kommentar: ")))
    db_connection.commit()
    db_connection.close()

db_connection = db_connect("c:/guestbook.db")

Code: Alles auswählen

In [2]: conn = db_connect(':memory:')

In [3]: db_add_entry()
Name: bla
Kommentar: blub
---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
/home/gerrit/<ipython-input-3-2f82cd18e3da> in <module>()
----> 1 db_add_entry()

/home/gerrit/<string> in db_add_entry()

NameError: global name 'db_connection' is not defined

In [4]: db_connection = db_connect(':memory:')

In [5]: db_add_entry()
Name: bla
Kommentar: blub
---------------------------------------------------------------------------
OperationalError                          Traceback (most recent call last)
/home/gerrit/<ipython-input-5-2f82cd18e3da> in <module>()
----> 1 db_add_entry()

/home/gerrit/<string> in db_add_entry()

OperationalError: no such table: guestbook

In [6]: db_create()

In [7]: db_add_entry()
Name: bla
Kommentar: blub

In [8]: db_add_entry()
Name: foo
Kommentar: flub
---------------------------------------------------------------------------
ProgrammingError                          Traceback (most recent call last)
/home/gerrit/<ipython-input-8-2f82cd18e3da> in <module>()
----> 1 db_add_entry()

/home/gerrit/<string> in db_add_entry()

ProgrammingError: Cannot operate on a closed database.

Code: Alles auswählen

def db_add_entry(conn):
    db_action = conn.cursor()
    db_action.execute('INSERT INTO guestbook VALUES(?,?)', (raw_input("Name: "), raw_input("Kommentar: ")))
    conn.commit()

Code: Alles auswählen

def db_add_entry(db_connection):
    db_action = db_connection.cursor()
    db_action.execute('INSERT INTO guestbook VALUES(?,?)',
                      (raw_input("Name: "), raw_input("Kommentar: ")))
    db_connection.commit()
    

db_connection = db_connect("c:/guestbook.db")

Code: Alles auswählen

db_add_entry(db_connection)