#34 SQL history view and log sql queries in a file

2014.10
closed
Anu
Evol (194)
2014-10-02
2012-02-28
PAscal
No
  1. Add a preference in General > "Max queries in history"
    ( If Max is set to 0 , then it will not log any queries.
    Default value is set to 10 just in case if users don't miss some queries )

  2. Save in user directory ".sqleo_history.csv" file with max queries executed in format csv header - "Timestamp,Connection,Window,Query" ( Same file will be overwritten when max queries is reached)

  3. Menu > "Show SQL History" which is a java swing table will open this file content and show and when user double click's a row, the query will be directly copy/pasted into last command editor (or) last query builder window opened.

Goal of this ticket is to log SQL queries so that users who want to re-execute them again can access them easily using history view with just one click.

Discussion

  • Anu

    Anu - 2012-09-14
    • milestone: 2012.07Beta --> next release
     
  • Anu

    Anu - 2012-09-15

    Propasal
    1. Make a favorite queries window (a table with list of queries, user should be able to order the rows of the table and order should be preserved)
    2. Command editor > Type a query and right click > add to favorite query
    3. Command editor > Show favorite queries window > double click a query of table should
    copy the query into command editor.

     
  • PAscal

    PAscal - 2013-02-13
    • milestone: 2013.02 --> not planned
     
  • PAscal

    PAscal - 2013-06-12
    • status: open --> wont-fix
     
  • Anu

    Anu - 2014-09-11
    • summary: command editor: SQL History --> SQL history view and log sql queries in a file
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1 +1,9 @@
    - 
    +
    +1. Add a preference in General > "Max queries in history"  ( Max is set to 0 by default which means this feature is disabled by default )  
    +
    +2. Save in user directory  ".sqleo_history.csv" file with max queries executed in format csv header - "Timestamp,Connection,Window,Query"  ( Same file will be overwritten when max queries is reached) 
    +
    +3. Menu > "Show SQL History" which is a java swing table will open this file content and show and when user double click's a row, the query will be directly copy/pasted into last command editor (or) last query builder window opened. 
    +
    +Goal of this ticket is to log SQL queries so that users who want to re-execute them again can access them easily using history view with just one click. 
    +
    
    • status: wont-fix --> accepted
    • assigned_to: Anu
    • Milestone: not planned --> 2014.10
     
  • Anu

    Anu - 2014-09-11
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,5 +1,6 @@
    -
    -1. Add a preference in General > "Max queries in history"  ( Max is set to 0 by default which means this feature is disabled by default )  
    +1. Add a preference in General > "Max queries in history"  
    + ( If Max is set to 0 , then it will not log any queries. 
    +   Default value is set to 10 just in case if users don't miss some queries )  
    
     2. Save in user directory  ".sqleo_history.xml" file with max queries executed in format header - "Timestamp,Connection,Window,Query"  ( Same file will be overwritten when max queries is reached) 
    
     
    Last edit: PAscal 2014-09-30
  • Anu

    Anu - 2014-09-21
    • status: accepted --> commited
     
  • PAscal

    PAscal - 2014-09-30
    • status: commited --> tested
     
  • PAscal

    PAscal - 2014-10-02
    • status: tested --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks