uliweb can bind tcp server?

[SeedSeek]

想在uliweb 綁定一個普通tcp server ，使用uliweb ORM

有什麼方法可以做到?

[limodou]

使用ORM和绑定tcp server有关系吗？

On Thu, Jan 7, 2016 at 10:17 PM, SeedSeek <frt5...@gmail.com> wrote:

想在uliweb 綁定一個普通tcp server ，使用uliweb ORM

有什麼方法可以做到?

--
-- ----
Project : https://github.com/limodou/uliweb
doc : http://limodou.github.com/uliweb-doc
---
You received this message because you are subscribed to the Google Groups "Uliweb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to uliweb+un...@googlegroups.com.
To post to this group, send email to uli...@googlegroups.com.
Visit this group at https://groups.google.com/group/uliweb.
To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/c2944975-757f-44dc-b5e0-1f4fcd83d987%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

I like python!
UliPad <<The Python Editor>>: http://code.google.com/p/ulipad/
UliWeb <<simple web framework>>: https://github.com/limodou/uliweb
My Blog: http://my.oschina.net/limodou

[Chunlin Zhang]

和web服务是不同的对吧?

那你需要和web服务在不同的线程或者进程中运行吗?

On Thu, Jan 7, 2016 at 10:17 PM, SeedSeek <frt5...@gmail.com> wrote:

想在uliweb 綁定一個普通tcp server ，使用uliweb ORM

有什麼方法可以做到?

--

[cnidance]

Chunlin Zhang 就像你說的那樣，你有經驗?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAG2rzAm2WvvxCe5_8g1h_SB_LbfMXdvTkVoan9AtFdHdNZ-WxA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[Chunlin Zhang]

我其实没有经验 只是大概知道你要做什么

不过为什么不直接用web api提供数据库服务呢 感觉那样更方便

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV_iqwJcSEt4jwPFmWm1pyhxpY6d5YfhYVuONa688GDSrA%40mail.gmail.com.

[cnidance]

使用web api 延遲時間太長，需要快速做完。

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAG2rzAnrtogs8P0jnvLhAqGCKT_JGioYc7fXrVkoqZmLh-Bsjw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

把你的应用场景再说清晰一些。目前uliweb的ORM是可吧不在web环境下使用的，如批处理，只要在使用前先启动应用，如：

from uliweb import functions

from uliweb.manage import make_simple_application

app = make_simple_application(project_dir='.')

User = functions.get_model('user')

On Thu, Jan 7, 2016 at 11:01 PM, cnidance <frt5...@gmail.com> wrote:

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV_iqwJcSEt4jwPFmWm1pyhxpY6d5YfhYVuONa688GDSrA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

[Chunlin Zhang]

按limodou说的应该是可以的

另外开一个进程来做这个活

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV9vvXt4pzLRx5G6g-X%2B4u9v%2BLYGOxEdV2-iDfcnqdWSQA%40mail.gmail.com.

[cnidance]

apps/settings.ini 裡面有

[MIDDLEWARES]

transaction = 'uliweb.orm.middle_transaction.TransactionMiddle'

orm_notfound = 'uliweb.orm.middle_notfound.ORMNotfoundMiddle'

會報錯

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/manage.py", line 177, in make_simple_application

    dispatcher_kwargs=dispatcher_kwargs, reuse=reuse, pythonpath=pythonpath)

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/manage.py", line 117, in make_application

    **dispatcher_kwargs)

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/core/SimpleFrame.py", line 582, in __init__

    self.init(project_dir, apps_dir)

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/core/SimpleFrame.py", line 636, in init

    Dispatcher.middlewares = self.install_middlewares()

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/core/SimpleFrame.py", line 1243, in install_middlewares

    m = self._sort_middlewares(settings.get('MIDDLEWARES', {}).values())

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/core/SimpleFrame.py", line 1292, in _sort_middlewares

    cls = import_attr(middleware_path)

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/utils/common.py", line 48, in import_attr

    mod, f = import_mod_attr(func)

  File "/home/other/uliweb_AIO/myproject/mydb/dbtracker/library/uliweb/utils/common.py", line 35, in import_mod_attr

    mod = __import__(module, fromlist=['*'])

  File "/home/other/uliweb_AIO/myproject/mydb/lib/python2.7/site-packages/gevent-1.1rc1-py2.7-linux-x86_64.egg/gevent/builtins.py", line 58, in __import__

    result = _import(*args, **kwargs)

ImportError: No module named middle_transaction

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAG2rzAmz1FE6uJx2VE3EZQ%2BXHj6to9Eh3V_ensVFPM2J9X2Z0Q%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

这个是怎么运行的？

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV9gY47pdTm2geD4mLjQmzmk6vHFkFTx5QUMyUB2E6oyfQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

[cnidance]

from uliweb import functions

from uliweb import manage

from uliweb.orm import *

#from uliweb.manage import make_simple_application

from uliweb.manage import make_application

path = os.path.dirname(os.path.abspath(__file__))

if path not in sys.path:

    sys.path.insert(0, path)

apps_dir = os.path.join(path, 'apps')

manage.call('uliweb syncdb')

#app = make_simple_application(project_dir='.')

application = make_application(apps_dir=apps_dir)

這樣跑起來的。

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg98Mo%2BB5%2B2kJw%3DJRm_PqZXZz7yfTan2TQjqGNX1dbRKGow%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

make_application调得晚了，把它放在from uliweb import manage之后，并且from uliweb.orm import *应该不需要吧

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV-yf3hVz1tH9Qvh4BJqWnj4GebmnFbJzemHr_uggmMtgg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[cnidance]

1. Linux 系統 使用UTC時間

2. apps/settings.ini

    TIME_ZONE = 'GMT +8'

     LOCAL_TIME_ZONE = 'GMT +0'

3. models.py

    time = Field(datetime.datetime, auto_now_add=True)

數據庫記錄的時間一樣是UTC時間，是不是設定有錯誤?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg9-WcKT7j%3DKayFMNfLHysdQTNiPmdJcuxP4VP%2Bn8Mvxktw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[Chunlin Zhang]

我猜这个跟unicode一样的 内部都保存uincode(utf8) 然后根据情况转成各种字符

时间这个内部都用utc,然后根据配置给客户端的时候转成需要的时间?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV_tj5xNwzZ1ThgDhXxToGg0xz3Wdar8Q3jm-gDq1Vs6iw%40mail.gmail.com.

[cnidance]

可能我沒說清楚

timezoe 的功能沒有被啟動?
ex: UTC時間為 20160119.011055 ， 應存入GMT +8 時間 20160119.091055

uliweb 對數據庫的datetime 字段，是在讀出時間才做timezone轉換? 還是寫入數據庫就轉換好timezone了?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAG2rzA%3DX5XJ68Fnfn2yT%3D2ddROAuBmNUXxHt%2B6ah9Edq8nMQ3g%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

要将 uliweb.contrib.timezone app添加进去才可以生效

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV_ykD5Mx%2Bdv9i9uCEpJQWuRJfg_%2BPj9-jnkQ_AOCzc7Gg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[SeedSeek]

from uliweb.manage import make_application

path = os.path.dirname(os.path.abspath(__file__))

if path not in sys.path:

    sys.path.insert(0, path)

apps_dir = os.path.join(path, 'apps')

application = make_application(apps_dir=apps_dir)

from uliweb import functions

from uliweb import manage

manage.call('uliweb syncdb')

manage.call('uliweb dbinit')

這樣跑起來還是報錯

ImportError: No module named middle_transaction

limodou於 2016年1月9日星期六 UTC+8上午7時45分59秒寫道：

[limodou]

是新工程还是老工程，另外uliweb的版本。因为orm的middlewares这块以前有点调整。

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/07c407f0-f126-46f9-af85-c524e7c2a3c6%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[cnidance]

__version__ = '0.5b'

在TCPServer 上，使用Uliweb ORM。

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg9802E9p0PTRtRbX%2BroNos3S7-WT9XVdkbnngwZtfhpoFQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

有没有一个可以简单测试的包？

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CAHLXMV_ROzJnq%3DBdN1i1ZW54WPv-hxC%3Dy3_tCvU_WEyozAL-%2Bw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

[SeedSeek]

這是簡單的測試包

https://drive.google.com/file/d/0B9xVqfk1kh8Oek5ZNDU1VzBFRHc/view?usp=sharing

現在還會出現另一個錯誤

MySQL server has gone away

limodou於 2016年1月20日星期三 UTC+8上午8時41分16秒寫道：

[limodou]

mysql gone away如果是因为长时间没有请求，可以在settings.ini中设置：

[ORM]
CONNECTION_ARGS = {'pool_recycle':7200}

pool_recycle表示连接池失效的时间，2个小时，只要比mysql的断开时间小就可以。

> https://groups.google.com/d/msgid/uliweb/37ca0cc9-2071-4810-a78a-1e6d97d3576c%40googlegroups.com.

[cnidance]

測試包裡面有設定，還是會報錯。

Traceback (most recent call last):

  File "/home/oth/uliweb/myproject/myOBD/OBDtracker/OBD_TCP.py", line 643, in handle

  File "/home/oth/uliweb/myproject/myOBD/OBDtracker/OBD_TCP.py", line 202, in _receiveBatch

  File "/home/oth/uliweb/myproject/myOBD/OBDtracker/OBD_TCP.py", line 268, in _receive

  File "library/uliweb/orm/__init__.py", line 3759, in save

    obj = do_(self.table.insert().values(**d), self.get_session())

  File "library/uliweb/orm/__init__.py", line 591, in do_

    result = conn.execute(query, *(args or ()))

  File "library/uliweb/orm/__init__.py", line 365, in execute

    return self.connection.execute(query, *args)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/base.py", line 914, in execute

    return meth(self, multiparams, params)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection

    return connection._execute_clauseelement(self, multiparams, params)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement

    compiled_sql, distilled_params

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/base.py", line 1146, in _execute_context

    context)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception

    exc_info

  File "build/bdist.linux-armv7l/egg/sqlalchemy/util/compat.py", line 200, in raise_from_cause

    reraise(type(exception), exception, tb=exc_tb)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/base.py", line 1139, in _execute_context

    context)

  File "build/bdist.linux-armv7l/egg/sqlalchemy/engine/default.py", line 450, in do_execute

    cursor.execute(statement, parameters)

  File "build/bdist.linux-armv7l/egg/MySQLdb/cursors.py", line 205, in execute

    self.errorhandler(self, exc, value)

  File "build/bdist.linux-armv7l/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler

    raise errorclass, errorvalue

OperationalError: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away') [SQL: u'INSERT INTO obdtrans (terminal_id, cmd_code, terminal_serial, paltform_serial, trans_code, threading, paltform_time, modified_time) VALUES (%s, %s, %s, %s, %s, %s, %s, %s)'] [parameters: ('20485454502f', '4554', '32', '', u'474554202f20485454502f312e310d0a486f73743a203136332e31372e31332e3234', u'Thread-3', datetime.datetime(2016, 2, 17, 10, 55, 47, 618270, tzinfo=<tzinfo GMT +8>), datetime.datetime(2016, 2, 17, 10, 55, 47, 618386, tzinfo=<tzinfo GMT +8>))]

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg9_EE8%3DBRJDcEm3aN69Yk1P_R%3D_PZYT5hW2e1R3xX7tVAQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

代码没有views.py没有入口

> https://groups.google.com/d/msgid/uliweb/CAHLXMV_6Xm1S_8qQ7ddsp2yfwdpHOSPf-q2G_a0rfZFXGzud%2Bg%40mail.gmail.com.

[cnidance]

touch views.py

增加一個空的檔案，也會報錯

Traceback (most recent call last):

  File "OBD_TCP.py", line 47, in <module>

    application = make_application(apps_dir=apps_dir)

  File "library/uliweb/manage.py", line 135, in make_application

    **dispatcher_kwargs)

  File "library/uliweb/core/SimpleFrame.py", line 582, in __init__

    self.init(project_dir, apps_dir)

  File "library/uliweb/core/SimpleFrame.py", line 636, in init

    Dispatcher.middlewares = self.install_middlewares()

  File "library/uliweb/core/SimpleFrame.py", line 1243, in install_middlewares

    m = self._sort_middlewares(settings.get('MIDDLEWARES', {}).values())

  File "library/uliweb/core/SimpleFrame.py", line 1292, in _sort_middlewares

    cls = import_attr(middleware_path)

  File "library/uliweb/utils/common.py", line 48, in import_attr

    mod, f = import_mod_attr(func)

  File "library/uliweb/utils/common.py", line 35, in import_mod_attr

    mod = __import__(module, fromlist=['*'])

ImportError: No module named middle_transaction

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg98c9n4nRABPXy6ziffkoCRM8KLWh-4bUQxvuzW%2B0Mvc8g%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

因为那两个middleware已经放到uliweb.contrib.orm中了，位置变了。而且transcation这个middle是缺省配置了，可以看uliweb/contrib/orm/settings.ini。所以这个可以不用配置。

> https://groups.google.com/d/msgid/uliweb/CAHLXMV8RF7FfDXgH6bGTBdQH_r3Ao4-Hjd8kks0CpxwiBvWGpA%40mail.gmail.com.

[cnidance]

原來是位置變更了。

另一個報錯。

在settings.ini 已經配置這樣了，還是會報錯。

[ORM]

CONNECTION_ARGS = {'pool_recycle':7200}

錯誤內容

OperationalError: (_mysql_exceptions.OperationalError) (2006, 'MySQL server has gone away')

報錯是因為沒有正常回收嗎?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg9-9fFW9ZcZ6SdNN%3DmrxnZS5kG%3D2JHOQnu-GUtNiJd51nQ%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

我执行不了你的代码，不太清楚是什么原因。连接超时只是 mysql server has gone away
的一种情况，有些sql超出缓冲区大小好象也有这样的错误，比如一次提交太多的数据。

> https://groups.google.com/d/msgid/uliweb/CAHLXMV-CGbu4t2SxsBUgYAC8KwS7BrwzZCWvnc6ESmVFu5aMrQ%40mail.gmail.com.

[cnidance]

我修改了一些原本的代碼，可以執行。

https://drive.google.com/file/d/0B9xVqfk1kh8ObnYzZm5ucEdyYWM/view?usp=sharing

我這邊測試是超時後的處理報錯，不是提交太多數據。

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg99apAj%2Ba8SEQqTWAk7JTNeg_OJ9exjvqyFPqs4n3Y5VFg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

还是代码不全，没有list的模板。

> https://groups.google.com/d/msgid/uliweb/CAHLXMV9gScwKnvnZNm7BQQdAbmFM%2B4BXW5ajouJR9S1zcBYBUQ%40mail.gmail.com.

[cnidance]

ORM對MYSQL超時的回收機制，與list 模板有關係?

To view this discussion on the web visit https://groups.google.com/d/msgid/uliweb/CADCtg99q8YkHf6cfvqipzLQV%2BqO03GmrmTjGWmHr9ymvV-zKdA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

--

~Ten ~

[limodou]

因为你的代码跑得有问题，看不到错误。

> https://groups.google.com/d/msgid/uliweb/CAHLXMV_LBMTS2jeWttPr2xpY-AuGa5O6GwraEHcPse4AMWxThA%40mail.gmail.com.