tpryan / apptacular Goto Github PK
View Code? Open in Web Editor NEWColdFusion Builder Extension for scaffolding applications straight from the database
License: Other
ColdFusion Builder Extension for scaffolding applications straight from the database
License: Other
Just installed the extensions apptacular under webroot (Applications/coldfusion9/wwwroot/apptacular) and get this for any apptacular menu:
Thoughts?
An Error has occured.
Message:Invalid CFML construct found on line 212 at column 25.
Details:ColdFusion was looking at the following text:
for
The CFML compiler was processing:
A script statement beginning with for on line 212, column 25.
A script statement beginning with { on line 209, column 65.
A script statement beginning with for on line 209, column 17.
A script statement beginning with public on line 199, column 9.
Apptacular creates an application first time through no problem but when i regenerate I get the above error.
I have the latest version of apptacular
cf 9
An Error has occured.
Message:Invalid CFML construct found on line 212 at column 25.
Details:ColdFusion was looking at the following text:
for
The CFML compiler was processing:
A script statement beginning with for on line 212, column 25.
A script statement beginning with { on line 209, column 65.
A script statement beginning with for on line 209, column 17.
A script statement beginning with public on line 199, column 9.
A naîve attempt to use Apptacular would be to open a project, create a folder for the app and then right-click > Apptacular > Create application on that new folder. The result is the application is generated into the root of the project (and doesn't actually work because it has references to .cfc.table[] in types (notice leading .).
If would be nice if Apptacular could detect this and explain that you need to create the application from the RDS view instead.
Whe I try to use the Apptacular v 1.000311 with MS SQL 2008 I get the following error:
Error occurred while parsing response form handler
"handler/handlerGenereate.cfm"
Check log for more details.
The success message should indicate success, maybe include names of created files.
When I open the "About Apptacular"-page I get the following error:
"The requested URL /Apptacular/handlers/about/index.cfm&ideVersion=1.0 was not found on this server."
The "&" should be replaced by a "?".
Apptacular doesn't show anything but a blank window. Investigation in the server's application logs will reveal errors.
I get the error "Properties cannot be declared more than once" when using the code generated by Apptacular.
When I take a look in the code I see that on several location, properties are created twice.
I noticed that i had a field that was set to float and the ormType was getting set to String. Changed the database field to decimal results in an ormType of Float. I think the problem is with the Apptacular / handlers / cfc / db / mappings.cfc in the area around line 62 where the datatypes are set for numerics. Adding datatypes['float'] = defaultnumeric; to my local mappings.cfc seems to do the trick.
John Piotrowski
Should say Changes saved.
Hi Terry
love your work on Apptacular, hope these issue tracking helps improve it...
installed Apptacular on a fresh CF builder 2 installation, so I got the latest version off Apptacular from the CF Builder 2 start screen, and not from RIAforge...
on the first application generation, all went well
then I re-generated the app after changing an ID field in a DB table from auto generated number to varchar (I planned to populate it with createUUID() ) after it not working, i altered the ID table field back to auto-generated int, and still I get the same Bug... don't know if it is related, but Apptacular generates many of the cfc properties and methods twice... which obviously leads to the breaking of the application code...
any Ideas?
cheers
s.
Receiving error when trying to use Apptacular (Log file was not created):
"Invalid CFML construct found on line 15 at column 21.
ColdFusion was looking at the following text:
cfc.utils.utils
The CFML compiler was processing:
A script statement beginning with utils on line 15, column 9.
A cfscript tag beginning on line 12, column 2."
I am running CF8 on WindowsXP.. Error message popup as soon as I am creating new project in CFBuilder and getting to the screen "Add existing Sources and Extensions" and adding "Apptacular". If I ignoring this error and later on try to use "Apptacular" to any DB tables I am receiving the same Error.
Thanks
Michael Sinaysky
I've got ColdFusion 9 running on port 8502 and because of that Apptacular throws the following error: "The requested URL was not found on this server."
These are the files in witch the problem occurs:
Apptacular/handlers/handlerAbout.cfm - line 2 -
Apptacular/handlers/handlerActiveTables.cfm - line 9 -
Apptacular/handlers/ handlerEditConfig.cfm - line 7 -
Apptacular/handlers/handlerEditDB.cfm - line 9
Apptacular/handlers/handlerPurge.cfm - line 9
This is a correction that fixed the problem:
<cfset handlerURL = "http://" & cgi.server_name & ":" & cgi.server_port & handlerPath />
It would be nice to be able to select a subset of the tables in a DB and have Apptacular ignore other tables..
Hi, I am running the latest version of apptacular, on CF builder 2 on windows 7. CF 9.0.
In both my application.cfc and config.xml it seems to be creating bad paths: (notice the dot after "C:)
This.ormsettings.eventHandler = "C:.ColdFusion9.wwwroot.test1323.cfc.eventHandler";
C:.ColdFusion9.wwwroot.test1323.test
This is the same on config.xml. Needless to say it wont run.
This what is generated in my application.cfc
component{
This.name = "whichCMS2";
This.ormenabled = true;
This.datasource = "whichCMS2";
This.customTagPaths = GetDirectoryFromPath(GetCurrentTemplatePath()) & "customtags";
This.ormsettings.eventHandler = "C:.ColdFusion9.wwwroot.test1323.cfc.eventHandler";
This.ormsettings.dbcreate = "update";
This.ormsettings.logSQL = true;
public boolean function onRequestStart() {
if (structKeyExists(url, "reset_app")){
ApplicationStop();
location(cgi.script_name, false);
}
return true;
}
public boolean function onApplicationStart() {
application.authorService = new C:.ColdFusion9.wwwroot.test1323.services.authorService();
application.franchiseService = new C:.ColdFusion9.wwwroot.test1323.services.franchiseService();
application.articletypeService = new C:.ColdFusion9.wwwroot.test1323.services.articletypeService();
application.articleService = new C:.ColdFusion9.wwwroot.test1323.services.articleService();
application.websiteService = new C:.ColdFusion9.wwwroot.test1323.services.websiteService();
return true;
}
}
CONFIG.XML
C:/ColdFusion9/wwwroot/test1323 cfscript true createdOn true false true false true screen.css C:/ColdFusion9/wwwroot/test1323\css css /C:/ColdFusion9/wwwroot/test1323/css C:/ColdFusion9/wwwroot/test1323\customTags customTags mm/dd/yyyy update false C:.ColdFusion9.wwwroot.test1323.cfc C:/ColdFusion9/wwwroot/test1323\cfc cfc false true false false mxunit C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\CFIDE\administrator\mxunit false false C:.ColdFusion9.wwwroot.test1323 C:/ColdFusion9/wwwroot/test1323 /C:/ColdFusion9/wwwroot/test1323/ http://www.cfadmin.com/C:/ColdFusion9/wwwroot/test1323 50 public C:.ColdFusion9.wwwroot.test1323.services count destroy C:/ColdFusion9/wwwroot/test1323\services services get init list listPaged searchCount search searchPaged update C:.ColdFusion9.wwwroot.test1323.test C:/ColdFusion9/wwwroot/test1323\test test /C:/ColdFusion9/wwwroot/test1323/test http://www.cfadmin.com/C:/ColdFusion9/wwwroot/test1323/test h:mm tt updatedOn trueNot sure what I'm doing wrong, but i have a default trial version of Cf Builder 2 installed with a default CF9 developer edition, and every time i try to create anything, i get an error.
Message:Element DATA.EVENT.IDE.CALLBACKURL.XMLTEXT is undefined in VARIABLES.
it installed perfectly fine once i had a server set up, and i did so from the welcome page.
Thanks,
David
"The specified directory /dev/null does not exist."
The error occurred in /Applications/ColdFusion9/wwwroot/Apptacular/handlers/editDB/editDatasource.cfm: line 15
13 : variables.NL = createObject("java", "java.lang.System").getProperty("line.separator");
14 : variables.FS = createObject("java", "java.lang.System").getProperty("file.separator");
15 : files = DirectoryList(schemaPath, true, "query", "*.xml");
16 :
17 :
An error occurred when performing a file operation read on file /Library/WebServer/Documents/apptac1/.apptacular/schema/cfartgallery//_table.xml.
The cause of this exception was: java.io.FileNotFoundException: /Library/WebServer/Documents/apptac1/.apptacular/schema/cfartgallery/_table.xml (No such file or directory).
The error occurred in /Library/WebServer/Documents/extensions/Apptacular/handlers/customTags/XMLForm.cfm: line 37
Called from /Library/WebServer/Documents/extensions/Apptacular/handlers/editDB/editTable.cfm: line 78
Called from /Library/WebServer/Documents/extensions/Apptacular/handlers/customTags/XMLForm.cfm: line 37
Called from /Library/WebServer/Documents/extensions/Apptacular/handlers/editDB/editTable.cfm: line 78
35 :
36 :
37 :
38 :
39 :
CF Builder 2
Windows 7
Apptacular 1.000311
SQL Server 2008
I downloaded and installed Apptacular with CFBuilder 2. I had an application that I had built previously which worked fine. This time when I built the application with the same database but with some new tables and changes in schema , the application did not generate correctly.
Here are the problems that I noticed.
Minor Issue : The paths get formatted slightly weird examples below. But this can easily be corrected.
/D:/inetpub/wwwroot/eGIS_Management/css
D:/inetpub/wwwroot/eGIS_Management\customTags
/D:/inetpub/wwwroot/eGIS_Management/
http://localhost/D:/inetpub/wwwroot/eGIS_Management
Earlier I had join tables which got picked up by apptacular automatically, for example I had Users, Roles and UserinRole table which basically is a join table between Users and Roles, I dont see any relationships wired up at all. There are no Related Tables for the join table in question under Edit Database model and no way to add one, this relationship does exist in the database as specified above. So I changed the "Is this table a join table?" to True and "Should this table get wired up" to False.
If I try to regenerate the application after that I get the following error. eGIS_Management is the name of the datasource.
An Error has occured.
Message:Element eGIS_Management is undefined in a CFML structure referenced as part of an expression.
Details:
*
Essentially the many-one relationships in the cfcs have a drop down in the editor. The one to many have no editing capability.
I cleaned everything out and started fresh so that I could have a log file, here is the log file
https://gist.github.com/1108054
Thanks
Apptacular errors out if it isn't installed into the root of a ColdFusion Server.
On any attempt to "Create Application", Apptacular throws this error:
Error
An Error has occured.
Message:Cannot access array element at position 2.
Details:The array has 1 indexes. Valid positions are from 1 to 1.
Here is the complete log:
struct Detail: The array has 1 indexes. Valid positions are from 1 to 1. ErrNumber: 0 Message: Cannot access array element at position 2. StackTrace: coldfusion.runtime.InvalidArrayIndexException: Cannot access array element at position 2. at coldfusion.runtime.Array.ArrayIsDefined(Array.java:266) at coldfusion.runtime.CFPage.ArrayIsDefined(CFPage.java:529) at cftable2ecfc1470774065$funcCALCULATEFOREIGNKEYLABEL.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc:152) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at cftable2ecfc1470774065$funcINIT.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc:110) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.CFPage.___createObjectInternal(CFPage.java:8370) at coldfusion.runtime.CFPage._createObject(CFPage.java:8338) at cfdatasource2ecfc1002938553$funcPOPULATETABLES.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc:93) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2582) at cfdatasource2ecfc1002938553$funcINIT.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc:35) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:490) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:336) at coldfusion.runtime.CFPage.___createObjectInternal(CFPage.java:8370) at coldfusion.runtime.CFPage._createObject(CFPage.java:8338) at cfhandlerGenerate2ecfm1091199144.runPage(C:\CF9\wwwroot\Apptacular\handlers\handlerGenerate.cfm:183) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:342) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:87) at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:53) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) TagContext: [array] 1) [struct] COLUMN: 0 ID: CF_CFPAGE LINE: 152 RAW_TRACE: at cftable2ecfc1470774065$funcCALCULATEFOREIGNKEYLABEL.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc:152) TEMPLATE: C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc TYPE: CFML 2) [struct] COLUMN: 0 ID: CF_UDFMETHOD LINE: 110 RAW_TRACE: at cftable2ecfc1470774065$funcINIT.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc:110) TEMPLATE: C:\CF9\wwwroot\Apptacular\handlers\cfc\db\table.cfc TYPE: CFML 3) [struct] COLUMN: 0 ID: CF_CFPAGE LINE: 93 RAW_TRACE: at cfdatasource2ecfc1002938553$funcPOPULATETABLES.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc:93) TEMPLATE: C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc TYPE: CFML 4) [struct] COLUMN: 0 ID: CF_UDFMETHOD LINE: 35 RAW_TRACE: at cfdatasource2ecfc1002938553$funcINIT.runFunction(C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc:35) TEMPLATE: C:\CF9\wwwroot\Apptacular\handlers\cfc\db\datasource.cfc TYPE: CFML 5) [struct] COLUMN: 0 ID: CF_CFPAGE LINE: 183 RAW_TRACE: at cfhandlerGenerate2ecfm1091199144.runPage(C:\CF9\wwwroot\Apptacular\handlers\handlerGenerate.cfm:183) TEMPLATE: C:\CF9\wwwroot\Apptacular\handlers\handlerGenerate.cfm TYPE: CFML Type: Expression len: 1 pos: 2 ************************************************************************************
"Are you sure you want to update" - personal opinion - but the button shouldn't be the confirmation. Put that text above and make the button nice and obvious ("Yes!")
If you add the apptacular project to an svn you get an error when trying to regenerate the application ,it throws an error saying "Datasource .svn could not be found"
Log file here http://64.72.142.162/apptacular/2010-08-13_11-42-54-142.html
Version : 1.000293
CF Builder Version : 1.0.0 build: 274293
Windows 7
When the application is first generated the default CFC path picked up is not quite right , I believe this is caused because its a Windows directory and not Mac . This can be fixed pretty easily by going and modifying the Apptacular config but as I have reported in Issue 22 http://github.com/tpryan/Apptacular/issues#issue/22 , I am having problems with Apptacular regeneration
Screenshot http://tinypic.com/r/123l0yu/4
Hey,
Just installed a fresh copy of the cfbuilder 2 beta and I was anxious to try out the apptacular extension, I am however face with an error.
Here is the entire log:
http://pastebin.com/raw.php?i=HGNyRvy7
Hope this can be resolved =)
Encountered this error after updating to version 1.000299. when creating an application using MSSQL 2008 database. But it does work on Apache Derby Database.
Version : 1.000293
CF Builder Version : 1.0.0 build: 274293
Windows 7
I get an error when I try to prune excess files or regenerate application after making changes in the Apptacular configuration.
Regenerate Application Screenshot: http://tinypic.com/r/rl01ag/4
Prune Application Screenshot : http://tinypic.com/r/24nkztt/4
In this example wayeo is the datasource name
Hu terrenceryan,
I installed Apptacular Extension successfully and its working but when i generate CFCs, Apptacular do not generating the relationship. Is there any configuration for to creating relationship(one-to-one.many-to-one etc). As I saw in your video. you just generate cfcs in myblog example and you got it cfcs with correct relationship but i am not getting relationship. Apptacular just give me a foreign key numeric field.
Please help
many thanks
Could not find the ColdFusion component or interface apptacular.handlers.generators.cfapp.config.
Ensure that the name is correct and that the component or interface exists.
The error occurred in /Library/WebServer/Documents/extensions/Apptacular/handlers/doc/fields.cfm: line 66
64 : return result;
65 : }
66 : var metaData = GetComponentMetaData(arguments.cfcreference);
67 : var props = metaData.properties;
68 :
These lines:
<cfset handlerURL = "http://" & cgi.server_name & handlerPath />
should be:
<cfset handlerURL = "http://" & cgi.server_name & ":" & cgi.server_port & handlerPath />
Howdy,
I just updated to the latest Apptacular, running ColdFusion Builder 2.0 beta, and CF 9.0.1 server. When I select a table in RDS Dataview, right click and select Apptacular -> Generate Application, I get a dialog box asking where the app should be located, then a mostly blank window appears with Apptacular in the upper right, and a close button. After a couple seconds, I get the error above in a small window.
I have a table called valueList and Apptacular generated the following erroneous code:
Invalid CFML construct found on line 49 at column 50.
ColdFusion was looking at the following text:
valuelist
The CFML compiler was processing:
A script statement beginning with remote on line 49, column 9.
The error occurred in /Applications/ColdFusion9/wwwroot/ws/services/valuelistService.cfc: line 49
47 : * @hint Updates one record from valuelist.
48 : */
49 : remote void function update(required any valuelist ) {
50 : arguments.valuelist.nullifyZeroID();
51 : EntitySave(arguments.valuelist);
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.