def __init__(self, name, db=None, uid=UID, kwargs=None):
"""
:param name: NAME FOR THIS TABLE
:param db: THE DB TO USE
:param uid: THE UNIQUE INDEX FOR THIS TABLE
:return: HANDLE FOR TABLE IN db
"""
global _config
if db:
self.db = db
else:
self.db = db = Sqlite()
if not _config:
# REGISTER sqlite AS THE DEFAULT CONTAINER TYPE
from jx_base.container import config as _config
if not _config.default:
_config.default = {"type": "sqlite", "settings": {"db": db}}
self.sf = Snowflake(fact=name, uid=uid, db=db)
self._next_guid = generateGuid()
self._next_uid = 1
self._make_digits_table()
self.uid_accessor = jx.get(self.sf.uid)
def create_or_replace_facts(self, fact_name, uid=UID):
"""
MAKE NEW TABLE, REPLACE OLD ONE IF EXISTS
:param fact_name: NAME FOR THE CENTRAL INDEX
:param uid: name, or list of names, for the GUID
:return: Facts
"""
self.remove_facts(fact_name)
self.ns.columns._snowflakes[fact_name] = ["."]
if uid != UID:
Log.error("do not know how to handle yet")
command = sql_create(fact_name, {UID: "INTEGER PRIMARY KEY", GUID: "TEXT"}, unique=UID)
with self.db.transaction() as t:
t.execute(command)
snowflake = Snowflake(fact_name, self.ns)
return Facts(self, snowflake)
def create_or_replace_facts(self, fact_name, uid=UID):
"""
MAKE NEW TABLE WITH GIVEN guid
:param fact_name: NAME FOR THE CENTRAL FACTS
:param uid: name, or list of names, for the GUID
:return: Facts
"""
self.remove_snowflake(fact_name)
self._snowflakes[fact_name] = ["."]
uid = listwrap(uid)
new_columns = []
for u in uid:
if u == UID:
pass
else:
c = Column(name=u,
jx_type=mo_json.STRING,
es_column=typed_column(
u, json_type_to_sql_type[mo_json.STRING]),
es_type=json_type_to_sqlite_type[mo_json.STRING],
es_index=fact_name,
last_updated=Date.now())
self.add_column_to_schema(c)
new_columns.append(c)
command = ("CREATE TABLE " + quote_column(fact_name) + sql_iso(
sql_list([quoted_GUID + " TEXT "] + [quoted_UID + " INTEGER"] + [
quote_column(c.es_column) + " " + c.es_type
for c in new_columns
] + [
"PRIMARY KEY " + sql_iso(
sql_list([quoted_GUID] + [quoted_UID] +
[quote_column(c.es_column) for c in new_columns]))
])))
with self.db.transaction() as t:
t.execute(command)
snowflake = Snowflake(fact_name, self)
return Facts(self, snowflake)
def get_snowflake(self, fact_name):
return Snowflake(fact_name, self)
def get_schema(self, fact_name):
return Schema(".", Snowflake(fact_name, self))
def get_facts(self, fact_name):
snowflake = Snowflake(fact_name, self)
return Facts(self, snowflake)