arxiv.users.legacy.models module¶
ORM models for legacy user and session tables.
-
class
arxiv.users.legacy.models.
DBCategory
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Metadata about arXiv categories.
Field Type Null Key Default archive subject_class definitive active category_name endorse_all endorse_email papers_to_endorse endorsement_domain varchar(16) varchar(16) int(1) int(1) varchar(255) enum(‘y’,’n’,’d’) enum(‘y’,’n’,’d’) smallint(5) unsigned varchar(32) NO NO NO NO YES NO NO NO YES PRI PRI
MUL
0 0 NULL d d 0 NULL -
active
¶
-
archive
¶
-
definitive
¶
-
endorsement_domain
¶
-
subject_class
¶
-
-
class
arxiv.users.legacy.models.
DBDocumentInCategory
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
M2M intermediate table for documents and their categories.
Field Type Null Key Default Extra document_id archive subject_class is_primary mediumint(8) unsigned varchar(16) varchar(16) tinyint(1) NO NO NO NO PRI PRI PRI 0
0
-
archive
¶
-
document_id
¶
-
is_primary
¶
-
subject_class
¶
-
-
class
arxiv.users.legacy.models.
DBDocuments
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Represents an arXiv paper.
Field Type Null Key Default document_id paper_id title authors submitter_email submitter_id dated primary_subject_class created mediumint(8) unsigned varchar(20) varchar(255) text varchar(64) int(10) unsigned int(10) unsigned varchar(16) datetime NO NO NO YES NO YES NO YES YES PRI UNI MUL
MUL MUL MUL
NULL
NULL
NULL 0 NULL NULL
-
dated
¶
-
document_id
¶
-
paper_id
¶
-
-
class
arxiv.users.legacy.models.
DBEmailBlacklist
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Patterns for identifying non-academic addresses.
pattern | varchar(64) | YES | | NULL |
-
pattern
¶
-
-
class
arxiv.users.legacy.models.
DBEmailWhitelist
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Patterns for identifying academic addresses.
pattern | varchar(64) | YES | | NULL |
-
pattern
¶
-
-
class
arxiv.users.legacy.models.
DBEndorsement
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Category endorsements for arXiv users.
Field Type Null Key Default endorsement_id endorser_id endorsee_id archive subject_class flag_valid type point_value issued_when request_id int(10) unsigned int(10) unsigned int(10) unsigned varchar(16) varchar(16) int(1) unsigned enum(‘user’,’admin’,’auto’) int(1) unsigned int(10) unsigned int(10) unsigned NO YES NO NO NO NO YES NO NO YES PRI MUL MUL MUL
MUL
NULL NULL 0
0 NULL 0 0 NULL
-
archive
¶
-
endorsee
¶
-
endorsee_id
¶
-
endorsement_id
¶
-
endorsement_type
¶
-
endorser_id
¶
-
flag_valid
¶
-
issued_when
¶
-
point_value
¶
-
request_id
¶
-
subject_class
¶
-
-
class
arxiv.users.legacy.models.
DBEndorsementDomain
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Encodes some policies about endorsement.
Field Type Null Key Default endorsement_domain endorse_all mods_endorse_all endorse_email papers_to_endorse varchar(32) enum(‘y’,’n’) enum(‘y’,’n’) enum(‘y’,’n’) smallint(5) unsigned NO NO NO NO NO PRI n n y 4 -
endorse_all
¶
-
endorse_email
¶
-
endorsement_domain
¶
-
mods_endorse_all
¶
-
papers_to_endorse
¶
-
-
class
arxiv.users.legacy.models.
DBPaperOwners
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Relates arXiv users to their owned papers.
Field Type Null Key Default Extra document_id user_id date valid flag_author mediumint(8) unsigned int(10) unsigned int(10) unsigned int(1) unsigned int(1) unsigned NO NO NO NO NO PRI PRI 0 0 0 0 0 -
date
¶
-
document_id
¶
-
user_id
¶
-
valid
¶
-
-
class
arxiv.users.legacy.models.
DBPermanentToken
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Bearer token for user authentication.
Field Type Null Key Default Extra user_id secret valid issued_when issued_to remote_host session_id int(4) unsigned varchar(32) int(1) int(4) unsigned varchar(16) varchar(255) int(4) unsigned NO NO NO NO NO NO NO PRI PRI
MUL
0
1 0
0
-
issued_to
¶ IP address of client.
-
issued_when
¶ Epoch time.
-
remote_host
¶
-
secret
¶ Token.
-
session_id
¶
-
user_id
¶
-
valid
¶
-
-
class
arxiv.users.legacy.models.
DBPolicyClass
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Legacy authorization table.
-
ADMIN
= 1¶
-
LEGACY_USER
= 3¶
-
POLICY_CLASSES
= [{'name': 'Administrator', 'class_id': 1, 'description': ''}, {'name': 'Public user', 'class_id': 2, 'description': ''}, {'name': 'Legacy user', 'class_id': 3, 'description': ''}]¶
-
PUBLIC_USER
= 2¶
-
class_id
¶
-
description
¶
-
name
¶
-
password_storage
¶
-
permanent_login
¶
-
recovery_policy
¶
-
-
class
arxiv.users.legacy.models.
DBProfile
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Legacy user profiles.
-
GROUP_FLAGS
= [('grp_physics', 'flag_group_physics'), ('grp_math', 'flag_group_math'), ('grp_cs', 'flag_group_cs'), ('grp_q-bio', 'flag_group_q_bio'), ('grp_q-fin', 'flag_group_q_fin'), ('grp_q-stat', 'flag_group_stat'), ('grp_q-econ', 'flag_group_econ'), ('grp_eess', 'flag_group_eess')]¶
-
TYPE_CHOICES
= [(1, 'Staff'), (2, 'Professor'), (3, 'Post Doc'), (4, 'Grad Student'), (5, 'Other')]¶ Legacy ranks in arXiv user profiles.
-
affiliation
¶
-
archive
¶
-
country
¶
-
flag_group_cs
¶
-
flag_group_econ
¶
-
flag_group_eess
¶
-
flag_group_math
¶
-
flag_group_nlin
¶
-
flag_group_physics
¶
-
flag_group_q_bio
¶
-
flag_group_q_fin
¶
-
flag_group_stat
¶
-
original_subject_classes
¶
-
rank
¶
-
subject_class
¶
-
to_domain
()[source]¶ Generate a domain representation from this database instance.
Return type: UserProfile
-
url
¶
-
user
¶
-
user_id
¶
-
-
class
arxiv.users.legacy.models.
DBSession
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Legacy arXiv session table.
Field Type Null Key Default session_id | int(4) unsigned user_id | int(4) unsigned last_reissue | int(11) start_time | int(11) end_time | int(11) NO NO NO NO NO PRI MUL
MUL MUL
NULL 0 0 0 0 -
end_time
¶
-
last_reissue
¶
-
session_id
¶
-
start_time
¶
-
user
¶
-
user_id
¶
-
-
class
arxiv.users.legacy.models.
DBSessionsAudit
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Legacy arXiv session audit table. Notably has a tracking cookie.
-
ip_addr
¶
-
remote_host
¶
-
session
¶
-
session_id
¶
-
-
class
arxiv.users.legacy.models.
DBUser
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Legacy user data table.
-
email
¶
-
email_bouncing
¶
-
first_name
¶
-
flag_allow_tex_produced
¶
-
flag_approved
¶
-
flag_banned
¶
-
flag_deleted
¶
-
flag_edit_system
¶
-
flag_edit_users
¶
-
flag_email_verified
¶
-
flag_html_email
¶
-
flag_internal
¶
-
flag_wants_email
¶
-
joined_date
¶
-
joined_ip_num
¶
-
joined_remote_host
¶
-
last_name
¶
-
policy_class
¶
-
suffix_name
¶
-
user_id
¶
-
-
class
arxiv.users.legacy.models.
DBUserNickname
(**kwargs)[source]¶ Bases:
sqlalchemy.ext.declarative.api.Base
Users’ usernames (because why not have a separate table).
Field Type Null Key Default Extra nick_id nickname user_id user_seq flag_valid role policy flag_primary int(10) unsigned varchar(20) int(4) unsigned int(1) unsigned int(1) unsigned int(10) unsigned int(10) unsigned int(1) unsigned NO NO NO NO NO NO NO NO PRI UNI MUL
MUL MUL MUL
NULL
0 0 0 0 0 0
autoincrement -
flag_primary
¶
-
flag_valid
¶
-
nick_id
¶
-
nickname
¶
-
policy
¶
-
role
¶
-
user
¶
-
user_id
¶
-
user_seq
¶
-