routes – Android – How to change ip table permanently on android device?

I have android with two network interface wlan0 and eth0.

Interface eth0 is connected with some private network (without internet).

Interface wlan0 is the source of Internet of my device.

The problem is when activate eth0 ethernet port of the device the internet coming from the wifi stops to work, there are routing problem.

I did some routing configuration command and i am able to solve it.

ip route add table eth0 default via 192.168.100.1 dev wlan0 proto static

The issue when i restart the kiosk the config disappear i have to do it again each time.

Can you tell me how can i change permanently ?

Thank you in advance.

algorithm – JavaScript implementation of Symbol Table (Dictionary)

I’m currently going over Robert Sedgewick Algorithms book. Here I’m implementing a Symbol Table using a Linked List. The Sequential Search Symbol table is implemented in JavaScript. The book mentiones that this Abstract Data Structure is not a good solution when dealing with big amounts of data.

I would like feedback on the implementation and on following JavaScript best practices. I’m coming from Ruby so having this implementation follow the best practices in JavaScript is a plus for me.

// Symbol Table using Sequential search (Linked List)
//
class SequentialSearchST {

  constructor() {
    this.first = null;
  }

  get(key) {
    for(let x = this.first; x != null; x = x.next) {
      if(x.key === key) {
        return x.val
      }
    }
    return null;
  }

  put(key, val) {
    for(let x = this.first; x != null; x = x.next) {
      if(x.key === key) {
        return x.val = val
      }
    }
    this.first = new Node(key, val, this.first);
  }

}

class Node {
  constructor(key, val, next) {
    this.key = key;
    this.val = val;
    this.next = next;
  }
}

st = new SequentialSearchST();
st.put('s', 0)
st.put('e', 1)
st.put('a', 2)
st.put('r', 3)
st.put('c', 4)
st.put('h', 5)
st.put('e', 6)
st.put('x', 7)
st.put('a', 9)
st.put('m', 10)
st.put('p', 11)
st.put('l', 12)
st.put('e', 13)
console.dir(st.get('s'));

Sql Server 2019 – Table update with 150 million rows taking 10+ hours

See below command which is updating table with 150 million records

Update is taking forever and never completing. How can we improve/break this into batches .. in SQL 2019

See screenshot below

sql server – Why does my table keep getting corrupted after removing large amounts of data?

I have a database that is about 400 gigs. The majority of the space is consumed by images of utility bills stored in binary form as varchar(max) in a single table. It’s a poor database design that I inherited. I have already exported the utility bills as pdfs to a network folder. Now I am trying to replace the images in the database with an empty string. I have been updating in small batches of 40k to 80k records at a time. The problem is that after a few batches, the table gets corrupted. I’ll get a message that the update failed. When I run CHECKDB I get

Msg 8909, Level 16, State 1, Line 1 Table error

It’s happened twice so far and I have to restore the database from a backup.

I need to know why this is happening and if there is a way to avoid it. I’m doing this in a test environment and I need to get this problem figured out before I can work on the production database.

Thank you for your help.

confluence – How to create multiple rows with shortcut in table on Ubuntu

In confluence is a short-cut to create another row in a table with “Ctrl+Alt+Downarrow”.
However, I can’t use this shortcut, because I am using Ubuntu 20.04 and this shortcut switches between multiple workspaces.

The problem is, I need a table with 20 rows and the only option that I have is to create a fresh table is to create a new table (which has 3 rows per default) and then add 17 rows manually with my mouse.

Is there any other way to create more rows? How can I enable this shortcut for Ubuntu?

database – Is it considered as best practice to use migration scripts for one-off large data manipulation over a table?

I have inherited a project via laravel that uses its database migration mechanism coming from the framework. The application has the following table named actions:

action_log_id SERIAL PK
user_id INT 
action_desc VARCHAR
awarded_points INT
date

And I want to add a column that records that awardee hence, I did the following migration script:

use IlluminateSupportFacadesSchema;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateDatabaseMigrationsMigration;

class ActionAwardee extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('actions', function (Blueprint $table){
            if (!Schema::hasColumn('actions', 'awardee')) {
                $table->string('awardee')->nullable();
            }
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('actions', function (Blueprint $table){
            if (Schema::hasColumn('actions', 'awardee')) {
                $table->dropColumn('awardee')
            }
        });
    }
}

But also I know that under some circumstances the awardee can take some dixed values for example if a record is before 2018 the awardee has value website, hence I can populate the table with some values. The population will be en bulk and it will be one-off field population.

Therefore I want to ask the $ 1.000.000 question (in zibabwe dollars) is it good idea to create yet another migration script for data manipulation or I should do it manually once my application is deployed?

plotting – How to plot a function using a table particular values

I would like to plot the following function in terms of kR, but using specific different values, I think the best easy way is using a Table. This is a common useful problem to explore numerical the behavior in a particular function, this is the code

f = Sin( Sqrt((Pi)) /Sqrt( n k R) ) E^(-((I k (R^2 + z^2))/(2 R))) ;

k = 2 Pi; R = 1; 

This code generates kR= 2Pi, 3 Pi, 4 Pi. But, The idea is to plot , let say plot kR = 2Pi, 50 Pi, and 100 Pi Of course it is simple for this case since could be evaluated, and show a legend. Interesting suggestions are welcome, thanks

Plot(Evaluate(Table(Re(f), {n, 3})), {z, 0, 20}, Filling -> Axis, PlotRange -> All, AxesLabel -> {z, f })


 



 

magento2.3 – Save Product custom filed data to sales_order_item table custom field from in Magento 2

I have created custom column in sales_order_item table, I am trying to save product custom field data to sales_order_item custom filed. But I am unable to save.

tried the way to create field as below:

<?xml version="1.0"?>
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
    <table name="sales_order_item" resource="sales" engine="innodb" comment="Sales Order Item">
        <column xsi:type="varchar" name="custom_message"   nullable="true" comment="Custom Message"/>
    </table>
</schema>

Any suggestions to do?

Сyclic routes in the table

In a $n × m$ table, some cells are locked. How to determinate time whether it is possible to split the remaining cells into cyclic routes of length at least $3$? All unremoved cells must participate in exactly one route exactly once. And the beginning of each route must coincide with its end.