Python create_pg_type Examples

Example #1

File: run.py Project: akushsky/basic-sproc-crud-scaffolder

def create_for_table(package):
    parentT = Table('public', 'parent', [
        Field('p_id', 'integer', isPk=True, isSerial=True),
        Field('p_name', 'text'),
        Field('p_first_name', 'text'),
        Field('p_parent_data_id', 'integer')
    ])
    parentDataT = Table('public', 'parent_data', [
        Field('pd_id', 'integer', isSerial=True, isPk=True),
        Field('pd_street', 'text'),
        Field('pd_city', 'text')
    ])

    association = Association(parentT, parentDataT,
                              {'p_parent_data_id': 'pd_id'}, True)
    parentT.addAssociation(association)

    if package != '':
        package += '.'

    print plpgsql.create_pg_type(parentT)
    print plpgsql.create_pg_type(parentDataT)
    print java.create_java_type(parentT, package)
    print java.create_java_type(parentDataT, package)
    print plpgsql.create_sprocs(parentT)
    print java.create_sproc_service_interface(parentT, package)
    print java.create_sproc_service_implementation(parentT, package)

Example #2

File: run.py Project: maciej-rosiek/basic-sproc-crud-scaffolder

def create_for_table(schema,name):
  parentT = Table('public','parent',[Field('p_id','integer',isPk=True,isSerial=True), Field('p_name','text'), Field('p_first_name','text'), Field('p_parent_data_id','integer') ])
  parentDataT = Table('public','parent_data', [Field('pd_id','integer',isSerial=True,isPk=True),Field('pd_street','text'),Field('pd_city','text')])

  parentT.addAssociation( Association(parentT,parentDataT,{'p_parent_data_id':'pd_id'}, True) )

  m = { 'public.parent':parentT, 'public.parent_data':parentDataT }
  
  print plpgsql.create_pg_type ( parentT )
  print plpgsql.create_pg_type ( parentDataT )
  print java.create_java_type ( parentT )
  print java.create_java_type ( parentDataT )
  print plpgsql.create_sprocs( parentT, name, parentT.fields)
  print java.create_sproc_service_interface( parentT )
  print java.create_sproc_service_implementation( parentT )

Example #3

File: run.py Project: Jan-M/basic-sproc-crud-scaffolder

def create_for_table(package):
    parentT = Table('public', 'parent', [Field('p_id', 'integer', isPk=True, isSerial=True), Field('p_name', 'text'),
                                         Field('p_first_name', 'text'), Field('p_parent_data_id', 'integer')])
    parentDataT = Table('public', 'parent_data',
                        [Field('pd_id', 'integer', isSerial=True, isPk=True), Field('pd_street', 'text'),
                         Field('pd_city', 'text')])

    association = Association(parentT, parentDataT, {'p_parent_data_id': 'pd_id'}, True)
    parentT.addAssociation(association)

    if package != '':
        package += '.'

    print plpgsql.create_pg_type(parentT)
    print plpgsql.create_pg_type(parentDataT)
    print java.create_java_type(parentT, package)
    print java.create_java_type(parentDataT, package)
    print plpgsql.create_sprocs(parentT)
    print java.create_sproc_service_interface(parentT, package)
    print java.create_sproc_service_implementation(parentT, package)

Example #4

File: run.py Project: maciej-rosiek/basic-sproc-crud-scaffolder

def scaffold( table ):
  print plpgsql.create_pg_type ( table )
  print java.create_java_type ( table )
  print plpgsql.create_sprocs( table , table.getName(), table.fields )
  print java.create_sproc_service_interface( table )
  print java.create_sproc_service_implementation( table )