1. PyPA
  2. Python Packaging Authority Projects
  3. pypi
  4. Issues


Issue #71 wontfix

What is accounts_user?

Dariusz Suchojad
created an issue


I'm trying to run a PyPI instance locally. So far I can't get past ./tools/demodata.py which fails on a missing accounts_user table

$ ./bin/python ./tools/demodata.py 
Traceback (most recent call last):
  File "./tools/demodata.py", line 20, in <module>
    otk = st.store_user('fred', 'fredpw', 'fred@python.test')
  File "/opt/install/pypa-pypi/store.py", line 1533, in store_user
    if self.has_user(name):
  File "/opt/install/pypa-pypi/store.py", line 1520, in has_user
    safe_execute(cursor, sql, (name,))
  File "/opt/install/pypa-pypi/store.py", line 218, in safe_execute
    return cursor.execute(sql, safe_params)
sqlite3.OperationalError: no such table: accounts_user

Indeed, there is no such table in pkgbase_schema.sql. The closest one is users. Which one of them is the correct one?


Comments (6)

  1. Donald Stufft

    PyPI is currently being phased out and a new cleaner code base with tests and all the nine yards is being developed. As part of this effort the database schema is moving from being "owned" by this code base, to being owned by the new codebase. So accounts_user is the "new" users table that comes from running the migrations from the new codebase. That is called Warehouse and is available on PyPI.

  2. Log in to comment