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]
