将不断更新的SQLite3数据库转换为Drupal站点 [英] Converting constantly updated SQLite3 db into Drupal site
问题描述
我有一个不断更新的SQLite3数据库,用于记录游戏数据。一个
牌桌用于游戏信息,另一个
牌桌用于游戏中的事件,而
牌桌的第三者用于玩家信息,包括谁输了谁:
I have a constantly updated SQLite3 db that records game data. One table for game information, another for events in a game, and the third for player information, including who won/lost:
< a href = http://schema.ccgames.db.94y.info/ rel = nofollow> http://schema.ccgames.db.94y.info/ (模式)
http://ccgames.db.94y.info/(任意只读查询)
我想创建一个具有三种内容类型的Drupal站点(每个
表一个),并在其中为每个记录创建一个节点每个表。
I want to create a Drupal site with three content-types (one for each table) and a node for each record in each table.
我知道导入节点,但这是一次性的事情。如何
保持我的Drupal节点与SQLite3数据库保持同步?
I know about "Import Node", but that's a one-time thing. How can I keep my Drupal nodes constantly in sync w/ my SQLite3 db?
我要导入到Drupal的某些功能:
Some of the functionality I'm trying to import to Drupal:
我玩过的游戏:< a href = http://798d4dab518a91787e0e0be5c94f8bb1.ccgames.db.94y.info/ rel = nofollow> http://798d4dab518a91787e0e0e5be94c94f8bb1.ccgames.db.94y.info/
赢/赔: http://57442d9ce4c5063869883519f2a9cd0f.ccgames.db.94y。 info /
点历史记录: http://9160fe29e3da336652ec98fbf7f2aeef.ccgames.db.94y.info/
团队游戏: http://a782c6b9be09f375e5f1b1d69f1e7c62.ccgames.db.94y.info/
我有很多可以在ccgames.db.94y.info上使用,但是很丑陋,
不允许使用通配符。
I have a lot of this working on ccgames.db.94y.info, but it's ugly and doesn't allow wildcarding.
推荐答案
如果我没记错的话,可以使用迁移模块以将数据连续导入Drupal。
If I remember correctly you can use The Migrate module to contiously import data into Drupal. Just set it up and it will import on cron.
其他可能的导入替代方法可能是 Feeds 模块-您可以为其创建自定义数据源,从而可以创建连接到SQLite数据库的对象。
Other possible alternatives for import might be the Feeds module - you can create custom data sources for it and thus can create something that connects to a SQLite database.
最后-您不一定总是需要将内容导入Drupal才能使用。 视图3 支持可插入查询处理程序-因此可以为您的SQLite数据库创建查询处理程序并创建使用该视图。这样做将需要最多的编码,因此我将首先尝试迁移。
Lastly - you don't always need to import stuff into Drupal to use it. Views 3 supports pluggable query handlers - so it would be possible to create a query handler for your SQLite database and create Views using that. Doing that would require the most coding though so I would try Migrate first.
这篇关于将不断更新的SQLite3数据库转换为Drupal站点的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!