from __future__ import unicode_literals
from prompt_toolkit import prompt
from prompt_toolkit.history import FileHistory
from prompt_toolkit.auto_suggest import AutoSuggestFromHistory
# from prompt_toolkit.contrib.completers import WordCompleter
# test
# SQLCompleter = WordCompleter(['select', 'from', 'insert', 'update', 'delete'], ignore_case=True)

while True:
    user_input = prompt('SQL>',history = FileHistory('history.txt'),auto_suggest=AutoSuggestFromHistory(),
# completer=SQLCompleter,
)

    print(user_input)
