summaryrefslogtreecommitdiff
path: root/FS/bin/freeside-dbdef-create
blob: 6c448c74c743557d2a8c1955670e965f2e9a0e64 (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
#!/usr/bin/perl -w

use strict;
use DBI;
use DBIx::DBSchema 0.26;
use FS::UID qw(adminsuidsetup datasrc driver_name);
use FS::Schema;

my $user = shift or die &usage;

$FS::Schema::setup_hack = 1;
$FS::CurrentUser::upgrade_hack = 1;
my($dbh)=adminsuidsetup $user;

#needs to match FS::Record
my($dbdef_file) = "%%%FREESIDE_CONF%%%/dbdef.". datasrc;

my $dbdef = new_native DBIx::DBSchema $dbh;

#print $dbdef->pretty_print;

#important
$dbdef->save($dbdef_file);

sub usage {
  die "Usage:\n  dbdef-create user\n";
}

=head1 NAME

freeside-dbdef-create - Recreate database schema cache

=head1 SYNOPSIS

  freeside-dbdef-create user

=head1 DESCRIPTION

Reverse engineers the database schema and recreates the dbdef cache file.

=head1 SEE ALSO

L<DBIx::DBSchema>

=cut

1;