"cells": [
{
"cell_type": "code",
- "execution_count": 22,
+ "execution_count": 1,
"metadata": {
"collapsed": true
},
},
{
"cell_type": "code",
- "execution_count": 23,
+ "execution_count": 2,
"metadata": {
"collapsed": true
},
" 'pg_type': 'inet'},\n",
" './report_metadata/date_range/begin': {'pg_field_name': 'report_metadata_date_range_begin',\n",
" 'pg_table': 'reports',\n",
- " 'pg_type': 'timestamp'},\n",
+ " 'pg_type': 'timestamptz'},\n",
" './report_metadata/date_range/end': {'pg_field_name': 'report_metadata_date_range_end',\n",
" 'pg_table': 'reports',\n",
- " 'pg_type': 'timestamp'},\n",
+ " 'pg_type': 'timestamptz'},\n",
" './report_metadata/email': {'pg_field_name': 'report_metadata_email',\n",
" 'pg_table': 'reports',\n",
" 'pg_type': 'varchar'},\n",
},
{
"cell_type": "code",
- "execution_count": 24,
+ "execution_count": 3,
"metadata": {
"collapsed": false
},
"['dmarc.ini']"
]
},
- "execution_count": 24,
+ "execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 25,
+ "execution_count": 8,
"metadata": {
"collapsed": false
},
},
{
"cell_type": "code",
- "execution_count": 26,
+ "execution_count": 9,
"metadata": {
"collapsed": false
},
},
{
"cell_type": "code",
- "execution_count": 27,
+ "execution_count": 10,
"metadata": {
"collapsed": false
},
{
"data": {
"text/plain": [
- "'create table reports (id serial primary key, policy_published_pct int, policy_published_adkim varchar, report_metadata_org_name varchar, policy_published_aspf varchar, policy_published_domain varchar, report_metadata_date_range_end timestamp, policy_published_p varchar, report_metadata_report_id varchar, report_metadata_email varchar, report_metadata_date_range_begin timestamp);'"
+ "'create table reports (id serial primary key, policy_published_domain varchar, policy_published_pct int, report_metadata_report_id varchar, report_metadata_date_range_end timestamptz, report_metadata_org_name varchar, report_metadata_date_range_begin timestamptz, policy_published_aspf varchar, report_metadata_email varchar, policy_published_p varchar, policy_published_adkim varchar);'"
]
},
- "execution_count": 27,
+ "execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 28,
+ "execution_count": 11,
"metadata": {
"collapsed": false
},
{
"data": {
"text/plain": [
- "'create table report_items (id serial primary key, report_id integer references reports, auth_results_spf_domain varchar, source_ip inet, policy_evaluated_spf varchar, count int, auth_results_dkim_result varchar, auth_results_dkim_domain varchar, policy_evaluated_disposition varchar, identifiers_header_from varchar, policy_evaluated_dkim varchar, auth_results_spf_result varchar);'"
+ "'create table report_items (id serial primary key, report_id integer references reports, auth_results_dkim_domain varchar, policy_evaluated_dkim varchar, policy_evaluated_spf varchar, policy_evaluated_disposition varchar, source_ip inet, auth_results_dkim_result varchar, count int, auth_results_spf_result varchar, auth_results_spf_domain varchar, identifiers_header_from varchar);'"
]
},
- "execution_count": 28,
+ "execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 29,
+ "execution_count": 12,
"metadata": {
"collapsed": true
},
"with conn.cursor() as cur:\n",
" cur.execute(create_report_table_string)\n",
" cur.execute(create_report_item_table_string)\n",
+ " cur.execute('create index on reports (report_metadata_date_range_end);')\n",
+ " cur.execute('create index on reports (report_metadata_report_id);')\n",
"conn.commit()"
]
},
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
- "version": "3.4.3+"
+ "version": "3.5.2+"
}
},
"nbformat": 4,