Hi Jeff, yes - I never used it. The ant task TorqueDataSQLTask was still in release candidate Torque 3_2_RC1, but not in Torque 4, which highly restructured the code.
The velocity templates are quite different if you compare src/generator/src/templates (old) and torque-templates/src/main/resources/org/apache/torque/templates (new). Bu the input generator code seems quite robust, using SAX, the effort might be more in adapting to the new velocity template structures - if anyone thinks about code reusing ;-) Further discussion should be done in [email protected], though IMO ;-) Best regards, Georg Von: Jeffery Painter <[email protected]> An: [email protected] Datum: 06.05.2021 00:26 Betreff: Re: application data schema not being parsed in torque-4.0 / turbine 5.0 This is more of a torque question than turbine... I had just grown used to using it in my old turbine environment. I found the old task that did the job here: http://svn.apache.org/viewvc/db/torque/tags/TORQUE_3_1_1/src/generator/src/java/org/apache/torque/task/TorqueDataSQLTask.java?revision=229611&view=markup However, it looks like it has been removed from newer versions of torque. It was an old maven-1 target torque-data-sql I think the easiest option for now is to run the old code, let it generate the SQL output and then bring that into my new project :-( - Jeff On 5/5/21 5:34 PM, Jeffery Painter wrote: > Hello turbine users, > > > I feel like I have asked this question before and don't remember the > answer (if there was one). > > I have an old project where I had made extensive use of the > application-data.xml - it was still based on turbine-2.3.3 and I am > upgrading this app now to the latest and greatest since I need to use > it on another project. > > I had it generating screens based on a templating system I could > configure from the application-data.xml (I would define for example > multiple choice questions and have all possible values defined in the > xml schema)... > > It worked great and allowed me to generate these "form" apps quickly > since I can re-use the question types and options pretty easily. > > > An example: > > I have grouped questions by top level.. > > <QuestionGroup RefId="1" Name="Poster Data" DisplayOrder="1"/> > > Then, the actual questions assigned to a group have properties like > the following: > > <SelectQuestion RefId="10" GroupId="1" DisplayOrder="1" > Question="ReporterType" Label="Who is posting" HasOther="0" > Instructions="HCP: An HCP includes doctors, nurses, pharmacists and > other professional health care providers." /> > <SelectQuestion RefId="11" GroupId="1" DisplayOrder="2" > Question="NoYesOption" Label="Patient's own experience" HasOther="0" > Instructions="If post is from a patient, does it represent their > own experience?" /> > <SelectQuestion RefId="12" GroupId="1" DisplayOrder="3" > Question="AgeGroup" Label="Patient age range" HasOther="0" > Instructions="" /> > <SelectQuestion RefId="13" GroupId="1" DisplayOrder="4" > Question="Gender" Label="Patient gender" HasOther="0" > Instructions="" /> > > ... then for "Question" I had defined options to select from... > HasOther is a flag to allow for additional free text entry. > > for the first one above, "Who is posting" would have the following > options in a drop down select control: > > <SelectOption RefId="51" DisplayOrder="1" Question="ReporterType" > Name="Unknown" DefaultOption="1"/> > <SelectOption RefId="52" DisplayOrder="2" Question="ReporterType" > Name="Patient/consumer" DefaultOption="0"/> > <SelectOption RefId="53" DisplayOrder="3" Question="ReporterType" > Name="HCP" DefaultOption="0"/> > <SelectOption RefId="54" DisplayOrder="4" Question="ReporterType" > Name="Other Family Member or Friend" DefaultOption="0"/> > > If I have to extract all of this and generate SQL again from the XML > myself, that is going to be a lot of work. > > I can get things to load if I manually convert and stick into the > application-data.sql when creating a new app from scratch, but the new > setup simply ignores my XML file for application data.... kind of > annoying. > > Does anyone have any suggestions? Did I miss something in the torque > setup that would make it load this? > > > Thanks! > > Jeff > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
smime.p7s
Description: S/MIME Cryptographic Signature
