python學(xué)習(xí)

判斷字段值是否包含某個(gè)數(shù)字,如果是字符，建議用icontains

Entry.objects.filter(Q(id__contains='1') & Q(id__contains='2') & Q(id__contains='3'))

Entry.objects.filter(Q(id__contains=1) & Q(id__contains=2) & Q(id__contains=3))

Entry.objects.filter(reduce(Q(id__contains=x) for x in [1, 2, 3]))

管理員身份運(yùn)行cmd配置虛擬環(huán)境

mkvirtualenv youpinmodel
pip install django==1.9.8
下載python的mysql驅(qū)動(dòng)轩娶，進(jìn)入到文件目錄cd /d C:\Users\Administrator\Desktop
pip install mysql(tab)
在虛擬環(huán)境youpinmodel中新建項(xiàng)目
pip install pillow

根據(jù)項(xiàng)目需求設(shè)計(jì)app

users-用戶管理
employee-考核對象管理
institution-制度管理
informationinput-考核信息錄入

配置數(shù)據(jù)庫連接

#數(shù)據(jù)庫連接配置
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': "youpin1",
        'USER':'root',
        'PASSWORD':'',
        'HOST':'127.0.0.1'
    }
}

新建users app

startapp users

model配置

#載入utf8編碼
# _*_ encoding:utf-8 _*_
#繼承app
from django.contrib.auth.models import AbstractUser
#新建模型框往，CharField要定義max_length
class UserProfile(AbstractUser):
    nick_name = models.CharField(max_length=50, verbose_name=u"昵稱", default="")
    birday = models.DateField(verbose_name=u"生日", null=True, blank=True)
    gender = models.CharField(max_length=6, choices=(("male",u"男"),("female","女")), default="female")
    image = models.ImageField(upload_to="image/%Y/%m",default=u"image/default.png", max_length=100)
    user_id = models.CharField(max_length=11, null=True, blank=True)

    class Meta:
        verbose_name = "用戶信息"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.username

將UserProfile注冊到app中，并重載setting方法

此步前一定要restart一下椰弊，否則后面xadmin就要重新生成auth_user，或者注釋掉下面一句重新生成下表

AUTH_USER_MODEL = "users.UserProfile"

生成user表

makemigrations users
migrate users

新建剩余app

考核對象表

class w_section(models.Model):
    w_sectionid = models.CharField(max_length=2, verbose_name=u"工段ID")
    name = models.CharField(max_length=50, verbose_name=u"工段名")

    class Meta:
        verbose_name = u"工段"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name

class w_team(models.Model):
    w_teamid = models.CharField(max_length=4, verbose_name=u"車間班組ID",default=0)
    name = models.CharField(max_length=50, verbose_name=u"車間班組名")

    class Meta:
        verbose_name = u"車間班組"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name


class w_employee(models.Model):
    w_employeeid = models.CharField(max_length=10, verbose_name=u"員工編號(hào)",default=0)
    name = models.CharField(max_length=50, verbose_name=u"員工姓名")
    w_sectionid = models.ForeignKey(w_section, verbose_name=u"所屬工段")
    w_teamid = models.ForeignKey(w_team, verbose_name=u"所屬車間班組")

    class Meta:
        verbose_name = u"員工信息管理"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name

制度表

class inscategory(models.Model):
    categoryid = models.CharField(max_length=2, verbose_name=u"制度類別ID")
    category = models.CharField(max_length=50, verbose_name=u"制度類別")

    class Meta:
        verbose_name = u"制度分類"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.category

class institution(models.Model):
    categoryid = models.ForeignKey(inscategory, verbose_name=u"制度類別ID")
    institution = models.CharField(max_length=50, verbose_name=u"制度內(nèi)容")
    institutionid = models.CharField(max_length=10, verbose_name=u"制度ID")
    score = models.CharField(max_length=2, verbose_name=u"加扣分")

    class Meta:
        verbose_name = u"制度"
        verbose_name_plural = verbose_name
    def __unicode__(self):
        return self.institutionid

考核信息錄入贤重，操作上面兩張表

class informationinput(models.Model):
    "考核信息錄入"
    user=models.ForeignKey(UserProfile,verbose_name=u"考核員")
    category=models.ForeignKey(institution,verbose_name="制度ID和加扣分")
    sketch=models.CharField(max_length=500,verbose_name=u"簡述")
    w_employeeid = models.ForeignKey(w_employee, verbose_name=u"考核對象")
    add_time=models.DateTimeField(default=datetime.now, verbose_name=u"添加時(shí)間")
    image = models.ImageField(upload_to="information/%y/%m", default=u"information/default.png", max_length=100)
    has_agree=models.BooleanField(default=False,verbose_name=u"是否審查通過")

    class Meta:
        verbose_name = u"考核信息"
        verbose_name_plural = verbose_name

將所有app放到apps文件夾下

import sys
sys.path.insert(0, os.path.join(BASE_DIR, 'apps'))
python manage.py runserver 0.0.0.0:8000

后臺(tái)管理配置

createsuperuser
LANGUAGE_CODE = 'zh-hans'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = False
#使用本地時(shí)間

安裝xadmin

pip install xadmin
#注冊app
    'xadmin',
    'crispy_forms',
#url注冊
import xadmin
    url(r'^xadmin/', xadmin.site.urls),
#同步表
makemigrations
migrate
#移動(dòng)xadmin到extra_apps中清焕，并mark
sys.path.insert(0, os.path.join(BASE_DIR, 'extra_apps'))
pip uninstall xadmin
makemigrations xadmin
migrate xadmin

設(shè)置模板祭犯，注冊其它app

# -*- coding: utf-8 -*-
__author__ = 'grl'
__date__ = '$DATE $TIME'
#制度app
import xadmin

from .models import inscategory,institution

class inscategoryAdmin(object):
    list_display = ['categoryid', 'category']
    search_fields = ['categoryid', 'category']
    list_filter = ['categoryid', 'category']

class institutionAdmin(object):
    list_display = ['categoryid', 'institution','institutionid','score']
    search_fields = ['categoryid', 'institution','institutionid','score']
    list_filter = ['categoryid', 'institution','institutionid','score']

xadmin.site.register(inscategory, inscategoryAdmin)
xadmin.site.register(institution, institutionAdmin)
#員工app
import xadmin

from .models import w_section,w_team,w_employee

class w_sectionAdmin(object):
    list_display = ['w_sectionid', 'name']
    search_fields = ['w_sectionid', 'name']
    list_filter = ['w_sectionid', 'name']

class w_teamAdmin(object):
    list_display = ['w_teamid', 'name']
    search_fields = ['w_teamid', 'name']
    list_filter = ['w_teamid', 'name']
    
class w_employeeAdmin(object):
    list_display = ['w_employeeid', 'name','w_sectionid','w_teamid']
    search_fields = ['w_employeeid', 'name','w_sectionid','w_teamid']
    list_filter = ['w_employeeid', 'name','w_sectionid','w_teamid']

xadmin.site.register(w_section, w_sectionAdmin)
xadmin.site.register(w_team, w_teamAdmin)
xadmin.site.register(w_employee, w_employeeAdmin)
#考核信息錄入app
import xadmin

from .models import informationinput

class informationinputAdmin(object):
    list_display = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']
    search_fields = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']
    list_filter = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']

xadmin.site.register(informationinput, informationinputAdmin)
#用戶adminx中配置全站基礎(chǔ)
import xadmin
from xadmin import views

class BaseSetting(object):
    enable_themes = True
    use_bootswatch = True

class GlobalSettings(object):
    site_title = "信息后臺(tái)管理系統(tǒng)"
    site_footer = ""


xadmin.site.register(views.BaseAdminView, BaseSetting)
xadmin.site.register(views.CommAdminView, GlobalSettings)
#apps.py中配置中文顯示
# -*- coding: utf-8 -*-
    verbose_name = u"制度管理"
#_init_文件中配置
default_app_config = "institution.apps.InstitutionConfig"

問題總結(jié)

獲取當(dāng)前用戶姓名：

重載save_models方法直接在方法中通過self.request.user就可以獲取到當(dāng)前操作xadmin的用戶了

外鍵過濾

def get_context(self):
   context = superCourseAdmin, self).get_context()
   if 'form' in context:
       context['form'].fields['course_org'].queryset = CourseOrg.objects.filter(is_main_stage=True)
   return context
#在adminx里面重載這個(gè)函數(shù)滚停，在xadmin中可以直接配置外鍵過濾 比如course的teacher是外鍵 如果要通過teacher的name過濾 直接在filter中寫 "teahcer__name"就行了， 注意是雙下劃線

設(shè)置mysql只能本地訪問

配置mysql的bind-addr 只需要配置成127.0.0.1

獲取用戶名等

獲取當(dāng)前用戶姓名：

重載save_models方法直接在方法中通過self.request.user就可以獲取到當(dāng)前操作xadmin的用戶了

外鍵過濾

def get_context(self):
   context = superCourseAdmin, self).get_context()
   if 'form' in context:
       context['form'].fields['course_org'].queryset = CourseOrg.objects.filter(is_main_stage=True)
   return context
#在adminx里面重載這個(gè)函數(shù)键畴，在xadmin中可以直接配置外鍵過濾 比如course的teacher是外鍵 如果要通過teacher的name過濾 直接在filter中寫 "teahcer__name"就行了， 注意是雙下劃線

設(shè)置mysql只能本地訪問

配置mysql的bind-addr 只需要配置成127.0.0.1

管理員身份運(yùn)行cmd配置虛擬環(huán)境

mkvirtualenv youpinmodel
pip install django==1.9.8
下載python的mysql驅(qū)動(dòng)起惕，進(jìn)入到文件目錄cd /d C:\Users\Administrator\Desktop
pip install mysql(tab)
在虛擬環(huán)境youpinmodel中新建項(xiàng)目
pip install pillow

根據(jù)項(xiàng)目需求設(shè)計(jì)app

users-用戶管理
employee-考核對象管理
institution-制度管理
informationinput-考核信息錄入

配置數(shù)據(jù)庫連接

#數(shù)據(jù)庫連接配置
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': "youpin1",
        'USER':'root',
        'PASSWORD':'',
        'HOST':'127.0.0.1'
    }
}

新建users app

startapp users

model配置

#載入utf8編碼
# _*_ encoding:utf-8 _*_
#繼承app
from django.contrib.auth.models import AbstractUser
#新建模型，CharField要定義max_length
class UserProfile(AbstractUser):
    nick_name = models.CharField(max_length=50, verbose_name=u"昵稱", default="")
    birday = models.DateField(verbose_name=u"生日", null=True, blank=True)
    gender = models.CharField(max_length=6, choices=(("male",u"男"),("female","女")), default="female")
    image = models.ImageField(upload_to="image/%Y/%m",default=u"image/default.png", max_length=100)
    user_id = models.CharField(max_length=11, null=True, blank=True)

    class Meta:
        verbose_name = "用戶信息"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.username

將UserProfile注冊到app中惹想，并重載setting方法

此步前一定要restart一下，否則后面xadmin就要重新生成auth_user勺馆，或者注釋掉下面一句重新生成下表

AUTH_USER_MODEL = "users.UserProfile"

生成user表

makemigrations users
migrate users

新建剩余app

考核對象表

class w_section(models.Model):
    w_sectionid = models.CharField(max_length=2, verbose_name=u"工段ID")
    name = models.CharField(max_length=50, verbose_name=u"工段名")

    class Meta:
        verbose_name = u"工段"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name

class w_team(models.Model):
    w_teamid = models.CharField(max_length=4, verbose_name=u"車間班組ID",default=0)
    name = models.CharField(max_length=50, verbose_name=u"車間班組名")

    class Meta:
        verbose_name = u"車間班組"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name


class w_employee(models.Model):
    w_employeeid = models.CharField(max_length=10, verbose_name=u"員工編號(hào)",default=0)
    name = models.CharField(max_length=50, verbose_name=u"員工姓名")
    w_sectionid = models.ForeignKey(w_section, verbose_name=u"所屬工段")
    w_teamid = models.ForeignKey(w_team, verbose_name=u"所屬車間班組")

    class Meta:
        verbose_name = u"員工信息管理"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.name

制度表

class inscategory(models.Model):
    categoryid = models.CharField(max_length=2, verbose_name=u"制度類別ID")
    category = models.CharField(max_length=50, verbose_name=u"制度類別")

    class Meta:
        verbose_name = u"制度分類"
        verbose_name_plural = verbose_name

    def __unicode__(self):
        return self.category

class institution(models.Model):
    categoryid = models.ForeignKey(inscategory, verbose_name=u"制度類別ID")
    institution = models.CharField(max_length=50, verbose_name=u"制度內(nèi)容")
    institutionid = models.CharField(max_length=10, verbose_name=u"制度ID")
    score = models.CharField(max_length=2, verbose_name=u"加扣分")

    class Meta:
        verbose_name = u"制度"
        verbose_name_plural = verbose_name
    def __unicode__(self):
        return self.institutionid

考核信息錄入，操作上面兩張表

class informationinput(models.Model):
    "考核信息錄入"
    user=models.ForeignKey(UserProfile,verbose_name=u"考核員")
    category=models.ForeignKey(institution,verbose_name="制度ID和加扣分")
    sketch=models.CharField(max_length=500,verbose_name=u"簡述")
    w_employeeid = models.ForeignKey(w_employee, verbose_name=u"考核對象")
    add_time=models.DateTimeField(default=datetime.now, verbose_name=u"添加時(shí)間")
    image = models.ImageField(upload_to="information/%y/%m", default=u"information/default.png", max_length=100)
    has_agree=models.BooleanField(default=False,verbose_name=u"是否審查通過")

    class Meta:
        verbose_name = u"考核信息"
        verbose_name_plural = verbose_name

將所有app放到apps文件夾下

import sys
sys.path.insert(0, os.path.join(BASE_DIR, 'apps'))
python manage.py runserver 0.0.0.0:8000

后臺(tái)管理配置

createsuperuser
LANGUAGE_CODE = 'zh-hans'

TIME_ZONE = 'Asia/Shanghai'

USE_I18N = True

USE_L10N = True

USE_TZ = False
#使用本地時(shí)間

安裝xadmin

pip install xadmin
#注冊app
    'xadmin',
    'crispy_forms',
#url注冊
import xadmin
    url(r'^xadmin/', xadmin.site.urls),
#同步表
makemigrations
migrate
#移動(dòng)xadmin到extra_apps中灌灾，并mark
sys.path.insert(0, os.path.join(BASE_DIR, 'extra_apps'))
pip uninstall xadmin
makemigrations xadmin
migrate xadmin

設(shè)置模板，注冊其它app

# -*- coding: utf-8 -*-
__author__ = 'grl'
__date__ = '$DATE $TIME'
#制度app
import xadmin

from .models import inscategory,institution

class inscategoryAdmin(object):
    list_display = ['categoryid', 'category']
    search_fields = ['categoryid', 'category']
    list_filter = ['categoryid', 'category']

class institutionAdmin(object):
    list_display = ['categoryid', 'institution','institutionid','score']
    search_fields = ['categoryid', 'institution','institutionid','score']
    list_filter = ['categoryid', 'institution','institutionid','score']

xadmin.site.register(inscategory, inscategoryAdmin)
xadmin.site.register(institution, institutionAdmin)
#員工app
import xadmin

from .models import w_section,w_team,w_employee

class w_sectionAdmin(object):
    list_display = ['w_sectionid', 'name']
    search_fields = ['w_sectionid', 'name']
    list_filter = ['w_sectionid', 'name']

class w_teamAdmin(object):
    list_display = ['w_teamid', 'name']
    search_fields = ['w_teamid', 'name']
    list_filter = ['w_teamid', 'name']
    
class w_employeeAdmin(object):
    list_display = ['w_employeeid', 'name','w_sectionid','w_teamid']
    search_fields = ['w_employeeid', 'name','w_sectionid','w_teamid']
    list_filter = ['w_employeeid', 'name','w_sectionid','w_teamid']

xadmin.site.register(w_section, w_sectionAdmin)
xadmin.site.register(w_team, w_teamAdmin)
xadmin.site.register(w_employee, w_employeeAdmin)
#考核信息錄入app
import xadmin

from .models import informationinput

class informationinputAdmin(object):
    list_display = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']
    search_fields = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']
    list_filter = ['user', 'category','sketch','w_employeeid','add_time','image','has_agree']

xadmin.site.register(informationinput, informationinputAdmin)
#用戶adminx中配置全站基礎(chǔ)
import xadmin
from xadmin import views

class BaseSetting(object):
    enable_themes = True
    use_bootswatch = True

class GlobalSettings(object):
    site_title = "信息后臺(tái)管理系統(tǒng)"
    site_footer = ""


xadmin.site.register(views.BaseAdminView, BaseSetting)
xadmin.site.register(views.CommAdminView, GlobalSettings)
#apps.py中配置中文顯示
# -*- coding: utf-8 -*-
    verbose_name = u"制度管理"
#_init_文件中配置
default_app_config = "institution.apps.InstitutionConfig"

最后編輯于：2017.12.09 00:39:41

?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者

人面猴
序言：七十年代末锋喜，一起剝皮案震驚了整個(gè)濱河市豌鸡，隨后出現(xiàn)的幾起案子，更是在濱河造成了極大的恐慌涯冠，老刑警劉巖炉奴，帶你破解...
沈念sama閱讀 217,509評論 6贊 504
死咒
序言：濱河連續(xù)發(fā)生了三起死亡事件瞻赶，死亡現(xiàn)場離奇詭異，居然都是意外死亡派任，警方通過查閱死者的電腦和手機(jī)，發(fā)現(xiàn)死者居然都...
沈念sama閱讀 92,806評論 3贊 394
救了他兩次的神仙讓他今天三更去死
文/潘曉璐我一進(jìn)店門掌逛，熙熙樓的掌柜王于貴愁眉苦臉地迎上來，“玉大人豆混，你說我怎么就攤上這事篓像。” “怎么了员辩？”我有些...
開封第一講書人閱讀 163,875評論 0贊 354
道士緝兇錄：失蹤的賣姜人
文/不壞的土叔我叫張陵，是天一觀的道長屈暗。經(jīng)常有香客問我拆讯，道長养叛，這世上最難降的妖魔是什么？我笑而不...
開封第一講書人閱讀 58,441評論 1贊 293
?港島之戀（遺憾婚禮）
正文為了忘掉前任弃甥，我火速辦了婚禮，結(jié)果婚禮上淆攻，老公的妹妹穿的比我還像新娘阔墩。我一直安慰自己瓶珊，他們只是感情好，可當(dāng)我...
茶點(diǎn)故事閱讀 67,488評論 6贊 392
惡毒庶女頂嫁案：這布局不是一般人想出來的
文/花漫我一把揭開白布伞芹。她就那樣靜靜地躺著，像睡著了一般唱较。火紅的嫁衣襯著肌膚如雪扎唾。梳的紋絲不亂的頭發(fā)上南缓，一...
開封第一講書人閱讀 51,365評論 1贊 302
城市分裂傳說
那天，我揣著相機(jī)與錄音汉形，去河邊找鬼纸镊。笑死获雕，一個(gè)胖子當(dāng)著我的面吹牛收捣，可吹牛的內(nèi)容都是我干的届案。我是一名探鬼主播罢艾，決...
沈念sama閱讀 40,190評論 3贊 418
雙鴛鴦連環(huán)套：你想象不到人心有多黑
文/蒼蘭香墨我猛地睜開眼尽纽，長吁一口氣：“原來是場噩夢啊……” “哼！你這毒婦竟也來了童漩？” 一聲冷哼從身側(cè)響起，我...
開封第一講書人閱讀 39,062評論 0贊 276
萬榮殺人案實(shí)錄
序言：老撾萬榮一對情侶失蹤矫膨，失蹤者是張志新（化名）和其女友劉穎，沒想到半個(gè)月后侧馅，有當(dāng)?shù)厝嗽跇淞掷锇l(fā)現(xiàn)了一具尸體危尿，經(jīng)...
沈念sama閱讀 45,500評論 1贊 314
?護(hù)林員之死
正文獨(dú)居荒郊野嶺守林人離奇死亡馁痴，尸身上長有42處帶血的膿包…… 初始之章·張勛以下內(nèi)容為張勛視角年9月15日...
茶點(diǎn)故事閱讀 37,706評論 3贊 335
?白月光啟示錄
正文我和宋清朗相戀三年，在試婚紗的時(shí)候發(fā)現(xiàn)自己被綠了罗晕。大學(xué)時(shí)的朋友給我發(fā)了我未婚夫和他白月光在一起吃飯的照片。...
茶點(diǎn)故事閱讀 39,834評論 1贊 347
活死人
序言：一個(gè)原本活蹦亂跳的男人離奇死亡小渊，死狀恐怖法褥，靈堂內(nèi)的尸體忽然破棺而出酬屉，到底是詐尸還是另有隱情，我是刑警寧澤梆惯，帶...
沈念sama閱讀 35,559評論 5贊 345
?日本核電站爆炸內(nèi)幕
正文年R本政府宣布，位于F島的核電站垛吗，受9級特大地震影響凹髓，放射性物質(zhì)發(fā)生泄漏怯屉。R本人自食惡果不足惜，卻給世界環(huán)境...
茶點(diǎn)故事閱讀 41,167評論 3贊 328
男人毒藥：我在死后第九天來索命
文/蒙蒙一锨络、第九天我趴在偏房一處隱蔽的房頂上張望赌躺。院中可真熱鬧羡儿，春花似錦、人聲如沸。這莊子的主人今日做“春日...
開封第一講書人閱讀 31,779評論 0贊 22
一樁弒父案，背后竟有這般陰謀
文/蒼蘭香墨我抬頭看了看天上的太陽肤粱。三九已至弹囚，卻和暖如春领曼，著一層夾襖步出監(jiān)牢的瞬間，已是汗流浹背庶骄。一陣腳步聲響...
開封第一講書人閱讀 32,912評論 1贊 269
情欲美人皮
我被黑心中介騙來泰國打工宋舷，沒想到剛下飛機(jī)就差點(diǎn)兒被人妖公主榨干…… 1. 我叫王不留瓢姻，地道東北人。一個(gè)月前我還...
沈念sama閱讀 47,958評論 2贊 370
代替公主和親
正文我出身青樓幻碱，卻偏偏與公主長得像绎狭，于是被迫代替她去往敵國和親褥傍。傳聞我的和親對象是個(gè)殘疾皇子，可洞房花燭夜當(dāng)晚...
茶點(diǎn)故事閱讀 44,779評論 2贊 354

python學(xué)習(xí)

目錄

判斷字段值是否包含某個(gè)數(shù)字,如果是字符，建議用icontains

管理員身份運(yùn)行cmd配置虛擬環(huán)境

根據(jù)項(xiàng)目需求設(shè)計(jì)app

配置數(shù)據(jù)庫連接

新建users app

新建剩余app

后臺(tái)管理配置

問題總結(jié)

獲取用戶名等

管理員身份運(yùn)行cmd配置虛擬環(huán)境

根據(jù)項(xiàng)目需求設(shè)計(jì)app

配置數(shù)據(jù)庫連接

新建users app

新建剩余app

后臺(tái)管理配置

推薦閱讀更多精彩內(nèi)容