�� 회할 �� Model클�� 하�� Manager클�� 한��. �� 하�� , �� object�� 한��. object �� 회하�� QuerySet�� 환��. �� 형 �� CLI�� JDBC�� ResultSet�� 하��.

filter ¶

한 �� 해�� 할 �� . �� SQL�� where�� 해��하�� 할�� 한��. �� 하�� , �� , �� , 포함, �� . �� AND ��합�� , OR��합�� 하�� Q�� 트�� 해�� 한��.9 �� 해 �� 2006�� 10�� 1�� 험 �� python�� 해��하�� SQL�� .

RiskReport.objects.filter(date__gt=datetime.date(2006, 10, 1))

SELECT ... FROM risk_report
WHERE date > '2006-10-1'

select_related ¶

�� selete_related�� 하�� 횟�� . �� 회�� 화�� 행할 �� 행한��. 하�� selete_related�� 하�� 한 �� 할 �� 한��. �� 확��할 �� .

# ������������������������ 한 ��� ������ ������������.
c = ControlReport.objects.get(id=1)
# Employee테��������� ������하��� ���해 ������ ������������������������ ������ ������������.
r = c.reporter

# ������������������������ ������ ������ ������������.
c = ControlReport.objects.select_related().get(id=1)
# ��������� Employee��������� ������������ ��������� ������ ������������������������ ������ ������������ ���������.
r = c.reporter

extra ¶

�� 하�� extra�� 해 ��하�� 한 �� . �� 2006�� 1�� 1�� 표��하�� 포트 �� .

RiskReport.objects.extra(select={'is_recent': " date > '2006-01-01'"})

�� SQL�� .

SELECT blog_entry.*, (pub_date > '2006-01-01')
FROM blog_entry;

extra�� 하�� 한 �� 할 �� . �� 험 �� 했�� .

Employee.objects.extra(
    select={
        'num_of_report': 'SELECT COUNT(*) FROM risk_report WHERE risk_report.reporter = employee.id'
    },
)

SELECT employee.*, (SELECT COUNT(*) FROM risk_report WHERE risk_report.reporter = employee.id)
FROM employee;

where�� 하�� 하��.7 하�� 하�� .

RiskReport.objects.extra(where=['id IN (3, 4, 5, 20)'])

SELECT * FROM risk_report WHERE id IN (3, 4, 5, 20);

values ¶

�� values함�� 해�� 하�� 할 �� . �� 하�� 한 �� 하�� 효��. ��한 values함�� QuerySet�� 한 ValuesQuerySet�� 하�� 한 �� 할 �� . 하�� ValuesQuerySet�� 형(dictionary) �� , �� 하��. �� .

Employee.objects.values('email')

join ¶

Django�� 하�� . SQL�� 행하�� 하�� . �� JDBC�� 페�� 하��, �� 하�� 행한 �� 하�� 한��. �� 행한 ��험 �� 함��.

def getDartmentControl(depart_id):
    from django.db import connection
    cursor = connection.cursor()
qeury=' ' '
select report_controlreport.content 
from report_controlreport, report_department_employees
where report_department_employees.department_id = report_department_employees.employee_id 
   and report_department_employees.employee_id = report_controlreport.reporter_id
   and report_department_employees.department_id= %d' ' '
    cursor.execute(query, [depart_id])
    row = cursor.fetchone()
    return row

----
django/Example

django/Retrieving Object

filter ¶

select_related ¶

extra ¶

values ¶

join ¶