def test_parse_GAAP10Q_Ez_XBRL():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/ggho-20140930.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"10-Q", "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 34273.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 127.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == -1078.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == -7593.0
assert result.data['liabilities_and_equity'] == 79451.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 13026.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 30543.0
assert result.data['net_income_loss'] == -8642.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 0.0
assert result.data['equity_attributable_interest'] == 309.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 0.0
assert result.data['income_before_equity_investments'] == -8531.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 1078.0
assert result.data['gross_profit'] == 5433.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 0.0
assert result.data['interest_and_debt_expense'] == 0.0
def test_parse_GAAP10Q_QXInteractive():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/aaoi-20140630.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"10-Q", "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 5606.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 85.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 978.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 1730.0
assert result.data['liabilities_and_equity'] == 153524.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 9458.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 111781.0
assert result.data['net_income_loss'] == 1919.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 2058.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 2058.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 106114.0
assert result.data['gross_profit'] == 11188.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 46431.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
df.index.names = ['Company-date']
xml_path="~/apps/repo/python-xbrl/tests"
for root, dirs, files in os.walk("."):
path = root.split(os.sep)
print((len(path) -1) * '---', os.path.basename(root))
for file in files:
print (file)
if re.match(r"[a-z]{3,5}\-[0-9]{8}\.xml",file):
#if re.match(r"aaww-20131231.xml",file):
# Parse an incoming XBRL file
xbrl = xbrl_parser.parse(file)
print("Process {}".format(os.path.join(root,file)))
date_of_doc = re.search(r"[0-9]{8}",file).group()
# Parse just the GAAP data from the xbrl object
gaap_obj = xbrl_parser.parseGAAP(xbrl,
doc_date=date_of_doc,
context="current",
ignore_errors=0)
result = serializer.dump(gaap_obj)
#Print out the serialized GAAP data
print (result)
attribute = [x.encode('ascii') for x in result[0].keys()]
values = result[0].values()
print(values)
df.loc[file] = values
df.to_csv('./output.csv')
print (df)
## Parse just the DEI data from the xbrl object
data_x = []
data_y = []
test_x = []
test_y = []
for subdir, dirs, files in os.walk("data/"):
print(os.path.split(subdir)[-1])
for f in files:
xbrl_parser = XBRLParser()
print(subdir + "/" + f)
try:
xbrl = xbrl_parser.parse(subdir + "/" + f)
except:
continue
gaap_obj = xbrl_parser.parseGAAP(xbrl,
context="current",
ignore_errors=0)
print("We here 2")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
if "-13-" in f:
test_x.append([])
for i, k in result.data:
test_x[-1].append(k)
else:
data_x.append([])
for i, k in result.data:
data_x[-1].append(k)
print(data_x)
X = tf.placeholder("float", [None, 76])
def test_parse_GAAP10K_Fujitsu():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/aaww-20131231.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 194292.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 0.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 3124306.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 0.0
assert result.data['liabilities_and_equity'] == 3718259.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 4870.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 0.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 1317773.0
assert result.data['net_income_loss'] == 0.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 0.0
assert result.data['equity_attributable_interest'] == 4352.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 0.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 3718259.0
assert result.data['gross_profit'] == 0.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 593953.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
assert result.data['common_shares_authorized'] == 0.0
def test_parse_GAAP10Q_RRDonnelley():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/sam-20130629.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 98032.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 12107.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 5417.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 19715.0
assert result.data['liabilities_and_equity'] == 60263.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 65084.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 253536.0
assert result.data['net_income_loss'] == 19715.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 19715.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 19715.0
assert result.data['income_before_equity_investments'] == 31822.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 376766.0
assert result.data['gross_profit'] == 97132.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 138996.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
def test_parse_GAAP10Q_Webfilings():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/goog-20140630.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result['liabilities'] == 3683.0
assert result['net_cash_flows_financing_continuing'] == 0.0
assert result['revenue'] == 0.0
assert result['income_tax_expense_benefit'] == 913.0
assert result['income_from_equity_investments'] == 0.0
assert result['preferred_stock_dividends'] == 0.0
assert result['redeemable_noncontrolling_interest'] == 0.0
assert result['extraordary_items_gain_loss'] == 0.0
assert result['temporary_equity'] == 0.0
assert result['costs_and_expenses'] == 11697.0
assert result['non_current_assets'] == 43703.0
assert result['net_cash_flows_discontinued'] == 0.0
assert result['income_loss'] == 3490.0
assert result['liabilities_and_equity'] == 121608.0
assert result['other_operating_income'] == 0.0
assert result['operating_income_loss'] == 0.0
assert result['net_income_parent'] == 0.0
assert result['equity'] == 0.0
assert result['net_cash_flows_operating_discontinued'] == 0.0
assert result['cost_of_revenue'] == 0.0
assert result['operating_expenses'] == 0.0
assert result['noncurrent_liabilities'] == 0.0
assert result['current_liabilities'] == 0.0
assert result['net_cash_flows_investing'] == 0.0
assert result['stockholders_equity'] == 95749.0
assert result['net_income_loss'] == 3422.0
assert result['net_cash_flows_investing_continuing'] == 0.0
assert result['nonoperating_income_loss'] == 0.0
assert result['net_cash_flows_financing'] == 0.0
assert result['net_income_shareholders'] == 0.0
assert result['comprehensive_income'] == 3579.0
assert result['equity_attributable_interest'] == 0.0
assert result['commitments_and_contingencies'] == 0.0
assert result['comprehensive_income_parent'] == 3579.0
assert result['income_before_equity_investments'] == 4403.0
assert result['comprehensive_income_interest'] == 0.0
assert result['other_comprehensive_income'] == 0.0
assert result['equity_attributable_parent'] == 0.0
assert result['assets'] == 121608.0
assert result['gross_profit'] == 0.0
assert result['net_cash_flows_operating_continuing'] == 0.0
assert result['current_assets'] == 77905.0
assert result['interest_and_debt_expense'] == 0.0
assert result['net_income_loss_noncontrolling'] == 0.0
assert result['net_cash_flows_operating'] == 0.0
assert result['common_shares_outstanding'] == 0.0
assert result['common_shares_issued'] == 0.0
assert result['common_shares_authorized'] == 0.0
#! /usr/bin/env python
# encoding: utf-8
from xbrl import XBRLParser
from xbrl_middleware import ExcelDump, OpenPyxlAdapter
xbrl_parser = XBRLParser(precision=0)
# Parse an incoming XBRL file
xbrl = xbrl_parser.parse(file("sam-20130629.xml"))
# Parse just the GAAP data from the xbrl object
gaap_obj = xbrl_parser.parseGAAP(xbrl,
doc_date="20130629",
doc_type="10-Q",
context="current",
ignore_errors=0)
# Dump the GAAP data to XLSX (Excel)
xbrl_dump = ExcelDump(gaap_obj)
dumper = xbrl_middleware.OpenPyxlAdapter(xbrl_dump)
dumper.write('demo.xlsx')
dumper.dump()
def test_parse_GAAP10Q_Ez_XBRL():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/ggho-20140930.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 34273.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 127.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 58615.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == -7593.0
assert result.data['liabilities_and_equity'] == 79451.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 13026.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 30543.0
assert result.data['net_income_loss'] == -8642.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 0.0
assert result.data['equity_attributable_interest'] == 309.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 0.0
assert result.data['income_before_equity_investments'] == -8531.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 79451.0
assert result.data['gross_profit'] == 5433.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 20836.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
assert result.data['common_shares_authorized'] == 0.0
def test_parse_GAAP10K_ThomsonReuters():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/aaoi-20131231.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 39057.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 0.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 177.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == -297.0
assert result.data['liabilities_and_equity'] == 111057.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 6973.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 63077.0
assert result.data['net_income_loss'] == -520.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 0.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 0.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 111057.0
assert result.data['gross_profit'] == 6676.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 77936.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
assert result.data['common_shares_authorized'] == 0.0
def test_parse_GAAP10Q_RRDonnelley():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/sam-20130629.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 98032.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 12107.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 5417.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 19715.0
assert result.data['liabilities_and_equity'] == 60263.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 65084.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 253536.0
assert result.data['net_income_loss'] == 19715.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 19715.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 19715.0
assert result.data['income_before_equity_investments'] == 31822.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 376766.0
assert result.data['gross_profit'] == 97132.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 138996.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
def test_parse_GAAP10Q_Fujitsu():
xbrl_parser = XBRLParser()
file_to_parse = "tests/aaww-20140630.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 233079.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == -23815.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 414512.0
assert result.data['non_current_assets'] == 3568474.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 26657.0
assert result.data['liabilities_and_equity'] == 4100064.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 4870.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 0.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 1355551.0
assert result.data['net_income_loss'] == 0.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == -515.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == -515.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == -515.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 4100064.0
assert result.data['gross_profit'] == 0.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 531590.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == -612.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 25256124.0
assert result.data['common_shares_issued'] == 28547138.0
assert result.data['common_shares_authorized'] == 50000000.0
def test_parse_GAAP10Q_QXInteractive():
xbrl_parser = XBRLParser()
file_to_parse = "tests/aaoi-20140630.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 5606.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 85.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 978.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 1730.0
assert result.data['liabilities_and_equity'] == 153524.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 9458.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 111781.0
assert result.data['net_income_loss'] == 1919.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 2058.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 2058.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 153524.0
assert result.data['gross_profit'] == 11188.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 106114.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 14798000.0
assert result.data['common_shares_issued'] == 14798000.0
assert result.data['common_shares_authorized'] == 45000000.0
def test_parse_GAAP10Q_Rivet():
xbrl_parser = XBRLParser()
file_to_parse = "tests/c289-20140503.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 12535.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 14.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 708.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == -983.0
assert result.data['liabilities_and_equity'] == 13261.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 3497.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 726.0
assert result.data['net_income_loss'] == -983.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == -977.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == -977.0
assert result.data['income_before_equity_investments'] == -969.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 13261.0
assert result.data['gross_profit'] == 2687.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 10747.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 146033000.0
assert result.data['common_shares_authorized'] == 650000000.0
# encoding: utf-8
from __future__ import print_function
from xbrl import XBRLParser, GAAP, GAAPSerializer, DEISerializer
xbrl_parser = XBRLParser(0)
# Parse an incoming XBRL file
file_to_parse = "../tests/sam-20130629.xml"
xbrl = xbrl_parser.parse(file_to_parse)
# Parse just the GAAP data from the xbrl object
gaap_obj = xbrl_parser.parseGAAP(xbrl,
doc_date="20131228",
context="current",
ignore_errors=0)
# Serialize the GAAP data
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
# Print out the serialized GAAP data
print(result.data)
# Parse just the DEI data from the xbrl object
dei_obj = xbrl_parser.parseDEI(xbrl)
# Serialize the DEI data
serializer = DEISerializer()
def test_parse_GAAP10K_RRDonnelley():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/sam-20131228.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"10-K", "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 104377.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 0.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 0.0
assert result.data['non_current_assets'] == 9556.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 29120.0
assert result.data['liabilities_and_equity'] == 69900.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 0.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 302085.0
assert result.data['net_income_loss'] == 18079.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 0.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 0.0
assert result.data['income_before_equity_investments'] == 0.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 1050.0
assert result.data['gross_profit'] == 104628.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 0.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
def test_parse_GAAP10Q_Webfilings():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/goog-20140630.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(xbrl,
str(file_to_parse
.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1]
.split(".")[0][4:6] +
file_to_parse.split("-")[1]
.split(".")[0][6:8]),
"current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result.data['liabilities'] == 3683.0
assert result.data['net_cash_flows_financing_continuing'] == 0.0
assert result.data['revenue'] == 0.0
assert result.data['income_tax_expense_benefit'] == 913.0
assert result.data['income_from_equity_investments'] == 0.0
assert result.data['preferred_stock_dividends'] == 0.0
assert result.data['redeemable_noncontrolling_interest'] == 0.0
assert result.data['extraordary_items_gain_loss'] == 0.0
assert result.data['temporary_equity'] == 0.0
assert result.data['costs_and_expenses'] == 11697.0
assert result.data['non_current_assets'] == 43703.0
assert result.data['net_cash_flows_discontinued'] == 0.0
assert result.data['income_loss'] == 3490.0
assert result.data['liabilities_and_equity'] == 121608.0
assert result.data['other_operating_income'] == 0.0
assert result.data['operating_income_loss'] == 0.0
assert result.data['net_income_parent'] == 0.0
assert result.data['equity'] == 0.0
assert result.data['net_cash_flows_operating_discontinued'] == 0.0
assert result.data['cost_of_revenue'] == 0.0
assert result.data['operating_expenses'] == 0.0
assert result.data['noncurrent_liabilities'] == 0.0
assert result.data['current_liabilities'] == 0.0
assert result.data['net_cash_flows_investing'] == 0.0
assert result.data['stockholders_equity'] == 95749.0
assert result.data['net_income_loss'] == 3422.0
assert result.data['net_cash_flows_investing_continuing'] == 0.0
assert result.data['nonoperating_income_loss'] == 0.0
assert result.data['net_cash_flows_financing'] == 0.0
assert result.data['net_income_shareholders'] == 0.0
assert result.data['comprehensive_income'] == 3579.0
assert result.data['equity_attributable_interest'] == 0.0
assert result.data['commitments_and_contingencies'] == 0.0
assert result.data['comprehensive_income_parent'] == 3579.0
assert result.data['income_before_equity_investments'] == 4403.0
assert result.data['comprehensive_income_interest'] == 0.0
assert result.data['other_comprehensive_income'] == 0.0
assert result.data['equity_attributable_parent'] == 0.0
assert result.data['assets'] == 121608.0
assert result.data['gross_profit'] == 0.0
assert result.data['net_cash_flows_operating_continuing'] == 0.0
assert result.data['current_assets'] == 77905.0
assert result.data['interest_and_debt_expense'] == 0.0
assert result.data['net_income_loss_noncontrolling'] == 0.0
assert result.data['net_cash_flows_operating'] == 0.0
assert result.data['common_shares_outstanding'] == 0.0
assert result.data['common_shares_issued'] == 0.0
assert result.data['common_shares_authorized'] == 0.0
from xbrl import XBRLParser, GAAPSerializer, DEISerializer
xbrl_parser = XBRLParser()
xbrl = xbrl_parser.parse(open("sample_report/apple-2013-qtr1-10Q-xbrl.xml"))
gaap_obj = xbrl_parser.parseGAAP(xbrl,
doc_date="20121229",
context="current",
ignore_errors=0)
print("Cash generated by operating activities: " +
str(gaap_obj.net_cash_flows_operating))
print("Cash generated by/(used in) investing activities: " +
str(gaap_obj.net_cash_flows_investing))
print("Cash used in financing activities: " +
str(gaap_obj.net_cash_flows_financing))
print("Total shareholders’ equity: " + str(gaap_obj.stockholders_equity))
print("Total assets: " + str(gaap_obj.assets))
print("Operating income: " + str(gaap_obj.operating_income_loss))
print("Net income: " + str(gaap_obj.net_income_loss))
print("Liabilities: " + str(gaap_obj.assets - gaap_obj.stockholders_equity))
print("Total net sales: " + str(gaap_obj.revenues))
dei_obj = xbrl_parser.parseDEI(xbrl)
# Serialize the DEI data
serializer = DEISerializer()
result = serializer.dump(dei_obj)
# serializer = GAAPSerializer()
# result = serializer.dump(gaap_obj)
#
# print(result.data)
def test_parse_GAAP10K_RRDonnelley():
xbrl_parser = XBRLParser(0)
file_to_parse = "tests/sam-20131228.xml"
xbrl = xbrl_parser.parse(file_to_parse)
gaap_obj = xbrl_parser.parseGAAP(
xbrl,
str(
file_to_parse.split("-")[1].split(".")[0][:4] +
file_to_parse.split("-")[1].split(".")[0][4:6] +
file_to_parse.split("-")[1].split(".")[0][6:8]), "current")
serializer = GAAPSerializer()
result = serializer.dump(gaap_obj)
assert result['liabilities'] == 104377.0
assert result['net_cash_flows_financing_continuing'] == 0.0
assert result['revenue'] == 0.0
assert result['income_tax_expense_benefit'] == 0.0
assert result['income_from_equity_investments'] == 0.0
assert result['preferred_stock_dividends'] == 0.0
assert result['redeemable_noncontrolling_interest'] == 0.0
assert result['extraordary_items_gain_loss'] == 0.0
assert result['temporary_equity'] == 0.0
assert result['costs_and_expenses'] == 0.0
assert result['non_current_assets'] == 9556.0
assert result['net_cash_flows_discontinued'] == 0.0
assert result['income_loss'] == 29120.0
assert result['liabilities_and_equity'] == 69900.0
assert result['other_operating_income'] == 0.0
assert result['operating_income_loss'] == 0.0
assert result['net_income_parent'] == 0.0
assert result['equity'] == 0.0
assert result['net_cash_flows_operating_discontinued'] == 0.0
assert result['cost_of_revenue'] == 0.0
assert result['operating_expenses'] == 0.0
assert result['noncurrent_liabilities'] == 0.0
assert result['current_liabilities'] == 0.0
assert result['net_cash_flows_investing'] == 0.0
assert result['stockholders_equity'] == 302085.0
assert result['net_income_loss'] == 18079.0
assert result['net_cash_flows_investing_continuing'] == 0.0
assert result['nonoperating_income_loss'] == 0.0
assert result['net_cash_flows_financing'] == 0.0
assert result['net_income_shareholders'] == 0.0
assert result['comprehensive_income'] == 0.0
assert result['equity_attributable_interest'] == 0.0
assert result['commitments_and_contingencies'] == 0.0
assert result['comprehensive_income_parent'] == 0.0
assert result['income_before_equity_investments'] == 0.0
assert result['comprehensive_income_interest'] == 0.0
assert result['other_comprehensive_income'] == 0.0
assert result['equity_attributable_parent'] == 0.0
assert result['assets'] == 444075.0
assert result['gross_profit'] == 104628.0
assert result['net_cash_flows_operating_continuing'] == 0.0
assert result['current_assets'] == 164278.0
assert result['interest_and_debt_expense'] == 0.0
assert result['net_income_loss_noncontrolling'] == 0.0
assert result['net_cash_flows_operating'] == 0.0
assert result['common_shares_outstanding'] == 0.0
assert result['common_shares_issued'] == 0.0
assert result['common_shares_authorized'] == 0.0
