Das deutsche Python-Forum

Code: Alles auswählen

try:
    from pysqlite2 import dbapi2 as sqlite
except ImportError:
    import sqlite3 as sqlite

class nn:
    def __init__(self, connection, tneurons = "", tsynapses = ""):
        self.tneurons = tneurons
        self.tsynapses = tsynapses
        self.connection = connection
        self.cursor = self.connection.cursor()

    def __del__(self):
        self.cursor.close()
        self.connection.close()

    def add_neuron(self, content):
        self.cursor.execute('INSERT INTO %s (content) VALUES (?)' % self.tneurons, (content))
        self.connection.commit()
        return self.cursor.lastrowid

    def add_synapse(self, id1, id2):
        self.cursor.execute('INSERT INTO %s (id1, id2) VALUES (?, ?)' % self.tsynapses, (id1, id2))
        self.connection.commit()
        return self.cursor.lastrowid

    def create_tables(self, neurons, synapses):
        self.tneurons = neurons
        self.tsynapses = synapses
        self.cursor.execute('CREATE TABLE %s (id INTEGER AUTO_INCREMENT PRIMARY KEY, content VARCHAR(50))'
        % self.tneurons)
        self.cursor.execute('CREATE TABLE %s (id1 INTEGER, id2 INTEGER)' % self.tsynapses)
        self.connection.commit()

    def delete_tables(self, neurons, synapses):
        self.cursor.execute('DROP TABLE %s' % neurons)
        self.cursor.execute('DROP TABLE %s' % synapses)
        self.connection.commit()

    def delete_neuron(self):
        self.cursor.execute('DELETE FROM %s WHERE id = "?"' % self.tneurons, id)
        self.connection.commit()

    def delete_synapse(self, id1, id2):
        self.cursor.execute('DELETE FROM %s WHERE id1 = "?" AND id2 = "?"' % self.tsynapses, (id1, id2))
        self.connection.commit()

    def get_neighbours(self, neighbours):
        #......
nn = nn(sqlite.connect('test.db'))

nn.delete_tables("nn_neurons", "nn_synapses")
nn.create_tables("nn_neurons", "nn_synapses")

id1 = nn.add_neuron("String1")
id2 = nn.add_neuron("String2")

nn.add_synapse(id1, id2)

Code: Alles auswählen

In [32]: type(42)
Out[32]: <type 'int'>

In [33]: type((42))
Out[33]: <type 'int'>

In [34]: type((42,))
Out[34]: <type 'tuple'>