[ 
http://jira.codehaus.org/browse/MSQL-53?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=212064#action_212064
 ] 

Ludwig Magnusson commented on MSQL-53:
--------------------------------------

Hey!
I actually noticed today that there is another option...
you can specify sourceFiles like this:
<scrFiles>
  <srcFile>first</srcFile>
  <srcFile>second</srcFile>
  <srcFile>third</srcFile>
</srcFiles>

and they are executed in the specified order.
I think the documentation could be better here. When looking att the code and 
documentation I saw that the fileset paramerter is of the class FileSet which 
is a subclass to directoryScanner. Therefore the fileset takes in parameters 
that the directoryscanner does, like baseDir. Bur this is not very well 
documented. I think that the fileSet is for specifying files with wildcards 
like *-data.sql. I havent checked if this works with srcFiles.



> Execution order of sql files
> ----------------------------
>
>                 Key: MSQL-53
>                 URL: http://jira.codehaus.org/browse/MSQL-53
>             Project: Maven 2.x SQL Plugin
>          Issue Type: New Feature
>    Affects Versions: 1.5
>            Reporter: Ludwig Magnusson
>            Priority: Minor
>
> When specefying sql source files for the sql plugin in the pom like this:
> <configuration>
>       <fileset>
>               <basedir>${project.basedir}/sql</basedir>
>               <includes>
>                       <include>create-db.sql</include>
>                       <include>project-structure.sql</include>
>                       <include>project-data.sql</include>
>               </includes>
>       </fileset>
> </configuration>
> the files will not be executed in the specified order, but rather in 
> alphabetical order. In this case that would mean that the data file is 
> executed before the structure file and the insertion will fail.
> A quick fix is to name the files something like
> 1-create-db.sql
> 2-project-structure.sql
> 3-project-data.sql
> But is it possibe/desirable to make it possible to specify the execution 
> order in the pom?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

---------------------------------------------------------------------
To unsubscribe from this list, please visit:

    http://xircles.codehaus.org/manage_email


Reply via email to