"cells": [
{
"cell_type": "code",
- "execution_count": 14,
+ "execution_count": 1,
"metadata": {
"collapsed": true
},
},
{
"cell_type": "code",
- "execution_count": 15,
+ "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": 16,
+ "execution_count": 3,
"metadata": {
"collapsed": false
},
"['dmarc.ini']"
]
},
- "execution_count": 16,
+ "execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 17,
+ "execution_count": 8,
"metadata": {
"collapsed": false
},
},
{
"cell_type": "code",
- "execution_count": 18,
+ "execution_count": 9,
"metadata": {
"collapsed": false
},
},
{
"cell_type": "code",
- "execution_count": 19,
+ "execution_count": 10,
"metadata": {
"collapsed": false
},
{
"data": {
"text/plain": [
- "'create table reports (id serial primary key, report_metadata_org_name varchar, policy_published_domain varchar, report_metadata_email varchar, report_metadata_date_range_begin timestamp, report_metadata_date_range_end timestamp, policy_published_adkim varchar, report_metadata_report_id varchar, policy_published_aspf varchar, policy_published_pct int, policy_published_p varchar);'"
+ "'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": 19,
+ "execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 20,
+ "execution_count": 11,
"metadata": {
"collapsed": false
},
{
"data": {
"text/plain": [
- "'create table report_items (id serial primary key, report_id integer references reports, auth_results_dkim_result varchar, auth_results_spf_result varchar, count int, auth_results_dkim_domain varchar, source_ip inet, policy_evaluated_disposition varchar, identifiers_header_from varchar, auth_results_spf_domain varchar, policy_evaluated_dkim varchar, policy_evaluated_spf 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": 20,
+ "execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
},
{
"cell_type": "code",
- "execution_count": 21,
+ "execution_count": 12,
"metadata": {
"collapsed": true
},
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
- "version": "3.4.3+"
+ "version": "3.5.2+"
}
},
"nbformat": 4,