TPAKTOPA
Member
First THANKS for such a great program ! I found more and more new functionality in it almost each day !
Question: How can I automate formating ( or to be more specific, "multi replace")
Like
{ " select * \r\n from basics \r\n where a=b" }
to be
select *
from basics
where a=b
I do this more than hundred times, while debuging ... What should I do best ? a plug-in DLL for patterns , or what ?
simon
PN Developer
Thanks for the compliments! A tool would probably be the best bet for formatting Sql, something that takes a file or stdin input and outputs the formatted SQL. It looks like the SQLinForm tool (postcardware) might do what you want:
http://www.sqlinform.com/license.phtml
It's available as a desktop java-based program so shouldn't be too hard to use as a tool.
simon
PN Developer
There are also various pay-for tools to pretty print SQL that you could use, just google for "pretty print SQL", "indent SQL" or "astyle SQL" because astyle is a tool that does this for other languages so you often see comparisons.
TPAKTOPA
Member
That's not SQL that I want to modify. It's just fine. String I got (input string) is from C++ Builder, debug information. I take it from debug information, and put in SQL Test Tool. But it must be "converted" To be exact, I want to make multiple replaces.
ALL symbols "\r\n" from debug information means a new line symbol "(CR)"
ALL symbols "\t" from debug information means tab symbol "tab"
Remove starting and trailing "{ "" and "" }"
and so on.
Now i made few replacements for this. And because of this I start multiple replaces in doc.
And line
{ " select * \r\n from basics \r\n \t where a=b " }
must become
select *
from basics
where a=b
Not a big job ... if it isn't too often - may be hundred times in day. So is there a way to make a macro, or to save a series of command in PN2 ?
simon
PN Developer
Download the latest pn-devel release and the pypn addon, then save this in a .py file in your scripts directory:
import pn
import scintilla
from pypn.decorators import script
@script("Clean SQL")
def CleanSqlString():
editor = scintilla.Scintilla(pn.CurrentDoc())
editor.BeginUndoAction()
options = pn.GetUserSearchOptions()
options.FindText = "\\r\\n"
options.ReplaceText = "\r\n"
options.UseSlashes = False
options.UseRegExp = False
pn.CurrentDoc().ReplaceAll(options)
options.FindText = "\\t"
options.ReplaceText = "\t"
pn.CurrentDoc().ReplaceAll(options)
options.FindText = "[ \t]*{[ \t]*\"[ \t]*"
options.ReplaceText = ""
options.UseRegExp = True
pn.CurrentDoc().ReplaceAll(options)
options.FindText = "[ \t]*\"[ \t]*}"
options.ReplaceText = ""
pn.CurrentDoc().ReplaceAll(options)
editor.EndUndoAction()
simon
PN Developer
If the script doesn't work, you may need to replace all the CurrentDoc() with CurrentDoc. I'm not running the latest build at work.
TPAKTOPA
Member
Sory for such a dump question ... how can I run a script , or to put it on shortkay? Is there any manual for it ?
And how can I define a special character with Python ?
e.g. In Delphi I put #10#13 for Enter symbol ( actually 2 symbols :) )
What I have to do in Python ?
simon
PN Developer
Hi, this is fairly new functionality so no manuals yet! If you save that script into a ".py" file in the Programmer's Notepad\scripts directory then a script called "Clean SQL" will appear in the Scripts docking window (View->Windows->Scripts). You can double click to run it on your current file. You can also set a keyboard shortcut using Tools->Options->Keyboard, scroll down and you'll find the script listed.
Note that the script I wrote does assume that the document you're using it on only contains that text to change. If you want to use it on a selection instead you'll want to change the script.
TPAKTOPA
Member
I can't get any lines in "Scripts" docking window. What I did - extracted pypn-0.3-py2.4.zip to directory of PN2. After that I got a message - no Python. I installed Python 2.5 - same message. Then I uninstall Python 2.5 and Installed Python 2.4 - nag screen disappear. But I still have no scripts in the window. Even test.py.
I even Uninstall PN2 and Python, and install them again - now in their default pathes - same. Also I noticed, that PN2 remembers it's settings .... after little research I found locations, delete all settings [EchoSoftawre ... couldn't guess ;)], reinstalled all things ... same.
What do I wrong ?
simon
PN Developer
Hmm, 0.3 is an old version of pypn - do I still have a link to that somewhere? In any case, you need 0.5:
http://downloads.sourceforge.net/pnotepad/pypn-0.5.667.zip
Sorry for all the confusion, you can tell this is quite a new feature!
TPAKTOPA
Member
On this page http://pnotepad.org/add-ons/
first link "Download PyPN Here" is leading to 0.3
You don't have to excuse - You bring such a good tool and you give it for free to the people. It's a beta version, so it's normal something to get wrong.
I put last pypn , did all reinstalls again, but still not working ... any other ideas ?
simon
PN Developer
Ah, another idea. Please run "pn --findexts" and then let me know. This tells PN to look for extensions that aren't installed yet.
simon
PN Developer
I've also updated the links on the add-ons page to point to the most recent versions and to include that install instruction.
simon
PN Developer
Excellent, I'm glad it's working! I've just used very similar code to help me reformat a bunch of files - best feature I ever added!
mk
Member
Hi,
about three month ago I had to switch to python version 2.5. I tried all the things in the above thread, however, I wasn't able to get my python scripts for pn running again. Probably, the python version isn't compatible with pypn 0.5 ? I'm really interested in using the python extension and would be very glad to get some help.
TPAKTOPA
Member
pypn by default works with Python 2.4. So you have few choises to run it.
1. Install Python 2.4 instead of 2.5 ( if u use it only for PyPN )
2. Change some options of PyPN. Build Boost.Python with option :
bjam -sPYTHON_VERSION=2.5 -sTOOLS=VC-8_0
Look in this tread for more information
http://pnotepad.org/forums/topic/108?replies=10
Also , you can try to put just python24.dll in the directory of Programer's Notepad
simon
PN Developer
Spot on TPAKTOPA! I'll try and fit in some time to do a Python 2.5 build of PyPN for the next release.
mk
Member
Thanks, traktora, for your fast response.
Copying the python dll doesn't work. Furthermore, I'm not sure if I'm able to build pn with my c++ builder. So I tried to install python version 2.4 in parallel and this seems to work at the moment. However, a version with pypn built for python 2.5 would be my preferred solution.
So I'm dying to see the next release. Is there any schedule ?
You must log in to post.