CA Live API Creator 3.2

5.4 5.3 5.2 5.1 5.0 4.1 4.0 3.2 3.1.1 3.1
English

Define Schema Filters

When you connect API Creator to a database, you can have  access only a small part of the database instead of reading the schema, including all tables, views, stored procedures, and functions in the given schema. You can do this by defining schema filters. While defining your data source, you can define which parts of the database schema you want  to read using regular expressions. You specify these as a list of Java regular expressions.
lac32
When you connect API Creator to a database, you can have 
CA Live API Creator
 access only a small part of the database instead of reading the schema, including all tables, views, stored procedures, and functions in the given schema. You can do this by defining schema filters. While defining your data source, you can define which parts of the database schema you want
CA Live API Creator
 to read using regular expressions. You specify these as a list of Java regular expressions.
  1. With your API open, in the Create section, click
    Data Sources
    .
    The Data Sources page appears. The Connection tab displays by default.
  2. Click the 
    Schema Filters
     tab.
  3. Complete the following, and then save your changes:
    • Enter a line for each entity you want to include or exclude into the 
      Include tables/views
       or 
      Exclude tables/views
       lists using Java regular expression syntax. Separate each line with a carriage return, line feed, or a combination of these.
    • Enter a line for each stored procedure or function you want to include or exclude into the 
      Include stored procedures/functions
       or Exclude
      stored procedures/functions
       lists using Java regular expression syntax. Separate each line with a carriage return, line feed, or a combination of these.
    Requirements:
    • If you do not enter an expression in the 
      Include tables/views
       list, 
      CA Live API Creator
       reads all tables and views.
    • If you do not enter an expression in the 
      Include stored procedures/functions
       list, 
      CA Live API Creator
       reads all stored procedures and functions.
    • If you enter at least one expression in the 
      Include tables/views
       list, then 
      CA Live API Creator
       reads all the tables and views whose name satisfies at least one of the regular expressions and ignores all other tables and views. In particular, in the case of tables, if you do not include the parent and the child, 
      CA Live API Creator
       ignores the foreign keys.
    • If you enter at least one expression in the 
      Include stored procedures/functions
       list, then 
      CA Live API Creator
       reads all the stored procedures and functions whose name satisfies at least one of the regular expressions and ignores all other stored procedures and functions.
    • If you do not enter an expression in the 
      Exclude tables/views
       list, then 
      CA Live API Creator
       reads all functions (subject to the entries in the 
      Include tables/views
       list).
    • If you do not enter an expression in the Exclude 
      stored procedures/functions
       list, then 
      CA Live API Creator
       reads all stored procedures and functions (subject to the expressions you have specified in the 
      Include tables/views
       list).
    • If you enter at least one expression in the 
      Exclude tables/views
       list, then 
      CA Live API Creator
       ignores all tables and views that match at least one of the expressions you have specified in the list.
    • If you enter at least one expression in the Exclude 
      stored procedures/functions
       list, then 
      CA Live API Creator
       ignores all stored procedures and functions that match at least one of the expressions you have specified in the list.
    There is no limit to the number of lines you can add.
    Examples
    Description
    Java Regular Expression
    All objects whose name starts with A, B, a or b
    [ABab].*
    All objects whose name consists of two words, optionally separated by a dash
    \w[-]?\w
    Named objects
    MyTable
    MyOtherTable
    MyThirdTable
    For more information about the syntax for Java regular expressions, see the Oracle documentation.
You schema filters are defined.