[파이썬] 오라클 DB 연동 CRUD - 1 / dao_emp, settings, url, views(HELLO_EMP_MVC)

jychae·2022년 11월 9일
0

파이썬

목록 보기
6/8

간단해보이지만 간단하지 않음 ^0^
언제쯤 안보고 짤 수 있을ㄲㅏ.....

엥... 내 노트북 DB 안만들어서 저렇게 나오는 듯...
귀찮다.. 만들어주기....
언제 올리지...파일이랑 올려야하는데...

emp_list.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>

<script type="text/javascript">
function fn_add(){
	location.href = "emp_add";
}
</script>

</head>
<body>
<table border="1px">
	<tr>
		<td>사번</td>
		<td>이름</td>
		<td>성별</td>
		<td>주소</td>
	</tr>
{% for e in emps %}	
	<tr>
		<td><a href="emp_detail?e_id={{e.e_id}}">{{e.e_id}}</a></td>
		<td>{{ e.e_name }}</td>
		<td>{{ e.sex }}</td>
		<td>{{ e.addr }}</td>
	</tr>
{% endfor %}
</table>
<input type="button" value="추가" onclick="fn_add()">
	
</table>
</body>
</html>

dao_emp.py

import cx_Oracle

class DaoEmp:
    def __init__(self):
        # 전역변수처리 self.
        self.conn = cx_Oracle.connect('python/python@localhost:1521/xe')
        self.cs = self.conn.cursor() 
        
        
    def myselects(self):
        rs = self.cs.execute("select e_id,e_name,sex,addr from emp")
        emps=[]
        for r in rs:
            emps.append( {'e_id':r[0],'e_name':r[1],'sex':r[2],'addr':r[3]})
        #print(emps)
        return emps
    
    def myselect(self,e_id):
        sql = f"""
            select 
                e_id,
                e_name,
                sex,
                addr 
            from 
                emp
            where
                e_id = '{e_id}'
        """
        #위에서 만든걸 담아주고 아래에
        rs = self.cs.execute(sql)
        #for문돌려서 찍어주자 어짜피 where해서 1줄만 나올꺼
        for r in rs:
            emp = {'e_id':r[0],'e_name':r[1],'sex':r[2],'addr':r[3]}
            
        return emp
    
    def myinsert(self,e_name,sex,addr):
        sql = f"""
            insert into 
                emp
                (e_id, e_name, sex, addr) 
            values 
                (e_seq.nextval,'{e_name}','{sex}','{addr}')
        """
        cnt = 0  
        try:  
            self.cs.execute(sql)   
            self.conn.commit()
            cnt = self.cs.rowcount  
        except:    # 예외가 발생했을 때 실행됨
            cnt = 0
            print('insert error')     
        return cnt   
    
    
    def myupdate(self,e_id,e_name,sex,addr):
        sql = f"""     
            update emp
            set
                e_name ='{e_name}',
                sex ='{sex}', 
                addr ='{addr}' 
            where 
                e_id ='{e_id}'
        
          """
        cnt = 0  
        try:  
            self.cs.execute(sql)   
            self.conn.commit()
            cnt = self.cs.rowcount  
        except:    # 예외가 발생했을 때 실행됨
            cnt = 0
            print('update error')     
        return cnt
    
    def mydelete(self,e_id):    
        sql = f"""     
            delete from emp 
            where 
                e_id='{e_id}'
        """
        cnt = 0  
        try:  
            self.cs.execute(sql)   
            self.conn.commit()
            cnt = self.cs.rowcount  
        except:    # 예외가 발생했을 때 실행됨
            cnt = 0
            print('delete error')     
        return cnt
    
    #소멸자로 죽여버리기..
    def __del__(self):
        self.cs.close()    
        self.conn.close()
        # 전역변수처리 self.
        
        
if __name__ == '__main__':
    # de = DaoEmp()
    # emps = de.myselects()
    # print(emps) 
           
    # de = DaoEmp()
    # emp = de.myselect('10')
    # print(emp)   
    
    # de = DaoEmp()
    # emp = de.myinsert('7','7','7')
    # print(emp)     
    
    # de = DaoEmp()
    # emp = de.myupdate('11','8','8','8')
    # print(emp)

    de = DaoEmp()
    emp = de.mydelete('11')
    print(emp)

settings.py

"""
Django settings for HELLO_EMP_MVC project.

Generated by 'django-admin startproject' using Django 4.1.

For more information on this file, see
https://docs.djangoproject.com/en/4.1/topics/settings/

For the full list of settings and their values, see
https://docs.djangoproject.com/en/4.1/ref/settings/
"""

from pathlib import Path

# Build paths inside the project like this: BASE_DIR / 'subdir'.
BASE_DIR = Path(__file__).resolve().parent.parent


# Quick-start development settings - unsuitable for production
# See https://docs.djangoproject.com/en/4.1/howto/deployment/checklist/

# SECURITY WARNING: keep the secret key used in production secret!
SECRET_KEY = 'django-insecure-3i71b6!d869=gw@r%9c_(^hi%n04=g0ju1vl&m#4j*m3@7s%zr'

# SECURITY WARNING: don't run with debug turned on in production!
DEBUG = True

ALLOWED_HOSTS = []


# Application definition

INSTALLED_APPS = [
    'django.contrib.admin',
    'django.contrib.auth',
    'django.contrib.contenttypes',
    'django.contrib.sessions',
    'django.contrib.messages',
    'django.contrib.staticfiles',
    'HELLO_EMP_MVC',
]

MIDDLEWARE = [
    'django.middleware.security.SecurityMiddleware',
    'django.contrib.sessions.middleware.SessionMiddleware',
    'django.middleware.common.CommonMiddleware',
    'django.middleware.csrf.CsrfViewMiddleware',
    'django.contrib.auth.middleware.AuthenticationMiddleware',
    'django.contrib.messages.middleware.MessageMiddleware',
    'django.middleware.clickjacking.XFrameOptionsMiddleware',
]

ROOT_URLCONF = 'HELLO_EMP_MVC.urls'

TEMPLATES = [
    {
        'BACKEND': 'django.template.backends.django.DjangoTemplates',
        'DIRS': [],
        'APP_DIRS': True,
        'OPTIONS': {
            'context_processors': [
                'django.template.context_processors.debug',
                'django.template.context_processors.request',
                'django.contrib.auth.context_processors.auth',
                'django.contrib.messages.context_processors.messages',
            ],
        },
    },
]

WSGI_APPLICATION = 'HELLO_EMP_MVC.wsgi.application'


# Database
# https://docs.djangoproject.com/en/4.1/ref/settings/#databases

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.sqlite3',
        'NAME': BASE_DIR / 'db.sqlite3',
    }
}


# Password validation
# https://docs.djangoproject.com/en/4.1/ref/settings/#auth-password-validators

AUTH_PASSWORD_VALIDATORS = [
    {
        'NAME': 'django.contrib.auth.password_validation.UserAttributeSimilarityValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.MinimumLengthValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.CommonPasswordValidator',
    },
    {
        'NAME': 'django.contrib.auth.password_validation.NumericPasswordValidator',
    },
]


# Internationalization
# https://docs.djangoproject.com/en/4.1/topics/i18n/

LANGUAGE_CODE = 'en-us'

TIME_ZONE = 'UTC'

USE_I18N = True

USE_TZ = True


# Static files (CSS, JavaScript, Images)
# https://docs.djangoproject.com/en/4.1/howto/static-files/

STATIC_URL = 'static/'

# Default primary key field type
# https://docs.djangoproject.com/en/4.1/ref/settings/#default-auto-field

DEFAULT_AUTO_FIELD = 'django.db.models.BigAutoField'

urls.py

from django.shortcuts import render
from django.http.response import HttpResponse
from HELLO_EMP_MVC.dao_emp import DaoEmp
from django.views.decorators.csrf import csrf_exempt

# Create your views here.

def emp_list(request):
    de = DaoEmp()
    emps = de.myselects()
    print(emps)
    return render(request, 'emp_list.html',{'emps' : emps}) 

def emp_detail(request):
    e_id = request.GET.get('e_id', '')
    # print("e_id",e_id)
    de = DaoEmp()
    emp = de.myselect(e_id)
    return render(request, 'emp_detail.html',{'emp':emp}) 

def emp_mod(request):
    e_id = request.GET.get('e_id', '')
    # print("e_id",e_id)
    de = DaoEmp()
    emp = de.myselect(e_id)
    return render(request, 'emp_mod.html',{'emp':emp}) 

@csrf_exempt
def emp_mod_act(request):
    e_id = request.POST.get('e_id')
    e_name = request.POST.get('e_name')
    sex = request.POST.get('sex')
    addr = request.POST.get('addr')
    de = DaoEmp()
    cnt = de.myupdate(e_id, e_name, sex, addr)
    return render(request, 'emp_mod_act.html',{'cnt':cnt}) 

def emp_add(request):
    return render(request, 'emp_add.html') 

@csrf_exempt
def emp_add_act(request):
    e_name = request.POST.get('e_name')
    sex = request.POST.get('sex')
    addr = request.POST.get('addr')
    de = DaoEmp()
    cnt = de.myinsert(e_name, sex, addr)
    return render(request, 'emp_add_act.html',{'cnt':cnt}) 

@csrf_exempt
def emp_del_act(request):
    e_id = request.POST.get('e_id')
    de = DaoEmp()
    cnt = de.mydelete(e_id)
    return render(request, 'emp_del_act.html',{'cnt':cnt})

views.py

from django.shortcuts import render
from django.http.response import HttpResponse
from HELLO_EMP_MVC.dao_emp import DaoEmp
from django.views.decorators.csrf import csrf_exempt

# Create your views here.

def emp_list(request):
    de = DaoEmp()
    emps = de.myselects()
    print(emps)
    return render(request, 'emp_list.html',{'emps' : emps}) 

def emp_detail(request):
    e_id = request.GET.get('e_id', '')
    # print("e_id",e_id)
    de = DaoEmp()
    emp = de.myselect(e_id)
    return render(request, 'emp_detail.html',{'emp':emp}) 

def emp_mod(request):
    e_id = request.GET.get('e_id', '')
    # print("e_id",e_id)
    de = DaoEmp()
    emp = de.myselect(e_id)
    return render(request, 'emp_mod.html',{'emp':emp}) 

@csrf_exempt
def emp_mod_act(request):
    e_id = request.POST.get('e_id')
    e_name = request.POST.get('e_name')
    sex = request.POST.get('sex')
    addr = request.POST.get('addr')
    de = DaoEmp()
    cnt = de.myupdate(e_id, e_name, sex, addr)
    return render(request, 'emp_mod_act.html',{'cnt':cnt}) 

def emp_add(request):
    return render(request, 'emp_add.html') 

@csrf_exempt
def emp_add_act(request):
    e_name = request.POST.get('e_name')
    sex = request.POST.get('sex')
    addr = request.POST.get('addr')
    de = DaoEmp()
    cnt = de.myinsert(e_name, sex, addr)
    return render(request, 'emp_add_act.html',{'cnt':cnt}) 

@csrf_exempt
def emp_del_act(request):
    e_id = request.POST.get('e_id')
    de = DaoEmp()
    cnt = de.mydelete(e_id)
    return render(request, 'emp_del_act.html',{'cnt':cnt})

너무 피곤해서 ㅠ 어제도 새벽 2시에 자서 힘듦
언제쯤 끝날까 싶으면서도 안끝났으면 ㅠㅠ 할게 너무 많음....
내일 마저 올려야지..나머지.. 올릴게 산더미 ㅠ

profile
jychae
안녕하세요! 초보개발자 공부 시작!
이전 포스트

[파이썬] Django CSRF {% csrf_token %}

다음 포스트

[파이썬] 오라클 DB 연동 CRUD - 2 / detail, add, mod, del (HELLO_EMP_MVC)

0개의 댓글