Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F74199678
webbasket_model.py
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Fri, Jul 26, 10:50
Size
7 KB
Mime Type
text/x-python
Expires
Sun, Jul 28, 10:50 (2 d)
Engine
blob
Format
Raw Data
Handle
19357770
Attached To
R3600 invenio-infoscience
webbasket_model.py
View Options
# -*- coding: utf-8 -*-
#
## Author: Jiri Kuncar <jiri.kuncar@gmail.com>
##
## This file is part of Invenio.
## Copyright (C) 2011, 2012 CERN.
##
## Invenio is free software; you can redistribute it and/or
## modify it under the terms of the GNU General Public License as
## published by the Free Software Foundation; either version 2 of the
## License, or (at your option) any later version.
##
## Invenio is distributed in the hope that it will be useful, but
## WITHOUT ANY WARRANTY; without even the implied warranty of
## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
## General Public License for more details.
##
## You should have received a copy of the GNU General Public License
## along with Invenio; if not, write to the Free Software Foundation, Inc.,
## 59 Temple Place, Suite 330, Boston, MA 02D111-1307, USA.
"""
webbasket database models.
"""
# General imports.
from
invenio.sqlalchemyutils
import
db
# Create your models here.
from
websession_model
import
User
,
Usergroup
from
websearch_model
import
Collection
class
BskBASKET
(
db
.
Model
):
"""Represents a BskBASKET record."""
def
__init__
(
self
):
pass
__tablename__
=
'bskBASKET'
id
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
nullable
=
False
,
primary_key
=
True
)
id_owner
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
User
.
id
),
nullable
=
False
,
server_default
=
'0'
)
name
=
db
.
Column
(
db
.
String
(
50
),
nullable
=
False
,
server_default
=
''
)
date_modification
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
nb_views
=
db
.
Column
(
db
.
Integer
(
15
),
nullable
=
False
,
server_default
=
'0'
)
owner
=
db
.
relationship
(
User
,
backref
=
'baskets'
)
class
BskEXTREC
(
db
.
Model
):
"""Represents a BskEXTREC record."""
def
__init__
(
self
):
pass
__tablename__
=
'bskEXTREC'
id
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
nullable
=
False
,
primary_key
=
True
)
external_id
=
db
.
Column
(
db
.
Integer
(
15
),
nullable
=
False
,
server_default
=
'0'
)
collection_id
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
Collection
.
id
),
nullable
=
False
,
server_default
=
'0'
)
original_url
=
db
.
Column
(
db
.
Text
,
nullable
=
True
)
creation_date
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
modification_date
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
collection
=
db
.
relationship
(
Collection
,
backref
=
'EXTRECs'
)
class
BskEXTFMT
(
db
.
Model
):
"""Represents a BskEXTFMT record."""
def
__init__
(
self
):
pass
__tablename__
=
'bskEXTFMT'
id
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
nullable
=
False
,
primary_key
=
True
)
id_bskEXTREC
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
BskEXTREC
.
id
),
nullable
=
False
,
server_default
=
'0'
)
format
=
db
.
Column
(
db
.
String
(
10
),
nullable
=
False
,
server_default
=
''
)
last_updated
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
value
=
db
.
Column
(
db
.
iLargeBinary
,
nullable
=
True
)
EXTREC
=
db
.
relationship
(
BskEXTREC
,
backref
=
'EXTFMTs'
)
class
BskREC
(
db
.
Model
):
"""Represents a BskREC record."""
def
__init__
(
self
):
pass
__tablename__
=
'bskREC'
id_bibrec_or_bskEXTREC
=
db
.
Column
(
db
.
Integer
(
16
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
id_bskBASKET
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
BskBASKET
.
id
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
id_user_who_added_item
=
db
.
Column
(
db
.
Integer
(
15
),
db
.
ForeignKey
(
User
.
id
),
nullable
=
False
,
server_default
=
'0'
)
score
=
db
.
Column
(
db
.
Integer
(
15
),
nullable
=
False
,
server_default
=
'0'
)
date_added
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
basket
=
db
.
relationship
(
BskBASKET
,
backref
=
'RECs'
)
user_who_added_item
=
db
.
relationship
(
User
)
class
BskRECORDCOMMENT
(
db
.
Model
):
"""Represents a BskRECORDCOMMENT record."""
def
__init__
(
self
):
pass
__tablename__
=
'bskRECORDCOMMENT'
id
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
nullable
=
False
,
primary_key
=
True
,
autoincrement
=
True
)
id_bibrec_or_bskEXTREC
=
db
.
Column
(
db
.
Integer
(
16
),
nullable
=
False
,
server_default
=
'0'
)
id_bskBASKET
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
BskBASKET
.
id
),
nullable
=
False
,
server_default
=
'0'
)
id_user
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
User
.
id
),
nullable
=
False
,
server_default
=
'0'
)
title
=
db
.
Column
(
db
.
String
(
255
),
nullable
=
False
,
server_default
=
''
)
body
=
db
.
Column
(
db
.
Text
,
nullable
=
False
)
date_creation
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
priority
=
db
.
Column
(
db
.
Integer
(
15
),
nullable
=
False
,
server_default
=
'0'
)
in_reply_to_id_bskRECORDCOMMENT
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
id
),
nullable
=
False
,
server_default
=
'0'
)
reply_order_cached_data
=
db
.
Column
(
db
.
iBinary
,
nullable
=
True
)
in_reply_to
=
db
.
relationship
(
'BskRECORDCOMMENT'
)
basket
=
db
.
relationship
(
BskBASKET
,
backref
=
'RECORDCOMMENTs'
)
user
=
db
.
relationship
(
User
)
class
UserBskBASKET
(
db
.
Model
):
"""Represents a UserBskBASKET record."""
def
__init__
(
self
):
pass
__tablename__
=
'user_bskBASKET'
id_user
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
User
.
id
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
id_bskBASKET
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
BskBASKET
.
id
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
topic
=
db
.
Column
(
db
.
String
(
50
),
nullable
=
False
,
server_default
=
''
)
user
=
db
.
relationship
(
User
,
backref
=
'user_baskets'
)
user_basket
=
db
.
relationship
(
BskBASKET
,
backref
=
'users'
)
class
UsergroupBskBASKET
(
db
.
Model
):
"""Represents a UsergroupBskBASKET record."""
def
__init__
(
self
):
pass
__tablename__
=
'usergroup_bskBASKET'
id_usergroup
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
Usergroup
.
id
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
id_bskBASKET
=
db
.
Column
(
db
.
Integer
(
15
,
unsigned
=
True
),
db
.
ForeignKey
(
BskBASKET
.
id
),
nullable
=
False
,
server_default
=
'0'
,
primary_key
=
True
)
topic
=
db
.
Column
(
db
.
String
(
50
),
nullable
=
False
,
server_default
=
''
)
date_shared
=
db
.
Column
(
db
.
DateTime
,
nullable
=
False
,
server_default
=
'0000-00-00 00:00:00'
)
share_level
=
db
.
Column
(
db
.
Char
(
2
),
nullable
=
False
,
server_default
=
''
)
usergroup
=
db
.
relationship
(
Usergroup
,
backref
=
'usergroup_baskets'
)
usergroup_basket
=
db
.
relationship
(
BskBASKET
,
backref
=
'usergroups'
)
Event Timeline
Log In to Comment