#130 Auto-complete with table aliases

2013.10
closed
Anu
Evol (193)
2013-10-18
2013-08-07
Anu
No

Auto-complete with table aliases.

Improvement of basic functionality , check description in ticket https://sourceforge.net/p/sqleo/tickets/110/

Discussion

  • PAscal

    PAscal - 2013-08-07

    Hi
    I would like to try to use it for
    - public synonyms
    - other schema than the user connected

    where is the list of tables built ?

    Regards
    PAscal

     
    Last edit: PAscal 2013-08-10
  • Anu

    Anu - 2013-08-07

    All names are loaded by the method MDIClient.loadAllTableNames()
    If connection has schema name, it takes the schema else it loads the first
    schema in all available schema and finally loads all PUBLIC (TABLE",
    "SYNONYM", "VIEW)

    All names are loaded into memory and stored as a Trie datastructure to fast
    load the names by prefix.

    If database has lot of things to load here, you can use garbage collector
    growing and you can cleanup(or) startup SQLeo with a max heap size. (Or)
    there is an option to disable this feature if its very slow.

     
    Last edit: PAscal 2013-08-10
  • PAscal

    PAscal - 2013-08-10

    Hi Anudeep

    Thanks for the answer for building the object list.
    Could you tell me where the column list is built ?

    thanks in advance
    regards
    PAscal

     
  • Anu

    Anu - 2013-08-10

    Hi Pascal,

    Column names are loaded in java class SQLHelper.getColumns()
    Thanks for testing.

    Thanks
    Anudeep

     
    Last edit: PAscal 2013-08-11
  • Anu

    Anu - 2013-10-13
    • status: open --> commited
    • Milestone: next release --> 2013.10
     
  • PAscal

    PAscal - 2013-10-15
    • status: commited --> tested
     
  • PAscal

    PAscal - 2013-10-18
    • 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