bug_x

导航

 
 pip install django

 pip install psycopg2
 
 pip install mysqlclient    

Entity.py

from django.db import models
from django.conf import settings
import django
INSTALLED_APPS = [
    "Entity"
]

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'baby_name',
        'USER': 'root',
        'PASSWORD': '',
        'HOST': '127.0.0.1',
        'PORT': '3306',
    }
}
settings.configure(DATABASES=DATABASES, INSTALLED_APPS=INSTALLED_APPS)
django.setup()
"""
Name Model
"""
class Name(models.Model):
    # name = models.CharField(db_column=u'id', max_length=512, primary_key=true)

    name = models.TextField(db_column=u'name')    #name 是字段名称
    # name = models.CharField(max_length=200)
    # id = models.CharField(max_length=200)
    # pub_date = models.DateTimeField('date published')

    def __unicode__(self):
        return 'name'
   ## table_name
    class Meta:
        db_table = 'name'

test_db.py

from Entity import Name
def getNames():
    all_baby_names = Name.objects.all()
    for i in all_baby_names:
        print(i.name)


if __name__ == "__main__":
    getNames()    

两个文件放在同一个目录...

 

posted on 2019-09-04 09:42  bug_x  阅读(420)  评论(0编辑  收藏  举报