- lol
- go to SQLite Download Page and get a Precompiled Binaries for Windows, maybe sqlite-tools-win-x64-3460000.zip then install it
- download Download Python | Python.org and install
- download the https://github.com/pfalcon/ppxml2db/archive/refs/heads/master.zip repo code into the same folder
- save a PP xml file into the folder eg
kommer.xml - in a command shell save and run the following batch file to test the PP round trip:
- eg
test kommer
- eg
test.bat
@echo off
if %1!==! goto usage
if exist %1.db del %1.db
if exist tmp.txt del tmp.txt
rem for /f "tokens=*" %%f in (tables.txt) do echo .read %%f.sql >>tmp.txt
for %%f in (*.sql) do echo .read %%f >>tmp.txt
sqlite3 -init tmp.txt %1.db .quit
rem del tmp.txt
@echo on
@ver
@python --version
@python ppxml2db.py --version
python ppxml2db.py %1.xml %1.db
python db2ppxml.py %1.db %12.xml
goto end
:usage
@echo off
echo.
echo Usage: %0 filename(without extension)
echo.
:end
[If you add *.sql files to the folder from the repo then create tables.txt with a list of the repo sql files (without the extension) and enable line with in (tables.txt) instead of in (*.sql).]
- might as well download a suitable Releases · sqlitebrowser/sqlitebrowser · GitHub
- From commit comment (testing xml regeneration with unsupported features) note:
Microsoft Windows [Version 10.0.22631.3880]
Python 3.12.4
ppxml2db.py 0.7.1
btw:
SQLite version 3.36.0 2021-06-18 18:36:39
DB Browser for SQLite Version 3.13.0