blob: 9296f3984f3214ce34a1dfb3a1f628c4dd2779bb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
### Valet Tools for development, test, and production support
|File| Description |
|---|---|
|crim.py|Commandline Rest Interface for Music<br>*read, add, delete from the music database*|
|lock.py|Manual (Un)Locking Of Valet Regions<br>*from the regions (locking) table*|
|ppdb.py|pretty print database<br>*try to make the database data readable*|
|lib/common|collection of functions<br>- **set_argument** - *Get arg from file, cmdline, a pipe or prompt user*<br>- **list2string** - *join list and return as a string*<br>- **chop** - *like perl*|
|lib/hosts.json|*contains all the currently known (by me) hosts for music and valet*|
|lib/logger.py|*like the official logger but allows logger to point to file and or console*|
|lib/tables.py|*Tables object, that handles each valet table as small subclass (could replace db_handler.py)*|
|lib/song.py|*Song is music for scripts, a subclass of music.py, with script helpers*|
#### Examples
`$ crim.py -?`
Show help message and exit (a lot more options than I am showing here...)
`$ crim.py -names -read requests -read results`
Show the contents of the requests and results tables in the default keyspace
`$ crim.py -n -r q -r u`
Same as above, but with using [watch](https://linux.die.net/man/1/watch "watch(1) - Linux man page") to execute the script repeatadly displaying the output
Also this is an example of using shortcuts for arguments
`$ watch crim.py -n -r q -r u`
Show the contents of the regions tables (locking) in the all the known keyspaces
`$ crim.py -K all -r regions`
Delete the cw keyspace - this is used for testing to "clean" the database
`$ crim.py -sD cw`
Show the database stuff for the pn2 keyspace
`$ crim.py -show -K pn`
Show the config stuff for the pn2 keyspace
`$ crim.py -ShowConfig -K pn`
Show the database tables and definitions (hardcoded, not a query from the database)
`$ crim.py -viewSchema`
Show the requests record with id create-0000-0003
`$ crim.py -i create-0000-0003 -r q`
Show the resources record in the pk2 keyspace with id "reg6:alan_stack_N003"
`$ crim.py -r s -K pk2 -i "reg6:alan_stack_N003"`
##### Testing Example
Here we are going to copy a record from one environment to another
Get a record from the request table, into a file; *Note:* Not the default config file...
`$ crim.py -config ../test/solver.json -r q -K ist -id "create-abc-10099" > z`
Put that record from the file into the request table of another keyspace
`$ crim.py -c ../test/solver.json -t q -K pk2 -a i -f z`
|
