I run :
./manage makemigrations and ./manage migrate with the following output:
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
(django_sql) mohsen@debian:~/Documents/django_sql/django_sql$ ./manage.py
makemigrations
Migrations for 'sql':
sql/migrations/0006_customertbl_employeepaytbl_employeetbl_orderstbl_productstbl.py
- Create model CustomerTbl
- Create model EmployeeTbl
- Create model OrdersTbl
- Create model ProductsTbl
- Create model EmployeePayTbl
(django_sql) mohsen@debian:~/Documents/django_sql/django_sql$ ./manage.py
migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions, sql
Running migrations:
Applying
sql.0006_customertbl_employeepaytbl_employeetbl_orderstbl_productstbl... OK
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
My models.py is:
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
from django.db import models
# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
# * Rearrange models' order
# * Make sure each model has one field with primary_key=True
# * Make sure each ForeignKey and OneToOneField has `on_delete` set to
the desired behavior
# * Remove `managed = False` lines if you wish to allow Django to create,
modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field
names.
class CustomerTbl(models.Model):
cust_id = models.CharField(db_column='CUST_ID', primary_key=True,
max_length=10) # Field name made lowercase.
cust_name = models.CharField(db_column='CUST_NAME', max_length=30) #
Field name made lowercase.
cust_address = models.CharField(db_column='CUST_ADDRESS',
max_length=20) # Field name made lowercase.
cust_city = models.CharField(db_column='CUST_CITY', max_length=15) #
Field name made lowercase.
cust_state = models.CharField(db_column='CUST_STATE', max_length=2) #
Field name made lowercase.
cust_zip = models.IntegerField(db_column='CUST_ZIP') # Field name made
lowercase.
cust_phone = models.CharField(db_column='CUST_PHONE', max_length=10,
blank=True, null=True) # Field name made lowercase.
cust_fax = models.CharField(db_column='CUST_FAX', max_length=10,
blank=True, null=True) # Field name made lowercase.
class Meta:
managed = False
db_table = 'CUSTOMER_TBL'
class EmployeePayTbl(models.Model):
emp = models.OneToOneField('EmployeeTbl', models.DO_NOTHING,
db_column='EMP_ID', primary_key=True) # Field name made lowercase.
position = models.CharField(db_column='POSITION', max_length=15) #
Field name made lowercase.
date_hire = models.DateField(db_column='DATE_HIRE', blank=True,
null=True) # Field name made lowercase.
pay_rate = models.DecimalField(db_column='PAY_RATE', max_digits=4,
decimal_places=2, blank=True, null=True) # Field name made lowercase.
date_last_raise = models.DateField(db_column='DATE_LAST_RAISE',
blank=True, null=True) # Field name made lowercase.
salary = models.DecimalField(db_column='SALARY', max_digits=8,
decimal_places=2, blank=True, null=True) # Field name made lowercase.
bonus = models.DecimalField(db_column='BONUS', max_digits=6,
decimal_places=2, blank=True, null=True) # Field name made lowercase.
class Meta:
managed = False
db_table = 'EMPLOYEE_PAY_TBL'
class EmployeeTbl(models.Model):
emp_id = models.CharField(db_column='EMP_ID', primary_key=True,
max_length=9) # Field name made lowercase.
last_name = models.CharField(db_column='LAST_NAME', max_length=15) #
Field name made lowercase.
first_name = models.CharField(db_column='FIRST_NAME', max_length=15) #
Field name made lowercase.
middle_name = models.CharField(db_column='MIDDLE_NAME', max_length=15,
blank=True, null=True) # Field name made lowercase.
address = models.CharField(db_column='ADDRESS', max_length=30) # Field
name made lowercase.
city = models.CharField(db_column='CITY', max_length=15) # Field name
made lowercase.
state = models.CharField(db_column='STATE', max_length=2) # Field name
made lowercase.
zip = models.IntegerField(db_column='ZIP') # Field name made lowercase.
phone = models.CharField(db_column='PHONE', max_length=10, blank=True,
null=True) # Field name made lowercase.
pager = models.CharField(db_column='PAGER', max_length=10, blank=True,
null=True) # Field name made lowercase.
class Meta:
managed = False
db_table = 'EMPLOYEE_TBL'
class OrdersTbl(models.Model):
ord_num = models.CharField(db_column='ORD_NUM', primary_key=True,
max_length=10) # Field name made lowercase.
cust_id = models.CharField(db_column='CUST_ID', max_length=10) # Field
name made lowercase.
prod_id = models.CharField(db_column='PROD_ID', max_length=10) # Field
name made lowercase.
qty = models.IntegerField(db_column='QTY') # Field name made lowercase.
ord_date = models.DateField(db_column='ORD_DATE', blank=True,
null=True) # Field name made lowercase.
class Meta:
managed = False
db_table = 'ORDERS_TBL'
class ProductsTbl(models.Model):
prod_id = models.CharField(db_column='PROD_ID', primary_key=True,
max_length=10) # Field name made lowercase.
prod_desc = models.CharField(db_column='PROD_DESC', max_length=40) #
Field name made lowercase.
cost = models.DecimalField(db_column='COST', max_digits=6,
decimal_places=2) # Field name made lowercase.
class Meta:
managed = False
db_table = 'PRODUCTS_TBL'
""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
But When I use the following command in mysql shell:
"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""
use esql;
show tables;
+----------------------------+
| Tables_in_esql |
+----------------------------+
| auth_group |
| auth_group_permissions |
| auth_permission |
| auth_user |
| auth_user_groups |
| auth_user_user_permissions |
| django_admin_log |
| django_content_type |
| django_migrations |
| django_session |
+----------------------------+
I don't see my tables.
What happen?
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9e88c777-6d8f-4de9-ae69-446b9e815e8fo%40googlegroups.com.
