python.django - k821209/pipelines GitHub Wiki

# setting.py

MEDIA_ROOT = os.path.join(BASE_DIR, 'media')
MEDIA_URL = '/media/'
STATIC_ROOT = os.path.join(BASE_DIR, 'static')
FILE_UPLOAD_MAX_MEMORY_SIZE = 5242880000  # 5 MB
# STATIC_ROOT = os.path.join(BASE_DIR, 'static')
# STATIC_ROOT = '/static/'
STATIC_URL = '/static_django/'
print(BASE_DIR)

# main:urls.py
from django.contrib import admin
from django.urls import path
from django.conf.urls import url, include
from app.views import Researcher_view
from rest_framework import routers
from django.contrib.staticfiles.urls import staticfiles_urlpatterns
from django.conf.urls.static import static
from django.conf import settings



router = routers.DefaultRouter()
router.register('Researcher', Researcher_view)

urlpatterns = [
    path('api/admin/', admin.site.urls),
    # url(r'^', include(router.urls)),
    path('api/', include(router.urls)),
    path('markdownx/', include('markdownx.urls')),
]

urlpatterns += staticfiles_urlpatterns()
urlpatterns += static(settings.MEDIA_URL,
                      document_root=settings.MEDIA_ROOT)
urlpatterns += static(settings.STATIC_URL,
                              document_root=settings.STATIC_ROOT)

print(urlpatterns)

# django setting.py

MEDIA_ROOT = os.path.join(BASE_DIR, 'media')
MEDIA_URL = '/media/'
STATIC_ROOT = os.path.join(BASE_DIR, 'static')
FILE_UPLOAD_MAX_MEMORY_SIZE = 5242880000  # 5 MB
REST_FRAMEWORK = {
    'DEFAULT_PAGINATION_CLASS': 'rest_framework.pagination.PageNumberPagination',
    'PAGE_SIZE': 10
}

FILE_UPLOAD_MAX_MEMORY_SIZE = 5242880000 # 5 MB

# urls.py
# static 을 gunicorn이 불러오려면 이런 설정이 필요 
from django.contrib.staticfiles.urls import staticfiles_urlpatterns
from django.conf.urls.static import static
from django.conf import settings

...

urlpatterns += staticfiles_urlpatterns()
urlpatterns += static(settings.MEDIA_URL,
                      document_root=settings.MEDIA_ROOT)

<a class="item" href="{% url 'network:index' %}" target="_blank"> # network 라는 이름은 url에 정의 되어 있음 
                    <button class="ui fluid button">
                        LINK
                    </button>
                </a>

# setting.py
DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
               },
    'soyped': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'soyped.sqlite3'),
               },
    'lemna_tandemDB': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': os.path.join(BASE_DIR, 'lemna_tandemDB.sqlite3'),
               },
}
DATABASE_ROUTERS = ['lemna_tandem.router.lemna_Router','SoyPed.router.SP_Router']

# router.py # in app directory
class lemna_Router(object):
    def db_for_read(self, model, **hints):
        "Point all operations on SoyPed models to 'soyped'"
        if model._meta.app_label == 'lemna_tandem':
            return 'lemna_tandemDB'
        return None # 이게 꼭 넌이 되어줘야한다.. 그래야 아닐경우 다음 항목으로 넘어간다... 이런젠장할 이것때문에 내가 

    def db_for_write(self, model, **hints):
        "Point all operations on SoyPed models to 'soyped'"
        if model._meta.app_label == 'lemna_tandem':
            return 'lemna_tandemDB'
        return None # None 으로 안해주고 default로 돌리면 다음 라우터가 일을 못한다. 무조건 None을 하고 setting.py 순서상 마지막 router에는 default return을 해줘도 된다 

    def allow_relation(self, obj1, obj2, **hints):
        "Allow any relation if a both models in chinook app"
        if obj1._meta.app_label == 'lemna_tandem' and obj2._meta.app_label == 'lemna_tandem':
            return True
        # Allow if neither is chinook app
        elif 'lemna_tandem' not in [obj1._meta.app_label, obj2._meta.app_label]:
            return True
        return None

    def allow_migrate(self, db, app_label, model_name=None, **hints):
        """
        Make sure the auth app only appears in the 'auth_db'
        database.
        """
        if app_label == 'lemna_tandem':
            return db == 'lemna_tandemDB'
        return None
    def allow_syncdb(self, db, model):
        if db == 'lemna_tandemDB' or model._meta.app_label == "lemna_tandem":
            return False # we're not using syncdb on our legacy database
        else: # but all other models/databases are fine
            return True

url(r'^blog/', include('blog.urls'))
path('kkd2/',include('kkd2.urls'))

from django.conf.urls import url
from . import views
urlpatterns = [
    url(r'^$', views.post_list, name='post_list'),
    
]

def post_list(request):
        return render(request, 'blog/post_list.html', {}) 
# url에서 view.post_list를 부르면 blog/post_list.html을 부른다. 부를때 {}안에 변수를 보내준다. 해당 변수는 model.py 에서 가져오게됨.  

from django.shortcuts import render
from .models import DBmodel
def index(request):
        DBex    = DBmodel.objects.order_by('?')[0:2] # 렌덤으로 클레스를 가져온다. 
        return render(request, 'CreDB/index.html', {'DBex' : DBex}) # 렌덤으로 가져온 클레스를 html로 보낸다. 

...
DBex          = DBmodel.objects.order_by('?')[0] # 하나만 선택해놨음. 
final_comp_ex = final_comp.objects.get(transcriptname=DBex.genename) # DBex 라는 모델 클레스의 genename 필드의 값을 가져와라. 
...

class NameForm_plain(forms.Form): # view 안에서 그냥 선언을 함. 
    transcript_name = forms.CharField(label='transcript name', max_length=50)
def index(request):
        DBex          = DBmodel.objects.order_by('?')[0]
        final_comp_ex = final_comp.objects.get(transcriptname=DBex.genename)
        if request.method=='POST':
            form = NameForm_plain(request.POST)
            if form.is_valid():
                query = form.cleaned_data['transcript_name'] # 쿼리라는 변수에 폼에서 받은 값을 넣어준다. 클레스의 변수명이 딕셔너리의 키값으로 변신한것에 주목. 모델 클레스와 다르다.
...

from django.shortcuts import render
from django import forms
from .models import DBmodel
class NameForm(forms.ModelForm):
    class Meta:
        model = DBmodel
        fields = ('genename',)
def index(request):
        DBex       = DBmodel.objects.order_by('?')[0]
        if request.method=='POST':
            form = NameForm(request.POST)
            if form.is_valid():
                query = form.cleaned_data['genename']
                DBex = DBmodel.objects.get(genename=query)
                form = NameForm()
                return render(request, 'CreDB/index.html', {'DBex' : DBex, 'form': form})
                #return redirect('',query=genename)
        else:
            form = NameForm()
            return render(request, 'CreDB/index.html', {'DBex' : DBex, 'form': form})

# model.py
class Post(models.Model):
        author = models.ForeignKey('auth.User')
        title = models.CharField(max_length=200)
        text = models.TextField()
        created_date = models.DateTimeField(
                default=timezone.now)
        published_date = models.DateTimeField(
                blank=True, null=True
        def publish(self):
            self.published_date = timezone.now()
            self.save()
        def __unicode__(self):  # __str__ 대신에 이렇게 해준다. 
            return self.title

# app/admin.py
from django.contrib import admin
from .models import DBmodel
admin.site.register(DBmodel)

from CreDB.models import DBmodel
file_in = 'all.merged.bam.transcripts.all.txt'
for line in open(file_in):
    cell = line.strip().split('\t')
    DBmodel.objects.create(genename=cell[0], cov_1x=cell[1], cov_10x=cell[2], cov_30x=cell[3],depth_ratio=cell[4],depth=cell[5],match=cell[6],match_ratio=cell[7])
posts = DBmodel.objects.all()
for post in posts:
    post.publish()

# 다음을 알아서 루프를 돌리든 함. 
DBmodel.object.filter(genename="name").update(newfield="ATGC")

# model.py
class Post(models.Model):
        author = models.ForeignKey('auth.User')
        title = models.CharField(max_length=200)
        text = models.TextField()
        created_date = models.DateTimeField(
                default=timezone.now)
        published_date = models.DateTimeField(
                blank=True, null=True)

        def publish(self):
            self.published_date = timezone.now()
            self.save()

        def __unicode__(self):  # __str__ 대신에 이렇게 해준다. 
            return self.title

# edit the "poll/model.py"
from django.db import models
class Question(models.Model):
    question_text = models.CharField(max_length=200)
    pub_date = models.DateTimeField('date published')


class Choice(models.Model):
    question = models.ForeignKey(Question)
    choice_text = models.CharField(max_length=200)
    votes = models.IntegerField(default=0)