- Integration New Media
Contents
1. Um GoldenGate Database Connector First Steps For Macromedia Director Version 1 1 integration new media 2001 2002 Integration New Media Inc 2002 02 18 Table of Contents Table of Contents Introduction Best Practices Before you Start Firewall considerations Explore the landscape Initializing GoldenGate Searching Data SetCriteria Select The ISNicknameUni que handler Retrieving Data GetField Retrieving the user s last name Adding a New Record AddRecord SetField UpdateRecord The AddNewAccount handler Modifying Data Quick Implementation User Interface Elements Scripting Modifying Data Methodology Step 1 Objective Step 2 Requirements and Specifications Step 3 Architecture Step 4 Implementation Step 5 Testing Error Checking Be Proactive The CheckError handler Appendix Database Structure 15 15 15 16 GoldenGate Database Connector First Steps for Director Introduction Thank you for using GoldenGate Database Connector This First Steps manual is a quick overview of GoldenGate s most common features It uses the Logon sample Director movie provided at http www GGdbc com getting started to illustrate e How a Director movie opens a connection to a GoldenGate server e How to search data e How to retrieve data e How to modify data In these First Steps you will use your own Director movie and connect to Integration New Media s GoldenGate and MS2. whenever an error occurs Therefore you must make sure to check for errors after each call to GoldenGate using one or both these methods e GGStatus returns the status of the last called GoldenGate method If no error occurred Gestatus returns 0 GGError returns text in English explaining the error code If no error occurred GGError returns an empty string The checkError handler Logon DIR features a convenient and generic error handler named CheckError on CheckGGError if GGstatus then alert GGstatus amp amp GGError return TRUE end if return FALSE end CheckGGError This handler returns TRUE if the last call to GoldenGate was successful or it displays an alert and returns FALSE if the last call to GoldenGate generated an error It is an excellent practice to insert a call to CheckError after each call to GoldenGate GoldenGate Database Connector First Steps for Director 15 Appendix Database Structure The structure of the MS SQL database used by this sample is GoldenGate Database Connector also 2 Desion Table Users oxi supports Oracle MSDE MySQL and Lt iL other ODBC compliant databases See http www GGdbe com for details varchar varchar varchar varchar varchar datetime int varchar KIRIK GoldenGate Database Connector First Steps for Director
3. SQL Servers through the Internet Most of all you will realize that all of this requires very little scripting in your Director movie and no scripting at all on the server side Best Practices This First Steps manual also emphasizes on some recommended practices such as development process and error management Such techniques apply to a wide variety of projects and are beyond the scope of GoldenGate They nonetheless constitute the core of our expertise at Integration New Media GoldenGate Database Connector First Steps for Director 3 Before you Start Before you start make sure that you have e Director 7 or later for MacOS or Windows e The Logon sample movie available from http www GGdbc com getting started e The GoldenGate Client Xtra for Director available from http www GGdbce com and that it is located in Director s Xtras folder e An Internet connection Firewall considerations If you are using these First Steps with a GoldenGate Server installed on your own computer or local area network you don t need to worry about firewall issues It you want to connect to the GoldenGate Server located at Integration New Media and if you are behind a firewall and if your firewall is configured to disallow outbound queries ask your system administrator to allow outbound queries from your computer so your GoldenGate client can contact the GoldenGate Server located at Integration New Media You don t need
4. abase Structure the user s last name is stored in a field named LastName which is the parameter passed to GetField This same operation would have involved server side script modification query encoding result parsing and or character set translation in technologies other the GoldenGate Retrieving Data In Logon DIR data is retrieved from the remote database for a few different reasons such as e matching a nickname s password against the one supplied by the user or e retrieving the user s first name last logon date and number of logon s to display on the Welcome screen In this section you will learn how to retrieve the user s last name from the database and display it on the Welcome screen GetField Data retrieval is primarily performed by the GetField method as in this excerpt from the checkAndLogon handler in cast member 3 nbrofLogons gT GetField NumberofLogons This statement retrieves the value of field NumberofLogons of the current record in table gt which refers to table users as shown in Initializing GoldenGate 3c Retrieving the user s last name 1 To modify the checkAndLogon handler and make it display the user s last name as well as the first name and logon information first add this statement shown in bold gets here if nickname and password valid 1Name gT GetField LastName fName gT GetField FirstName nbrofLogons gT GetField NumberofLogons lastLogon gT GetField Las
5. er top secret is AnyUser s password b Open a database instance gDB new Xtra GGDBE gCX FirstSteps where GGDBE is the GoldenGate database Xtra s name gcx is the connection instance created above FirstSteps is the GoldenGate database connector s name It resides on the GG IntegrationNewMedia com server c Open a table instance gT new Xtra GGRecordSet gDB Users where GGRecordSet is the GoldenGate recordset Xtra s name gbB is the database instance created above users is the name of the table required by this project It resides in the database identified as FirstSteps The rest of the movie will only use the gt global variable to search retrieve and store data gbB and gcx will not be directly used GoldenGate Database Connector First Steps for Director 6 GoldenGate is also able to perform searches on other types of data fields numerals dates etc with a wide range of comparison operators greater smaller within range full text etc See the GoldenGate Developer s Manual for details Searching Data Although GoldenGate accepts SQL statements for advanced data searching knowledge of SQL is not required in most projects thanks to GoldenGate s simplified API In Logon DIR data is searched in two different situations e When granting access to a nickname password combination to identify a nickname s record and make sure the user supplied password matches the one stored in that rec
6. erface Elements The following user interface elements are provided in Logon DIR for your convenience e A Modify Account button member 15 of Castlib UD e A Save button member 16 of Castlib UT e A Cancel button member 17 of Castlib UI The same Text members as New Account laid out the same way on the ModifyAccount screen frames 60 through 74 Place the Modify Account sprite on the Welcome screen at any convenient location Scripting 1 Create a new behavior for the Modify Account sprite Type this script on MouseUp DoPopulateAccountInfo end Mouseup 2 Type this handler at the top of movie script 4 Create or Modify Account on DoPopulateAccountinfo global gT GG table instance global gCurrentNickname keep for later verification gCurrentNickname Member txt Nickname text DisplayMsg Retrieving account info from database gT Setcriteria Nickname gCurrentNickname gT Select DisplayMsg EMPTY if CheckGGError then return FALSE populate user interface nickname and password are already in req d members Member txt FirstName text gT GetField FirstName Member txt LastName text gT GetField LastName Member txt Password text gT GetField Password Member txt FavoriteColor text gT GetField Favoritecolor Member txt Mission text gT GetField Mission GoldenGate Database Connector First Steps for Director 10 go to frame ModifyAcc
7. he addNewAccount handler in cast member 4 1 Tell GoldenGate to add a blank record gT AddRecord Assign user s entry to the fields of the new record gT SetField FirstName Member txt FirstName text gT SetField LastName Member txt LastName text gT SetField Nickname Member txt Nickname text gT SetField Password Member txt Password text gT SetField Favoritecolor Member txt FavoriteColor text gT SetField Mission Member txt Mission text Initialize the fields that do not depend on user interface GetCurrentDateTime is a handler defined in movie script 5 It returns the current date and time as a property list gT SetField LastLogon GetCurrentDateTime gT SetField NumberofLogons 1 Save the record to the database gT UpdateRecord GoldenGate Database Connector First Steps for Director If you don t feel like scripting the new additions you can copy paste them from the Copy Paste into your scripts Castlib or just download a completed version of Logon DIR from http www GGdbc com getting started Modifying Data Quick Implementation In this section you will learn step by step how to modify Logon DIR to let users modify their own account information nickname first name last name favorite color etc The next section will guide you through a more global and systematic approach to project development and modification through the same example User Int
8. here if data valid and modification successful Member txt wWelcomeMsg text Your account information was successfully modified go to frame Welcome end CheckAndSaveAccount 5 Finally drop the Go to Frame Label behavior on the Cancel sprite and choose Welcome in the popup menu You are now ready to test the new feature GoldenGate Database Connector First Steps for Director 11 Modifying Data Methodology Any project regardless of its size or scope and independently of GoldenGate must undergo a systematic analysis phase Oftentimes that phase is short but it lets you identify pitfalls before they actually become problems A typical development process for multimedia projects is 1 Identify clear objectives 2 List requirements and specify how they would look and interact once implemented 3 Architect the solution and put together a blueprint that would guide the implementation 4 Implement the solution create graphics and write scripts 5 Test test test Let s apply this process to Logon DIR s Modify Account project Step 1 Objective Let users modify their own account information Step 2 Requirements and Specifications Requirements e Users can only modify their own accounts e A nickname cannot be changed to another one that already exists e Allow users to review their modifications and cancel the account modification operation along the way Specifications e Anew Mod
9. ify Account screen displays a user s account and allow him her to modify it e A user must supply a password before viewing or modifying an account information e A Cancel button sends the user back to where s he came from e A Save buttons makes sure that a the modified data is valid i e no excessively long fields no empty nickname first name last name etc b the new nickname is unique throughout the database GoldenGate Database Connector First Steps for Director 12 c the account information is saved back to the same record from which it was read e A Modify Account button is added to the Welcome screen It gives access to the Modify Account area while at the same time authenticating a user before allowing modifications Step 3 Architecture e A new Modify Account screen is laid out in frames 60 through 74 using the same Text members as those used in Add Account e The Cancel button is in sprite 19 It basically does go to frame Welcome e The Save button is in sprite 20 It does the following Checks IsuserEntryvalid see handler in member 4 Checks if the nickname is unique Two distinct scenarios can occur o Ifthe user modifies his her nickname the new The depth of this text s indentation nickname must not be already used by any other reveals that there actually were pitfalls user Call IsNicknameuniqueQ to check if the new in this area of the project and that we ickn p ni me 1s uniq
10. n your testing The earlier you catch errors the less expensive they are to fix In the specific case of this project you must test at least two exceptional cases identified in Step 3 Architecture e When a nickname is modified by a user e When a nickname is not modified by a user Other tests include e Leaving some or all entries empty e Entering very long strings e Trying entries with high ASCII characters or punctuation e Entering an existing nickname e Clicking on buttons in different sequences GoldenGate Database Connector First Steps for Director 14 Once your project is working and ready for final testing you may want to remove some non critical calls those that only trap programming errors In Logon DIR all CheckErrors that followed SetCriteria GetField AddRecord and SetField were removed to improve script legibility Error Checking Error Checking is a very important part of any project that accesses external files or databases whether locally or through a network Be Proactive Not all errors are equal Some errors are fundamentally fatal e g network connection dropped some others are benign e g attempting to read a record that does not exist GoldenGate does not intrusively display alerts when errors occur Instead it lets you take whatever action is appropriate e g branch to a different handler terminate a session display a message in the appropriate language style etc
11. ord This is done in the IsLogonInfovalid handler e When creating a new account to make sure a nickname is unique before adding it to the database This is done in the CheckAndLogon handler SetCriteria Select Searching data is performed in two steps in GoldenGate e Call setcriteria with one or more search criteria as in gT Setcriteria Nickname nick e Call select to actually trigger the search process on the server as in gT Select Then you are ready to check the number of records selected with Selectcount browse through the selected records with GoNext GoPrevious GoFirst GoLast and Go retrieve data with GetField etc The IsNicknameuni que handler This is the logic behind the IsNicknameuni que handler in cast member 4 1 Tell GoldenGate to search for all records who s Nickname field equals the user s entry gT Setcriteria Nickname member txt Nickname text 2 Trigger the search gT Select 3 Ask GoldenGate how many records were found n gT Selectcount 4 If one or more records were found i e the nickname already exists tell the user to pick another nickname if n gt 0 then found at least one occurrence Alert This nickname already exists end if GoldenGate Database Connector First Steps for Director 7 Other data retrieval methods are GetSelection and GetMedia See the GoldenGate Developer s Manual for details As shown in Appendix Dat
12. ount end DoPopulateAccountInfo This handler selects the current nickname s record in the database and then retrieves First Name Last Name Password Favorite Color and Mission to the user interface Nickname is already in the appropriate text member Once DoPopulateAccountiInfo completes the user is ready to edit his her account 3 Create a new behavior for the Save sprite Type this on Mouseup CheckAndSaveAccount end Mouseup Type this handler at the top of movie script 4 Create or Modify Account on CheckAndSaveAccount global gT GG table instance global gCurrentNickname initial nickname if NOT IsUserEntryValid then exit fail if entered text ii empty or too long if Member txt Nickname text lt gt gCurrentNickname then nickname was modified check uniqueness if NOT IsNicknameUnique then exit fail User must pick another nickname end if make sure you got the right Current Record gT Setcriteria Nickname gCurrentNickname gT Select gT EditRecord set UI data gT SetField FirstName Member txt FirstName text gT SetField LastName Member txt LastName text gT SetField Nickname Member txt Nickname text gT SetField Password Member txt Password text gT SetField Favoritecolor Member txt FavoriteColor text gT SetField Mission Member txt Mission text gT UpdateRecord if CheckGGError then exit gets
13. tLogon d MMMM yyyy hh mm ss 2 Then modify the last statement to Member txt welcomeMsg text Welcome back amp amp fName amp amp 1Name amp amp RETURN amp You had last logged on amp amp lastLogon amp amp RETURN amp You logged on a total of amp amp nbrofLogons amp amp times to this system Run the movie 4 Log on with the nickname and account you created earlier in Explore the landscape The Welcome screen will now display both your first and last name GoldenGate Database Connector First Steps for Director 8 It is always a good practice to initialize all the fields of a new record In this case it is not necessary to initialize the ID field because it is defined to automatically increment in the MS SQL database See database structure in Appendix Database Structure Adding a New Record In Logon DIR a new record is added to the remote database every time a new account is created This is performed by the AddNewAccount handler This section will show you how it is implemented AddRecord SetField UpdateRecord To add anew record with GoldenGate 1 First call AddRecord to create a blank record The new record is not saved to the database yet Then call setField as many times as needed to populate the fields of the new record Finally call updateRecord to save the new record to the database The AddNewAccount handler This is the logic behind t
14. to worry about firewall issues in all other situations GoldenGate Database Connector First Steps for Director 4 Explore the landscape First run the Logon sample movie and make sure it works properly on your computer e Create a new account e Try to logon using your newly created nickname and password e Keep your nickname and password on hand as you will need them in the next few steps GoldenGate Database Connector First Steps for Director If both the server and the client are running on your own computer use localhost as the Server name instead of GG IntegrationNewMedia com Initializing GoldenGate 1 Open the Logon DIR movie If you have Director 8 or later you may want to immediately save the movie back with a new name so you can easily save your upcoming modifications 2 Open the Initialize movie script cast member 2 The Initcc handler performs everything you need to open a connection to the remote database This is a three step process a Open a connection to the GoldenGate Server gCX new xtra GGConnection GG IntegrationNewMedia com 1729 AnyUser top secret where GGConnection is the GoldenGate connection Xtra s name GG IntegrationNewMedia com is the GoldenGate Server s name hosted at Integration New Media 1729 is the GoldenGate Server s TCP IP port Anyuser is the name under which your project will identify itself when connecting to the GoldenGate Serv
15. ue identified them before we proceeded to ARE q the implementation o If the user keeps the same nickname then there is no Thus the application of methodology need to check for uniqueness Otherwise we will DATE Sen eCER ee certainly find it not to be unique The query will identify the account s original record in the database c If both preceding tests succeed it calls a handler similar to AddNewAccount except that it calls GoldenGate s EditRecord method instead of AddRecord e The Modify Account button is in sprite 19 It basically a Preserves the current nickname to check for possible modifications later on b Locates the user s record c Retrieves and displays account information d Goes to frame ModifyAccount GoldenGate Database Connector First Steps for Director 13 Note that the step by step implementation you performed in Modifying Data Quick Implementation is a direct result of Step 1 Objective Step 2 Requirements and Specifications and Step 3 Architecture Step 4 Implementation This is precisely what we focused on in the previous section User Interface Elements See User Interface Elements in Modifying Data Quick Implementation previous section Scripting See Scripting in Modifying Data Quick Implementation previous section Step 5 Testing Testing is an important part of any project not specifically those that involve GoldenGate Be persistent and systematic i
Download Pdf Manuals
Related Search