blob: 344b5a864cd2b8529367289efd266f8b3c905d81 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
package local::db::dbi;
use base 'Class::DBI';
local::db::dbi->connection('dbi:SQLite:/srv/nzbget/datenbank.sqlite', '', '');
package local::db::download;
use base 'local::db::dbi';
local::db::download->table('download');
local::db::download->columns(All => qw/download_id owner size time category name description/);
local::db::download->has_a(owner => 'local::db::owner');
local::db::download->has_a(category => 'local::db::category');
package local::db::category;
use base 'local::db::dbi';
local::db::category->table('category');
local::db::category->columns(All => qw/category_id name/);
local::db::category->has_many(download => 'local::db::download');
package local::db::owner;
use base 'local::db::dbi';
local::db::owner->table('owner');
local::db::owner->columns(All => qw/owner_id name quoata quota_used/);
local::db::owner->has_many(download => 'local::db::download');
|
