本文整理汇总了Python中socorro.external.postgresql.crashstorage.PostgreSQLCrashStorage._table_suffix_for_crash_id方法的典型用法代码示例。如果您正苦于以下问题：Python PostgreSQLCrashStorage._table_suffix_for_crash_id方法的具体用法？Python PostgreSQLCrashStorage._table_suffix_for_crash_id怎么用？Python PostgreSQLCrashStorage._table_suffix_for_crash_id使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类socorro.external.postgresql.crashstorage.PostgreSQLCrashStorage的用法示例。
在下文中一共展示了PostgreSQLCrashStorage._table_suffix_for_crash_id方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: setUp
# 需要导入模块: from socorro.external.postgresql.crashstorage import PostgreSQLCrashStorage [as 别名]
# 或者: from socorro.external.postgresql.crashstorage.PostgreSQLCrashStorage import _table_suffix_for_crash_id [as 别名]
def setUp(self):
assert 'test' in databaseName.default, databaseName.default
dsn = ('host=%(database_host)s dbname=%(database_name)s '
'user=%(database_user)s password=%(database_password)s' % DSN)
self.conn = psycopg2.connect(dsn)
cursor = self.conn.cursor()
date_suffix = PostgreSQLCrashStorage._table_suffix_for_crash_id(a_processed_crash['uuid'])
self.reports_table_name = 'reports%s' % date_suffix
cursor.execute("""
DROP TABLE IF EXISTS %(table_name)s;
CREATE TABLE %(table_name)s (
id integer NOT NULL,
client_crash_date timestamp with time zone,
date_processed timestamp with time zone,
uuid character varying(50) NOT NULL,
product character varying(30),
version character varying(16),
build character varying(30),
signature character varying(255),
url character varying(255),
install_age integer,
last_crash integer,
uptime integer,
cpu_name character varying(100),
cpu_info character varying(100),
reason character varying(255),
address character varying(20),
os_name character varying(100),
os_version character varying(100),
email character varying(100),
user_id character varying(50),
started_datetime timestamp with time zone,
completed_datetime timestamp with time zone,
success boolean,
truncated boolean,
processor_notes text,
user_comments character varying(1024),
app_notes character varying(1024),
distributor character varying(20),
distributor_version character varying(20),
topmost_filenames text,
addons_checked boolean,
flash_version text,
hangid text,
process_type text,
release_channel text,
productid text
);
DROP SEQUENCE reports_id_seq;
CREATE SEQUENCE reports_id_seq
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;
ALTER TABLE ONLY %(table_name)s ALTER COLUMN id
SET DEFAULT nextval('reports_id_seq'::regclass);
DROP TABLE IF EXISTS plugins;
CREATE TABLE plugins (
id serial NOT NULL,
filename text NOT NULL,
name text NOT NULL
);
DROP TABLE IF EXISTS plugins_reports;
CREATE TABLE plugins_reports (
report_id integer NOT NULL,
plugin_id integer NOT NULL,
date_processed timestamp with time zone,
version text NOT NULL
);
DROP TABLE IF EXISTS plugin_%(table_name)s;
CREATE TABLE plugin_%(table_name)s (
report_id integer NOT NULL,
plugin_id integer NOT NULL,
date_processed timestamp with time zone,
version text NOT NULL
);
DROP TABLE IF EXISTS extensions;
CREATE TABLE extensions (
report_id serial NOT NULL,
date_processed timestamp with time zone,
extension_key integer NOT NULL,
extension_id text NOT NULL,
extension_version text
);
DROP TABLE IF EXISTS extensions%(date_suffix)s;
CREATE TABLE extensions%(date_suffix)s (
report_id serial NOT NULL,
date_processed timestamp with time zone,
extension_key integer NOT NULL,
extension_id text NOT NULL,
extension_version text
);
#.........这里部分代码省略.........