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 ¶