Advertisement
Guest User

Untitled

a guest
Mar 31st, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <cfscript>
  2. writeOutput('starting db source installation...<br/ >');
  3.  
  4. function createDSN( name ) {
  5. // Login is always required. This example uses two lines of code.
  6. adminObj = createObject("component","cfide.adminapi.administrator");
  7. adminObj.login("pete", "admin");
  8. // Instantiate the data source object.
  9. myObj = createObject("component","cfide.adminapi.datasource");
  10. // Create a DSN.
  11. myObj.setMYSQL5(
  12. name="dsn#ARGUMENTS.name#",
  13. host="127.0.0.1",
  14. database=ARGUMENTS.name,
  15. username="pete",
  16. password="pete"
  17. );
  18.  
  19. writeOutput('<br />created #ARGUMENTS.name# datasource');
  20. }
  21.  
  22. arr_names = [
  23. 'books',
  24. 'authors'
  25. ];
  26.  
  27. for( name in arr_names ) {
  28. createDSN( name );
  29. }
  30.  
  31. writeOutput('<br />completed');
  32.  
  33. </cfscript>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement