def Initialize(self, configFileName):
from Logging import mainlog, horse_dir, init_logging
init_logging('web_server.log')
mainlog.info("Horse dir : {}".format(horse_dir))
try:
from Configurator import load_configuration, configuration, resource_dir
mainlog.info("Resource dir : {}".format(resource_dir))
load_configuration("server.cfg", "server_config_check.cfg")
mainlog.info("configuration loaded")
from koi.http_handler import HorseHTTPHandler
p = int(configuration.get("DownloadSite", "port"))
mainlog.info("Listening on port {}".format(p))
self.server = HTTPServer(('', p), HorseHTTPHandler)
except Exception as ex:
mainlog.exception(ex)
raise ex
from datetime import date
from sqlalchemy.sql import select,func,and_,or_
from Logging import mainlog,init_logging
from Configurator import init_i18n,load_configuration,configuration,resource_dir
init_logging()
init_i18n()
load_configuration()
from db_mapping import metadata
from datalayer.database_session import init_db_session
from datalayer.database_session import session
from db_mapping import FilterQuery
init_db_session(configuration.database_url, metadata, False or configuration.echo_query)
from dao import dao
def alter_structure():
session().connection().execute("""CREATE TABLE horse.filter_queries (
filter_query_id SERIAL NOT NULL,
name VARCHAR NOT NULL,
query VARCHAR NOT NULL,
shared BOOLEAN NOT NULL,
owner_id INTEGER NOT NULL,
PRIMARY KEY (filter_query_id),
CONSTRAINT fq_by_name UNIQUE (name, owner_id),
FOREIGN KEY(owner_id) REFERENCES horse.employees (employee_id))""")
import urllib.request, urllib.error, urllib.parse
from Logging import init_logging, mainlog, horse_dir, log_stacktrace
init_logging("file_server.log")
from Configurator import load_configuration, init_i18n, configuration, resource_dir
load_configuration("server.cfg", "server_config_check.cfg")
if __name__ == "__main__":
base_url = "http://localhost:{}".format(
configuration.get("DownloadSite", "port"))
mainlog.info("Testing {}".format(base_url))
response = urllib.request.urlopen(base_url)
if "This is the Horse download site !" not in response.read():
mainlog.error("Can't see homepage")
else:
mainlog.info("Homepage OK")
response = urllib.request.urlopen(base_url + "/database")
mainlog.info("Database = " + response.read())
response = urllib.request.urlopen(base_url + "/version")
mainlog.info("Version = " + response.read())
response = urllib.request.urlopen(base_url + "/file")
mainlog.info("Client file = {} ".format(
response.info().headers[4].strip()))
mainlog.info("Client file = {} bytes".format(len(response.read())))
if __name__ == "__main__":
from Logging import init_logging
init_logging("rlab.log")
from Configurator import configuration, mainlog, init_i18n, load_configuration
init_i18n()
load_configuration()
from datetime import datetime, date
from decimal import *
from reportlab.lib.pagesizes import A4
from reportlab.lib.styles import ParagraphStyle
from reportlab import platypus
from reportlab.platypus import Paragraph
from reportlab.lib.enums import TA_RIGHT, TA_CENTER
from reportlab.lib.units import cm
from reportlab.platypus.doctemplate import FrameBreak
from reportlab.platypus.flowables import PageBreak
from reportlab.lib import colors
from koi.translators import nunicode, date_to_dmy, crlf_to_br
from koi.reporting.utils import MyTable, make_pdf_filename, open_pdf, customer_PDF, moneyfmt, NumberedCanvas, append_general_conditions, append_header_block, escape_html
import os
from koi.Configurator import resource_dir
from reportlab.pdfbase import pdfmetrics
from reportlab.pdfbase.ttfonts import TTFont
# reportlab.rl_config.warnOnMissingFontGlyphs = 0
pdfmetrics.registerFont(
TTFont('DejaVuSansMono', os.path.join(resource_dir, 'DejaVuSansMono.ttf')))
from datetime import datetime, date, timedelta
# Make sure we work with an in memory database
import Configurator
# Configurator.configuration.in_test()
import logging
from Logging import init_logging
init_logging("test.log")
from Configurator import init_i18n, load_configuration
init_i18n()
load_configuration()
from Configurator import mainlog, configuration
from sqlalchemy.exc import IntegrityError, InternalError
from sqlalchemy.sql.expression import func, select, join, and_, desc
import db_mapping
from db_mapping import Employee, Task, OperationDefinition, TaskActionReport, TimeTrack, DeliverySlipPart, Order, Customer, OrderPart, Operation, ProductionFile, TaskOnOperation, TaskActionReportType, TaskOnNonBillable
from db_mapping import OrderStatusType
from dao import *
from server import ClockServer, ServerException
s = db_mapping.global_session()
d = date(2013, 1, 1)
for i in range(90):
# In IPython
# %run dbsetup.py
from datetime import datetime
import sys
sys.path.append('..')
from Logging import init_logging
init_logging(r"ipython.log")
from Configurator import init_i18n, mainlog, load_configuration
load_configuration()
init_i18n()
from db_mapping import *
from dao import DAO, printquery
dao = DAO(session())
def printquery(statement, bind=None):
"""
print a query, with values filled in
for debugging purposes *only*
for security, you should always separate queries from their values
please also note that this function is quite slow
"""
import sqlalchemy.orm
if isinstance(statement, sqlalchemy.orm.Query):
if bind is None:
bind = statement.session.get_bind(statement._mapper_zero_or_none())
statement = statement.statement
elif bind is None:
