import sys
import os
import os.path
import xml.dom.minidom

import time
import datetime


import Hand
import Configuration
from PokerStarsToFpdb import *
import simplejson as json


log = logging.getLogger("root")
Configuration.set_logfile("fpdb-log.txt")
config = Configuration.Config()
con = PokerStars(config, '-', '-', 0)

# Create a list to hold the data object
hands = []

# Loop through and process hands
for hand in con.getProcessedHands():
    h = {
            'sitename' : hand.sitename,
            'gametype' : hand.gametype,
            'handText' : hand.handText,
            'handid' : hand.handid,
            'in_path' : hand.in_path,
            'cancelled' : hand.cancelled,
            'tablename' : hand.tablename,
            'hero' : hand.hero,
            'maxseats' : hand.maxseats,
            'counted_seats' : hand.counted_seats,
            'buttonpos' : hand.buttonpos,
            'runItTimes' : hand.runItTimes,
            'uncalledbets' : hand.uncalledbets,
            'tourNo' : hand.tourNo,
            'tourneyId' : hand.tourneyId,
            'tourneyTypeId' : hand.tourneyTypeId,
            'buyin' : hand.buyin,
            'buyinCurrency' : hand.buyinCurrency,
            'buyInChips' : hand.buyInChips,
            'fee' : hand.fee,
            'level' : hand.level,
            'mixed' : hand.mixed,
            'speed' : hand.speed,
            'isSng' : hand.isSng,
            'isRebuy' : hand.isRebuy,
            'rebuyCost' : hand.rebuyCost,
            'isAddOn' : hand.isAddOn,
            'addOnCost' : hand.addOnCost,
            'isKO' : hand.isKO,
            'koBounty' : hand.koBounty,
            'isMatrix' : hand.isMatrix,
            'isShootout' : hand.isShootout,
            'isZoom' : hand.isZoom,
            'added' : hand.added,
            'addedCurrency' : hand.addedCurrency,
            'tourneyComment' : hand.tourneyComment,
            'seating' : hand.seating,
            'players' : hand.players,
            'posted' : hand.posted,
            'tourneysPlayersIds' : hand.tourneysPlayersIds,
            'bets' : hand.bets,
            'lastBet' : hand.lastBet,
            'streets' : hand.streets,
            'actions' : hand.actions,
            'board' : hand.board,
            'holecards' : hand.holecards,
            'discards' : hand.discards,
            'showdownStrings' : hand.showdownStrings,
            'stacks' : hand.stacks,
            'collected' : hand.collected,
            'collectees' : hand.collectees,
            'folded' : dict.fromkeys(hand.folded),
            'dealt' : dict.fromkeys(hand.dealt),
            'shown' : dict.fromkeys(hand.shown),
            'mucked' : dict.fromkeys(hand.mucked),
            'totalpot' : hand.totalpot,
            'totalcollected' : hand.totalcollected,
            'rake' : hand.rake,
            'sym' : hand.sym

        }
    hands.append(h)


print json.dumps(hands, use_decimal=True)

 cat hand.txt | fpdb_json.py

db.hands.find({'position': 6})

        self.query['handActions'] = """
            SELECT
                      ha.actionNo,
                      p.name,
                      ha.street,
                      ha.actionId,
                      ha.allIn,
                      round(ha.amount / 100.0,2) as bet,
                      ha.numDiscarded,
                      ha.cardsDiscarded
                FROM
                      HandsActions as ha,
                      Players as p,
                      Hands as h
                WHERE
                          h.id = %s
                      AND ha.handId = h.id
                      AND ha.playerId = p.id
                ORDER BY
                      ha.id ASC
                """

MySQL:
format( (sum(totalProfit)/100.0) / sum(HDs), 4)                 AS Profitperhand
v
SQLite:
round( (sum(totalProfit)/100.0) / sum(HDs), 4)                  AS Profitperhand
v
Postgres
to_char(sum(totalProfit/100.0) / (sum(HDs)+0.0), '990D0000')    AS Profitperhand

user = collection.find_one({'email': email})

        self.query['store_hands_actions'] = """insert into HandsActions (
                        handId,
                        playerId,
                        street,
                        actionNo,
                        streetActionNo,
                        actionId,
                        amount,
                        raiseTo,
                        amountCalled,
                        numDiscarded,
                        cardsDiscarded,
                        allIn
               )    
               values (
                    %s, %s, %s, %s, %s,
                    %s, %s, %s, %s, %s,
                    %s, %s
                )"""

        for a in adata:
            self.habulk.append( (hid,
                                 pids[adata[a]['player']],
                                 adata[a]['street'],
                                 adata[a]['actionNo'],
                                 adata[a]['streetActionNo'],
                                 adata[a]['actionId'],
                                 adata[a]['amount'],
                                 adata[a]['raiseTo'],
                                 adata[a]['amountCalled'],
                                 adata[a]['numDiscarded'],
                                 adata[a]['cardsDiscarded'],
                                 adata[a]['allIn']
                               ) )  
        if doinsert:
            q = self.sql.query['store_hands_actions']
            q = q.replace('%s', self.sql.query['placeholder'])
            c = self.get_cursor()
            self.executemany(c, q, self.habulk) #c.executemany(q, self.habulk)

if doinsert:
    #A couple of lines to get the collection object.
    hands_actions_collection.insert(adata)