1DBICADMIN(1)          User Contributed Perl Documentation         DBICADMIN(1)
2
3
4

NAME

6       dbicadmin - utility for administrating DBIx::Class schemata
7

SYNOPSIS

9       dbicadmin: [-I] [long options...]
10
11         deploy a schema to a database
12         dbicadmin --schema=MyApp::Schema \
13           --connect='["dbi:SQLite:my.db", "", ""]' \
14           --deploy
15
16         update an existing record
17         dbicadmin --schema=MyApp::Schema --class=Employee \
18           --connect='["dbi:SQLite:my.db", "", ""]' \
19           --op=update --set='{ "name": "New_Employee" }'
20

OPTIONS

22   Actions
23       --create
24           Create version diffs needs preversion
25
26       --upgrade
27           Upgrade the database to the current schema
28
29       --install
30           Install the schema version tables to an existing database
31
32       --deploy
33           Deploy the schema to the database
34
35       --select
36           Select data from the schema
37
38       --insert
39           Insert data into the schema
40
41       --update
42           Update data in the schema
43
44       --delete
45           Delete data from the schema
46
47       --op
48           compatibility option all of the above can be supplied as
49           --op=<action>
50
51       --help
52           display this help
53
54   Arguments
55       --config-file or --config
56           Supply the config file for parsing by Config::Any
57
58       --connect-info
59           Supply the connect info as trailing options e.g. --connect-info
60           dsn=<dsn> user=<user> password=<pass>
61
62       --connect
63           Supply the connect info as a JSON-encoded structure, e.g. an
64           --connect=["dsn","user","pass"]
65
66       --schema-class
67           The class of the schema to load
68
69       --config-stanza
70           Where in the config to find the connection_info, supply in form
71           MyApp::Model::DB
72
73       --resultset or --resultset-class or --class
74           The resultset to operate on for data manipulation
75
76       --sql-dir
77           The directory where sql diffs will be created
78
79       --sql-type
80           The RDBMs flavour you wish to use
81
82       --version
83           Supply a version install
84
85       --preversion
86           The previous version to diff against
87
88       --set
89           JSON data used to perform data operations
90
91       --attrs
92           JSON string to be used for the second argument for search
93
94       --where
95           JSON string to be used for the where clause of search
96
97       --force
98           Be forceful with some operations
99
100       --trace
101           Turn on DBIx::Class trace output
102
103       --quiet
104           Be less verbose
105
106       -I  Same as perl's -I, prepended to current @INC
107

AUTHORS

109       See "AUTHORS" in DBIx::Class
110

LICENSE

112       You may distribute this code under the same terms as Perl itself
113
114
115
116perl v5.32.1                      2021-01-27                      DBICADMIN(1)
Impressum