Skip to content

4.6 Update Fields

Jump to bottom Edit New page
Steven Sotelo edited this page May 21, 2015 · 6 revisions

This option facilitates update rows values of the tables into database and running SQL querys in the database. You can select if you want to update by a file or by fields

Update files

Configuration

  • Type: The application will validate that the query matches with the table
  • Log: The folder where the application will save the files that contain the results
    • QUERY_ERROR: contains the query that the application try to upload but the database refused

By file

  • File: This allow you select the source file that contains all querys desired to run in the database
  • Clear query: It indicates that you have a file with Sql queries by every line
  • Fields: It indicates that you have a .csv file with values that you want to update into database. It should has a column called "id"
    • Split: It is a pattern to split the columns from file .csv. This option is only validate if you select the option fields.
    • Taxon Final: It is a special condition for the files by fields. If you want to update the taxon final field and its others fields final (e.g f_x1_genus, f_x1_sp1, etc), you only need to upload a file with two columns (id and taxon_final) and check this option.
  • Run: This button executes all queries

By fileds

  • Grid: Every row of the grid indicates one update to do into database. For each row you should fill the column field and value, the column condition is optional, if you don't fill it, the update query will affect all table. when the values is a "String", you should put it inside within apostrophe " ' ". For example: 'Mi value'
  • Run: This button executes all updates

Dev by Steven Sotelo

Logo

Clone this wiki locally