Python create_sp 예제들

예제 #1

def upgrade():
    op.add_column('nodes', sa.Column('title_abstract', TSVectorType))
    op.create_sp(title_abstract_update_trigger)
    op.create_trigger(title_abstract_update)

    # Initialize index with already existing data
    op.execute('UPDATE nodes SET hyperdata = hyperdata')

예제 #2

파일: 03bdb0a44083_remove_history_constraints.py 프로젝트: sujaypatil96/raw-data-repository

def upgrade_rdr():
  op.create_sp(sp_drop_index_if_exists)

  op.execute("""call sp_drop_index_if_exists('biobank_dv_order_history', 'uidx_partic_id_order_id')""")
  op.execute("""call sp_drop_index_if_exists('biobank_dv_order_history', 'biobank_order_id')""")
  op.execute("""call sp_drop_index_if_exists('biobank_dv_order_history', 'biobank_state_id')""")
  op.execute("""call sp_drop_index_if_exists('biobank_dv_order_history', 'state_id')""")

예제 #3

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_sequence("Employee_seq_autoid")
    op.create_sequence("Employee_id_autoid")
    op.create_table('Employee',
    sa.Column('id', sa.Integer(), server_default=sa.text("nextval('employee_id_autoid')"), nullable=False),
    sa.Column('employeeId', sa.VARCHAR(length=25), nullable=False),
    sa.Column('firstName', sa.VARCHAR(length=200), nullable=True),
    sa.Column('lastName', sa.VARCHAR(length=200), nullable=True),
    sa.Column('password', sa.VARCHAR(length=500), nullable=True),
    sa.Column('email', sa.VARCHAR(length=200), nullable=False),
    sa.Column('phoneNumber', sa.VARCHAR(length=20), nullable=True),
    sa.Column('joinedDate', sa.TIMESTAMP(), nullable=True),
    sa.Column('employeeType', postgresql.ENUM('EMPLOYEE', 'ADMIN', name='EmployeeTYPE'), server_default='EMPLOYEE', nullable=False),
    sa.Column('employeeDesignation', postgresql.ENUM('DEVELOPER', 'SENIOR DEVELOPER', 'MANAGER', name='EmployeeDESIGNATION'), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('email'),
    sa.UniqueConstraint('employeeId')
    )
    op.create_sequence("Holiday_id_autoid")
    op.create_table('Holiday',
    sa.Column('id', sa.Integer(), server_default=sa.text("nextval('holiday_id_autoid')"), nullable=False),
    sa.Column('date', sa.TIMESTAMP(), nullable=True),
    sa.Column('festivalName', sa.VARCHAR(length=200), nullable=True),
    sa.Column('description', sa.VARCHAR(length=500), nullable=True),
    sa.Column('holidayBanner', sa.VARCHAR(length=8000), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_sequence("LeaveManagement_seq_autoid")
    op.create_sequence("LeaveManagement_id_autoid")
    op.create_table('LeaveManagement',
    sa.Column('id', sa.Integer(), server_default=sa.text('nextval(\'"leavemanagement_id_autoid"\')'), nullable=False),
    sa.Column('leaveId', sa.VARCHAR(length=25), nullable=False),
    sa.Column('employeeId', sa.VARCHAR(length=25), nullable=False),
    sa.Column('fromDate', sa.TIMESTAMP(), nullable=True),
    sa.Column('toDate', sa.TIMESTAMP(), nullable=True),
    sa.Column('reason', sa.VARCHAR(length=500), nullable=False),
    sa.Column('leaveType', postgresql.ENUM('SICK', 'MEDICAL', 'CASUAL', name='LeaveTYPE'), nullable=False),
    sa.Column('approver', sa.VARCHAR(length=200), nullable=True),
    sa.Column('approvedStatus', postgresql.ENUM('PENDING', 'ACCEPTED', 'DENIED', name='ApprovedSTATUS'), nullable=False),
    sa.PrimaryKeyConstraint('id'),
    sa.UniqueConstraint('leaveId')
    )
    op.create_sp(Employees_trigger)
    op.create_sp(Leave_trigger)

예제 #4

파일: d35479348bbe_add_procedure.py 프로젝트: rostislavborovyk/sa_mysql_topics

def upgrade():
    op.create_sp(insert_user_sp)

예제 #5

파일: a04aac3da46d_create_datediff_procedure.py 프로젝트: erssebaggala/bts-ce-database

def upgrade():
    op.create_sp(datediff_sp)

예제 #6

파일: 335d191204c1_adding_db_functions_for_code_id_lookup_.py 프로젝트: lrwb-aou/raw-data-repository

def upgrade_rdr():
  op.create_sp(fn_get_code_id_from_key)
  op.create_sp(fn_get_participant_ethnicity)

예제 #7

def upgrade_rdr():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_sp(sp_get_code_module_items)
    op.create_sp(sp_get_questionnaire_answers)

예제 #8

파일: 601e9d9baa4c_add_occ_hist_occ_hist_part_functions.py 프로젝트: project-renard-survey/gargantext

def upgrade():
    op.create_sp(occ_hist_part)
    op.create_sp(occ_hist)