text:
Add CSV option

We've got to the stage where our jobs are big enough that Redshift loads are becoming a major bottleneck with its AVRO performance problems. We're hoping Amazon will fix them, but in the mean time we've started running with a modified spark-redshift to allow us to import via CSV (Redshift COPYs are running at least 5 times faster with this for us).
It's probably not a good idea to merge this in at the moment - I'm not sure how robust it is to different data types / unusual characters in strings etc., and it would at least need some tests and documentation. And hopefully Amazon will soon fix AVRO import making it unnecessary anyway. But I thought I'd share my changes in case they are useful to anyone else.

Current coverage is 75.07%

Merging #165 into master will decrease coverage by -13.99% as of ed40281

@@            master    #165   diff @@
======================================
  Files           13      13
  Stmts          649     662    +13
  Branches       144     146     +2
  Methods          0       0
======================================
- Hit            578     497    -81
  Partial          0       0
- Missed          71     165    +94

Review entire Coverage Diff as of ed40281

Powered by Codecov. Updated on successful CI builds.

Thanks for sharing. I'm glad to see that this was a relatively small change.
I agree that it's probably best to wait and see if Amazon speeds up Avro ingest; let's wait a couple of months and re-assess this feature later if there's significant interest / demand.

authors: JoshRosen codecov-io emlyn

repo: databricks/spark-redshift


text:
SQL Error: ОШИБКА:  нет прав для изменения параметра "session_replication_role"

Hello, Maxim!
There is problem (in subject) that I can't understand.
Also I can't find default mechanism of authentication without password (under 'postgres' user)
Here is listing:
root@someserver:~# perl pgcompacttable.pl -U someuser -W somepass -d somedb -t history -v
[Fri Aug 18 09:39:02 2017] (somedb) Connecting to database
[Fri Aug 18 09:39:02 2017] (somedb) Postgress backend pid: 8163
Wide character in print at pgcompacttable.pl line 187.
[Fri Aug 18 09:39:02 2017] (somedb) SQL Error: ОШИБКА:  нет прав для изменения параметра "session_replication_role"
[Fri Aug 18 09:39:02 2017] (somedb) Database handling interrupt.
[Fri Aug 18 09:39:02 2017] (somedb) Disconnecting from database
[Fri Aug 18 09:39:02 2017] Processing incomplete: 1 databases left.
Best regards,
Vladimir

There is a method to authenticate without password using -h /path/to/unix/socket/dir (usually /tmp or somthing like /var/run/postgresql) under postgres user. Not very convenient, I agree.
For changing session_replication_role you have to be superuser - this setting is used to disable all triggers in session so DB won't have to do additional (and potentially dangerous) work when pgcompacttable performing fake updates.

Please add next to your code, to prevent 'Wide character in print at' error message.

#!/usr/bin/perl
use strict;
use utf8;
binmode(STDOUT,':utf8');

Alexius2,
Explain please what do you mean here:
For changing session_replication_role you have to be superuser
Because I run my 'perl pgcompacttable.pl.....' with root. :)
My first message was "....root@someserver:~#...."

default superuser in db is postgres. so to connect as superuser need to switch to postgres OS user and connect via unix socket or set password to postgres user and connect with -U postgres or set authentication method to trust in pg_hba if it's local/test machine.

Dear Alexius2,
Thanks a lot, it works for me!
IMHO, this hint should be written in --man. (about -h parameter and socket path)
also I was needed to enable pgstattuple, and it was first time I faced with, so please AUTHOR, if you're reading this - add some more info about how to use.
Some kind like this:
If you're not sure about pgstattuple was installed do this:
su - postgres
psql
\c
create extension pgstattuple;
Best regards!
Vladimir

source: gharchive/issue

repo: dataegret/pgcompacttable

license_type: permissive

license_source: github-api


text:
Correction for raw affiliation Univ Rennes, École Nationale Supérieure de Chimie de Rennes, CNRS, ISCR – UMR6226, F-35000 Rennes, France

Correction needed for raw affiliation Univ Rennes, École Nationale Supérieure de Chimie de Rennes, CNRS, ISCR – UMR6226, F-35000 Rennes, France
raw_affiliation_name: Univ Rennes, École Nationale Supérieure de Chimie de Rennes, CNRS, ISCR – UMR6226, F-35000 Rennes, France
new_rors: 01h0ffh48;015m7wh34;02feahw73;00adwkx90
previous_rors: 01h0ffh48;015m7wh34;02feahw73
works_examples: W4376126242;W4311302651;W4319311796;W4384153568
contact: 36a74fcd2bbf761168ab07c929a31b5b:326f7a3655c754b0818cd9cbacbcb493 @ univ-rennes.fr

This issue was accepted and ingested by the OpenAlex team on 2024-10-10. The new affiliations should be visible within the next 7 days.

repo: dataesr/openalex-affiliations

license: MIT


text:
Correction for raw affiliation Canadian Rivers Institute, Fredericton, NB, Canada, E3B 5A3; School of Environment and Sustainability, University of Saskatchewan, Saskatoon, SK, Canada, S7N 5C8

Correction needed for raw affiliation Canadian Rivers Institute, Fredericton, NB, Canada, E3B 5A3; School of Environment and Sustainability, University of Saskatchewan, Saskatoon, SK, Canada, S7N 5C8
raw_affiliation_name: Canadian Rivers Institute, Fredericton, NB, Canada, E3B 5A3; School of Environment and Sustainability, University of Saskatchewan, Saskatoon, SK, Canada, S7N 5C8
new_rors: 010x8gc63;05nkf0n29
previous_rors: 010x8gc63
works_examples: W3035374088
contact: 96f5c8d7bcc1169187bc3130133af506:08c5533f @ ourresearch.org

This issue was accepted and ingested by the OpenAlex team on 2024-10-10. The new affiliations should be visible within the next 7 days.


text:
Correction for raw affiliation CNRS, ENSL, INRI A, UCBL, Univ. Lyon, Lab. LIP (UMR 5668), École Normale Supérieure de Lyon, LIP, 46 allée d'Italie, 69364 Lyon Cedex 07, France

Correction needed for raw affiliation CNRS, ENSL, INRI A, UCBL, Univ. Lyon, Lab. LIP (UMR 5668), École Normale Supérieure de Lyon, LIP, 46 allée d'Italie, 69364 Lyon Cedex 07, France
raw_affiliation_name: CNRS, ENSL, INRI A, UCBL, Univ. Lyon, Lab. LIP (UMR 5668), École Normale Supérieure de Lyon, LIP, 46 allée d'Italie, 69364 Lyon Cedex 07, France
new_rors: 02feahw73;04zmssz18;029brtt94;04msnz457
previous_rors: 02feahw73;04zmssz18;029brtt94
works_examples: W2118926140
contact: 3a668eebbfc087bfccde57b6535e3cf8:57108dd118b95fe9668c0d5e860a @ ens-lyon.fr

This issue was accepted and ingested by the OpenAlex team on 2024-12-19. The new affiliations should be visible within the next 7 days.


text:
Migrate SQLFederationOptimizerRule to OptimizerRule::rewrite

DataFusion 40 changed the OptimizerRule format, ref apache/datafusion#9954. We'll need to migrate over.

We did the migration in this PR #64


text:
HitTriage

Workflow:

[ ] Ingestion
[ ] Enrichment
[ ] Filtering
[ ] Submission

This issue has been mirrored in Jira: https://reddata.atlassian.net/browse/GROK-14812

This issue has been mirrored in Jira: https://reddata.atlassian.net/browse/GROK-16071

authors: dnillovna skalkin

repo: datagrok-ai/public


text:
The sqlalchemy recipe for DB2 source is not respecting schema/table allow / deny pattern

Describe the bug
When using a sqlalchemy based recipe to fetch metadata from Db2 source , the schema / table pattern information provided is not being used. All the tables metadata is being fetched.
To Reproduce
source:
type: sqlalchemy
config:
connect_uri: "db2+ibm_db://:<my-password@host:port/"
platform: "DB2-ZOS"
table_pattern:
allow:
- "schema".<table_name>"
sink:
type: "console"
Additional context
I am using python:3.8.10 docker image with ibm_db and ibm_db_sa python libraries installed.

The allow/deny patterns use regexes - could that possibly be the issue?
It's hard to diagnose given that the recipe above has been anonymized, but logs when run with datahub --debug ingest ... would be helpful.

Hey @SwadX - did you figure this one out?

Closing due to inactivity. Please open new issue if issue persists with latest releases

authors: SwadX anshbansal hsheth2

repo: datahub-project/datahub


text:
Change documentation for curl command that creates a user group

Describe the bug
A clear and concise description of what the bug is.
When using the curl command to create a user group taking from the datahub documentation it fails as raised in  #5161.
The issue was identiefied changing (corpUser -> corpuser) but the documentation was updated.
The correct command should be
curl 'http://localhost:8080/entities?action=ingest' -X POST --data '{
   "entity":{
      "value":{
         "com.linkedin.metadata.snapshot.CorpGroupSnapshot":{
            "urn":"urn:li:corpGroup:dev",
            "aspects":[
               {
                  "com.linkedin.identity.CorpGroupInfo":{
                     "email":"dev@linkedin.com",
                     "admins":[
                        "urn:li:corpuser:jdoe"
                     ],
                     "members":[
                        "urn:li:corpuser:datahub",
                        "urn:li:corpuser:jdoe"
                     ],
                     "groups":[

                     ]
                  }
               }
            ]
         }
      }
   }
}'

I can probably change this myself however adding it here in case I'd forget


text:
feat(ingestion/sql-common): add column level lineage for external tables

Checklist

[ ] The PR conforms to DataHub's Contributing Guideline (particularly Commit Message Format)
[ ] Links to related issues (if applicable)
[ ] Tests for the changes have been added/updated (if applicable)
[ ] Docs related to the changes have been added/updated (if applicable). If a new feature has been added a Usage Guide has been added for the same.
[ ] For any breaking change/potential downtime/deprecation/big changes an entry has been made in Updating DataHub

The SqlParsingAggregator has a add_known_lineage_mapping that generates CLL based on the schema of the downstream. Ideally we'd centralize on using that as the external lineage mechanism.
Long term, I want to move sql_common.py to use the SqlParsingAggregator instead of the older SqlParsingBuilder. Internal ticket tracking that - https://linear.app/acryl-data/issue/ING-779/refactor-move-sql-common-to-use-sqlparsingaggregator
In the short term, I'm ok with having this CLL generation logic, although all the complexity of the simplify_field_path logic worries me a bit on this PR.

Now that https://github.com/datahub-project/datahub/pull/12220 has been merged, we can make this implementation be a bit cleaner.

source: gharchive/pull-request


text:
feat: add chart entities to similar browsepath as dashboards

If the ingested workspaces have multiple reports in them, usually the result is that there are a ton of ingested chart entities. Although common use case might not be to find report or datasource of a report by finding the chart first, I think it makes sense to expand similar behavior of browsepaths as the current implementation has on dashboards.
Checklist

[ ] The PR conforms to DataHub's Contributing Guideline (particularly Commit Message Format)
[ ] Links to related issues (if applicable)
[ ] Tests for the changes have been added/updated (if applicable)
[ ] Docs related to the changes have been added/updated (if applicable). If a new feature has been added a Usage Guide has been added for the same.
[ ] For any breaking change/potential downtime/deprecation/big changes an entry has been made in Updating DataHub

Thanks for the PR @looppi ! We are reviewing on our side. On the surface looking good


text:
Adjusting pyopenephys requirement for pypi publication

In this PR, I update the pyopenephys to reflect our merged PR and pypi publication.

Thanks @CBroz1!  Now that the requirements.txt are fixed, please make a release of version 0.2.3 so that we can get an updated version of element-array-ephys published to PyPI.

repo: datajoint/element-array-ephys


text:
Test release

test

datalens-ui 0.1741.0
datalens-us 0.209.0

First e2e check, failed:
✘  311 [basic] › suites/wizard/export/pivotTable.test.ts:36:17 › Wizard - export. Summary table › CSV (retry #1) (15.3s)
✘  325 [basic] › suites/wizard/geolayer/geopoints/addTooltip.test.ts:10:17 › Wizard - Geo Points › Tooltip appearance (retry #1) (13.7s)

repo: datalens-tech/datalens-ui


text:
"Error: {equatiomatic} only supports models where each random effect has a corresponding fixed effect."

Hi, I am having an issue trying to use equatiomatic with lme4, please see below:
d =
  dplyr::tribble(
  ~study, ~treat, ~n, ~event, ~control,
  1, 0, 377, 113, 1,
  1, 1, 377, 128, 0,
  2, 0, 40, 4, 1,
  2, 1, 41, 6, 0,
  3, 0, 100, 20, 1,
  3, 1, 101, 22, 0,
  4, 0, 1010, 201, 1,
  4, 1, 1001, 241, 0
)

m1 =
  lme4::glmer(
  cbind(event, n - event) ~ 1 + factor(treat) + (control + treat - 1|study),
  data=d,
  family=binomial(link="logit"))

summary(m1)

equatiomatic::extract_eq(m1)

I get this error message: Error: {equatiomatic} only supports models where each random effect has a corresponding fixed effect. You specified the following variables as randomly varying without including the corresponding fixed effect: control, treat
Would it be possible to add support for this type of model?
Thanks!

Hi! I see. The model was extracted from this article, section: "Model 6: the “Van Houwelingen bivariate” model".
Honestly, I am an inexperienced medical student, so I am not sure I can be of any help, but the article above describes the model.

Thanks, I'll take a look and see if I can figure it out.

authors: arthur-albuquerque datalorax

repo: datalorax/equatiomatic


text:
influxdb duplicate field stored

I write a kcql like insert into record select * from record WITHTAG (ptype, pid).
when I run this and look at the data in the influxdb, there exists two field ptype and ptype_1, pid and pid_1, ptype and pid is tag, ptype_1 and pid_1 is not, why should the duplicate ptype_1 and pid_1 should be stored? Is there any way to avoid this?

We don't duplicate the field names. we will investigate the issue.

thank you, I use the stream-reactor-0.2.4-3.1.1.tar.gz package, use the following config in confluent connect config.
key.converter=org.apache.kafka.connect.json.JsonConverter value.converter=org.apache.kafka.connect.json.JsonConverter key.converter.schemas.enable=false value.converter.schemas.enable=false
kafa-version: kafka_2.11-0.10.2.0
jre:1.8.0
influxdb 1.2.0

@iyuq
i can confirm we don't actually duplicate the item. i have been trying to get to the influxdb code where they would do this but i can't find it. But let's go over what you want to do, because i have a pretty good idea what's happening.
You have a row with columnd ptype,pid and then you want to add the same names as a tag. Think of the database where you have a query, joining two tables, and returning the same field table1.A, table2.A. If you run that in rdbms you will always see the second one returned as A_1. So here they would, most likely do the same thing. so how about you check 'show tag values ...' to only look at the tags.
To be honest, i don't see the value of adding the tags which are a copy of the fields already. why would you duplicate data, plus in this case is not a tag. if you want to have those fields as tags you do: SELECT * FROM record IGNORE ptype, pid WITHTAG(ptype, pid).
Hope this helps.

I haved tried this, but got the following error instead.
[2017-03-27 13:10:56,146] INFO InfluxSinkConfig values:
        connect.influx.connection.database = mydb
        connect.influx.connection.password = [hidden]
        connect.influx.connection.url = http://localhost:8086
        connect.influx.connection.user = root
        connect.influx.consistency.level = ALL
        connect.influx.error.policy = THROW
        connect.influx.max.retires = 20
        connect.influx.retention.policy = autogen
        connect.influx.retry.interval = 60000
        connect.influx.sink.kcql = INSERT INTO record SELECT * FROM record IGNORE ptype, pid WITHTAG (ptype, pid) WITHTIMESTAMP time
 (com.datamountaineer.streamreactor.connect.influx.config.InfluxSinkConfig:180)
[2017-03-27 13:10:56,146] INFO Sink task WorkerSinkTask{id=influx-record-sink-0} finished initialization and start (org.apache.kafka.connect.runtime.WorkerSinkTask:222)
[2017-03-27 13:10:56,251] INFO Discovered coordinator localhost:9092 (id: 2147483647 rack: null) for group connect-influx-record-sink. (org.apache.kafka.clients.consumer.internals.AbstractCoordinator:555)
[2017-03-27 13:10:56,251] INFO Revoking previously assigned partitions [] for group connect-influx-record-sink (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:333)
[2017-03-27 13:10:56,252] INFO (Re-)joining group connect-influx-record-sink (org.apache.kafka.clients.consumer.internals.AbstractCoordinator:381)
[2017-03-27 13:10:56,254] INFO Successfully joined group connect-influx-record-sink with generation 363 (org.apache.kafka.clients.consumer.internals.AbstractCoordinator:349)
[2017-03-27 13:10:56,255] INFO Setting newly assigned partitions [record-0] for group connect-influx-record-sink (org.apache.kafka.clients.consumer.internals.ConsumerCoordinator:225)
[2017-03-27 13:10:56,259] ERROR Task influx-record-sink-0 threw an uncaught and unrecoverable exception (org.apache.kafka.connect.runtime.WorkerSinkTask:404)
java.lang.IllegalArgumentException: ptype can't be found on the values list:ip,bit,ua,browser,os,query,deviceType,agent,resolution,origin,cookieEnabled,region,time,title,lang,sid,device
        at com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$$anonfun$fromMap$1$$anonfun$apply$4.apply(TagsExtractor.scala:52)
        at com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$$anonfun$fromMap$1$$anonfun$apply$4.apply(TagsExtractor.scala:52)
        at scala.collection.MapLike$class.getOrElse(MapLike.scala:128)
        at scala.collection.AbstractMap.getOrElse(Map.scala:59)
        at com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$$anonfun$fromMap$1.apply(TagsExtractor.scala:52)
        at com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$$anonfun$fromMap$1.apply(TagsExtractor.scala:49)
        at scala.collection.immutable.Stream.foldLeft(Stream.scala:610)
        at com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$.fromMap(TagsExtractor.scala:49)
        at com.datamountaineer.streamreactor.connect.influx.writers.InfluxBatchPointsBuilderFn$$anonfun$6.apply(InfluxBatchPointsBuilderFn.scala:126)
        at com.datamountaineer.streamreactor.connect.influx.writers.InfluxBatchPointsBuilderFn$$anonfun$6.apply(InfluxBatchPointsBuilderFn.scala:117)
        at scala.Option.map(Option.scala:146)

@iyuq ptype is not  a field in the message schema ptype can't be found on the values list:ip,bit,ua,browser,os,query,deviceType,agent,resolution,origin,cookieEnabled,region,time,title,lang,sid,device

@andrewstevenson @stheppi  I am not using the schema message, I am using the json message without schema, I'm sure it's a bug now, I have the following test using the influx-java-client
Point point1 = Point.measurement("cpu")
      .time(System.currentTimeMillis(), TimeUnit.MILLISECONDS)
      .tag("atag", "a")
      .addField("atag", "a")
      .addField("idle", 90L)
      .addField("user", 9L)
      .addField("system", 1L)
      .build();

and I got a atag and atag_1 in the cpu measurements, so you guys must add the tag field both in .tag and .addField method.

We are doing as you instructed via KCQL, nothing more nothing less.
First:" Select *"=> this picks up all the fields and will result in an addField.
Then you say  "withtag(ptype) "=> translates in addTag. So the code does what it was instructed in the KCQL. Therefore is not a bug. What i suggested with ignoring fields  should be the way to go in your case bit seems we have to relax the validation rules( which i thought we did already).
If you know all your fields you can configure KCQL like: Insert into record select field1,field2,.. from record withtag(ptype,pid)

But the code will throw an error when the tags field not in the select field list, that's the problem, as I    said before. So when I use select * from record withtag(ptype, pid), i will get two duplicate field, when I use select * from record IGNORE ptype, pid withtag(ptype, pid), just the same as Insert into record select field1,field2,.. from record withtag(ptype,pid), I got the error java.lang.IllegalArgumentException: ptype can't be found on the values list:ip,bit,ua,browser,os,query,deviceType,agent,resolution,origin,cookieEnabled,region,time,title,lang,sid,device, either case I can't get what I actual wanted. So if this is the bug, so the check field and throw error must be a bug. @stheppi

@iyuq Are you sure that you have ptype, consistently in your json for every message?

@iyuq We'll certainly relax the checking of ignored columns being present in the message, it's shouldn't be an error but a warning.

@andrewstevenson yeah, I'm pretty sure about that. For when I add ptype in the select fields, the error disapeared. I will have someone who knows scala to have a look at the code, thank you all for your help.

@andrewstevenson you were right all along. the stack and error clearly shows the ptype is not present in the json payload!!
I am updating the code to avoid the error and just add a big warning.

@iyuq : you would need to take the latest and build it yourself before we release the next version. the code has been changed to avoid throwing exceptions if the tag is not present (like in your case).

@stheppi @andrewstevenson  thank you!

@stheppi I build the new version and find out it is not what I need either. The influx tag is like a field with index, the new version will not throw a error, but also can not insert the tag to the influxdb. I got the following error message:
[2017-03-28 17:26:17,236] WARN Tag can't be set because field:ptype can't be found or is null on the incoming value. topic=record;partition=0;offset=38 (com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$:79)
[2017-03-28 17:26:17,237] WARN Tag can't be set because field:pid can't be found or is null on the incoming value. topic=record;partition=0;offset=38 (com.datamountaineer.streamreactor.connect.influx.writers.TagsExtractor$:79)

I think the correct way is to extact the field in the select field join the tag field from message, then add field of select field exclude the tag field to builder and add tag in the tag field to the builder.

I am not  following what you said at all.
Let me explain kcql because i think it adds value.
'Withtag field1'=> means the code looks at the payload for field1 and adds it to the the influxdb point as a tag.
From your message field1 doesn't exist in the kafka message value.
Are those two fields:ptype and pid part of the kafka message key ? If so, we have no support for such extraction at the moment.

@stheppi ptype and pid is just the same as other fields, they are the field key of the kafka message json field, not the kafka message key.

Well i can tell you we pick them up if they are present in the json message. It looks like they are not. Look at the 38th message on your topic and you see they are not there.

What I find out is only the field in the select field will extract from the message, which I think is a bug,  the tag fields should also be picked up.

@stheppi  connect.influx.sink.kcql = INSERT INTO record SELECT * FROM record IGNORE ptype, pid WITHTAG (ptype, pid) WITHTIMESTAMP time

@iyuq Can you dump the 38th message from Kafka via the console consumer and post the message becuase as @stheppi ptype and pid are not in the payload.

okay, here is all my message.
{"time":1490340519980,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346078493,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346569624,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490423927960,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424086196,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424259157,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424604375,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490425087586,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490339822519,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490340519980,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346078493,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346569624,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490423927960,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424086196,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424259157,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424604375,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490425087586,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490591217743,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490591734702,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490339822519,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490340519980,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346078493,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490346569624,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490423927960,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424086196,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424259157,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490424604375,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490425087586,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490591217743,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490591734702,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490689409863,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490689541088,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490690792524,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490692116790,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490692147188,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490692269944,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490692363992,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490692622596,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}
{"time":1490693176034,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}

the 38th message is
{"time":1490692622596,"sid":"SymvD4Ghg","ptype":"lp","pid":"B1xHp7f3e","origin":"https://p.hecaila.com/l/B1xHp7f3e","resolution":"1440x900","bit":"24-bit","lang":"zh-CN","cookieEnabled":1,"title":"未项目","ua":"Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.110 Safari/537.36","ip":"0.0.0.0","query":"ck\u003d1\u0026ln\u003dzh-CN\u0026cl\u003d24-bit\u0026ds\u003d1440x900\u0026tt\u003d%E6%9C%AA%E9%A1%B9%E7%9B%AE\u0026u\u003dhttps%3A%2F%2Fp.hecaila.com%2Fl%2FB1xHp7f3e\u0026tp\u003dlp\u0026id\u003dB1xHp7f3e\u0026rnd\u003d620884\u0026p\u003d0\u0026t\u003d0","region":"上海","browser":"Chrome","device":"Apple Macintosh","os":"Mac OS X 10.12.3","agent":"Chrome","deviceType":"Desktop"}

@stheppi  The problem fixed after your today's commit, thank you very much for helping me. Sorry to tell that I get another problem, the WITHTIMESTAMP doesn't take effect and the system_time used instead.

it is the order in KCQL:
SELECT * FROM $topic IGNORE ptype, pid WITHTIMESTAMP time WITHTAG (ptype, pid)

@stheppi Thank you!

authors: andrewstevenson iyuq stheppi

repo: datamountaineer/stream-reactor

license_source: bigquery


text:
Problem with copying generated columns

Anonymizer throws error when dealing with table with generated columns
Error: db error: ERROR: column "tsv" is a generated column
DETAIL: Generated columns cannot be used in COPY.
pg_dump on its own works fine.
postgresql and pg_dump version is 12.12
pg_datanymizer version is 0.6.0

@ruslan-kurbanov-jr Thanks, It's interesting problem... We'll research it as soon as possible.
The main approach we use is to replace COPY stage in the dump... We'll see how pg_dumper uses it when working with similar columns.

i just ran in to this problem as well. Is there a solution?
pg_dump (PostgreSQL) 16.0
pg_datanymizer version is 0.6.0

A workaround approach for this could be to create a view of the table and dump that instead (using table filters). Do a find and replace on the dump file before importing to rename the view to the table name.
It seems like PG is supposed to work if the dump value for the generated column is default: https://stackoverflow.com/questions/64600614/restoring-pg-database-from-dump-fails-due-to-generated-columns

Tried adding the --inserts pg_dump argument but it still used COPY. I was hoping that since the error specifically mentioned COPY, then using --inserts would allow it to work.

Thanks a lot! Is new release going to be published?

authors: BillBuilt akirill0v gregwebs ruslan-kurbanov-jr

repo: datanymizer/datanymizer


text:
[Fix #85] use leading underscores in cached instance variable name

Before you submit a pull request, please make sure you have to follow:

[x] read and know items from the Contributing Guide
[x] add a description of the problem you're trying to solve (short summary from related issue)
[x] verified that cops are ordered by alphabet
[x] add a note to the style guide docs (if it needs)
[x] add a note to the changelog file
[x] the commit message contains the number of the related issue (if it presents)
and word Fix if this PR closes related issue
[x] squash all commits before submitting to review

@lazycoder9 rebase pls your changes

repo: datarockets/datarockets-style


text:
Differentiate display from user ID in autocomplete

The autocomplete from this issue:

#18

Isn't fit for purpose on Datasette Cloud, where user IDs are integers.
Need to be able to display their "display names" in lists of e.g. members of a group, and also autocomplete against those when adding users to groups or to table permissions.
Also: the <datalist> autocomplete really isn't very good - it still allows freeform text input and, at least on Firefox, shows a whole butch of irrelevant suggestions mixed in with the "valid" options:

I can use the actors_from_ids mechanism to show better actors, and I can update the design of the datasette_acl_actor_ids plugin hook to return whole actors, not just IDs, and implement one of the JavaScript autocomplete things I considered in https://github.com/datasette/datasette-acl/issues/18#issuecomment-2323460110

From https://alphagov.github.io/accessible-autocomplete/#progressive-enhancement

If your autocomplete is meant to select from a small list of options (a few hundred), we strongly suggest that you render a <select> menu on the server, and use progressive enhancement.

Instances with more than a few hundred users will be rare, I'm going to do that.

I tried getting the alphagov one working - it's pretty glitchy for me:

I had to hack the source code and add the selected text here to disable the 1Password icon on it too:

Got this working with https://projects.verou.me/awesomplete/

I'd prefer it if selecting the item submitted the form, you have to enter twice right now.

Here's that prototype so far (the custom event thing doesn't work though):
diff --git a/datasette_acl/templates/manage_acl_group.html b/datasette_acl/templates/manage_acl_group.html
index b293f42..9bbf7f3 100644
--- a/datasette_acl/templates/manage_acl_group.html
+++ b/datasette_acl/templates/manage_acl_group.html
@@ -3,6 +3,8 @@
 {% block title %}{{ name }}{% endblock %}

 {% block extra_head %}
+
+<link rel="stylesheet" href="{{ urls.static_plugins("datasette-acl", "awesomplete.css") }}">

Group Permissions

                staff (1)
                <select multiple id="select-staff">
                    <option value="insert-row">insert-row</option>
                    <option value="delete-row">delete-row</option>
                    <option value="update-row">update-row</option>
                    <option value="alter-table" selected>alter-table</option>
                    <option value="drop-table">drop-table</option>
                </select>

                devs (5)
                <select multiple id="select-devs">
                    <option value="insert-row" selected>insert-row</option>
                    <option value="delete-row" selected>delete-row</option>
                    <option value="update-row" selected>update-row</option>
                    <option value="alter-table" selected>alter-table</option>
                    <option value="drop-table">drop-table</option>
                </select>

                newgroup (0)
                <select multiple id="select-newgroup">
                    <option value="insert-row">insert-row</option>
                    <option value="delete-row">delete-row</option>
                    <option value="update-row">update-row</option>
                    <option value="alter-table" selected>alter-table</option>
                    <option value="drop-table">drop-table</option>
                </select>

                muppets (5)
                <select multiple id="select-muppets">
                    <option value="insert-row">insert-row</option>
                    <option value="delete-row">delete-row</option>
                    <option value="update-row">update-row</option>
                    <option value="alter-table">alter-table</option>
                    <option value="drop-table">drop-table</option>
                </select>

I implemented Choices for permission selection and user selection here:

#24

Still need to differentiate user ID from user display though.

New hook design: it can return a list of IDs, or it can return a list of dicts with "id" and "display" keys.

I'm going to rename datasette_acl_actor_ids to datasette_acl_valid_actors.

repo: datasette/datasette-acl


text:
S3 bucket creation command is missing for archive handler

In the newer version of aws command and S3 server, S3 bucket needs to be create with an separate S3 API since the aws s3 cp command no longer creates a new bucket. Below are the quick fixes to make it working.
Ideally we should make these commands configurable via a configmap, so when there's new changes to S3 API, we can update the configmap rather than building a new image every time.

@YiannisGkoufas can you review this? Thanks.

thanks @Tomcli looks good!

authors: Tomcli YiannisGkoufas

repo: datashim-io/datashim


text:
fix OPS_API_RESPONSE union type to include lists

I inadvertently gave a very silly definition of the OPS_API_RESPONSE, which did not include List[Any] as one of the types (the DevOps API as a matter of fact does return top-level lists for some calls, such as get_databases).
Now I fixed it and to satisfy the type checker the whole of the ops methods are, correctly, moved to the OPS_API_RESPONSE return type.

LGTM! :)

authors: erichare hemidactylus

repo: datastax/astrapy


text:
[HW] Muhammad Atif Ahsan

Name: Muhammad Atif Ahsan
Email: atif.rfo@gmail.com
Linkedin Profile: https://www.linkedin.com/in/atifahsan/
Attach the homework screenshots below for both step II and step III:

Hey Muhammad Atif Ahsan, great job! Congrats! Here is your badge! https://api.badgr.io/public/assertions/SlhV6khfTzKnRot2Oexd8Q

authors: HadesArchitect atifahsan


text:
pull/pull cache for all branches

dvc sync [file] uploads/downloads data snapshot for only the current brunch.
dvc sync -all [file] should upload\download all versions of the file(s).

I am not sure it is worth implementing, as there are usually more branches that don't even belong to you(i.e. various branches from origin, upstream and etc), which makes pushing/pulling all branches counter-productive, as in those rare cases when you indeed need to sync a few branches, you can easily do so by checking out those branches with git yourself. Actually, same logic applies to dvc metrics, but there the cost of it was pretty low, so it was an easy choice to just implement it. Lets discuss this one later. Moving to 0.9.8 for consideration.

authors: dmpetrov efiop

repo: dataversioncontrol/dvc


text:
Throttle/group Ops

Currently each keystroke results in a fresh op. It would be more efficient if ops were batched by some time interval, so that quickly typing multple characters in a single word results in a single op. The time interval in ms could be passed into the constructor, making this behavior opt-in.

Here's a working implementation of this feature https://github.com/datavis-tech/codemirror-6-experiments/blob/master/packages/experiments/src/client/codeMirrorShareDBBinding.js#L31

Closing as ShareDB batches like this internally.

repo: datavis-tech/codemirror-ot


text:
Replace screenshots

The screenshots aren't too great. They should look good.

I've uploaded new ones to the GDrive folder 'Platform/Ordino Screenshots'

authors: alexsb mstreit


text:
Automate upgrading envoy

There is some build+test+push awesomeness at https://github.com/datawire/envoy/tree/datawire/extauth-build-automation/DATAWIRE that would be awesome to have automated.
Let's do it :tm:

Closing since I think @LukeShu managed to do this...

authors: containscafeine kflynn

repo: datawire/ambassador


text:
Adding max_request_headers_kb configuration support.

Description
Exposing max_request-headers_kb envoy parameter through the ambassador.
Related Issues

None

Testing

max_request-headers_kb configured in Ambassador Global configuration. For e.g.

---
apiVersion: ambassador/v1
kind: Module
name: ambassador
config:
  service_port: 4567
  max_request-headers_kb: 90

Todos

[X] Tests
[X] Documentation

Hey, thanks for this! A couple of questions:
First, this looks like it'll enforce a 60KB limit on headers globally for all Ambassador installations, which is a behavioral change that's probably not desirable. If the user doesn't specify a size, I think we shouldn't apply any limit.
Second, this is definitely one that needs a test -- maybe set the limit to 1KB, then send a request through with longer headers than that. Should the request fail? or do the headers get truncated? or... what?
Thanks again!

authors: ankurpshah kflynn


text:
Dockerhub deprecation warning

Related to: https://github.com/datopian/giftless/issues/119
Changes

Added a "docker-prerun.sh" script to serve as the entry point of the docker file, that right now only echoes a deprecation warning in case the image is being pulled from Dockerhub, but also that can be extended in the future for different deprecation warnings
If the image is build with --build-arg IS_DOCKERHUB=true, upon running the image, the following warning can be seen:

I have built the docker image at the point of this PR and pushed that to Dockerhub, please try it out if you can https://hub.docker.com/repository/docker/datopian/giftless/tags/0.6.2/sha256-a7f53727881796de19c169899e7f9cb4d9e701803958855f52f8150c4d10f9b5
Future

If this PR is approved, I'll also push the same image with the "latest" tag and tweak the descriptions at the Dockerhub repo to flag that it's deprecated.
At first, I didn't want to have an "IS_DOCKERHUB" env var. Wanted something like "PRERUN_ARGS" so that the prerun script could be extended more easily, but had some difficulties with that, perhaps something to revisit later on

@athornton @vit-zikmund how does this look?

The warning seems legit, but the handling of tini is not right. My OCD also tells me not to introduce any runtime ENV var unless its being used by the main code. Also my "overengineering gate" (which is a thing I'm starting to embrace fairly recently) tells me not to introduce new generic features unless it's apparent the extensibility is worth the loss of code simplicity. Working on a followup commit that would adhere to what I described ;)

Here's the update, please @demenech have a look.
I took the liberty to use the same branch, we can revert/force push that commit if you don't like my solution. On retrospect, this move was rather presumptuous and I don't want to shadow anyone. Sorry. Next time, I'll rather use my own branch.
FYI the Dockerfile as a whole is pretty suboptiomal for build re-runs and it's necessarily bloated, containing all the project files, where only a fraction is actually needed. I'd try at some improvements, but not before this PR is done.

authors: demenech rufuspollock vit-zikmund

repo: datopian/giftless


text:
Refactor code and simplify file processing

Pull Request: Main Refactoring and Conversion
Summary of Changes
This pull request introduces significant improvements and refactoring to enhance the MarkdownDB functionality. The key modifications include:

Class Breakdown:

The MarkdownDB class has been refactored into two distinct classes, separating concerns for indexing and querying.

Conversion to TypeScript Objects and SQL:

The Markdown file processing has been optimized by converting MD files into TypeScript objects before transforming them into SQL data.

Function Refactoring:

Few smaller functions have undergone refactoring.

Also, not sure if parse.ts and markdownToObject need to be separate. They seem to have overlapping responsibilities. I'd merge these two.

@mohamedsalem401 What do you think? I'm not sure about it

The reason why I think they should be independent is that parseFile.ts parses the links and tags from a string source, irrespective of whether it's in a local file or not, while markdownToObject.ts is responsible for loading files from the local file system.

The reason why I think they should be independent is that parseFile.ts parses the links and tags from a string source, irrespective of whether it's in a local file or not, while markdownToObject.ts is responsible for loading files from the local file system.

Yes, I agree, let's leave them separate

@mohamedsalem401 Where are the tests? 😄

I believe this pull request (PR) includes numerous changes at the moment. Therefore, I plan to open a new PR specifically for the latest changes, including tests.

@mohamedsalem401 Where are the tests? 😄

I believe this pull request (PR) includes numerous changes at the moment. Therefore, I plan to open a new PR specifically for the latest changes, including tests.

I think it would be better if we add tests to the same PR...
Also, I wouldn't merge it into main. We don't want to publish a new version of the package until the whole refactoring is ready. (Note we have an auto-publish workflow in place.)  Let's create another branch, .e.g v2, off of main and reopen this PR against that branch.

I think it would be better if we add tests to the same PR...
Also, please don't merge it to main. We don't want to publish a new version of the package until the whole refactoring is ready. (Note we have an auto-publish workflow in place.) Let's create another branch, .e.g v2, off of main and reopen this PR against that branch.

OK, I will add them in this pull request and will switch to the new branch v2

This was for #47 and we did this (for now) in a simpler way where we don't refactor existing code - see resolution details in #47. We reused some of this and will probably reuse more in future.

authors: mohamedsalem401 olayway rufuspollock

repo: datopian/markdowndb


text:
Cite and discuss Hardekopf

His paper introduces an time stamp feature to AAM for which properties can be proven and re-used.  Thus it's relevant to discuss as an instance of re-usable metatheory for static analysis.

This still hasn't happened and needs to.

Done.

authors: davdar dvanhorn

repo: davdar/maam


text:
change msbuild discovery path logic

Change to logic for msbuild.exe  discovery

Thanks for pulling this out separate from the WIP solution loading - makes it easier to merge while figuring out the solution part.

authors: colombod daveaglick

repo: daveaglick/Buildalyzer


text:
Refactor advanced options page

This should help with #60

Good luck reviewing this :D

Changes:

Facefixer strength slider now only shows when facefixer is active
Made the giant advanced options file 500 lines less giant :smirk:


text:
Deluge

Add deluge application to ansible-nas repository.

Thank you for submitting this PR, getting Deluge merged will be awesome. This has however, reminded me why I didn't do it myself in the first place :smile:
Few things that will need fixing;

You've supplied a default username/password, but not mentioned in the docs what it is or how to change it (I think mentioning the default for the container, and how to change it is fine)
The docs need to mention that having Transmission and Deluge pointing at a watch directory will cause problems
The paths in the supplied config don't look right (ie /root/Downloads)
The added variables need adding to tests/test.yml
You've specified a local network range that's different to the one specified in the example config and transmission. It's probably worth pulling this (and the transmission one) out to a central variable in the config shared by both containers.

Also I'm not clear on;

Why are config files supplied? Is there something you're changing that's required that isn't possible to do via environment variables? (if so, is there a better image floating around that could be configured with environment variables?)

Please tell me, why you didn't do this?
Deluge after installation is not configured properly, it misses configuration about watch folder and where to download files that why I add configuration files to the repository. But I can delete these files, and add information to deluge docs the user after the first login needs to configure watch and downloads directory manually in configuration from webUI.

Have a read of this: https://github.com/davestephens/ansible-nas/blob/master/docs/contributing.md
It's generally considered good practise to read contribution guidelines before contributing to a project on GitHub. If you don't and still submit a PR, you should expect some sort of feedback along the lines of what the guidelines say, which is what I did.
I'm not at a computer right now but I want to test what you say about directories properly, if possible I don't want to supply config files. Reason being, if you run the playbook, change the config, run the playbook again then you're going to break people's config for them, which is not great.

authors: davestephens tcharewicz

repo: davestephens/ansible-nas


text:
Added twitch.tv/alejandromp4

I saw there is now a section for twitch 🎉

CI issue seems to be on ruby setup not on validate.

repo: daveverwer/iOSDevDirectory


text:
Add pretty-print functionality to the rule classes

At request of @vjawahar , let us know if this is good

Will do this better and reopen a PR in a sec


text:
can events be added to the calendar?

I see that there are events: boolean in a few views, but how do I pass the actual events into the component?

Hi @williamli, events should be controlled from outside of the component, so you need to hold a state outside, and just pass those in as an array of events into the Organizer component. Here is an example repo - https://github.com/davidalekna/organizer-examples/blob/master/src/index.js
let me know if you have more questions 👍🏻

I was looking for the definition of event object.
I found it in https://github.com/davidalekna/organizer-examples/blob/master/src/helpers/index.js https://github.com/davidalekna/organizer-examples/blob/master/src/helpers/index.js
Thanks.

On 16 Aug 2019, at 15:55, David notifications@github.com wrote:
Hi @williamli https://github.com/williamli, events should be controlled from outside of the component, so you need to hold a state outside, and just pass those in as an array of events into the Organizer component. Here is an example repo - https://github.com/davidalekna/organizer-examples/blob/master/src/index.js https://github.com/davidalekna/organizer-examples/blob/master/src/index.js
let me know if you have more questions 👍🏻
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub https://github.com/davidalekna/react-organizer/issues/1?email_source=notifications&email_token=AABL4MMKJEKVZHLE2UA6NYLQEZMNNA5CNFSM4IMDQQIKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD4N6L5Q#issuecomment-521922038, or mute the thread https://github.com/notifications/unsubscribe-auth/AABL4MJESEIHWBDTETPJQF3QEZMNNANCNFSM4IMDQQIA.

No worries mate. This package is being moved to a monorepo and is in a progress on being rewritten in typescript.
https://github.com/davidalekna/react-components/tree/master/packages/alekna-organizer

authors: davidalekna williamli

repo: davidalekna/react-organizer


text:
Introduce request: Use one subdomain for multiple projects

Idea:
Currently I should generate certificates for each project and use something like app.project.test as domain.
It would  be good to use domains like project.magento2.test, project.magento1.test, project.laravel.test
In this case I need generate one wildcard certificate for all projects and urls looks more clear

@Den4ik I'm not sure this is somewhere I'd like to go with this project. Using domains in this way would have confusing semantics, and would result in conflicts for the domains generated for auxiliary services for things like Mailhog and RabbitMQ which both run on a per-project basis at mailhog.project.test and rabbitmq.project.test currently.
The use of a root CA to sign SSL certificates was done because by-design each project should have a separate domain name. If you're merely concerned about the manual step during setup for other devs working on the project, perhaps adopting an init script similar to this one would be a good idea (the repo this is in mirrors how I and my colleagues at Mediotype setup each Magento project to get started):
https://github.com/davidalger/warden-env-magento2/blob/develop/tools/init.sh
Appreciate the suggestion, but I'm going to go ahead and close this one out.

repo: davidalger/warden


text:
Syntax for inlining of function calls

Currently we support inlining in two forms.
rotate 1, 2 fill red box
rotate 1, 2 >> fill red >> box

Could we standardise on the latter of these? It still gives us a useful inlining short cut, but it's (imho) a bit easier to see what's an argument and what's a function.
Also it's a damn site easier to parse, and would mean that I'll be able to extend it to work with arbitrary functions more easily.

That separation is not a difficult part to do - I do that separation part in 134 badly-written lines in two functions called in sequence (findQualifiers and fleshOutQualifiers) here https://github.com/davidedc/livecodelab/blob/master/coffee/languages/livelangv1/code-preprocessor.coffee#L1080-L1214
before those two functions the input is
rotate 1, 2 fill red box
and after those two functions becomes
rotate 1, 2, -> fill red, -> box;;
(I then need more transformations, but that's where all the "chevrons" positioning is done).
And I made no attempt to be short about it and I'm sure that there is redundant code in there, it's probably just 1 screen of clean code rather than my 3... and I have no clever tokenisation in place which I think you have in place, so really the matching/transformation in your situation would be shorter and cleaner...
It's just unnecessary symbols, and it's so much easier not to use the chevrons, in fact I never used them, so no I don't think is good to mandate them.

heh fair enough if you want to keep it working without the >> operator. was asking incase I could make my life easier :)
I'm realising that I'm going to have to have a more extensive rewriter/preprocessor anyway. I'm adding in support for using closures as arbitrary expressions, so we can more easily pass them into functions without having to assign them to variables before hand. turns out that because we don't have a prefix for closures, it's really difficult to parse.
Ah well :p

authors: davidedc rumblesan

repo: davidedc/livecodelab


text:
improve physics drawing

I've been drawing each physics object manually but just saw this tutorial for doing it all together
https://love2d.org/wiki/Tutorial:PhysicsDrawing
Should go through and try and apply. Need to look into if I can expand it to change colour for each shape or texture each object. Would be really nice to centralize object drawing if poss.

I'm not going to do this.

repo: davidjtferguson/silly-sam


text:
Pulling react-redux-forms from npm doesn't have 1.14.2 built code

After updating to 1.14.2 and using isValid an undefined error is thrown. It appears the changes are in the /src folder but not in /lib. I built it manually and it works fine.

@davidkpiano would you be able to push the changes to npm please?

Same here... exported isValid is found in the /src but not in the /lib

1.14.4 was just published!

Thanks @davidkpiano !

authors: davidkpiano mewben stevenmason

repo: davidkpiano/react-redux-form

license: mit


text:
chore: remove unneeded entries in CI's Makefile

Issue or need
Some entries in CI/CD's .ci/Makefile are just redirecting to run scripts. The purpose of that file is to add commands that are only different when running in CI/CD

Proposed changes
Remove CI's Makefile targets that just run regular run scripts

Quick reminders

🤝 I will follow Code of Conduct
✅ No existing pull request already does almost same changes
👁 Contributing docs are something I've taken a look at
📝 Commit messages convention has been followed
💬 TSDoc comments have been added or updated indicating API visibility if API surface has changed.
🧪 Tests have been added if needed. For instance, if adding new features or fixing a bug. Or removed if removing features.
⚙ API Report has been updated if API surface is altered.

#1034  👈
main

This stack of pull requests is managed by Graphite. Learn more about stacking.

Join @davidlj95 and the rest of your teammates on  Graphite


text:
Implement task configuration avoidance for avro plugin

This PR supports https://github.com/davidmc24/gradle-avro-plugin/issues/97

@davidmc24 - not quite ready yet. This needs a bit of work to make sure the tests are passing. Some tests will need to be adjusted, but I think there is an issue with the code. I will look into it as soon as I find a bit of time to do so.

Sounds good. Let me know when it’s ready
On Mon, Feb 24, 2020 at 2:06 PM Denis Cabasson notifications@github.com
wrote:

@davidmc24 https://github.com/davidmc24 - not quite ready yet. This
needs a bit of work to make sure the tests are passing. Some tests will
need to be adjusted, but I think there is an issue with the code. I will
look into it as soon as I find a bit of time to do so.
—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub
https://github.com/davidmc24/gradle-avro-plugin/pull/102?email_source=notifications&email_token=AADNKULEF2DPTSB5V3GJKCLREQLC3A5CNFSM4KTHBAQKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOEMZEITI#issuecomment-590496845,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AADNKUJ54BBOQIR5GGAZFP3REQLC3ANCNFSM4KTHBAQA
.

--
David M. Carr
david@carrclan.us

Went with a different implementation for #97.  Thanks for the contribution.  It was a helpful example of some of the techniques needed.


text:
Remove BorderlessEntryRenderer that was left after cleanup.

Fixed iOS build.
With cleanup a few days ago BorderlessEntry was removed but the renderer was still in iOS project and broke the build.

iOS builds now, but Xappy stops immediately after displaying its blue launch screen.
I have dealt with the usual suspects ("xapping" the .vs, bin and obj directories) without success.
I haven't changed anything and this is the cloned respository directly from GitHub to my Mac.
I have attached a file with the 16 warnings reported during the build.
The head and tail of the installation, In case this helps:
/Library/Frameworks/Xamarin.iOS.framework/Versions/Current/bin/mlaunch -sdkroot "/Applications/Xcode.app/Contents/Developer" --installdev "~/Documents/Xamarin_solutions/Xappy/Xappy/Xappy.iOS/bin/iPhone/Debug/device-builds/iphone8.1-12.3.1/Xappy.iOS.app" --device ios "--devname=FAR iP6s" --install-progress
Installing application bundle 'com.companyname.Xappy' on 'FAR iP6s'

Installing application bundle 'com.companyname.Xappy' on 'FAR iP6s'
 TransferringPackage - PercentComplete: 10%
 CopyingFile - Path: ~/Documents/Xamarin_solutions/Xappy/Xappy/Xappy.iOS/bin/iPhone/Debug/device-builds/iphone8.1-12.3.1/Xappy.iOS.app/META-INF/
 CopyingFile - PercentComplete: 10%

 . . .

 CreatingStagingDirectory - PercentComplete: 5%
 ExtractingPackage - PercentComplete: 15%
 InspectingPackage - PercentComplete: 20%
 TakingInstallLock - PercentComplete: 20%
 PreflightingApplication - PercentComplete: 30%
 InstallingEmbeddedProfile - PercentComplete: 30%
 VerifyingApplication - PercentComplete: 40%
 CreatingContainer - PercentComplete: 50%
 InstallingApplication - PercentComplete: 60%
 PostflightingApplication - PercentComplete: 70%
 SandboxingApplication - PercentComplete: 80%
 GeneratingApplicationMap - PercentComplete: 90%
Application bundle 'com.companyname.Xappy' installed on 'FAR iP6s'

Upload succeeded.

190721_Xappy_warnings.txt
Thanks.

More FYI:
I attempted to include all nightly builds even remotely associated with this issue.
Pease see attached report with specific details: Could not add packages.
Are there any specific packages to include and/or to exclude?
All I'm trying to do is to get some consistent state that will build and run without gobbling up all of my scarce time, with the objective of using some of the working code as an example of what Xamarin can do.
Thanks for doing all the hard work on the fundamentals.

190721_Xappy_could_not_add_packages.txt

Hi @farr64,
for me the iOS build an run works with the configuration Debug | iPhoneSimulator > iPhone XR iOS 12.2
Not tried it with real device or other configuration. Maybe that helps.

Best Alex
P.S. If you still have errors it may help if you attach the Application Output besides the Tool Output (build).

Hi Alex,
It most certainly helped: Xappy works wonderfully on the simulator. Thanks for the great tip ;-)
Now, if we can only get this baby out of the simulator and into the real world, that would be a giant step for Xumanity.
Almost there, an important step at a time.
I appreciate all of your work. I know how challenging each step is.

Well . . .
I let the simulator run for a few minutes and then the simulator decided to eject Xappy (or perhaps vice versa).
I enclose the crash log. I didn't bother to send it to Apple, so I just copied and pasted and saved it for you.
Thanks.
190721_Xappy_Simulator_crash.txt

So the native crash log don't help.
I have fixed one more crash that comes when navigating to about but the PullRequest is currently missing.
Will see if I can do it today evening (CEST).
It looks like the iOS Version needs some general love ;)

repo: davidortinau/Xappy


text:
VSCode plugin login failure

CodeGPT plugin login does redirect tot http://localhost:54112/auth/callback?code=XXX
Once logged in with Google, page shows Connection Success and redirect back to VSCode app.
Launched external handler for 'vscode://'.

However, nothing really happens, plugin still shows as logged out.
The only log entry is this -
[15:15:51] Registering CodeGPT Copilot provider

Re-installing the plugin did not help.
Removing plugin files from ~/.vscode/extensions/danielsanmedium.dscodegpt-3.2.1/ with clean install did not help.
VSCode upgrade 1.86.2 to 1.87.0 did not help.
Another confusing thing is version - plugin version is 3.2.1,  Chat shows 3.1.1, welcome banner shows 2.0.
VSCode Version: 1.87.0
Commit: 019f4d1419fbc8219a181fab7892ebccf7ee29a2
Date: 2024-02-27T23:42:51.279Z
Electron: 27.3.2
ElectronBuildId: 26836302
Chromium: 118.0.5993.159
Node.js: 18.17.1
V8: 11.8.172.18-electron.0
OS: Darwin arm64 23.3.0

+1
Having the exact same issue.

@gudzenkov @red-daut Hi guys!, try to update Node.js: 18.17.1 to Node.js 20.

That is Node.js bundled with VSCode 1.87.0
My local node is already 21.6.2

facing the same issue. not redirect to VSC after web login
Version: 1.87.0 (user setup)
Commit: 019f4d1419fbc8219a181fab7892ebccf7ee29a2
Date: 2024-02-27T23:41:44.469Z
Electron: 27.3.2
ElectronBuildId: 26836302
Chromium: 118.0.5993.159
Node.js: 18.17.1
V8: 11.8.172.18-electron.0
OS: Windows_NT x64 10.0.22621
local node version 20.11

Having the same issue.

Mostly the same happening here. Ubuntu 23.10, VS Code Insiders (latest as of this post).
I get the "Connection Success" message" but when I click on "Open in VSCode Insider", Chrome silently fails to reach my running VSCode instance.

Some issue here. Can't login. Is there any alternative form of login to codeGPT vscode extension?

Same issue too. I click on "Open in VSCode" after web login but nothing happens. I tried with with Firefox and Chrome, same issue. I'm on Linux Mint.

Same issue here, vscode on macos.
CodeGPT: v3.2.4
VSCode: 1.87.2

I cannot login, stuck here:

If I click signin it opens the browser at this local page:
http://localhost:54112/login
But get this:

VSCODE:
Versione: 1.87.2 (user setup)
Commit: 863d2581ecda6849923a2118d93a088b0745d9d6
Data: 2024-03-08T15:20:17.278Z
Electron: 27.3.2
ElectronBuildId: 26836302
Chromium: 118.0.5993.159
Node.js: 18.17.1
V8: 11.8.172.18-electron.0
Sistema operativo: Windows_NT x64 10.0.19045

same problem here. Is this going to be fixed? if not I'll just use cursor

We have not been able to replicate the error, so far every time we log in, the account remains connected in the extension.
The only error that currently exists is that depending on the browser the buttons to return to VSCode do not work, this will be resolved in the next version.
You could follow this tutorial to confirm that the entire Login process is correctly working on your accounts.
https://youtu.be/yErnyqXobcI?si=p3Tr925PcvjvzR_h
If after following the tutorial the Connected icon still does not appear in CodeGPT, could you send me an email to daniel@codegpt.co with a video or images of the complete flow you are doing so we can fix the problem.
Thank you very much for your help reporting the error, we will try to solve it as soon as possible

Emailed you with the video!

@bgeneto @matiaszanolli @clintonruairi Hi guys! I just test it on Ubuntu 22.04 and works!
, just follow the tutorial is the same for Ubuntu https://youtu.be/yErnyqXobcI?si=p3Tr925PcvjvzR_h

Can you guys provide a way to copy the token and paste in the extension via cmd? I'm stuck, can't login to cursor too.

no need the token just set the connection on the menu, please follow the tutorial https://youtu.be/yErnyqXobcI?si=p3Tr925PcvjvzR_h

I followed the tutorial the first time. It didn't work. After you posted this message, I made sure to follow it again, very slowly, to ensure I was not doing anything incorrectly. Same result.
When prompted to sign in by the extension, it is still redirected to a dead page on localhost.
The codeGPT plugin still gets stuck on an infinite loading screen.
When manually clicking sign in from the extension bar, it still redirects to a dead page on localhost.
This problem has been echoed by dozens of your users. If this extension worked I would happily pay the annual subscription fee. If your 'solution' is that we should all watch your Youtube video again, and that it works for you, I guess we should all just use cursor instead.
https://cursor.sh/
Screencast from 2024-04-17 22-21-23.webm

@clintonruairi
Now that we can see the video, possibly the problem is that port 54112 or 54113 are being used by another service.
Could you check if by turning off the services that run through those ports you can now lift the extension?

Nope, no process running on those ports. Ran the following commands:
 sudo lsof -i :54112
sudo lsof -i :54113
sudo fuser 54112/tcp
sudo fuser 54113/tcp
sudo fuser -k 54113/tcp
sudo fuser -k 54112/tcp

First to see if there were any processes running on those ports - returned nothing. Then killing any processes on those ports, just to be sure. Then installed codeGPT, opened the sidebar - still stuck on infinite loading. Clicked the sign in prompt in the bottom right of vs code, redirected to 'Not found' link on localhost.
Screenshot:

Other things I have tried so far (all unsuccessful), each after uninstalling codeGPT, closing VS code, and then reinstalling codeGPT:

disabled firewall
disabled VPN
cleared browser cache for codeGPT
changed browser to firefox
disabled adblocker
made sure VS code up to date
made sure codeGPT up to date
tried on multiple other wifi networks
tried on 2 other machines. Windows 11 and MacOs Sonoma 14.4.1
restarted/ Reinstalled VS code

Behaviour is the same across all of the above configs. Leads me to believe this is almost certainly a problem with codeGPT itself, or conflicting behaviour with another extensions. My installed extensions:
code --list-extensions
cweijan.vscode-office
dbaeumer.vscode-eslint
ecmel.vscode-html-css
esbenp.prettier-vscode
file-icons.file-icons
github.github-vscode-theme
grapecity.gc-excelviewer
infeng.vscode-react-typescript
magicstack.magicpython
mkxml.vscode-filesize
monokai.theme-monokai-pro-vscode
ms-azuretools.vscode-docker
ms-python.debugpy
ms-python.python
ms-python.vscode-pylance
ms-vscode-remote.remote-containers
ms-vscode.remote-repositories
ms-vscode.vscode-typescript-next
pmneo.tsimporter
prisma.prisma
rust-lang.rust
rust-lang.rust-analyzer
tomoki1207.pdf
xabikos.javascriptsnippets
yoavbls.pretty-ts-errors

Got any suggestions? @davila7

Thank you for the information @clintonruairi
We are evaluating with the team what might be happening... we will keep you updated.

@clintonruairi
Now that we can see the video, possibly the problem is that port 54112 or 54113 are being used by another service.
Could you check if by turning off the services that run through those ports you can now lift the extension?

Used this command to check if those ports were occupied by a service:
Get-NetTCPConnection | where {$.LocalPort -eq 54112 -or $.LocalPort -eq 54113}
Returned nothing when VSCODE wasn't active.
Returned values and PID were of a VSCODE process, suspecting it was CODEGPT, I uninstalled the extension. And now It doesn't detect it.
Which means the problem is not dependent on some other process cause as soon I reinstalled again those ports were detected as used...by CodeGPT. But still cannot connect.

@bgeneto @matiaszanolli @clintonruairi Hi guys! I just test it on Ubuntu 22.04 and works! , just follow the tutorial is the same for Ubuntu https://youtu.be/yErnyqXobcI?si=p3Tr925PcvjvzR_h

Hi,
For info, it is not the right way to reproduce this issue.
You need to do a remote connection, for example through an SSH connection to an GNU/Linux instance.
Thanks

@bgeneto @matiaszanolli @clintonruairi Sorry guys, you are right, I haven't try on remote server yet, but I made a procedure on  WSL here: https://medium.com/p/881b91ba193e

im getting unable to connect to the extension services, however i have latest node and vscode version and port 54112 is unused.

authors: JeromeGsq Mayorc1978 Neoplayer PilarHidalgo Sarinoty bgeneto camsique clintonruairi davila7 djacquensf9 gudzenkov luqmanyusof matiaszanolli pokhreldipesh red-daut


text:
Support for reading images in correct orientation using EXIF data.

Current Behavior
I'm working on image processing with some images I collected myself. Dlib's dlib.load_rgb_image('image_path') method swaps the rows and columns on some images while OpenCV's cv2.imread('image_path') method does not.
Check out the results below
img = dlib.load_rgb_image("myimg.jpg")
print(img.shape)

--------------------
OUTPUT: (1944, 2592, 3)
(the resultant image is rotated 90 degrees clockwise)

while OpenCV's method returns the correct shape:
img = cv2.imread("myimg.jpg")
print(img.shape)

--------------------
OUTPUT: (2592, 1944, 3)

dlib.load_rgb_image() does not take into account the EXIF orientation metadata, so some images are read incorrectly.
I don't want to go in and rotate some of these offending images myself manually because I'm creating an app.
Is there a way in Dlib to read images using orientation information?
Note: I asked this question of stackoverflow, one of the comments told me to create an issue here

Version: 19.17.0
Where did you get dlib:  pip
Platform: Windows 10 - 64bit
Compiler: python 3.6

Added platform info

Yeah, it doesn't do anything with EXIF data.  It would be cool if it loader used it.  Someone should submit a pull request that adds that feature :)

I'll see what I can do.

Would this require changes somewhere towards the top of image_loader.h?

That would be sensible.

authors: RafayAK davisking nmaynes

repo: davisking/dlib


text:
[fix] this change fixes compilation problems under mac

I have noticed the following problem with compilation on Mac:
dlib/tools/python/src/other.cpp:56:1: error: reference to 'list' is ambiguous list _max_cost_assignment ( ^ /Library/Developer/CommandLineTools/usr/include/c++/v1/list:805:28: note: candidate found by name lookup is 'std::__1::list' class _LIBCPP_TEMPLATE_VIS list                            ^ /usr/local/include/boost/python/list.hpp:57:7: note: candidate found by name lookup is 'boost::python::list' class list : public detail::list_base       ^ /Users/jaroslaw/code/dlib/tools/python/src/other.cpp:72:11: error: reference to 'list' is ambiguous     const list& assignment           ^ /Library/Developer/CommandLineTools/usr/include/c++/v1/list:805:28: note: candidate found by name lookup is 'std::__1::list' class _LIBCPP_TEMPLATE_VIS list                            ^ /usr/local/include/boost/python/list.hpp:57:7: note: candidate found by name lookup is 'boost::python::list' class list : public detail::list_base       ^ 2 errors generated. make[2]: *** [CMakeFiles/dlib_.dir/src/other.cpp.o] Error 1 error: cmake build failed!
this change fixes it.
PLEASE DOUBLE CHECK ME - I have not read this code or code in c++ recently... :)

I see the fix in place already :D


text:
Cannot access command palette from fullscreen

Hi Davis,
I can't access the command palette from fullscreen mode. Let me know if there's other info you need that would help solve this. Thanks!
Also: I was trying to access the palette because I wanted to split the screen to see two notes at once. I left fullscreen mode, split the screen, and reactivated fullscreen. One of the notes closed. So it seems that you can't split the screen in fullscreen mode. Let me know if you'd like me to open a separate issue thread for this. Thanks again!

Hey, thanks for opening the issue. To achieve Fullscreen Mode I am just calling requestFullscreen on the Editor element. Since Obsidian places the command palette on a completely separate div that is not a child of the editor element, there is no way to make it appear in fullscreen mode as it is implemented at the moment. This also explains why you can only fullscreen one editor, as only one element can be fullscreen.
To solve these issues we'd have to fullscreen the complete obsidian window and do some css tricks to make the editor appear fullscreen. I tried some things, but somehow position: fixed on the editor is not working. I suppose obsidian is using one of these properties https://stackoverflow.com/a/52937920 in any of the parent nodes. But I could not identifiy it quickly.
So fixing this requires some more thought and experimentation. I have thus postponed it to a later release.

Gotcha. Thanks for the explanation. For now, I'm using fullscreen with the Minimal theme and Hider plugin. That's what I was doing before, and it works fine.

Hey 👋 in the mean time I have completely rewritten the fullscreen mode, which fixes this issue as well. If any problems remain, feel free to open an issue.

authors: davisriedel seldstein

repo: davisriedel/obsidian-typewriter-mode


text:
🛑 Melody is down

In 5ebaceb, Melody (https://melody.red-mirror.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Melody is back up in 5921703 after 8 minutes.

repo: davorg/uptime