logica

logica copied to clipboard

Make programs run on Microsoft SQL server.

EvgSkv

Documentation on -> operator

2

The tutorial uses at one point the `->` operator. ``` # Finding most popular name for each year. @OrderBy(TopNameByYear, "year"); TopNameByYear(year) ArgMax= name -> NameCountByYear(name:, year:); ``` While this seems...

tel

FileNotFoundError: [Errno 2] No such file or directory: 'bq'

3

Whenever example command `logica primes.l run Prime` is executed, error is produced: `FileNotFoundError: [Errno 2] No such file or directory: 'bq'` It happens in docker container ubuntu:latest with python3.8.5 installed...

ryptozee

Hi @EvgSkv , When working with Logica scripts across multiple cells, I've identified a potential enhancement (unless it's already implemented). For comparison, in Jupyter, when executing an SQL query, I...

yilinxia

Databricks SQL support

10

Based on recent work for clients, I for one would think support for [Databricks SQL](https://www.databricks.com/product/databricks-sql) would be a huge deal. Seems to be used a little bit of everywhere. I...

samuell

Graph did not work

1

I am using the current packages within Python 3.11.3 conda env ``` logica == 1.3.141592 graphviz == 0.20.1 jupyterlab == 3.5.3 ``` and I want to execute ``` from logica.common...

yilinxia

Re-digest predicates from DB

4

I tried to pass one predicate to another with the following scripts on local PC ``` %%logica Child @Engine("sqlite"); @AttachDatabase("mydata", "my_database.db"); @Dataset("ParentTable"); Parent(..r) :- mydata.ParentTable(..r); Child(x):- Parent(child:x); ``` The Child...

yilinxia

Too many references to "advised": max 65535

3

Hi, When running the following script ``` %%logica Lowest_Common_Ancestors_with_Name @Engine("sqlite"); @AttachDatabase("mgdb","mgdb.db"); @Dataset("advised"); @Dataset("person"); @Dataset("dissertation"); Adv_Stu(advisor:, student:author) :- Advised(did:x, advisor:),Dissertation(did:y, author:), x=y; @Recursive(Anc,33); Anc(ancestor:advisor, student:m) distinct :- Adv_Stu(advisor:, student:m), m=63244; Anc(ancestor:x,...

yilinxia

Engineers example broken under sqlite

1

Code: %%logica Engineers @Engine("sqlite"); Employee(name: "Alice", role: "Product Manager"); Employee(name: "Bob", role: "Engineer"); Employee(name: "Caroline", role: "Engineer"); Employee(name: "David", role: "Data Scientist"); Employee(name: "Eve", role: "Data Scientist"); Engineers(..r) :- Employee(..r),...

emiruz

EvgSkv