[Django Homepage] models.py

from django.db import models
from ckeditor.fields import RichTextField
from ckeditor_uploader.fields import RichTextUploadingField
from filer.fields.image import FilerImageField
from filer.fields.file import FilerFileField
from django.shortcuts import get_object_or_404
from django.utils import timezone
from django.contrib.auth.models import User
from crum import get_current_user
from datetime import date

import logging

logger = logging.getLogger('project')

# Create your models here.

STATUS = (
    (1, 'Active'),
    (2, 'Inactive'),
)

class Code(models.Model):
    pid                 = models.ForeignKey('self', on_delete=models.PROTECT, related_name='code_pid', blank=True, null=True)
    name                = models.CharField(max_length=200, unique=True)
    title               = models.CharField(max_length=200, blank=True, null=True)
    description         = models.TextField(blank=True, null=True)
    display_order       = models.IntegerField(default=0, blank=True, null=True)

    status              = models.IntegerField(choices=STATUS, default=1)
    creator             = models.ForeignKey(User, on_delete=models.PROTECT, related_name='code_creator', null=True, blank=True)      
    modifier            = models.ForeignKey(User, on_delete=models.PROTECT, related_name='code_modifier', null=True, blank=True)       
    created             = models.DateTimeField(default=timezone.now)
    modified            = models.DateTimeField(default=timezone.now)
    
    def __str__(self):
        # if self.pid:
        #     return_msg = str(self.pid) + '.' + str(self.name)
        # else:
        #     return_msg = str(self.name)
        return self.title

    def save(self, *args, **kwargs):
        ''' On save, update timestamps '''
        user = get_current_user()

        if not self.id:
            self.created = timezone.now()
            try:
                self.creator = user
            except:
                self.creator = self.creator
        self.modified = timezone.now()
        try:
            self.modifier = user
        except:
            self.modifier = self.modifier
        return super(Code, self).save(*args, **kwargs)

def get_code_id(code_name):
    try:
        type_id = Code.objects.get(name=code_name).id
    except:
        type_id = 0

    return {'pid': type_id}

class Content(models.Model):
    type                = models.ForeignKey(Code, on_delete=models.PROTECT, limit_choices_to=get_code_id('content_type'), related_name='content_type', blank=True, null=True)
    style               = models.ForeignKey(Code, on_delete=models.PROTECT, limit_choices_to=get_code_id('content_style'), related_name='content_style', blank=True, null=True)
    category            = models.ForeignKey(Code, on_delete=models.PROTECT, limit_choices_to=get_code_id('content_category'), related_name='content_category', blank=True, null=True)
    
    pid                 = models.ForeignKey('self', on_delete=models.PROTECT, related_name='content_pid', blank=True, null=True)
    
    name                = models.CharField(max_length=500)
    title               = models.CharField(max_length=500)
    description         = models.TextField(blank=True, null=True)
    
    url_type            = models.ForeignKey(Code, on_delete=models.PROTECT, limit_choices_to=get_code_id('url_type'), related_name='content_url_type', blank=True, null=True)
    url                 = models.CharField(max_length=500, blank=True)
    url_parameter       = models.CharField(max_length=500, blank=True)
    icon                = models.CharField(max_length=200, blank=True)
    view_count          = models.IntegerField(default=0, blank=True)
    display_order       = models.IntegerField(default=0, blank=True, null=True)

    content_body        = RichTextUploadingField(blank=True, null=True)

    image1              = FilerImageField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_image1")
    image2              = FilerImageField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_image2")
    image3              = FilerImageField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_image3")
    file1               = FilerFileField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_file1")
    file2               = FilerFileField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_file2")
    file3               = FilerFileField(on_delete=models.PROTECT, null=True, blank=True, related_name="content_file3")
    text1               = models.CharField(max_length=500, blank=True)
    text2               = models.CharField(max_length=500, blank=True)
    text3               = models.CharField(max_length=500, blank=True)
    int1                = models.IntegerField(default=0, blank=True)
    int2                = models.IntegerField(default=0, blank=True)
    int3                = models.IntegerField(default=0, blank=True)

    status              = models.IntegerField(choices=STATUS, default=1)

    creator             = models.ForeignKey(User, on_delete=models.PROTECT, related_name='content_creator', null=True, blank=True)      
    modifier            = models.ForeignKey(User, on_delete=models.PROTECT, related_name='content_modifier', null=True, blank=True)       
    created             = models.DateTimeField(default=timezone.now)
    modified            = models.DateTimeField(default=timezone.now)
    
    def __str__(self):
        if self.pid:
            return_msg = str(self.pid) + '.' + str(self.name)
        else:
            return_msg = str(self.name)
        return return_msg

    def save(self, *args, **kwargs):
        ''' On save, update timestamps '''
        user = get_current_user()

        if not self.id:
            self.created = timezone.now()
            try:
                self.creator = user
            except:
                self.creator = self.creator
        self.modified = timezone.now()
        try:
            self.modifier = user
        except:
            self.modifier = self.modifier
        return super(Content, self).save(*args, **kwargs)

class Obslog(models.Model):
    who_user_id                 = models.IntegerField(blank=True, null=True)                # user username
    who_ip                      = models.CharField(max_length=50, blank=True, null=True)    # ip address
    who_useragent               = models.CharField(max_length=500, blank=True, null=True)   # usergent full string
    who_device                  = models.CharField(max_length=200, blank=True, null=True)   # device string
    who_device_type             = models.CharField(max_length=50, blank=True, null=True)    # device type
    who_device_family           = models.CharField(max_length=50, blank=True, null=True)    # device family
    who_device_brand            = models.CharField(max_length=50, blank=True, null=True)    # device brand
    who_device_model            = models.CharField(max_length=50, blank=True, null=True)    # device model
    who_os                      = models.CharField(max_length=200, blank=True, null=True)   # os string
    who_os_family               = models.CharField(max_length=50, blank=True, null=True)    # os family
    who_os_version_string       = models.CharField(max_length=50, blank=True, null=True)    # os version
    who_browser                 = models.CharField(max_length=200, blank=True, null=True)   # browser string
    who_browser_family          = models.CharField(max_length=50, blank=True, null=True)    # browser family
    who_browser_version_string  = models.CharField(max_length=50, blank=True, null=True)    # browser version
    what_object_type            = models.CharField(max_length=50, blank=True, null=True)    # page, content, related
    what_object_name            = models.CharField(max_length=50, blank=True, null=True)    # page name, content/related name
    what_object_id              = models.IntegerField(blank=True, null=True)                # content/related id
    when_datetime               = models.DateTimeField(default=timezone.now)                # datetime
    when_date                   = models.DateField(default=date.today)                      # date
    where_ip                    = models.CharField(max_length=50, blank=True, null=True)    # ip address
    where_continent             = models.CharField(max_length=50, blank=True, null=True)    # continent
    where_country               = models.CharField(max_length=50, blank=True, null=True)    # country
    where_city                  = models.CharField(max_length=50, blank=True, null=True)    # city
    where_zipcode               = models.CharField(max_length=50, blank=True, null=True)    # zipcode
    where_latitude              = models.CharField(max_length=50, blank=True, null=True)    # latitude
    where_longitude             = models.CharField(max_length=50, blank=True, null=True)    # longitude
    where_region                = models.CharField(max_length=50, blank=True, null=True)    # region
    where_timezone              = models.CharField(max_length=50, blank=True, null=True)    # timezone
    how_action                  = models.CharField(max_length=50, blank=True, null=True)    # signup, signin, signout, list, read, create, update, delete, cart, buy
    why                         = models.CharField(max_length=50, blank=True, null=True)    # reason
    created                     = models.DateTimeField(default=timezone.now)
    modified                    = models.DateTimeField(default=timezone.now)

    def __str__(self):
        if self.who_ip is None:
            return ''
        else:
            return self.who_ip

    def save(self, *args, **kwargs):
        ''' On save, update timestamps '''
        if not self.id:
            self.created = timezone.now()
        self.modified = timezone.now()
        return super(Obslog, self).save(*args, **kwargs)


댓글

댓글 쓰기

이 블로그의 인기 게시물

[Django Install] 11. Install Python3 for Centos8/RedhatLinux8

  [install python3] # python -bash: python: command not found # python3 -bash: python3: command not found # sudo yum install python3 # python3 --version [install  virtualenv virtualenvwrapper] # sudo pip3 install virtualenv virtualenvwrapper # cd $HOME # vi .bashrc 아래 내용을 마지막 라인에 추가한다. # Virtualenvwrapper settings: export VIRTUALENVWRAPPER_PYTHON=/usr/bin/python3 export WORKON_HOME=$HOME/.virtualenvs source /usr/local/bin/virtualenvwrapper.sh export PATH=.:$PATH 로그아웃하고 다시 로그인한다. # workon 아무것도 나오지 않는다. # mkvirtualenv virtualenvname (가상환경 생성하고 가상환경에 들어간다.) (virtualenvname) # deactivate (가상환경 빠져나오기) # workon (가상환경 리스트 조회) virtualenvname # workon project name (가상환경 들어가기) (virtualenvname) # cd $HOME (virtualenvname) # mkdir projectname (virtualenvname) # cd projectname [install mysql driver] (virtualenvname) # pip install mysqlclient 에러발생 시 아래의 내용을 설치한다. (virtualenvname) # sudo yum install python-devel mysql-devel (virtualenvname) # sudo yum install gcc (virtual...
자세한 내용 보기

[windows] filebeat 스케쥴링 테스트

 [windows server 2021 설치] aws에 windows server 2021 Basic 설치 rdp로 접속 (키 필요) [windows server 2021 ftp 설치] iis설치 ftp Enable (windows 방화벽 자동 설정) 참조사이트 : http://blog.servis.co.kr/index.php/2019/10/08/windows-server-2012-ftp/ [windows server 2021 task scheduler 설치] task scheduler 실행 create basic task 실행 Create a Basic Type : name 입력 - next Trigger : 주기 선택 - next Action : Start a program 선택 - next Start a Program :     - Program/script : 실행파일명만 입력    - Start in (optional) : 실행파일이 있는 Full Path 입력 [batch] cd C:\elastic\filebeat-7.9.2-windows-x86_64 rmdir /s /q data timeout /t 5 .\filebeat run --once -c filebeat.yml [logstash] input {   beats {     # host => "1.234.25.136"     port => 30001   } } output {   elasticsearch {     hosts => ["http://192.168.0.136:49100"]     index => "ra_program-%{+YYYY.MM.dd}"     user => "elastic"     password => "nadaimma"     # ...
자세한 내용 보기

[sqlite] error 조치

 Error : sqlite3 버전 오류 sqlite 3.7 -> 3.36 cd  /opt/  sudo wget https://sqlite.org/2021/sqlite-autoconf-3360000.tar.gz  sudo tar -zxf sqlite-autoconf-3360000.tar.gz  cd  sqlite-autoconf-3360000/ gcc 컴파일러가 없어서 sudo yum install gcc sudo ./configure  sudo make clean sudo make -j 20 sudo make install sudo /bin/cp -rf /usr/lib64/libsqlite3.so.0.8.6 /usr/lib64/libsqlite3.so.0.8.6_bak  sudo /bin/cp -rf /usr/ local /lib/libsqlite3.so.0.8.6 /usr/lib64/libsqlite3.so.0.8.6 sudo rm /usr/lib64/libsqlite3.so.0 sudo ln -s /usr/lib64/libsqlite3.so.0.8.6 /usr/lib64/libsqlite3.so.0 python >>> import sqlite3 >>> sqlite3.sqlite_version 3.36.0
자세한 내용 보기