Skip to content

Instantly share code, notes, and snippets.

@eclecticmiraclecat
eclecticmiraclecat / oracle cdc autolog
Last active December 15, 2020 12:27
oracle cdc autolog
docker run --privileged --name oracle11g -p 1521:1521 -v /home/oracle/install:/install jaspeen/oracle-11g
docker exec -it oracle11g bash
su oracle
sqlplus / as sysdba
alter system set log_archive_dest_1 ="location=/opt/oracle/dbs mandatory reopen=5" log_archive_dest_state_1=enable
alter system set streams_pool_size='10' java_pool_size=50000000;
docker run --privileged --name oracle11g -p 1521:1521 -v /home/oracle/install:/install jaspeen/oracle-11g
docker exec -it oracle11g bash
su oracle
sqlplus / as sysdba
alter system set streams_pool_size='10' java_pool_size=50000000;
create tablespace ts_cdcpub datafile 'ts_cdcpub01.dbf' size 300m;
# project urls.py
from django.urls import path, include
from django.views.generic import RedirectView

urlpatterns = [
    path('catalog/', include('catalog.urls')),
    path('', RedirectView.as_view(url='catalog/')),
]

Go to admin page add set the permission for the user under User Permissions, eg

  1. <app name> | <model name> | Can add model
  2. <app name> | <model name> | Can change model
  3. <app name> | <model name> | Can delete model
# views.py
from .models import Secret
from django.contrib.auth.decorators import login_required, permission_required
$ tree templates/
templates/
├── login
│   └── read.html
└── registration
    └── login.html
# models.py
# urls.py
from session.views import pageCount

urlpatterns = [
    path('index/', pageCount),
]
# forms.py
from django import forms

class ItemForm(forms.Form):
  name = forms.CharField()
  quantity = forms.IntegerField()

many to many

  • many author can write many books
# models..py
class Author(models.Model):
  name = models.CharField(max_length=20)

class Book(models.Model):
 title = models.CharField(max_length=20)

many to one

  • one customer ordering many product
# models.py
class Customer(models.Model):
  name = models.CharField(max_length=20)

class Product(models.Model):
 product = models.CharField(max_length=20)

one to one

  • one person one license
# models.py
class Person(models.Model):
  name = models.CharField(max_length=20)

class License(models.Model):
 license_number = models.IntegerField()