Andreas,
Thanks for the syntax correction. That worked for the creation but the results are still not what I’m getting with the 6.1 gui:
************************************
C:\Program Files (x86)\BaseX>java -cp BaseX61.jar org.basex.BaseXClient -Uadmin
-Padmin
BaseX 6.1 [Client]
Try "help" to get some information.
> drop db songs
Database 'songs' was not found.
> create db C:\Users\David\Documents\OpenSong\songpacks\Songs songs
Database 'songs' created in 1922.45 ms.
> info index
Tags
- Hash Index
- Entries: 0
Attributes
- Hash Index
- Entries: 0
Text Index
- Tree Index
- Size on Disk: 4 Bytes
- Entries: 0
Attribute Index
- Tree Index
- Size on Disk: 4 Bytes
- Entries: 0
Full-Text Index
Path Summary
doc() 1x
>
Then I tried the “ADD” syntax and got this:
> add C:\Users\David\Documents\OpenSong\songpacks\Songs
Document 'Songs' added in 1024.26 ms.
> info index
Tags
- Hash Index
- Entries: 0
Attributes
- Hash Index
- Entries: 0
Text Index
Attribute Index
Full-Text Index
Path Summary
doc() 1x
> help add
ADD [path]
Add document.
Adds a document to the current database.
> add C:\Users\David\Documents\OpenSong\songpacks\Songs\*.*
File or directory "C:/Users/David/Documents/OpenSong/songpacks/Songs/*.*" not fo
und.
>
Here’s some screen prints for my results with the 6.1 gui (sorry if that doesn’t work for the mailing list).
At the moment, I still have other coding to do on my project that I can accomplish using a database created with the gui, but at some point, I need to be able to duplicate my database creation and recreation with the command line. Any help to move that forward will be much appreciated! ;c)
Thanks!
David
From: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de]
Sent: Wednesday, December 29, 2010 11:26 AM
To: david@leighweb.com; BaseX-Talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Database creation from a directory tree
Hi David,
the syntax of the create command changed between the releases of 6.1 and 6.3.4.
In release 6.1 you have to use:
create db C:\Users\David\Documents\OpenSong\songpacks\Songs songs
Kind regards,
Andreas
Am 28.12.10 18:00, schrieb David leigh:
Here are my command line results from 6.3.4:
C:\Users\David\Documents\OpenSong\OpenSongSearch\BaseX>java -cp BaseX.jar org.basex.BaseXClient -Uadmin -Padmin
BaseX 6.3.5 [Client]
Try "help" to get more information.
> drop db songs
Database 'songs' was dropped.
> create db song
Database 'song' created in 1683.61 ms.
> info index
Tags
- Structure: Hash
- Entries: 0
Attributes
- Structure: Hash
- Entries: 0
Text Index
- Structure: Binary tree
- Size: 4 Bytes
- Entries: 0
Attribute Index
- Structure: Binary tree
- Size: 4 Bytes
- Entries: 0
Full-Text Index
- Not available
Path Summary
doc() 1x
> info table
Stopped at line 1, column 10:
Syntax: INFO ([DATABASE|INDEX|STORAGE])
Show information on current database.
Shows information on the currently opened database:
- no argument: show global information
- DATABASE: shows database information
- INDEX: shows index information
- STORAGE [start end] | [query]: show internal database table
> info storage
PRE DIS SIZ ATS NS KIND CONTENT
-------------------------------------
0 1 1 1 0 DOC song
> info
General Information
Database Path: C:\Users\David\Documents\OpenSong\OpenSongSearch\BaseX\data
Used Main Memory: 895 KB
Database Creation
Whitespace Chopping: ON
Entity Parsing: OFF
Indexes
Path Summary: ON
Text Index: ON
Attribute Index: ON
Full-Text Index: OFF
>
So, for 6.3.4, it creates from the command line, but it’s empty. The root of that path has NO files in it. The 5861 files are in all the subdirectories.
Then, when I try the same syntax with 6.1, I get the following results:
> create db songs C:\Users\David\Documents\OpenSong\songpacks\Songs
Stopped at line 1, column 17:
Syntax: CREATE [DB|COLL|FS|INDEX|USER] [...]
Create database, index or user.
Creates a new database, index or user:
- DB [path] [name?]:
creates the database [name] for the file or directory [path]
- COLL [name]:
creates an empty database [name]
- INDEX [TEXT|ATTRIBUTE|FULLTEXT|PATH]:
creates the specified index
- FS [path] [name] ([mountpoint] [backingstore]):
creates filesystem database [name] for [path]
(using [mountpoint] and [backingstore] if FUSE is activated)
- USER [name] [password?]:
creates the specified user
Summary:
6.1 GUI – works as I want it
6.1 command line – can’t get it to create
6.3.4 GUI – creates but with only 14 entries
6.3.4 command line – creates, but it’s empty
I don’t mind staying with 6.1, but I DO want to do everything with the command line.
Is the ADD syntax the same, in that I can simply specify the path and it will recurse the whole directory tree?
Thanks!!!
David
From: Andreas Weiler [mailto:andreas.weiler@uni-konstanz.de]
Sent: Tuesday, December 28, 2010 01:29 PM
To: david@leighweb.com
Cc: basex-talk@mailman.uni-konstanz.de
Subject: Re: [basex-talk] Database creation from a directory tree
Additional question: That was in the GUI. I’d like to do the same thing using the command line with the .JAR file, but somewhere my syntax is not right. Additionally, all the XML files have NO EXTENSION so I don’t know how to specify that either in the command line. So, any help in that area would also be appreciated.
Could you provide your syntax?
The syntax should be:
create db dbname path/to/folder
The missing extension shouldnt be a problem, i just tested it.
In the GUI in 6.1, I can create a database from a whole directory hierarchy of 5,681 individual XML files. When I point to the same source file directory and using the 6.3.4 GUI (which I installed with a pre-release version of the installer), it only processes 14 files. No error message (that I saw) was produced. The behavior that I’m wanting is what 6.1 does. Glad to help in solving the problem.
We will check for modifications between the releases. As quick workaround you could try to create an empty database and then add the documents with the Database/Add documents menu.
Kind regards,
Andreas
Am 28.12.10 12:55, schrieb David leigh:
I’ve just installed 6.3.4 and I’ve noticed a difference from version 6.1.
In the GUI in 6.1, I can create a database from a whole directory hierarchy of 5,681 individual XML files. When I point to the same source file directory and using the 6.3.4 GUI (which I installed with a pre-release version of the installer), it only processes 14 files. No error message (that I saw) was produced. The behavior that I’m wanting is what 6.1 does. Glad to help in solving the problem.
Additional question: That was in the GUI. I’d like to do the same thing using the command line with the .JAR file, but somewhere my syntax is not right. Additionally, all the XML files have NO EXTENSION so I don’t know how to specify that either in the command line. So, any help in that area would also be appreciated.
Thank you,
David
_______________________________________________
BaseX-Talk mailing list
BaseX-Talk@mailman.uni-konstanz.de
https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk