Prompt with D*** db names

[pydemo]

trafficstars

Prompt for db DY_DeskPLRSRange03.db becomes this

C:\temp\liteFri Jul 26 17:21:37 2019Y_DeskPLRSRange03.db>

probably \D is treated as sysdate?

[amjith]

You're right. That's an interesting issue. I wonder if there is an easy way to detect whether the \D is part of the prompt or path. :thinking:

[thorstenkampe]

Same issue here:

> litecli  --prompt "[\d]> " --database F:\cygwin\home\thorsten\.jupyter\nbsignatures.db
Version: 1.4.1
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
[F:\cygwin\home\thorsten\.jupyter
bsignatures.db]>

An easy fix would be to replace all backslashes with slashes:

> litecli  --prompt "[\d]> "  --database F:/cygwin/home/thorsten/.jupyter/nbsignatures.db
Version: 1.4.1
Mail: https://groups.google.com/forum/#!forum/litecli-users
GitHub: https://github.com/dbcli/litecli
[F:/cygwin/home/thorsten/.jupyter/nbsignatures.db]>