User Tools

Site Tools


mapping_database_objects_to_files

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mapping_database_objects_to_files [2013/07/25 21:00]
127.0.0.1 external edit
mapping_database_objects_to_files [2013/07/29 18:57] (current)
admin
Line 14: Line 14:
 Let's assume that the Lure connect file is located in the folder "​C:​\workspace\project1\sql"​ then a database package with name STORE_DATA within the schema with name MY_SCHEMA will be mapped by Lure to the following filename: Let's assume that the Lure connect file is located in the folder "​C:​\workspace\project1\sql"​ then a database package with name STORE_DATA within the schema with name MY_SCHEMA will be mapped by Lure to the following filename:
  
-  C:​\workspace\project1\sql\MY_SCHEMA\code\packages\STORE_DATA.pack+  C:​\workspace\project1\sql\MY_SCHEMA\code\packages\STORE_DATA.pack.lsql
  
 The file name and path are determined as follows: The file name and path are determined as follows:
Line 21: Line 21:
   - Below that will always be a folder with the same name as the database schema within which the object lives.   - Below that will always be a folder with the same name as the database schema within which the object lives.
   - Below that is the relative path for the object type as specified in the Lure configuration file. For this example the type is a database package for which the relative path is "​code/​packages"​.   - Below that is the relative path for the object type as specified in the Lure configuration file. For this example the type is a database package for which the relative path is "​code/​packages"​.
-  - Next is the filename of the text file where the database source code will be stored. Lure maps a package to a file with the same name as the package name (using the same case) appended ​with an extension ​as specified in the Lure configuration fileIn this case the extension is specified as "pack" and the filename is therefore "​STORE_DATA.pack".+  - Next is the filename of the text file where the database source code will be stored. Lure maps a package to a file with the same name as the package name (using the same case)
 +  - With regards to the extension, from Lure version 3 onwards all source files have "​.lsql" ​appended ​as an additional ​extension. ​The complete ​extension is therefore ​"pack.lsql"
  
 Lure maps different object types in slightly different ways. For packages it is possible to configure Lure such that the package and corresponding package body are mapped and stored in the same or in seperate files (two files). In this example the package and package body are mapped to one file. Lure maps different object types in slightly different ways. For packages it is possible to configure Lure such that the package and corresponding package body are mapped and stored in the same or in seperate files (two files). In this example the package and package body are mapped to one file.
mapping_database_objects_to_files.txt · Last modified: 2013/07/29 18:57 by admin

Page Tools