insert & update ¶

SQL�� insert into values �� 해 �� 하��, update set where �� 해 �� 한��. 하�� django�� 하�� 하�� 하�� , �� (save)하�� 화했��. �� 클�� save�� . �� 한 �� save�� , �� 할 �� . �� save �� 히 �� 행한��.

class Employee(models.Model):
    name= models.CharField(maxlength=100)
    email= models.EmailField()

Employee �� 해��하�� save�� 하��, �� 하��, �� 한��. �� 하�� save�� 호��하�� 하��, �� save�� 호��하�� 한��. �� , �� 한��.

e= Employee(name='John', email='John@django.com')
e.save() # insert
e.name= 'jack'
e.save() # update

save�� 하�� 키�� 하�� 할 �� 할 �� 한��. ��키�� 해 �� 히 ��한��. ��키�� 해 �� 한 �� 히 ��한��. �� 키�� 하�� 한��. �� save�� .

  def save(self):
        # First, try an UPDATE. If that doesn't update anything, do an INSERT.
        record_exists = True
        if pk_set:
            # Determine whether a record with the primary key already exists.
            cursor.execute("SELECT 1 FROM %s WHERE %s=%%s LIMIT 1" % \
            # If it does already exist, do an UPDATE.
            if cursor.fetchone():
                    cursor.execute("UPDATE %s SET %s WHERE %s=%%s" % \
            else:
                record_exists = False
        if not pk_set or not record_exists:
            if pk_set:
            # If the PK has been manually set, respect that.
            else:
                # Create a new record with defaults for everything.
                cursor.execute("INSERT INTO %s (%s) VALUES (%s)" %

delete ¶

�� 하�� Model클�� delete�� 화했��. 하�� 하�� delete_objects��.8 delete_objects�� 하�� 테�� 함�� 하��, ��키�� NULL�� 한��. �� Risk테�� 한 �� 하�� 하�� Consequence, Control 테�� 함�� 하�� 화��.

----
django/Example

django/Modifying Object

insert & update ¶

delete ¶