Attachment #163391 for bug #35919

View | Details | Raw Unified | Return to bug 35919
Collapse All | Expand All




use utf8;
package Koha::Schema::Result::RecordSource;

# Created by DBIx::Class::Schema::Loader
# DO NOT MODIFY THE FIRST PART OF THIS FILE

=head1 NAME

Koha::Schema::Result::RecordSource

=cut

use strict;
use warnings;

use base 'DBIx::Class::Core';

=head1 TABLE: C<record_sources>

=cut

__PACKAGE__->table("record_sources");

=head1 ACCESSORS

=head2 record_source_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

Primary key for the `record_sources` table

=head2 name

  data_type: 'text'
  is_nullable: 0

User defined name for the record source

=head2 can_be_edited

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

If records from this source can be edited

=cut

__PACKAGE__->add_columns(
  "record_source_id",
  { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
  "name",
  { data_type => "text", is_nullable => 0 },
  "can_be_edited",
  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
);

=head1 PRIMARY KEY

=over 4

=item * L</record_source_id>

=back

=cut

__PACKAGE__->set_primary_key("record_source_id");

=head1 RELATIONS

=head2 biblio_metadatas

Type: has_many

Related object: L<Koha::Schema::Result::BiblioMetadata>

=cut

__PACKAGE__->has_many(
  "biblio_metadatas",
  "Koha::Schema::Result::BiblioMetadata",
  { "foreign.record_source_id" => "self.record_source_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);

=head2 deletedbiblio_metadatas

Type: has_many

Related object: L<Koha::Schema::Result::DeletedbiblioMetadata>

=cut

__PACKAGE__->has_many(
  "deletedbiblio_metadatas",
  "Koha::Schema::Result::DeletedbiblioMetadata",
  { "foreign.record_source_id" => "self.record_source_id" },
  { cascade_copy => 0, cascade_delete => 0 },
);


# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-01-24 18:05:50
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WX72aRYhWBK9bQWr9AJk2A

__PACKAGE__->add_columns(
    '+can_be_edited' => { is_boolean => 1 },
);

1;




use Modern::Perl;

return {
    bug_number  => "35919",
    description => "Add record_sources table",
    up          => sub {
        my ($args) = @_;
        my ( $dbh, $out ) = @$args{qw(dbh out)};

        unless ( TableExists('record_sources') ) {
            $dbh->do(
                q{
                CREATE TABLE `record_sources` (
                    `record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table',
                    `name` text NOT NULL COMMENT 'User defined name for the record source',
                    `can_be_edited` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If records from this source can be edited',
                    PRIMARY KEY (`record_source_id`)
                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
            }
            );

            say $out "Added new table 'record_sources'";
        }

        unless ( column_exists( 'biblio_metadata', 'record_source_id' ) ) {
            $dbh->do(
                q{
                    ALTER TABLE biblio_metadata
                        ADD COLUMN `record_source_id` int(11) NULL DEFAULT NULL
                        COMMENT 'The record source for the metadata'
                        AFTER timestamp
            }
            );

            say $out "Added new column 'biblio_metadata.record_source_id'";
        }

        unless ( foreign_key_exists( 'biblio_metadata', 'record_metadata_fk_2' ) ) {
            $dbh->do(
                q{
                ALTER TABLE biblio_metadata
                ADD CONSTRAINT `record_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
            }
            );

            say $out "Added new foreign key 'biblio_metadata.record_metadata_fk_2'";
        }

        unless ( column_exists( 'deletedbiblio_metadata', 'record_source_id' ) ) {
            $dbh->do(
                q{
                    ALTER TABLE deletedbiblio_metadata
                        ADD COLUMN `record_source_id` int(11) NULL DEFAULT NULL
                        COMMENT 'The record source for the metadata'
                        AFTER timestamp
            }
            );

            say $out "Added new column 'deletedbiblio_metadata.record_source_id'";
        }

        unless ( foreign_key_exists( 'deletedbiblio_metadata', 'deletedrecord_metadata_fk_2' ) ) {
            $dbh->do(
                q{
                ALTER TABLE deletedbiblio_metadata
                ADD CONSTRAINT `deletedrecord_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
            }
            );

            say $out "Added new foreign key 'deletedbiblio_metadata.record_metadata_fk_2'";
        }

        $dbh->do(
            q{
            INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
            ( 3, 'manage_record_sources', 'Manage record sources')
        }
        );

        say $out "Added new permission 'manage_record_sources'";

    },
};




) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `record_sources`
--

DROP TABLE IF EXISTS `record_sources`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `record_sources` (
  `record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table',
  `name` text NOT NULL COMMENT 'User defined name for the record source',
  `can_be_edited` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If records from this source can be edited',
  PRIMARY KEY (`record_source_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `biblio_metadata`
--

  `schema` varchar(16) NOT NULL,
  `metadata` longtext NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `record_source_id` int(11) NULL DEFAULT NULL COMMENT 'The record source for the metadata',
  PRIMARY KEY (`id`),
  UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),
  KEY `timestamp` (`timestamp`),
  CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `record_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;


  `schema` varchar(16) NOT NULL,
  `metadata` longtext NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `record_source_id` int(11) NULL DEFAULT NULL COMMENT 'The record source for the metadata',
  PRIMARY KEY (`id`),
  UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),
  KEY `timestamp` (`timestamp`),
  CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `deletedrecord_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;


Lines 43-48 INSERT INTO permissions (module_bit, code, description) VALUES Link Here

(-)a/installer/data/mysql/mandatory/userpermissions.sql (-1 / +1 lines)
43	( 3, 'manage_curbside_pickups', 'Manage curbside pickups'),	43	( 3, 'manage_curbside_pickups', 'Manage curbside pickups'),
44	( 3, 'manage_search_filters', 'Manage custom search filters'),	44	( 3, 'manage_search_filters', 'Manage custom search filters'),
45	( 3, 'manage_identity_providers', 'Manage identity providers'),	45	( 3, 'manage_identity_providers', 'Manage identity providers'),
		46	( 3, 'manage_record_sources', 'Manage record sources'),
46	( 4, 'delete_borrowers', 'Delete patrons'),	47	( 4, 'delete_borrowers', 'Delete patrons'),
47	( 4, 'edit_borrowers', 'Add, modify and view patron information'),	48	( 4, 'edit_borrowers', 'Add, modify and view patron information'),
48	( 4, 'list_borrowers', 'Search, list and view patrons'),	49	( 4, 'list_borrowers', 'Search, list and view patrons'),
49	-

Return to bug 35919

Lines 1122-1127 CREATE TABLE `biblio_framework` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-2 / +21 lines)
1122	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	1122	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1123	/!40101 SET character_set_client = @saved_cs_client /;	1123	/!40101 SET character_set_client = @saved_cs_client /;
1124		1124
		1125	--
		1126	-- Table structure for table `record_sources`
		1127	--
		1128
		1129	DROP TABLE IF EXISTS `record_sources`;
		1130	/!40101 SET @saved_cs_client = @@character_set_client /;
		1131	/!40101 SET character_set_client = utf8 /;
		1132	CREATE TABLE `record_sources` (
		1133	`record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table',
		1134	`name` text NOT NULL COMMENT 'User defined name for the record source',
		1135	`can_be_edited` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If records from this source can be edited',
		1136	PRIMARY KEY (`record_source_id`)
		1137	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		1138	/!40101 SET character_set_client = @saved_cs_client /;
		1139
1125	--	1140	--
1126	-- Table structure for table `biblio_metadata`	1141	-- Table structure for table `biblio_metadata`
1127	--	1142	--
Lines 1136-1145 CREATE TABLE `biblio_metadata` ( Link Here
1136	`schema` varchar(16) NOT NULL,	1151	`schema` varchar(16) NOT NULL,
1137	`metadata` longtext NOT NULL,	1152	`metadata` longtext NOT NULL,
1138	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),	1153	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
		1154	`record_source_id` int(11) NULL DEFAULT NULL COMMENT 'The record source for the metadata',
1139	PRIMARY KEY (`id`),	1155	PRIMARY KEY (`id`),
1140	UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),	1156	UNIQUE KEY `biblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),
1141	KEY `timestamp` (`timestamp`),	1157	KEY `timestamp` (`timestamp`),
1142	CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE	1158	CONSTRAINT `record_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		1159	CONSTRAINT `record_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
1143	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	1160	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
1144	/!40101 SET character_set_client = @saved_cs_client /;	1161	/!40101 SET character_set_client = @saved_cs_client /;
1145		1162
Lines 2571-2580 CREATE TABLE `deletedbiblio_metadata` ( Link Here
2571	`schema` varchar(16) NOT NULL,	2588	`schema` varchar(16) NOT NULL,
2572	`metadata` longtext NOT NULL,	2589	`metadata` longtext NOT NULL,
2573	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),	2590	`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
		2591	`record_source_id` int(11) NULL DEFAULT NULL COMMENT 'The record source for the metadata',
2574	PRIMARY KEY (`id`),	2592	PRIMARY KEY (`id`),
2575	UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),	2593	UNIQUE KEY `deletedbiblio_metadata_uniq_key` (`biblionumber`,`format`,`schema`),
2576	KEY `timestamp` (`timestamp`),	2594	KEY `timestamp` (`timestamp`),
2577	CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE	2595	CONSTRAINT `deletedrecord_metadata_fk_1` FOREIGN KEY (`biblionumber`) REFERENCES `deletedbiblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE,
		2596	CONSTRAINT `deletedrecord_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
2578	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;	2597	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2579	/!40101 SET character_set_client = @saved_cs_client /;	2598	/!40101 SET character_set_client = @saved_cs_client /;
2580		2599

Line 0 Link Here

(-)a/Koha/Schema/Result/RecordSource.pm (+112 lines)
		1	use utf8;
		2	package Koha::Schema::Result::RecordSource;
		3
		4	# Created by DBIx::Class::Schema::Loader
		5	# DO NOT MODIFY THE FIRST PART OF THIS FILE
		6
		7	=head1 NAME
		8
		9	Koha::Schema::Result::RecordSource
		10
		11	=cut
		12
		13	use strict;
		14	use warnings;
		15
		16	use base 'DBIx::Class::Core';
		17
		18	=head1 TABLE: C<record_sources>
		19
		20	=cut
		21
		22	__PACKAGE__->table("record_sources");
		23
		24	=head1 ACCESSORS
		25
		26	=head2 record_source_id
		27
		28	data_type: 'integer'
		29	is_auto_increment: 1
		30	is_nullable: 0
		31
		32	Primary key for the `record_sources` table
		33
		34	=head2 name
		35
		36	data_type: 'text'
		37	is_nullable: 0
		38
		39	User defined name for the record source
		40
		41	=head2 can_be_edited
		42
		43	data_type: 'tinyint'
		44	default_value: 0
		45	is_nullable: 0
		46
		47	If records from this source can be edited
		48
		49	=cut
		50
		51	__PACKAGE__->add_columns(
		52	"record_source_id",
		53	{ data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
		54	"name",
		55	{ data_type => "text", is_nullable => 0 },
		56	"can_be_edited",
		57	{ data_type => "tinyint", default_value => 0, is_nullable => 0 },
		58	);
		59
		60	=head1 PRIMARY KEY
		61
		62	=over 4
		63
		64	=item * L</record_source_id>
65
66	=back
67
68	=cut
69
70	__PACKAGE__->set_primary_key("record_source_id");
71
72	=head1 RELATIONS
73
74	=head2 biblio_metadatas
75
76	Type: has_many
77
78	Related object: L<Koha::Schema::Result::BiblioMetadata>
79
80	=cut
81
82	__PACKAGE__->has_many(
83	"biblio_metadatas",
84	"Koha::Schema::Result::BiblioMetadata",
85	{ "foreign.record_source_id" => "self.record_source_id" },
86	{ cascade_copy => 0, cascade_delete => 0 },
87	);
88
89	=head2 deletedbiblio_metadatas
90
91	Type: has_many
92
93	Related object: L<Koha::Schema::Result::DeletedbiblioMetadata>
94
95	=cut
96
97	__PACKAGE__->has_many(
98	"deletedbiblio_metadatas",
99	"Koha::Schema::Result::DeletedbiblioMetadata",
100	{ "foreign.record_source_id" => "self.record_source_id" },
101	{ cascade_copy => 0, cascade_delete => 0 },
102	);
103
104
105	# Created by DBIx::Class::Schema::Loader v0.07049 @ 2024-01-24 18:05:50
106	# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WX72aRYhWBK9bQWr9AJk2A
107
108	__PACKAGE__->add_columns(
109	'+can_be_edited' => { is_boolean => 1 },
110	);
111
112	1;

Line 0 Link Here

(-)a/installer/data/mysql/atomicupdate/bug_35919.pl (+83 lines)
		1	use Modern::Perl;
		2
		3	return {
		4	bug_number => "35919",
		5	description => "Add record_sources table",
		6	up => sub {
		7	my ($args) = @_;
		8	my ( $dbh, $out ) = @$args{qw(dbh out)};
		9
		10	unless ( TableExists('record_sources') ) {
		11	$dbh->do(
		12	q{
		13	CREATE TABLE `record_sources` (
		14	`record_source_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary key for the `record_sources` table',
		15	`name` text NOT NULL COMMENT 'User defined name for the record source',
		16	`can_be_edited` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'If records from this source can be edited',
		17	PRIMARY KEY (`record_source_id`)
		18	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
		19	}
		20	);
		21
		22	say $out "Added new table 'record_sources'";
		23	}
		24
		25	unless ( column_exists( 'biblio_metadata', 'record_source_id' ) ) {
		26	$dbh->do(
		27	q{
		28	ALTER TABLE biblio_metadata
		29	ADD COLUMN `record_source_id` int(11) NULL DEFAULT NULL
		30	COMMENT 'The record source for the metadata'
		31	AFTER timestamp
		32	}
		33	);
		34
		35	say $out "Added new column 'biblio_metadata.record_source_id'";
		36	}
		37
		38	unless ( foreign_key_exists( 'biblio_metadata', 'record_metadata_fk_2' ) ) {
		39	$dbh->do(
		40	q{
		41	ALTER TABLE biblio_metadata
		42	ADD CONSTRAINT `record_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
		43	}
		44	);
		45
		46	say $out "Added new foreign key 'biblio_metadata.record_metadata_fk_2'";
		47	}
		48
		49	unless ( column_exists( 'deletedbiblio_metadata', 'record_source_id' ) ) {
		50	$dbh->do(
		51	q{
		52	ALTER TABLE deletedbiblio_metadata
		53	ADD COLUMN `record_source_id` int(11) NULL DEFAULT NULL
		54	COMMENT 'The record source for the metadata'
		55	AFTER timestamp
		56	}
		57	);
		58
		59	say $out "Added new column 'deletedbiblio_metadata.record_source_id'";
		60	}
		61
		62	unless ( foreign_key_exists( 'deletedbiblio_metadata', 'deletedrecord_metadata_fk_2' ) ) {
		63	$dbh->do(
		64	q{
65	ALTER TABLE deletedbiblio_metadata
66	ADD CONSTRAINT `deletedrecord_metadata_fk_2` FOREIGN KEY (`record_source_id`) REFERENCES `record_sources` (`record_source_id`) ON DELETE CASCADE ON UPDATE CASCADE
67	}
68	);
69
70	say $out "Added new foreign key 'deletedbiblio_metadata.record_metadata_fk_2'";
71	}
72
73	$dbh->do(
74	q{
75	INSERT IGNORE INTO permissions (module_bit, code, description) VALUES
76	( 3, 'manage_record_sources', 'Manage record sources')
77	}
78	);
79
80	say $out "Added new permission 'manage_record_sources'";
81
82	},
83	};