Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBICADMIN(1)	      User Contributed Perl Documentation	  DBICADMIN(1)

NAME
       dbicadmin - utility for administrating DBIx::Class schemata

SYNOPSIS
       dbicadmin: [-I] [long options...]

	 deploy	a schema to a database
	 dbicadmin --schema=MyApp::Schema \
	   --connect='["dbi:SQLite:my.db", "", ""]' \
	   --deploy

	 update	an existing record
	 dbicadmin --schema=MyApp::Schema --class=Employee \
	   --connect='["dbi:SQLite:my.db", "", ""]' \
	   --op=update --set='{	"name":	"New_Employee" }'

OPTIONS
   Actions
       --create
	   Create version diffs	needs preversion

       --upgrade
	   Upgrade the database	to the current schema

       --install
	   Install the schema version tables to	an existing database

       --deploy
	   Deploy the schema to	the database

       --select
	   Select data from the	schema

       --insert
	   Insert data into the	schema

       --update
	   Update data in the schema

       --delete
	   Delete data from the	schema

       --op
	   compatibility option	all of the above can be	supplied as
	   --op=<action>

       --help
	   display this	help

   Arguments
       --config-file or	--config
	   Supply the config file for parsing by Config::Any

       --connect-info
	   Supply the connect info as trailing options e.g. --connect-info
	   dsn=<dsn> user=<user> password=<pass>

       --connect
	   Supply the connect info as a	JSON-encoded structure,	e.g. an
	   --connect=["dsn","user","pass"]

       --schema-class
	   The class of	the schema to load

       --config-stanza
	   Where in the	config to find the connection_info, supply in form
	   MyApp::Model::DB

       --resultset or --resultset-class	or --class
	   The resultset to operate on for data	manipulation

       --sql-dir
	   The directory where sql diffs will be created

       --sql-type
	   The RDBMs flavour you wish to use

       --version
	   Supply a version install

       --preversion
	   The previous	version	to diff	against

       --set
	   JSON	data used to perform data operations

       --attrs
	   JSON	string to be used for the second argument for search

       --where
	   JSON	string to be used for the where	clause of search

       --force
	   Be forceful with some operations

       --trace
	   Turn	on DBIx::Class trace output

       --quiet
	   Be less verbose

       -I  Same	as perl's -I, prepended	to current @INC

AUTHORS
       See "AUTHORS" in	DBIx::Class

LICENSE
       You may distribute this code under the same terms as Perl itself

perl v5.32.1			  2020-06-16			  DBICADMIN(1)

NAME | SYNOPSIS | OPTIONS | AUTHORS | LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=dbicadmin&sektion=1&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help