ge.schemacrawler.schemacrawler-sqlite.10.10.05.source-code.schemacrawler-sqlite.config.properties Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of schemacrawler-sqlite Show documentation

The newest version!

driver=org.sqlite.JDBC
url=jdbc:sqlite:${database}

schemacrawler.override.identifier_quote_string="

select.INFORMATION_SCHEMA.VIEWS=\
SELECT \
  NULL AS TABLE_CATALOG, \
  NULL AS TABLE_SCHEMA, \
  name AS TABLE_NAME, \
  sql AS VIEW_DEFINITION, \
  'UNKNOWN' AS CHECK_OPTION, \
  'N' AS IS_UPDATABLE \
FROM \
  sqlite_master \
WHERE \
  type = 'view' \
ORDER BY \
  name

select.INFORMATION_SCHEMA.TRIGGERS=\
SELECT \
  NULL AS TRIGGER_CATALOG, \
  NULL AS TRIGGER_SCHEMA, \
  name AS TRIGGER_NAME, \
  CASE \
    WHEN sql LIKE '%INSERT ON%' THEN 'INSERT' \
    WHEN sql LIKE '%UPDATE ON%'  THEN 'UPDATE' \
    WHEN sql LIKE '%DELETE ON%'  THEN 'DELETE' \
    ELSE 'UNKNOWN' \
  END \
  AS EVENT_MANIPULATION, \
  NULL AS EVENT_OBJECT_CATALOG, \
  NULL AS EVENT_OBJECT_SCHEMA, \
  tbl_name AS EVENT_OBJECT_TABLE, \
  0 \
    AS ACTION_ORDER, \
  '' AS ACTION_CONDITION, \
  CASE \
    WHEN sql LIKE '%ROW%' THEN 'ROW' \
    WHEN sql LIKE '%STATEMENT%' THEN 'STATEMENT' \
    ELSE 'UNKNOWN' \
  END \
    AS ACTION_ORIENTATION, \
  CASE \
    WHEN sql LIKE '%AFTER%' THEN 'AFTER' \
    WHEN sql LIKE '%BEFORE%' THEN 'BEFORE' \
    ELSE 'INSTEAD OF' \
  END \
    AS CONDITION_TIMING, \
  sql AS ACTION_STATEMENT \
FROM \
  sqlite_master \
WHERE \
  type = 'trigger' \
ORDER BY \
  name

 master=SELECT * FROM sqlite_master