{"id":917,"date":"2020-07-20T10:02:14","date_gmt":"2020-07-20T05:32:14","guid":{"rendered":"http:\/\/pahlevanzadeh.net\/?p=917"},"modified":"2020-07-20T10:12:34","modified_gmt":"2020-07-20T05:42:34","slug":"%d9%86%d9%88%d8%b4%d8%aa%d9%86-query-%d9%87%d8%a7%db%8c-sql-%d8%a8%d8%a7-django-%d9%82%d8%b3%d9%85%d8%aa-%d8%a7%d9%88%d9%84%d9%85%d9%82%d8%af%d9%85%d9%87","status":"publish","type":"post","link":"http:\/\/pahlevanzadeh.net\/?p=917","title":{"rendered":"\u0646\u0648\u0634\u062a\u0646 Query \u0647\u0627\u06cc SQL \u0628\u0627 Django (\u0642\u0633\u0645\u062a \u0627\u0648\u0644[\u0645\u0642\u062f\u0645\u0647])"},"content":{"rendered":"\n

\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0648 \u0645\u0637\u0627\u0644\u0628 \u0622\u062a\u06cc \u0627\u0635\u0644\u0627\u064b \u06a9\u0627\u0631\u06cc \u0646\u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 ORM \u0686\u06cc\u0633\u062a \u0648 \u0686\u0631\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0628\u0644\u06a9\u0647 \u0641\u0642\u0637 \u0642\u0635\u062f \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0647\u0631 query \u06a9\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0645\u0639\u0627\u062f\u0644 \u0622\u0646 \u0631\u0627 \u0628\u0627 Django ORM \u067e\u06cc\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062e\u0648\u0627\u0646\u0646\u062f\u0647 \u0627\u06cc\u0646 \u0634\u0645\u0627\u0631\u0647 \u0628\u06af\u0648\u06cc\u062f: “\u062e\u06cc\u0644\u06cc \u0627\u0632 \u0645\u0633\u0627\u06cc\u0644 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0628\u0647 \u062e\u0648\u062f \u062e\u0648\u0627\u0646\u0646\u062f\u0647 \u0648\u0627\u06af\u0630\u0627\u0631 \u06a9\u0631\u062f\u0647 \u0627\u0633\u062a”. \u0627\u0645\u0627 \u0642\u0631\u0627\u0631 \u0646\u06cc\u0633\u062a \u0627\u0632 \u0634\u0645\u0627\u0631\u0647 \u0628\u0639\u062f \u0686\u0646\u06cc\u0646 \u0628\u0627\u0634\u062f.<\/p>\n

\"\"<\/a>
Django Framework<\/figcaption><\/figure>\n

\u0628\u0631\u0627\u06cc dataset \u0627\u0632 dataset \u06a9\u062a\u0627\u0628 Sams Teach Yourlself sql in 24 hours \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0627\u0644\u0628\u062a\u0647 \u0627\u06cc\u0646 dataset \u0646\u0648\u0627\u0642\u0635\u06cc \u062f\u0627\u0631\u062f\u060c \u0627\u0645\u0627 \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u200c\u0647\u0627\u06cc \u0645\u0627 \u06a9\u0641\u0627\u06cc\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0627\u06cc\u0646 dataset \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646\u062c\u0627 \u062f\u0627\u0646\u0644\u0648\u062f<\/a> \u06a9\u0646\u06cc\u062f.<\/p>\n

\u0627\u06cc\u062c\u0627\u062f \u0645\u062f\u0644:<\/strong><\/p>\n

\u0646\u06a9\u062a\u0647:<\/strong> \u06cc\u06a9 \u067e\u0631\u0648\u0698\u0647 \u0628\u0633\u0627\u0632\u06cc\u062f \u0648 \u062f\u0631 \u0622\u0646 \u06cc\u06a9 app \u0628\u0627 \u0646\u0627\u0645 sql \u0628\u0633\u0627\u0632\u06cc\u062f.<\/p>\n

\u0646\u06a9\u062a\u0647:<\/strong> \u0641\u0627\u06cc\u0644\u200c\u0647\u0627\u06cc \u062f\u0627\u0646\u0644\u0648\u062f \u0634\u062f\u0647 \u0627\u0648\u0644\u06cc \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f table\u200c\u0647\u0627 \u0648 \u062f\u0648\u0645\u06cc \u0628\u0631\u0627\u06cc INSERT<\/em> \u06a9\u0631\u062f\u0646\u200c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0645\u06cc\u200c\u0628\u0627\u0634\u0646\u062f.<\/p>\n

\u0646\u06a9\u062a\u0647:<\/strong> \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u06af\u0648\u06cc\u06cc\u062f models.py<\/em> \u0631\u0627 \u0686\u06af\u0648\u0646\u0647 \u0628\u0633\u0627\u0632\u0645. \u0641\u0631\u0645\u0627\u0646 manage.py<\/em> \u06cc\u06a9 command \u062f\u0627\u0631\u062f \u0628\u0627 \u0646\u0627\u0645 inspectdb<\/em> \u06a9\u0647 \u0645\u062f\u0644 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06cc\u06a9 DB \u0648 \u06cc\u0627 \u06cc\u06a9 Table \u0631\u0627 \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u067e\u0631\u06cc\u0646\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f.<\/p>\n

.\/manage.py inspectdb<\/pre>\n
\u0646\u06a9\u062a\u0647:<\/strong> \u0641\u06cc\u0644\u062f managed<\/em> \u0631\u0627 \u0628\u0647 True \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc\u062a\u0627\u0646 \u062c\u062f\u0627\u0648\u0644 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u062f.<\/p>\n
\u0628\u0631\u0627\u06cc models.py<\/em> \u0622\u0646 \u06a9\u0644\u0627\u0633\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n
 <\/p>\n
from django.db import models\n\nclass CustomerTbl(models.Model):\n    cust_id = models.CharField(db_column='CUST_ID', primary_key=True, max_length=10)  # Field name made lowercase.\n    cust_name = models.CharField(db_column='CUST_NAME', max_length=30)  # Field name made lowercase.\n    cust_address = models.CharField(db_column='CUST_ADDRESS', max_length=20)  # Field name made lowercase.\n    cust_city = models.CharField(db_column='CUST_CITY', max_length=15)  # Field name made lowercase.\n    cust_state = models.CharField(db_column='CUST_STATE', max_length=2)  # Field name made lowercase.\n    cust_zip = models.IntegerField(db_column='CUST_ZIP')  # Field name made lowerscase.\n    cust_phone = models.CharField(db_column='CUST_PHONE', max_length=10, blank=True, null=True)  # Field name made lowercase.\n    cust_fax = models.CharField(db_column='CUST_FAX', max_length=10, blank=True, null=True)  # Field name made lowercase.\n\n    class Meta:\n        managed = True\n        db_table = 'CUSTOMER_TBL'\n\n\nclass EmployeePayTbl(models.Model):\n    emp = models.OneToOneField('EmployeeTbl', models.DO_NOTHING, db_column='EMP_ID', primary_key=True)  # Field name made lowercase.\n    position = models.CharField(db_column='POSITION', max_length=15)  # Field name made lowercase.\n    date_hire = models.DateField(db_column='DATE_HIRE', blank=True, null=True)  # Field name made lowercase.\n    pay_rate = models.DecimalField(db_column='PAY_RATE', max_digits=4, decimal_places=2, blank=True, null=True)  # Field name made lowercase.\n    date_last_raise = models.DateField(db_column='DATE_LAST_RAISE', blank=True, null=True)  # Field name made lowercase.\n    salary = models.DecimalField(db_column='SALARY', max_digits=8, decimal_places=2, blank=True, null=True)  # Field name made lowercase.\n    bonus = models.DecimalField(db_column='BONUS', max_digits=6, decimal_places=2, blank=True, null=True)  # Field name made lowercase.\n\n    class Meta:\n        managed = True\n        db_table = 'EMPLOYEE_PAY_TBL'\n\n\nclass EmployeeTbl(models.Model):\n    emp_id = models.CharField(db_column='EMP_ID', primary_key=True, max_length=9)  # Field name made lowercase.\n    last_name = models.CharField(db_column='LAST_NAME', max_length=15)  # Field name made lowercase.\n    first_name = models.CharField(db_column='FIRST_NAME', max_length=15)  # Field name made lowercase.\n    middle_name = models.CharField(db_column='MIDDLE_NAME', max_length=15, blank=True, null=True)  # Field name made lowercase.\n    address = models.CharField(db_column='ADDRESS', max_length=30)  # Field name made lowercase.\n    city = models.CharField(db_column='CITY', max_length=15)  # Field name made lowercase.\n    state = models.CharField(db_column='STATE', max_length=2)  # Field name made lowercase.\n    zip = models.IntegerField(db_column='ZIP')  # Field name made lowercase.\n    phone = models.CharField(db_column='PHONE', max_length=10, blank=True, null=True)  # Field name made lowercase.\n    pager = models.CharField(db_column='PAGER', max_length=10, blank=True, null=True)  # Field name made lowercase.\n\n    class Meta:\n        managed = True\n        db_table = 'EMPLOYEE_TBL'\n\n\nclass OrdersTbl(models.Model):\n    ord_num = models.CharField(db_column='ORD_NUM', primary_key=True, max_length=10)  # Field name made lowercase.\n    cust_id = models.CharField(db_column='CUST_ID', max_length=10)  # Field name made lowercase.\n    prod_id = models.CharField(db_column='PROD_ID', max_length=10)  # Field name made lowercase.\n    qty = models.IntegerField(db_column='QTY')  # Field name made lowercase.\n    ord_date = models.DateField(db_column='ORD_DATE', blank=True, null=True)  # Field name made lowercase.\n\n    class Meta:\n        managed = True\n        db_table = 'ORDERS_TBL'\n\n\nclass ProductsTbl(models.Model):\n    prod_id = models.CharField(db_column='PROD_ID', primary_key=True, max_length=10)  # Field name made lowercase.\n    prod_desc = models.CharField(db_column='PROD_DESC', max_length=40)  # Field name made lowercase.\n    cost = models.DecimalField(db_column='COST', max_digits=6, decimal_places=2)  # Field name made lowercase.\n\n    class  Meta:\n         managed = True\n         db_table = 'PRODUCTS_TBL'<\/pre>\n
\u0633\u067e\u0633 \u0628\u0627 \u0641\u0631\u0645\u0627\u0646\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u062c\u062f\u0627\u0648\u0644 \u0631\u0627 \u0627\u06cc\u062c\u0627\u062f \u0646\u0645\u0627\u06cc\u06cc\u062f:<\/p>\n
.\/manage.py makemigrations sql \n.\/manage.py migrate sql<\/pre>\n
\u0646\u06a9\u062a\u0647:<\/strong> \u0641\u0631\u0636 \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 \u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644 \u0648 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0622\u0646 \u062f\u0631 \u062e\u0648\u062f Django \u0622\u0634\u0646\u0627 \u0647\u0633\u062a\u06cc\u062f \u0648 \u0646\u06cc\u0627\u0632\u06cc \u0628\u0647 \u062a\u0648\u0636\u06cc\u062d \u0641\u0627\u06cc\u0644 models.py<\/em> \u0646\u06cc\u0633\u062a.<\/p>\n
\u0646\u06a9\u062a\u0647:<\/strong> \u0641\u0631\u0636 \u062f\u06cc\u06af\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0627 SQL \u0628\u0647 \u0635\u0648\u0631\u062a \u06a9\u0627\u0645\u0644 \u0622\u0634\u0646\u0627 \u0647\u0633\u062a\u06cc\u062f.<\/p>\n
 \u0646\u06a9\u062a\u0647:<\/strong> \u0641\u0631\u0636 \u062f\u06cc\u06af\u0631 \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0634\u0645\u0627 \u0628\u0627 \u0641\u0627\u06cc\u0644 settings.py<\/em> \u06a9\u0627\u0645\u0644\u0627\u064b \u0622\u0634\u0646\u0627\u06cc\u06cc \u062f\u0627\u0631\u06cc\u062f \u0648 \u0647\u0631 \u0686\u06cc\u0632\u06cc \u0631\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f setup \u06a9\u0646\u06cc\u062f.<\/p>\n
 \u0646\u06a9\u062a\u0647:<\/strong> \u0641\u0631\u0636 \u062f\u06cc\u06af\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0634\u0645\u0627 \u0628\u0627 virtualenv<\/em> \u0622\u0634\u0646\u0627 \u0647\u0633\u062a\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0646 \u0631\u0627 \u0641\u0639\u0627\u0644 \u0648 \u063a\u06cc\u0631 \u0641\u0639\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n
 \u0622\u0634\u0646\u0627\u06cc\u06cc \u0628\u0627 QuerySet:<\/strong><\/p>\n
QuerySet \u06cc\u06a9 data type \u0628\u0627 \u0646\u0627\u0645 django.db.models.query.QuerySet<\/em> \u0627\u0633\u062a \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f\u0647 \u0634\u062f\u0647 \u0627\u0632 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0631 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f. \u0627\u06af\u0631 \u06cc\u06a9 \u0646\u0648\u0639 \u06cc\u06a9 QuerySet \u0631\u0627 \u0628\u0627 \u062a\u0627\u0628\u0639 type<\/em> \u067e\u0631\u06cc\u0646\u062a \u0628\u06af\u06cc\u0631\u06cc\u062f \u0627\u06cc\u0646 \u0686\u0646\u06cc\u0646 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n
print(type(EmployeePayTbl.objects.all())<\/pre>\n
<class 'django.db.models.query.QuerySet'><\/pre>\n
\u0646\u06a9\u062a\u0647:<\/strong> \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0633\u0648\u0627\u0644 \u067e\u06cc\u0634 \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06a9\u0647 EmployeePayTbl<\/em> \u0686\u06cc\u0633\u062a. \u06cc\u06a9\u06cc \u0627\u0632 \u06a9\u0644\u0627\u0633\u200c\u0647\u0627\u06cc \u0641\u0627\u06cc\u0644 models.py<\/em> \u0645\u06cc\u200c\u0628\u0627\u0634\u062f\u060c \u06a9\u0647 \u0627\u0634\u0627\u0631\u0647 \u0628\u0647 \u062c\u062f\u0648\u0644 EMPLOYEE_PAY_TBL \u062f\u0627\u0631\u062f.<\/p>\n
\u0627\u06af\u0631  \u062a\u0627\u0628\u0639 \u0628\u0627\u0644\u0627 \u0631\u0627 \u067e\u0631\u06cc\u0646\u062a \u0628\u06af\u06cc\u0631\u06cc\u0645\u060c \u062e\u0631\u0648\u062c\u06cc\u200c\u0627\u0634 \u0646\u06cc\u0632 \u0632\u06cc\u0631 \u0622\u0646 \u0622\u0645\u062f\u0647 \u0627\u0633\u062a.<\/p>\n
print(EmployeePayTbl.objects.all())<\/pre>\n
<QuerySet [<EmployeePayTbl: EmployeePayTbl object (213764555)>, <EmployeePayTbl: EmployeePayTbl object (220984332)>, <EmployeePayTbl: EmployeePayTbl object (311549902)>, <EmployeePayTbl: EmployeePayTbl object (313782439)>, <EmployeePayTbl: EmployeePayTbl object (442346889)>, <EmployeePayTbl: EmployeePayTbl object (443679012)>]><\/pre>\n
\u0627\u06af\u0631 \u062f\u0631 \u0634\u0644 SQL \u0627\u0632 \u062c\u062f\u0648\u0644 \u0645\u0630\u06a9\u0648\u0631 Select<\/em> \u0628\u06af\u06cc\u0631\u06cc\u0645\u060c \u0646\u062a\u06cc\u062c\u0647 \u0632\u06cc\u0631 \u062d\u0627\u0635\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n
MariaDB [esql]> select * from EMPLOYEE_PAY_TBL;\n+-----------+---------------+------------+----------+-----------------+----------+---------+\n| EMP_ID    | POSITION      | DATE_HIRE  | PAY_RATE | DATE_LAST_RAISE | SALARY   | BONUS   |\n+-----------+---------------+------------+----------+-----------------+----------+---------+\n| 213764555 | SALES MANAGER | 2004-08-14 |     NULL | 2009-08-01      | 30000.00 | 2000.00 |\n| 220984332 | SHIPPER       | 2006-07-22 |    11.00 | 1999-07-01      |     NULL |    NULL |\n| 311549902 | MARKETING     | 1999-05-23 |     NULL | 2009-05-01      | 40000.00 |    NULL |\n| 313782439 | SALESMAN      | 2007-06-28 |     NULL | NULL            | 20000.00 | 1000.00 |\n| 442346889 | TEAM LEADER   | 2000-06-17 |    14.75 | 2009-06-01      |     NULL |    NULL |\n| 443679012 | SHIPPER       | 2001-01-14 |    15.00 | 1999-01-01      |     NULL |    NULL |\n+-----------+---------------+------------+----------+-----------------+----------+---------+\n<\/pre>\n
\u0633\u0648\u0627\u0644\u06cc \u06a9\u0647 \u0645\u0637\u0631\u062d \u0645\u06cc\u200c\u0634\u0648\u062f \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0686\u0631\u0627 \u0641\u0642\u0637 \u0641\u06cc\u0644\u062f \u0627\u0648\u0644 \u062f\u0631 QuerySet \u067e\u0631\u06cc\u0646\u062a \u0645\u06cc\u200c\u0634\u0648\u062f. \u062f\u0631 \u067e\u0627\u06cc\u062a\u0648\u0646 \u062a\u0627\u0628\u0639\u06cc \u0628\u0627 \u0646\u0627\u0645 __str__<\/em> \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u062f \u062f\u0627\u062e\u0644 \u0647\u0631 \u06a9\u0644\u0627\u0633\u06cc override \u0634\u0648\u062f \u0648 \u0646\u0648\u0639 \u0646\u0645\u0627\u06cc\u0634 string \u062e\u0631\u0648\u062c\u06cc \u0631\u0627 \u0645\u0634\u062e\u0635 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0641\u0631\u0636 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0641\u06cc\u0644\u062f POSITION<\/em> \u0631\u0627 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0647\u06cc\u0645. \u062f\u0631 \u0646\u062a\u06cc\u062c\u0647 \u0627\u06cc\u0646 \u062a\u0627\u0628\u0639 \u0631\u0627 \u0628\u0647 \u06a9\u0644\u0627\u0633 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645:<\/p>\n
     def  __str__(self):\n           return str(self.position)<\/pre>\n
\u062e\u0631\u0648\u062c\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a \u0632\u06cc\u0631 \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n
<QuerySet [<EmployeePayTbl: SALES MANAGER>, <EmployeePayTbl: SHIPPER>, <EmployeePayTbl: MARKETING>, <EmployeePayTbl: SALESMAN>, <EmployeePayTbl: TEAM LEADER>, <EmployeePayTbl: SHIPPER>]> <\/pre>\n
\u0646\u06a9\u062a\u0647:<\/strong> \u062a\u0627\u0628\u0639 all \u06a9\u0647 \u062f\u0631 \u0628\u0627\u0644\u0627 \u0645\u062b\u0627\u0644 \u0632\u062f\u0647 \u0634\u062f\u060c \u06cc\u06a9 QuerySet \u0628\u0631 \u0645\u06cc\u200c\u06af\u0631\u062f\u0627\u0646\u062f \u06a9\u0647 \u06a9\u0644 row \u0647\u0627\u06cc \u0634\u0645\u0627 \u0631\u0627 \u0634\u0627\u0645\u0644 \u0645\u06cc\u200c\u0634\u0648\u062f.<\/p>\n
\u0628\u0647 \u062a\u06a9\u0647 \u06a9\u062f \u0632\u06cc\u0631 \u062f\u0642\u062a \u06a9\u0646\u06cc\u062f:<\/p>\n
for row in EmployeePayTbl.objects.all():\n    print(row)<\/pre>\n
\u06a9\u0644 row \u0647\u0627\u06cc \u062c\u062f\u0648\u0644 \u0628\u0631\u06af\u0634\u062a\u0647 \u0634\u062f\u0647 \u0631\u0627 \u067e\u0631\u06cc\u0646\u062a \u0645\u06cc\u200c\u06a9\u0646\u062f:<\/p>\n
SALES MANAGER\n\nSHIPPER\nMARKETING\nSALESMAN\nTEAM LEADER\nSHIPPER\n<\/pre>\n
\u062f\u0631 \u0645\u0637\u0627\u0644\u0628 \u0628\u0639\u062f\u06cc \u0628\u0647 \u0635\u0648\u0631\u062a \u062c\u062f\u06cc \u0628\u0647 \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0627\u0646\u0648\u0627\u0639 query \u062f\u0631 Django \u0645\u06cc\u200c\u067e\u0631\u062f\u0627\u0632\u06cc\u0645.<\/p>\n
\u0645\u0637\u0627\u0644\u0628 \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 ORM \u062c\u0646\u06af\u0648 \u0627\u062f\u0627\u0645\u0647 \u062e\u0648\u0627\u0647\u0646\u062f \u062f\u0627\u0634\u062a. \u0645\u0646\u062a\u0638\u0631 \u0628\u0627\u0634\u06cc\u062f.<\/strong><\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0648 \u0645\u0637\u0627\u0644\u0628 \u0622\u062a\u06cc \u0627\u0635\u0644\u0627\u064b \u06a9\u0627\u0631\u06cc \u0646\u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 ORM \u0686\u06cc\u0633\u062a \u0648 \u0686\u0631\u0627 \u0628\u0627\u06cc\u062f \u0627\u0632 \u0622\u0646 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f. \u0628\u0644\u06a9\u0647 \u0641\u0642\u0637 \u0642\u0635\u062f \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u0647\u0631 query \u06a9\u0647 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0645\u0639\u0627\u062f\u0644 \u0622\u0646 \u0631\u0627 \u0628\u0627 Django ORM \u067e\u06cc\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645. \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062e\u0648\u0627\u0646\u0646\u062f\u0647 \u0627\u06cc\u0646 \u0634\u0645\u0627\u0631\u0647 \u0628\u06af\u0648\u06cc\u062f: “\u062e\u06cc\u0644\u06cc \u0627\u0632 \u0645\u0633\u0627\u06cc\u0644 \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u067e\u06cc\u0634\u200c\u0641\u0631\u0636 \u0628\u0647 \u062e\u0648\u062f \u062e\u0648\u0627\u0646\u0646\u062f\u0647 … \u0627\u062f\u0627\u0645\u0647 \u062e\u0648\u0627\u0646\u062f\u0646 \u0646\u0648\u0634\u062a\u0646 Query \u0647\u0627\u06cc SQL \u0628\u0627 Django (\u0642\u0633\u0645\u062a \u0627\u0648\u0644[\u0645\u0642\u062f\u0645\u0647])<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110],"tags":[337,347,345,341,338,346,343,342,66,344,340],"_links":{"self":[{"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/917"}],"collection":[{"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=917"}],"version-history":[{"count":44,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions"}],"predecessor-version":[{"id":1022,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=\/wp\/v2\/posts\/917\/revisions\/1022"}],"wp:attachment":[{"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=917"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/pahlevanzadeh.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}