User manual KAWAI 400 DELUXE CONSOLE

[. . . ] To view a copy of this license, visit http://creativecommons. org/licenses/by-nc-sa/3. 0/ Adobe, the Adobe logo, ColdFusion, and Flash are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States and/or other countries. Java is a trademark or registered trademark of Sun Microsystems, Inc. in the United States and other countries. All other trademarks are the property of their respective owners. [. . . ] In this example, a join table named "EMP_DEPT" is created in the Offline SQLite DB with a many-tomany relationship between the Employee and Department tables. Lazy loading and fetch type The ActionScript persistent framework supports lazy loading although it may not be as intuitive because of the asynchronous connection with the database. The fetch type EAGER or LAZY determines the fetch type for the relationship that is loaded. An EAGER fetch type loads the relationship and fetches data when the call is first made. A LAZY fetch type loads the relationship and fetches data only when an explicit fetch call is made. The default value for the fetch type is EAGER and the default value for ignoreLazyLoad is false. When you specify fetchType="EAGER" at the class-definition level, the loadByPk function always loads the related object, irrespective of the value you specify for the ignoreLazyLoad parameter. When you specify fetchType="LAZY" at the class-definition level, you can have two possibilities: · When you specify the ignoreLazyLoad parameter as true, the related object is also loaded. For example, if you have two related objects Address and Customer, and specify loadByPK(Customer, {id:3}, true), the Address object is also loaded. · When you do not specify any value for the ignoreLazyLoad parameter, it takes the default value that is false, and the related object is not loaded. For example, if you have two related objects Address and Customer, and specify loadByPK(Customer, {id:3}), the Address object is not loaded. Cascading options Cascading lets you specify the operations to be cascaded from the parent object to the associated object. The supported operations are INSERT, UPDATE, and DELETE. The cascadeType attribute lets you set any of the following values. ALL If The source entity is inserted, updated, or deleted, the target entity is also inserted, updated, or deleted. Last updated 8/5/2010 DEVELOPING 400 DELUXE CONSOLE 9 APPLICATIONS Flex and AIR Integration in ColdFusion 632 PERSIST If The source entity is inserted or updated, the target entity is also inserted or updated. To fetch the initial data from the server, you can include the following code in the Application init() method. // fetch the data. var token:AsyncToken = syncmanager. fetch("fetch"); //Specify the responder to handle the fetch results. token. addResponder(new mx. rpc. Responder(fetchSuccess, fetchFault)); Managing the local database You use a Session object to manage the data in the local SQLite database. You call the syncmanager. openSession method to create a session with a specific database file. The method returns a SessionToken token, and the SessionToken. session property provides access to the session. You use code in the token's openSessionSuccess responder event handler to provide access to the session object. This way, you do not access the session, and therefore the database, until it is successfully opened. Last updated 8/5/2010 DEVELOPING 400 DELUXE CONSOLE 9 APPLICATIONS Flex and AIR Integration in ColdFusion 634 The following code expands on the session initialization code that was shown above. and shows an openSessionSuccess event handler that uses the session to save the contents of the remote database in the local image. In this example, users is the array collection fetched from server: var dbFile:File = File. userDirectory. resolvePath("basic. db"); var token:SessionToken = syncmanager. openSession(dbFile, 113); token. addResponder(new mx. rpc. Responder(openSessionSuccess, openSessionFault)); function openSessionSuccess(event:SessionResultEvent):void { //Initialize a variable for access to the session. var session:Session = event. sessionToken. session; //Save the remote database data in the local database. //users is the array collection fetched from server var saveToken:SessionToken = session. saveCache(users); //Add responder event handlers for successful and failed saves. [. . . ] 4 Enter the project folder where you want to save the CFC in the CFC Folder text box. 5 Enter the CFC package in the CFC Package Name text box. 6 (Optional) Select the Primary Key column if a primary key is not defined in the database. 7 (Optional) To specify the primary key column in addition to the other values specified in the CFC, select the Primary Key is Controlled by the User option. [. . . ]